Learning MySQL – What you will find when you read it

Recently, I and my colleague Sergey Kuzmichev published a book about Learning MySQL. So, what people will find in case they are considering using the book?

The book has 16 chapters, and we go from the basics steps until more advanced ones. Our main objective is to make the DBA aware of the whole universe that surrounds the MySQL database. With that in mind, we start with the installation process on the most diverse operating systems with all necessary steps included, then we introduce the database design concepts and explain why poorly designed databases can lead to poor performance.

After this, you will start touching the basics of SQL, to select, update and delete data and how to create the database structures and its tables.

We know that from chapter 1 until 6, experienced DBAs might find it tedious since most topics are the basics to start using a database. So for this group, we recommend start reading chapter 6.

In chapter 6, we discuss the MySQL fundamental mechanisms of locks, deadlocks, and their isolation modes. As I saw at Percona, this is an issue that most DBAs face daily, and sometimes there is some misunderstanding about it. next, for those who are seeking solutions for their daily activities, chapters 8, 9, 10, and 11 are the ones that DBAs should focus on. We talk about backups, user privileges, monitoring, and tuning the database to extract the most of it.

From there, we enter a more advanced world, where more critical databases need high availability and load balancing. We talk about Galera Cluster and Group Replication, which are the two most famous clusters in the MySQL realm.

For last, we talk about bug investigation, compiling the database, and the new MySQL shell and its interesting tools.

The above mentioned are just a few of the things that I personally consider that were important for my career. Also, there are a few topics that I wish I knew when I was starting that would make my life easier.

Most of the topics have a personal touch since I faced a challenge in all of them during these years. It might sound a bit stupid, but for one or two years the only way I knew of backing up a database was using the mysqldump.

Lastly, if you got curious to see if you can learn something from this and don’t want to buy the book, you can use the following OReilly link to get 30-day access:

https://learning.oreilly.com/get-learning/?code=LMYSQL21

For those who are interested, they can be found at OReilly, Amazon and a few other sites:

https://www.oreilly.com/library/view/learning-mysql-2nd/9781492085911/

Or at Amazon: