This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
public:module:mariadb_database:overview [2021/02/01 15:48] ronnie.chan |
public:module:mariadb_database:overview [2021/02/02 15:25] ronnie.chan |
||
---|---|---|---|
Line 10: | Line 10: | ||
| {{public:module:mariadb_database:image009.png?800}} | | | {{public:module:mariadb_database:image009.png?800}} | | ||
+ | |||
+ | ===== MariaDB Database Backup Method ===== | ||
+ | |||
+ | CloudBacko Pro's MariaDB Database backup uses a spooling method to make a consistent snapshot of the database(s) for backup. For each database backup job, CloudBacko Pro will trigger MariaDB to spool or make a copy of the database (.sql) file to the temporary folder using the mysqldump utility. | ||
+ | |||
+ | | {{public:module:mariadb_database:image011.png?800}} | | ||
+ | |||
+ | ===== Mysqldump Parameters ===== | ||
+ | |||
+ | Here is the mysqldump parameter list used for generating the spooled dump file: \\ | ||
+ | --databases \\ | ||
+ | --password \\ | ||
+ | --result-file \\ | ||
+ | --port \\ | ||
+ | --user \\ | ||
+ | --host \\ | ||
+ | --opt \\ | ||
+ | --quote-names \\ | ||
+ | --allow-keywords \\ | ||
+ | --triggersv | ||
+ | |||
+ | Example: \\ | ||
+ | For the spooling of the “nation” database to D:\Temp folder, the following parameters will be used: | ||
+ | Mysqldump --databases nation --user=user1 --password=qwerty --host=localhost --port=3306 --opt --quote-names --allow-keywords --triggers --result-file=D:\Temp\nation.sql | ||
+ | For details on mysqldump parameters please refer to https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html | ||
+ | |||
+ | ===== Backup Process ===== | ||
+ | |||
+ | The following steps are performed during a MariaDB Database backup job. | ||
+ | |||
+ | | {{public:module:mariadb_database:image075.png}} | | ||
+ | |||
+ | ==== Process A). ==== | ||
+ | |||
+ | | {{public:module:mariadb_database:image077.png}} | | ||
+ | |||
+ | ==== Process B). ==== | ||
+ | |||
+ | | {{public:module:mariadb_database:image079.png}} | | ||
+ | |||
+ | ==== Process C). ==== | ||
+ | |||
+ | | {{public:module:mariadb_database:image081.png}} | | ||
+ | |||
+ | |||