Mastering MariaDB

Key Features

Book Description

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