10% off all books and free delivery over £40
Buy from our bookstore and 25% of the cover price will be given to a school of your choice to buy more books. *15% of eBooks.

Hands-On MySQL Administration

View All Editions

£63.99 £57.59

In Stock. Same day dispatch on orders before 3pm.

Add To Wishlist
Write A Review

About

Hands-On MySQL Administration Synopsis

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 This Edition

ISBN: 9781098155896
Publication date: 12th July 2024
Author: Arunjith Aravindan, Jeyaram Ayyalusamy
Publisher: O'Reilly an imprint of O'Reilly Media
Format: Paperback
Pagination: 606 pages
Genres: Data capture and analysis
Data warehousing
Data mining
Database software