Mastering MariaDB
| By: | Federico Razzoli |
| Publisher: | Packt Publishing |
| Print ISBN: | 9781783981540 |
| eText ISBN: | 9781783981557 |
| Edition: | 1 |
| Copyright: | 2014 |
| Format: | Reflowable |
Lifetime - $39.59
eBook Features
Instant Access
Purchase and read your book immediately
Read Offline
Access your eTextbook anytime and anywhere
Study Tools
Built-in study tools like highlights and more
Read Aloud
Listen and follow along as Bookshelf reads to you
Details
Table of Contents
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