Book description
Familiarize yourself with the MariaDB system and build high-performance applications
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 wrong strategic choices.
This book will throw light on important and crucial subjects such as which hardware should be used in which situation and what the bottlenecks generally are. You will get acquainted with the latest addition to the MariaDB family, known as Spider, and you will get to know how data sharding is carried out across several MariaDB servers using Spider.
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 using 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
Table of contents
-
MariaDB High Performance
- Table of Contents
- MariaDB High Performance
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
-
1. Performance Introduction
- MariaDB history
- Choosing the appropriate hardware
- Architecture types and performances
- BIOS power management optimization
- Migrating from MySQL to MariaDB
- Introduction to MariaDB engines
- Summary
- 2. Performance Analysis
- 3. Performance Optimizations
- 4. MariaDB Replication
- 5. WAN Slave Architectures
- 6. Building a Dual Master Replication
- 7. MariaDB Multimaster Slaves
- 8. Galera Cluster – Multimaster Replication
- 9. Spider – Sharding Your Data
- 10. Monitoring
- 11. Backups
- Index
Product information
- Title: MariaDB High Performance
- Author(s):
- Release date: September 2014
- Publisher(s): Packt Publishing
- ISBN: 9781783981601
You might also like
book
Mastering MariaDB
Debug, secure, and back up your data for optimum server performance with MariaDB In Detail MariaDB …
book
High Performance MySQL, 2nd Edition
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by …
book
MySQL 8 Query Performance Tuning: A Systematic Method for Improving Execution Speeds
Identify, analyze, and improve poorly performing queries that damage user experience and lead to lost revenue …
book
Learning MySQL and MariaDB
If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB—you’ve …