- 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
This book is for intermediate MariaDB or MySQL users who need a more thorough comprehension of MariaDB, to administer a MariaDB server, or set of servers. Expert users of other relational DBMSs can also read this book, though they are encouraged to learn MariaDB basics using the MariaDB Knowledge Base or a MariaDB or MySQL beginner's book.
In particular, the reader of this book should already know the following topics:
- The basic concepts of a relational DBMS
- SQL language, at least at a basic level
- The syntax and structure of configuration files
Knowledge of the following topics is not necessary to understand the book but is recommended to get the best from it:
- How to write a script to automate tasks on Linux or Windows
- How to write a script or program that interacts with MariaDB
- MariaDB stored programs: stored procedures, events, and triggers
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.