Tags:
IT
In 2012 I was working in a mall Startup as a Software Engineer but also happened to be a part time System Administrator because we just did not have one.
At some point we got more users and the mysql server became a bottleneck.
This book helped me to setup replication and load balancing and also find some queries that caused to much load because an index was missing.
But only some years later in a different company I would I would setup a more sophisticated solution that goes beyond this book with transparent load balancing through the MaxScale proxy and MHA for automatically switching the master role and replication setup in the mariadb cluster.