Description
Familiarize yourself with the MariaDB system and build high-performance applications
About This Book
- Build multiple slaves and load balance with HA-Proxy
- Explore MariaDB 10 features like GTID replication or Sharding the use of Spider
- This is a step by step tutorial guide that can assist you build high performance applications
Who This Book Is For
This book is aimed at system administrators/architects or DBAs who wish to learn more about how to grow their current infrastructure to strengthen larger traffic.
Before beginning with this book, we expect you to be well-practiced with MySQL/MariaDB for common usage. It is possible for you to to get a grasp quickly in case you are comfortable with learning and building large infrastructures for MariaDB the use of Linux.
What You Will Learn
- Set up master/slave classical replications and make them scale easily, even over WAN
- Create a dual master replication with load balancer and cluster software
- Shard your data the use of the Spider engine
- Grow your write infrastructure by setting up a Galera Cluster
- Make your Galera Cluster and replication work together to build complex solutions
- Optimize your engine and identify bottlenecks
- Compare the Galera and MySQL Cluster
- Graph your data and tools solution
- Build a Galera disaster recovery solution
In Detail
Designing and maintaining a huge amount of data in production is not an easy task. Understanding how solutions work, what kind of differences exist between them, and how to get them working is necessary before designing a solution for production. MariaDB High Performance will help you avoid mistakes, bad designs, and incorrect strategic choices.
This book will throw light on important and crucial subjects such as which hardware must be used in which situation and what the bottlenecks generally are. You are going to get acquainted with the latest addition to the MariaDB family, known as Spider, and You are going to get to know how data sharding is carried out across several MariaDB servers the use of Spider.