Updating nqs spool file
Included in the blog is an overview of different backup methodologies, overview of logical and physical backups, and some best practices and guidelines you can follow.
In the blog “The Choice of My SQL Storage Engine and its Impact on Backup Procedures” we discuss how the selection of different types of storage engines (like My ISAM, Inno DB, etc) can have an impact on your backup strategy. Backup Strategies for My SQL Galera Cluster” we discuss the different options available to you when making your backup and restore plan with special focus on doing it in a way that does not affect performance.
Read the Blog Cluster Control follows some best practices to perform backups using mysqldump or Percona xtrabackup.
Although these work for the majority of database workloads, you might still want to customize your backups. Read the Blog Whether you use unbreakable private data centers or public cloud platforms, Disaster Recovery (DR) is indeed a key issue.
By leveraging the simplicity of Bittorrent Sync, we can transfer backup files away from our cluster, enhancing the backups availability and reducing the cost of broken backup, where you can regularly verify your backups off-site.
These blog posts lists the different types of Toku DB and Percona FT files, explains their purpose, shows their location and how to move them around.
Here at Severalnines we have database experts who have written much about the topic and in this blog we will collect the top resources to help you build your own database backup strategy for My SQL and Maria DB databases more specifically.
If you are running a My SQL or Maria DB environment our best resource for you is the free whitepaper “The Dev Ops Guide to Database Backups for My SQL and Maria DB.” The guide covers the two most popular backup utilities available for My SQL and Maria DB, namely mysqldump and Percona Xtra Backup.
The basic method of creating a clone is to restore a database from a recent backup onto a different database server.
Other methods include replicating from a source database while it is up, in which case it is important the original database be unaffected by any cloning procedure.