Arunjith Aravindan, Jeyaram Ayyalusamy

eBook, PDF

Hands-On MySQL Administration (eBook, PDF)

Beschreibung

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 cloudInstall and configure software, manage user accounts, and optimize database performanceUse backup and recovery strategies, security measures, and high availability solutionsApply best practices for database schema design, indexing strategies, and replication techniquesImplement advanced database features and techniques such as replication, clustering, load balancing, and high availabilityTroubleshoot common issues and errors, using diagnostic tools and techniques to identify and resolve problems quickly and efficientlyFacilitate major MySQL upgrades including MySQL 5.7 to MySQL 8

Technische Details

• Geräte: PC
• mit Kopierschutz
• Größe: 20.06MB
• FamilySharing(5)

Barrierefreiheit

• Text-to-Speech

Autor

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.

Produktdetails

• Verlag: O'Reilly Media
• Seitenzahl: 608
• Erscheinungstermin: 28. Juni 2024
• Englisch
• ISBN-13: 9781098155865
• Artikelnr.: 72415638