<div><p>How can you realize MySQL's full power? With <i>High Performance MySQL</i>, 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 p
High Performance MySQL: Proven Strategies for Operating at Scale
โ Scribed by Silvia Botros, Jeremy Tinley
- Publisher
- O'Reilly Media
- Year
- 2021
- Tongue
- English
- Leaves
- 388
- Edition
- 4
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
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
โฆ Subjects
MySQL; Tuning; Replication; Load Balancing; High Availability;
๐ SIMILAR VOLUMES
<div><p>How can you realize MySQL's full power? With <i>High Performance MySQL</i>, you'll learn advanced techniques for everything from choosing the right abstraction layer for databases to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve thei
Sales force effectiveness drives every company's success, but keeping a sales organization at the top of its game is a constant challenge. As experts in the field, Andy Zoltners and Prabha Sinha have helped sales leaders around the world perfect their sales strategy, operations, and execution.
<p><i>High Performance MySQL</i> teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries, and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardwar
MySQL architecture and history -- Benchmarking MySQL -- Profiling server performance -- Optimizing schema and data types -- Indexing for high performance -- Query performance optimization -- Advanced MySQL features -- Optimizing server settings -- Operating system and hardware optimization -- Replic