Название: Hands-On MySQL Administration: Managing MySQL on Premise and on the Cloud (3rd Early Release)
Автор: Arunjith Aravindan, Jeyaram Ayyalusamy
Издательство: O’Reilly Media, Inc.
Год: 2024-02-08
Страниц: 686
Язык: английский
Формат: epub
Размер: 45.9 MB

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.

You'll learn how to:

Design and implement a scalable and reliable database infrastructure using MySQL 8.0 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 such as MySQL 5.7 to MySQL 8

Who This Book Is For:
The Hands-On MySQL Administration book is designed for a diverse audience seeking to acquire expertise in efficiently managing MySQL both on-premise and in the Cloud. The book provides valuable insights and practical tips on how to optimize and manage MySQL databases effectively. The book is targeted at beginners, as well as intermediate to advanced-level professionals who already have a fundamental knowledge of database administration and aim to enhance their skills in MySQL. The primary audience for this book includes database administrators, developers, and IT professionals looking to manage, administer, and optimize MySQL databases efficiently.

The book can be used as a reference for daily tasks, as well as for learning and mastering new concepts. Database administrators can use the book to optimize the performance of their databases, identify and solve common issues, and learn new techniques for managing MySQL databases. Developers can also use the book to create efficient and scalable applications by learning how to design database schema and optimize queries. IT professionals can use the book to enhance their skills and keep up with the latest trends and best practices in database administration.