Hands-On MySQL Administration

Geared to intermediate- to advanced-level DBAs and IT professionals looking to enhance their MySQL skills, this guide provides a comprehensive overview on how to manage and optimize MySQL databases. You’ll learn how to create databases and implement backup and recovery, security configurations, high availability, scaling techniques, and performance tuning.

Using practical techniques, tips, and real-world examples, authors Arunjith Aravindan and Jeyaram Ayyalusamy show you how to deploy and manage MySQL, Amazon RDS, Amazon Aurora, and Azure MySQL. By the end of the book, you’ll have the knowledge and skills necessary to administer, manage, and optimize MySQL databases effectively.

• Design and implement a scalable and reliable database infrastructure using MySQL 8 on premises and cloud
• Install and configure software, manage user accounts, and optimize database performance
• Use backup and recovery strategies, security measures, and high availability solutions
• Apply best practices for database schema design, indexing strategies, and replication techniques
• Implement advanced database features and techniques such as replication, clustering, load balancing, and high availability
• Troubleshoot common issues and errors, using diagnostic tools and techniques to identify and resolve problems quickly and efficiently
• Facilitate major MySQL upgrades including MySQL 5.7 to MySQL 8

Table of Contents

Chapter 1. Introduction to MySQL 8

Chapter 2. Installing and Configuring MySQL Server

Chapter 3. Transactional Data Dictionary

and lnnoDB Architecture

Chapter 4. Backup and Recovery

Chapter 5. MySQL Security

Chapter 6. MySQL Replication

Chapter 7. High Availability and Scalability

Chapter 8. MySQL Performance Tuning

Chapter 9. MySQL Monitoring and Management

Chapter 10. How to Facilitate Major MySQL Upgrades

Chapter 11. MySQL on the Cloud: Amazon RDS

Chapter 12. MySQL on the Cloud: Amazon Aurora

Chapter 13. MySQL on the Cloud:

Azure Database for MySQL

About the Authors

Arunjith Aravindan is a highly experienced computer professional with over 14 years of Open Source and MySQL consulting expertise. Holding a Master of Computer Application (MCA) postgraduate degree, he joined Percona in 2014 as a consultant, where he collaborates with Managed Services customers to establish and maintain robust MySQL infrastructures. Arunjith specializes in performance analysis and optimization of MySQL, RDS, Aurora and Azure, query optimization, troubleshooting, as well as high availability and scalability. His dedication to staying current with industry developments is reflected in his blogs and speaking engagements at various conferences. Arunjith’s exceptional technical communication skills, coupled with his passion for Open Source and MySQL technologies, distinguish him in his field.

Jeyaram Ayyalusamy is a seasoned computer professional with over 18 years of expertise in Open Source and Oracle database technologies. His proficiency spans MySQL, PostgreSQL, MSSQL, and cloud platforms such as AWS and Azure, focusing on performance tuning and high availability. As a project manager at Doyensys since December 2014, he oversees multiple enterprise application projects, ensuring clients leverage innovation for success. Jeyaram holds certifications in Oracle, MySQL, AWS, and ITIL, reflecting his commitment to continuous learning. His passion for Open Source and diverse technologies, combined with a postgraduate degree in MSc. Information Technology, makes him a valuable asset in managing complex IT projects. Overall, Jeyaram’s extensive experience and dedication to staying current in the industry solidify him as a knowledgeable and indispensable professional.