Hands-On MySQL Administration: Managing MySQL on Premises and in the Cloud

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

From the brand

Databases, data science & more

Data Science

Data Visualization

Databases

Streaming

Sharing the knowledge of experts

O'Reilly's mission is to change the world by sharing the knowledge of innovators. For over 40 years, we've inspired companies and individuals to do new things (and do them better) by providing the skills and understanding that are necessary for success.

Our customers are hungry to build the innovations that propel the world forward. And we help them do just that.

Publisher ‏ : ‎ O'Reilly Media
Publication date ‏ : ‎ August 6, 2024
Edition ‏ : ‎ 1st
Language ‏ : ‎ English
Print length ‏ : ‎ 606 pages
ISBN-10 ‏ : ‎ 1098155890
ISBN-13 ‏ : ‎ 978-1098155896
Item Weight ‏ : ‎ 2.31 pounds
Dimensions ‏ : ‎ 7 x 1.25 x 9 inches
Best Sellers Rank: #1,222,384 in Books (See Top 100 in Books) #53 in MySQL Guides #139 in SQL #504 in Data Processing
Customer Reviews: 4.7 4.7 out of 5 stars (8) var dpAcrHasRegisteredArcLinkClickAction; P.when('A', 'ready').execute(function(A) { if (dpAcrHasRegisteredArcLinkClickAction !== true) { dpAcrHasRegisteredArcLinkClickAction = true; A.declarative( 'acrLink-click-metrics', 'click', { "allowLinkDefault": true }, function (event) { if (window.ue) { ue.count("acrLinkClickCount", (ue.count("acrLinkClickCount") || 0) + 1); } } ); } }); P.when('A', 'cf').execute(function(A) { A.declarative('acrStarsLink-click-metrics', 'click', { "allowLinkDefault" : true }, function(event){ if(window.ue) { ue.count("acrStarsLinkWithPopoverClickCount", (ue.count("acrStarsLinkWithPopoverClickCount") || 0) + 1); } }); });