Key Features
Book Description
This 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 learn
- Identify inefficient queries using logs and log analysis tools
- Design your indexes and optimize your queries to produce efficient query plans
- Tune MariaDB and InnoDB configuration to achieve a stabilized degree of performance and reliability
- Create and manage users, roles, and permissions
- Perform regular backups and restore data
- Share your data through several partitions, disks, or servers using techniques such as replication to make operations faster
- Set up, maintain, and troubleshoot a replication environment as well as a database cluster
Who this book is for
Table of Contents
- Understanding the Essentials
- Debugging
- Optimizing queries
- Transactions and locks
- Users and connections
- Caches
- InnoDB compression
- Backup and disaster recovering
- Replication
- Table partitioning
- Data sharding
- MariaDB Galera Cluster
Loading...
Loading...
