- 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
Author
Federico Razzoli
Reviewers
Josh King
Daniel Parnell
Giacomo Picchiarelli
Philipp Wollermann
Commissioning Editor
Kunal Parikh
Acquisition Editor
Reshma Raman
Content Development Editor
Akshay Nair
Technical Editor
Mrunmayee Patil
Copy Editors
Sarang Chari
Mradula Hegde
Adithi Shetty
Project Coordinator
Swati Kumari
Proofreaders
Stephen Copestake
Paul Hindle
Joanna McMahon
Indexer
Hemangini Bari
Graphics
Abhinash Sahu
Production Coordinator
Shantanu N. Zagade
Cover Work
Shantanu N. Zagade
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.