Mastering MySQL Administration

High Availability, Security, Performance, and Efficiency

By: Y V Ravi Kumar, Arun Kumar Samayam, Naresh Kumar Miryala

Write A Review

eText | 2 May 2024

At a Glance

Format
ePUB

eText

$99.00

or 4 interest-free payments of $24.75 with

or

Instant online reading in your Booktopia eTextbook Library *

This book is your one-stop resource on MySQL database installation and server management for administrators. It covers installation, upgrades, monitoring, high availability, disaster recovery, security, and performance and troubleshooting. You will become fluent in MySQL 8.2, the latest version of the highly scalable and robust relational database system.

With a hands-on approach, the book offers step-by-step guidance on installing, upgrading, and establishing robust high availability and disaster recovery capabilities for MySQL databases. It also covers high availability with InnoDB and NDB clusters, MySQL routers and enterprise MySQL tools, along with robust security design and performance techniques. Throughout, the authors punctuate concepts with examples taken from their experience with large-scale implementations at companies such as Meta and American Airlines, anchoring this practical guide to MySQL 8.2 administration in the real world.

What YouWill Learn

Understand MySQL architecture and best practices for administration of MySQL server
Configure high availability, replication, disaster recovery with InnoDB and NDB engines
Back up and restore with MySQL utilities and tools, and configure the database for zero data loss
Troubleshoot with steps for real-world critical errors and detailed solutions

Who This Book Is For

Technical professionals, database administrators, developers, and engineers seeking to optimize MySQL databases for scale, security, and performance