- 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
The primary source of documentation is the MariaDB Knowledge Base, also called KB, that contains information about related open source tools. It is also a good place to ask technical questions about MariaDB and the community will answer. The MariaDB KB can be found at:
The MariaDB Foundation has a blog that allows users to stay updated with new releases and other important news. It can be found at:
Planet MariaDB aggregates blog posts related to MariaDB at:
MariaDB's project planning tool JIRA can be used to report bugs, browse information on known bugs and their fixes, and to know when new releases are scheduled and which bug fixes and features they will contain. It can be found at:
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.