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

mysql

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

身份认证购VIP最低享 7 折!

30元优惠券

资源详情

资源推荐

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

kylin advanced server v10 sp3 系统自带了MySQL，如何使用

idea连接mysql server returns invalid timezone. go to 'advanced' tab and set

kali安装mysql数据库

docker desktop安装mysql5.7

win11 安装mysql

No data sources are configured to run this SQL and provide advanced code assistance. SQL dialect is not configured.MariaDB,MySQL match best.

idea如何导入mysql

idea里创建mysql数据库时怎么默认为utf-8

mac m1 docker安装mysql

C:\Users\Admin>mysql --version 'mysql' 不是内部或外部命令，也不是可运行的程序 或批处理文件。

mysql workbench中文乱码

mysql安装配置教程oracle

通过docker desktop 安装启用mysql

打开mysql密码忘了

mysql workbench密码忘了

kettle中pg与mysql字符集转化

2023最新版mysql8.0.34安装

笔记本怎么安装mysql

最新资源

C:\Users\Admin>mysql --version 'mysql' 不是内部或外部命令，也不是可运行的程序或批处理文件。