作者:
Silvia Botros
/
Jeremy Tinley 出版社: O'Reilly Media 副标题: Proven Strategies for Running MySQL at Scale 出版年: 2021-12 页数: 386 装帧: Paperback ISBN: 9781492080510
How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from setting service-level objectives to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve your platform's full potential. This guide also teaches database administrators safe and practical ways to scale appl...
How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from setting service-level objectives to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve your platform's full potential. This guide also teaches database administrators safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
Updated to reflect recent advances in cloud- and self-hosted MySQL, InnoDB performance, and new features and tools, this revised edition helps you design a relational data platform that will scale with your business. You'll learn best practices for database security along with hard-earned lessons in both performance and database stability.
* Dive into MySQL's architecture, including key facts about its storage engines
* Learn how server configuration works with your hardware and deployment choices
* Make query performance part of your software delivery process
* Examine enhancements to MySQL's replication and high availability
* Compare different MySQL offerings in managed cloud environments
* Explore MySQL's full stack optimization from application-side configuration to server tuning
* Turn traditional database management tasks into automated processes
作者简介
· · · · · ·
Silvia Botros is a Senior Principal Engineer at Twilio. During her time at SendGrid, she helped deploy and maintain various MySQL datastores that support the mail pipeline and other products that SendGrid offers and to drive MySQL designs from inception to production.
Jeremy Tinley is a Senior Staff Engineer at Etsy, with over 20 years of MySQL experience. Throughout his career...
Silvia Botros is a Senior Principal Engineer at Twilio. During her time at SendGrid, she helped deploy and maintain various MySQL datastores that support the mail pipeline and other products that SendGrid offers and to drive MySQL designs from inception to production.
Jeremy Tinley is a Senior Staff Engineer at Etsy, with over 20 years of MySQL experience. Throughout his career, he has managed tens of thousands of MySQL instances with an eye towards availability, reliability, and operational efficiency.
目录
· · · · · ·
1. MySQL Architecture
2. Monitoring in a Reliability Engineering World
3. Performance Schema
4. Operating System and Hardware Optimization
5. Optimizing Server Settings
6. Schema Design and Management
· · · · · ·
(更多)
1. MySQL Architecture
2. Monitoring in a Reliability Engineering World
3. Performance Schema
4. Operating System and Hardware Optimization
5. Optimizing Server Settings
6. Schema Design and Management
7. Indexing for High Performance
8. Query Performance Optimization
9. Replication
10. Backup and Recovery
11. Scaling MySQL
12. MySQL in the Cloud
13. Compliance with MySQL
A. Upgrading MySQL
B. MySQL on Kubernetes
· · · · · · (收起)
Sometimes people protest that they just don’t have time to benchmark the server for 8 or 12 hours at 10 different levels of concurrency on two or three server versions. If you don’t have the time to do the benchmarks right, any time you do spend is wasted; it is better to trust other people’s results, instead of doing an incomplete benchmark and getting the wrong answers. (查看原文)
The Cisco server has lower per-CPU performance than the EC2 servers. Surprised? We were a bit surprised ourselves.。。。Thus, the explanation for our results is probably as follows: the Cisco
server’s CPUs are a couple of years old, and are slower than the EC2 servers. But for
more complex tasks such as running a database server, the overhead of virtualization
places the EC2 servers at a disadvantage. It’s not always easy to distinguish between
slow CPUs, slow memory access, and virtualization overhead, but in this instance the
differences seem a bit clearer. (查看原文)
量子纠缠
电子工业出版社2010版
马丁.伊登
电子工业出版社2013版
豆友YXS
电子工业出版社2022版
DavidTian
电子工业出版社2013版
因为我在种豆子
电子工业出版社2022版
不见长安见晨雾
电子工业出版社2013版
0 有用 五小聊 2023-11-29 21:42:17 浙江
my.cnf一章帮了大忙