What do you think?
Rate this book
Mastering MariaDB: Debug, secure, and back up your data for optimum server performance with MariaDB
Debug, secure, and back up your data for optimum server performance with MariaDBAbout This BookMonitor database activity and the major operating system parameters to improve performanceTweak the behaviour of a large number of servers to achieve the desired level of stability and reliabilitySolve the typical problems related to running a server, such as slow queries, long locks, and so onA practical guide to implementing MariaDB to administrate servers and improve their performanceWho This Book Is ForThis 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.
What You Will LearnIdentify inefficient queries using logs and log analysis toolsDesign your indexes and optimize your queries to produce efficient query plansTune MariaDB and InnoDB configuration to achieve a stabilized degree of performance and reliabilityCreate and manage users, roles, and permissionsPerform regular backups and restore dataShare your data through several partitions, disks, or servers using techniques such as replication to make operations fasterSet up, maintain, and troubleshoot a replication environment as well as a database clusterIn DetailMariaDB 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.
What You Will LearnIdentify inefficient queries using logs and log analysis toolsDesign your indexes and optimize your queries to produce efficient query plansTune MariaDB and InnoDB configuration to achieve a stabilized degree of performance and reliabilityCreate and manage users, roles, and permissionsPerform regular backups and restore dataShare your data through several partitions, disks, or servers using techniques such as replication to make operations fasterSet up, maintain, and troubleshoot a replication environment as well as a database clusterIn DetailMariaDB 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.
386 pages, Kindle Edition
First published January 1, 2014
5 people are currently reading
8 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 3 of 3 reviews
January 7, 2015
(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.
"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.
January 5, 2015
MariaDB is a fork of MySQL with additional features added. MariaDB 10.0 is essentially MySQL 5.5 with some additional features taken from MySQL 5.6 and Percona MySQL.
Therefore MariaDB 10.0 is compatible with MySQL 5.5. MySQL 5.6 is not as stable as MySQL 5.5. MariaDB 10.0 maintains the stability gained from MySQL 5.5 and 5.6 features that didn't compromise that stability.
Mastering MariaDB is geared towards database administration. The topics presented are covered by most MySQL database administration books with the exception of the last two chapters, which are sharding and the Galera cluster.
Overall Mastering MariaDB covered most topics adequately, however the handling of some topics failed to provide in-depth insights. My expectation from the title was that this book would have covered some topics more thoroughly.
The book is an excellent resource for intermediate MySQL database administrators, but it may disappoint the more experienced/senior database administrators.
There are some topics that are not covered sufficiently
- TokuDB storage engine
- Linux system configurations
- Performance optimization
- Database monitoring
- Configuration management tools use to manage a large MySQL environment (including Cloud providers or Virtual environments)
The thing I found missing from this book is how to use the information provided in the book in an atypical scenario. The author would explain a subject but didn't spend sufficient time to demonstrate how to make use of it. When examples were provided, they were simple and standard.
I like that Mastering MariaDB provides details of some of the MariaDB configuration settings that are not well known. These settings are generally not implemented or configured but the knowledge of these settings are essential for performance tuning and troubleshooting.
I rate the book a 4 out of 5 with the corollary that you would need to supplement this book with additional resources that delve deeper into each of the topics the book covers.
Therefore MariaDB 10.0 is compatible with MySQL 5.5. MySQL 5.6 is not as stable as MySQL 5.5. MariaDB 10.0 maintains the stability gained from MySQL 5.5 and 5.6 features that didn't compromise that stability.
Mastering MariaDB is geared towards database administration. The topics presented are covered by most MySQL database administration books with the exception of the last two chapters, which are sharding and the Galera cluster.
Overall Mastering MariaDB covered most topics adequately, however the handling of some topics failed to provide in-depth insights. My expectation from the title was that this book would have covered some topics more thoroughly.
The book is an excellent resource for intermediate MySQL database administrators, but it may disappoint the more experienced/senior database administrators.
There are some topics that are not covered sufficiently
- TokuDB storage engine
- Linux system configurations
- Performance optimization
- Database monitoring
- Configuration management tools use to manage a large MySQL environment (including Cloud providers or Virtual environments)
The thing I found missing from this book is how to use the information provided in the book in an atypical scenario. The author would explain a subject but didn't spend sufficient time to demonstrate how to make use of it. When examples were provided, they were simple and standard.
I like that Mastering MariaDB provides details of some of the MariaDB configuration settings that are not well known. These settings are generally not implemented or configured but the knowledge of these settings are essential for performance tuning and troubleshooting.
I rate the book a 4 out of 5 with the corollary that you would need to supplement this book with additional resources that delve deeper into each of the topics the book covers.
April 10, 2015
A great book, practical and concise! Mastering is just the right word. Packt Publishing unveiled a good book.
This book provides the knowledge needed to administrate the MariaDB server and clusters of servers.
It helps to master database development on the MariaDB server,
It helps administrators how to maintain a MariaDB server, diagnosing and solving problems encounter on production, such as MariaDB errors, logs, and locks.
Performance can be a bottleneck and administrators or Dba will love how this books shows the way to improve the performance of a server by identifying slow queries.
I really loved the way the author dealt with set up a proper backup plan and recover data when disaster occurs .
The galleria arbitrator was not forgotten, this special type of node designed to help solve the split brain problem.
A great book, I really love it and use it on my daily work.
What I dislike:
the font and indentation of command-line input or output, this font in bold makes reading painful ( really ! )
i.e the show processlist output is awful( sorry )
despite that, I would recommend this book !
thanks a lot.
This book provides the knowledge needed to administrate the MariaDB server and clusters of servers.
It helps to master database development on the MariaDB server,
It helps administrators how to maintain a MariaDB server, diagnosing and solving problems encounter on production, such as MariaDB errors, logs, and locks.
Performance can be a bottleneck and administrators or Dba will love how this books shows the way to improve the performance of a server by identifying slow queries.
I really loved the way the author dealt with set up a proper backup plan and recover data when disaster occurs .
The galleria arbitrator was not forgotten, this special type of node designed to help solve the split brain problem.
A great book, I really love it and use it on my daily work.
What I dislike:
the font and indentation of command-line input or output, this font in bold makes reading painful ( really ! )
i.e the show processlist output is awful( sorry )
despite that, I would recommend this book !
thanks a lot.
Displaying 1 - 3 of 3 reviews