This book is your one-stop resource for MySQL database installation and server management for administrators. It covers installation, upgrades, monitoring, high availability, disaster recovery, security, performance, and troubleshooting. You'll be fluent in MySQL 8.2, the latest version of the highly scalable and reliable relational database system.
With a hands-on approach, the book offers step-by-step guidance on installing, upgrading, and building robust high availability and disaster recovery capabilities for MySQL databases. It also covers high availability with InnoDB and NDB clusters, MySQL routers, and MySQL enterprise tools, as well as robust security and performance practices. Throughout, the authors complement concepts with examples drawn from their experience with large-scale implementations at companies like Meta and American Airlines, grounding this practical guide to MySQL 8.2 administration in the real world.
What You'll Learn
Understand MySQL architecture and MySQL server administration best practices
Configure high availability, replication, and disaster recovery using the InnoDB and NDB engine modules
Create and restore backups using MySQL utilities and tools, and tune your database to avoid data loss
Step-by-step troubleshooting of real-world critical errors and detailed solutions
Who This Book Is For
Technicians, DBAs, developers, and engineers looking to optimize MySQL databases for scalability, security, and performance.
https://pixeldrain.com/u/vNKqoDgB