Hands-On MySQL Administration: Managing MySQL on Premises and in the Cloud
Author: Arunjith Aravindan (Author), Jeyaram Ayyalusamy (Author)
Publisher finelybook 出版社: O’Reilly Media
Edition 版本: 1st
Publication Date 出版日期: 2024-08-06
Language 语言: English
Print Length 页数: 606 pages
ISBN-10: 1098155890
ISBN-13: 9781098155896
Book Description
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
About the Author
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.
下载地址
相关推荐
Explainable AI and Blockchain for Secure and Agile Supply Chains
Experiment with the Sense HAT: Sense the real world with your Raspberry Pi, 2nd Edition
Introduction to Statistical Computing and Visualization Using R
Communication Networks in Smart Power Grids
Cloud Application Architecture Patterns: Designing, Building, and Modernizing for the Cloud
The Kubernetes Book, 2025 Edition