Subscribe to Read
Sign up today to enjoy a complimentary trial and begin exploring the world of books! You have the freedom to cancel at your convenience.
Mastering MariaDB: Debug, Secure, and Back Up Your Data for Optimum Server Performance With Mariadb
Title | Mastering MariaDB: Debug, Secure, and Back Up Your Data for Optimum Server Performance With Mariadb |
Writer | |
Date | 2025-04-03 12:34:57 |
Type | |
Link | Listen Read |
Desciption
Debug, secure, and back up your data for optimum server performance with MariaDB This book is intended for intermediate users who want to learn how to administrate a MariaDB server or a set of servers. It is aimed at MariaDB users, and hence working knowledge of MariaDB is a prerequisite. MariaDB is a community-driven fork of MySQL, and is a relational DBMS that can be used to build reliable, high-performance database servers. MariaDB combines MySQL characteristics such as replication, backup and disaster recovery, transactions and locks, and also includes important improvements to the performance, stability, security, and monitoring capabilities. Mastering MariaDBstarts with an overview of the basic features and mechanisms, which includes diagnosing and solving real-life problems such as data corruption, poorly performing queries, and deadlocks. You will learn how to improve the performance of a server by identifying slow queries, and how to choose and set up a proper backup plan and recover data when disasters occur. You will learn how to share your data through several servers using replication. By the end of this book, you will be able to configure MariaDB servers, diagnose as well as troubleshoot common transactional problems, and execute database maintenance.
Review
(Full disclosure: I am friends with the author.)"Mastering MariaDB" is a great introduction to MariaDB for intermediate level MySQL DBAs, as well as a good overall technical manual for MySQL. For example, I thought it described InnoDB locking better than the online MySQL manual. But it definitely assumes a basic knowledge in SQL, so beginner DBAs should come back to this book later, or use it for reference alongside simpler textbooks.Razzoli has a fluid writing style, which is a nice change from the usual terse language we expect in technical books. It makes the book a more comfortable read, given the dry subject matter. You can see more of Razzoli's writing about MariaDB and MySQL in his blog: https://falseisnotnull.wordpress.com/The book topics include: features specific to MariaDB; debugging; buffers and caches; backups and sharding. The book also focuses on stored procedures and partitioning, which are often overlooked subjects in other MySQL manuals. I was happy to see whole chapter on query tuning, because that's a lost art in database administration and a common bottleneck to optimal server performance. And the last section covers the step-by-step setup and troubleshooting of MariaDB Galera Clusters, so it's well worth a read if you want to test Galera for your own systems.I would have liked the book to be a bit more interactive; it doesn't say which MariaDB version it's referring to so that you could download it and play along (other than to point out when certain features were added), and there aren't very many examples compared to similar books. However, the theory is a good basis for further investigation and I will be coming back to this book in the future.