Differences

This shows you the differences between two versions of the page.

--- public:module:mariadb_database:overview [2021/02/01 15:48]
ronnie.chan
+++ public:module:mariadb_database:overview [2021/02/02 15:25] (current)
ronnie.chan
@@ Line 9: / Line 9: @@
 Below is the system architecture diagram illustrating the major elements involved in the backup and restore process. In this user guide, we will focus on the end-to-end backup and restore process using CloudBacko Pro backup software.
-{{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?950}} |
+==== Process A). ====
+| {{public:module:mariadb_database:image077.png?950}} |
+==== Process B). ====
+| {{public:module:mariadb_database:image079.png?950}} |
+==== Process C). ====
+| {{public:module:mariadb_database:image081.png?950}} |

User Tools

Site Tools

Differences

Page Tools