Book description
Debug, secure, and back up your data for optimum server performance with MariaDB
In Detail
MariaDB is a community-driven fork of MySQL, and is a relational DBMS that can be used to build reliable, high-performance database servers. MariaDB combines MySQL characteristics such as replication, backup and disaster recovery, transactions and locks, and also includes important improvements to the performance, stability, security, and monitoring capabilities.
Mastering MariaDBstarts with an overview of the basic features and mechanisms, which includes diagnosing and solving real-life problems such as data corruption, poorly performing queries, and deadlocks. You will learn how to improve the performance of a server by identifying slow queries, and how to choose and set up a proper backup plan and recover data when disasters occur. You will learn how to share your data through several servers using replication. By the end of this book, you will be able to configure MariaDB servers, diagnose as well as troubleshoot common transactional problems, and execute database maintenance.
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
Table of contents
-
Mastering MariaDB
- Table of Contents
- Mastering MariaDB
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Understanding the Essentials of MariaDB
- 2. Debugging
- 3. Optimizing Queries
- 4. Transactions and Locks
- 5. Users and Connections
- 6. Caches
- 7. InnoDB Compressed Tables
-
8. Backup and Disaster Recovery
- Types of backups
- Complete and incremental backups
- Creating a dump file with mysqldump
-
Delimited text backups
- The --tab option of the mysqldump command
- Loading a dump file with the mysqlimport command
- Creating a text-delimited file with the SELECT … INTO OUTFILE command
- Dumping a table definition with the SHOW CREATE TABLE command
- Loading a dump file with the LOAD DATA INFILE statement
- Separator options and clauses
- An example to create and restore dump files
- Performing a backup using a CONNECT or CSV engine
- Physical backups
- Using the binary log for incremental backups
- Percona XtraBackup
- Securing backups
- Repairing tables
- Summary
-
9. Replication
- An overview of replication
- Choosing a binary log format
-
Configuring replication
- Configuring a new replication master
- Configuring a new replication slave
- Starting a slave
- Checking whether a slave is running
- Reconfiguring an existing slave
- Importing the data into a master
- Importing the data into a slave from a master
- Filtering binary log events
- Filtering the replication of events on the slaves
- Checksums of the binary log events
- Configuring parallel replication
- Delaying a slave
- Multisource replication
- Replication logs
- Checking the replication for errors
- Troubleshooting
- Summary
- 10. Table Partitioning
- 11. Data Sharding
- 12. MariaDB Galera Cluster
- Index
Product information
- Title: Mastering MariaDB
- Author(s):
- Release date: September 2014
- Publisher(s): Packt Publishing
- ISBN: 9781783981540
You might also like
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 …
book
MariaDB Essentials
Quickly get up to speed with MariaDB - the leading, drop-in replacement for MySQL, through this …
book
Mastering PostgreSQL 12
Master PostgreSQL 12 features such as advanced indexing, high availability, monitoring, and much more to efficiently …
book
Mastering Kubernetes
Exploit design, deployment, and management of large-scale containers About This Book Explore the latest features available …