Hands-On MySQL Administration - Arunjith Aravindan, Jeyaram Ayyalusamy

Hands-On MySQL Administration

Managing MySQL on Premises and in the Cloud
Buch | Softcover
614 Seiten
2024 | 1. Auflage
O'Reilly Media (Verlag)
978-1-0981-5589-6 (ISBN)
79,80 inkl. MwSt
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

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.

Erscheinungsdatum
Zusatzinfo Illustrationen
Verlagsort Sebastopol
Sprache englisch
Maße 178 x 233 mm
Einbandart kartoniert
Themenwelt Informatik Datenbanken Data Warehouse / Data Mining
Informatik Datenbanken MySQL
Mathematik / Informatik Informatik Programmiersprachen / -werkzeuge
ISBN-10 1-0981-5589-0 / 1098155890
ISBN-13 978-1-0981-5589-6 / 9781098155896
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Auswertung von Daten mit pandas, NumPy und IPython

von Wes McKinney

Buch | Softcover (2023)
O'Reilly (Verlag)
44,90
Datenanalyse für Künstliche Intelligenz

von Jürgen Cleve; Uwe Lämmel

Buch | Softcover (2024)
De Gruyter Oldenbourg (Verlag)
69,95