掌握高级MySQL 8：构建高性能分布式数据库指南

需积分: 9 161 浏览量更新于2024-07-16 收藏 12MB PDF 举报

"Advanced MySQL 8 是一本专为业务规模数据库管理设计的指南，无论企业大小，都广泛采用 MySQL 来访问和处理全球范围内的企业级数据。本书深入挖掘 MySQL 的全部潜力，特别关注在高流量网站、企业系统以及打包软件运行环境中实现和管理大规模分布式 MySQL 集群，以确保数据库性能的极致发挥。作者 Eric Vanier、Birju Shah 和 Tejaswi Malepati 以其丰富的经验，从实际操作和最佳实践角度出发，带领读者步入高级 MySQL 8 的世界。通过本书，读者将学习如何构建、优化和维护高效稳定的分布式数据库架构，包括集群配置、故障转移、负载均衡、安全性和性能监控等方面的技术。本书不仅涵盖了基础知识，如 SQL 查询优化、存储引擎选择、索引设计，还深入探讨了 MySQL 8 的新特性和改进，如 InnoDB Clusters、多可用区部署（Multi-AZ）、以及与 NoSQL 数据库的集成策略。读者可以借此提升对 MySQL 高可用性、可扩展性和容错性的理解。版权方面，Advanced MySQL 8 的所有权利受 2019 年 Packt Publishing 所保护，未经出版商事先书面许可，禁止任何形式的复制、存储或传输。尽管作者和 Packt Publishing 已尽最大努力确保信息的准确性，但本书提供的内容不保证无误，也不承担因使用本书内容而产生的直接或间接损失的责任。此外，本书在提及公司和产品时尽可能正确使用商标信息，但 Packt Publishing 不对这些信息的准确性提供保证。本书由 Pravin Dhandre 主编，经过了精心策划和审阅，旨在为 MySQL 技术人员提供实用且全面的学习资源。阅读 Advanced MySQL 8，将帮助读者在日益竞争激烈的 IT 领域保持技术领先，提升企业的数据库管理能力。"

Preface

[ 4 ]

Piracy: If you come across any illegal copies of our works in any form on the Internet, we

would be grateful if you would provide us with the location address or website name.

Please contact us at copyright@packt.com with a link to the material.

If you are interested in becoming an author: If there is a topic that you have expertise in

and you are interested in either writing or contributing to a book, please visit

authors.packtpub.com.

Reviews

Please leave a review. Once you have read and used this book, why not leave a review on

the site that you purchased it from? Potential readers can then see and use your unbiased

opinion to make purchase decisions, we at Packt can understand what you think about our

products, and our authors can see your feedback on their book. Thank you!

For more information about Packt, please visit packt.com.

Introduction Chapter 1

[ 7 ]

Why it is so important to have a good

MySQL architecture design

It must be said that MySQL is easy to use and its operation is very fast. MySQL requires at

first a general knowledge of SQL to work effectively with it. MySQL does not require much

more knowledge, but a little knowledge of common relational database management

system (RDBMS) is helpful.

However, despite the fact that MySQL comes with a minimal configuration to help your

database launch and perform well, MySQL needs more attention to maintain optimal

performance, and in general a good understanding of MySQL's configuration becomes

more important.

The fact is that the more your database grows with time and demands more hardware

resources such as memory, processors, and disk speed, the slower response times will be;

this is a sign that your data model need to be revised and adjusted to meet growing and

critical demands. The better your data model is at the beginning, the easier it will be to re-

adjust your configuration along the way.

The more your business or website grows the more you need a good solid MySQL

architecture. During this growth phase, you will notice that you will be asking yourself

questions such as the following ones:

Do I need to completely rethink my MySQL architecture?

Should I start thinking about having a large MySQL infrastructure?

Do I need to review my queries?

Do I need to create indexes?

Imagine the questions and doubts when we are in the phase where MySQL is likely to

under-perform. That's when you desperately start looking at your options on Google and

YouTube to see how you can improve your architecture.

This is what I call the critical or gray-zone phase. You will try to make all kinds of changes

with the hope of solving your performance problems when the solution was simply to have

a good architecture and a logical structure of your data right from the start.

Fortunately, MySQL 8.0 will provide a detailed understanding of high availability with

InnoDB Cluster, Global Replication, and all the other features that have been added or

improved. I must mention that I have been so far pleasantly surprised by the new

performance of MySQL 8.0.

剩余279页未读，继续阅读

lionli618

粉丝: 0
资源: 13

掌握高级MySQL 8：构建高性能分布式数据库指南

mysql-8-cookbook2018

High Performance MySQL: Optimization, Backups, Replication, and More

Advanced MySQL 8 1st Edition.Pdf

An advanced MySQL SQL monitoring tool-开源

Advanced Pagination for MySQL(mysql高级分页)

Advanced SQL Injection with MySQL

MySQL学习仓库。Cover basic and advanced knowledge of MySQL. Lis.zip

mysql_advanced-master.zip

Advanced-MySQL-Performance-Optimization.zip_peter

Eloquent-Relationships-Advanced-Laravel-7-and-MySQL:Laravel和MySQL开发软件

最新资源