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

Author Biography

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.