public:module:mariadb_database:preparation
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
public:module:mariadb_database:preparation [2021/02/02 13:33] ronnie.chan |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Preparation ====== | ||
| - | ---- | ||
| - | |||
| - | ===== Hardware Requirement ===== | ||
| - | ---- | ||
| - | |||
| - | To achieve the optimal performance when CloudBacko Pro is running on your machine, refer to this [[public:edition:cloudbacko_pro:hardware_requirement|list of hardware requirements]]. | ||
| - | |||
| - | ===== Software Requirement ===== | ||
| - | ---- | ||
| - | |||
| - | Make sure the operating system where you have the MariaDB Database Server installed is compatible with the CloudBacko Pro. Refer to these lists of [[public:edition:cloudbacko_pro:supported_platforms|compatible operating systems]] and [[public:edition:cloudbacko_pro:supported_applications|application versions]]. | ||
| - | |||
| - | ===== Antivirus Exclusion ===== | ||
| - | ---- | ||
| - | |||
| - | To optimize performance of CloudBacko Pro on Windows, and to avoid conflict with your antivirus software, refer to this [[public:faq:antivirus_exclusion|list of processes and directory paths that should be added to all antivirus software white-list / exclusion list]]. | ||
| - | |||
| - | ===== CloudBacko Pro Installation ===== | ||
| - | ---- | ||
| - | |||
| - | Make sure that the latest version of CloudBacko Pro is installed directly on the machine where the MariaDB database(s) are hosted. | ||
| - | |||
| - | <WRAP info> | ||
| - | Backup and restore of MariaDB database(s) running on a remote machine is not supported. | ||
| - | </WRAP> | ||
| - | |||
| - | ===== Java Heap Size ===== | ||
| - | ---- | ||
| - | |||
| - | The default Java heap size setting on CloudBacko Pro is 2048MB. It is highly recommended to increase the Java heap size setting to be at least 4096MB to improve backup and restore performance. The actual heap size is dependent on amount of free memory available on your MariaDB Database Server. See [[public:edition:cloudbacko_pro:faq:how_to_increase_java_heap_size|how to change CloudBacko Pro's Java heap size]]. | ||
| - | |||
| - | ===== Network Drive ===== | ||
| - | ---- | ||
| - | |||
| - | The login accounts for network drives must have read and write access permission to ensure that backup and restore would be successful. | ||
| - | |||
| - | |||
| - | ===== MariaDB Version ===== | ||
| - | ---- | ||
| - | |||
| - | For details of all supported MariaDB versions please refer to this [[public:edition:cloudbacko_pro:supported_applications|Software Compatibility List]]. To verify the MariaDB database version you can run the following query: | ||
| - | |||
| - | Example: MariaDB database version 10.4.12 | ||
| - | <code> | ||
| - | MariaDB [(none)]> select version(); | ||
| - | +-----------------+ | ||
| - | | version() | | ||
| - | +-----------------+ | ||
| - | | 10.4.12-MariaDB | | ||
| - | +-----------------+ | ||
| - | 1 row in set (0.00 sec) | ||
| - | |||
| - | MariaDB [(none)]> | ||
| - | </code> | ||
| - | |||
| - | For some older MariaDB database versions, to connect to MariaDB database use the **mysql –u root –p** command | ||
| - | |||
| - | Example: MariaDB database version 10.1.22 | ||
| - | <code> | ||
| - | >mysql -u root -p | ||
| - | Enter password: ******** | ||
| - | Welcome to the MariaDB monitor. Commands end with ; or \g. | ||
| - | Your MariaDB connection id is 17 | ||
| - | Server version: 10.1.22-MariaDB mariadb.org binary distribution | ||
| - | |||
| - | Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. | ||
| - | |||
| - | Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. | ||
| - | |||
| - | MariaDB [(none)]> select version(); | ||
| - | +-----------------+ | ||
| - | | version() | | ||
| - | +-----------------+ | ||
| - | | 10.1.22-MariaDB | | ||
| - | +-----------------+ | ||
| - | 1 row in set (0.00 sec) | ||
| - | </code> | ||
| - | |||
| - | ===== MariaDB Database Status ===== | ||
| - | ---- | ||
| - | |||
| - | The MariaDB database instance must be online. | ||
| - | |||
| - | Example: MariaDB database version 10.4.12 | ||
| - | |||
| - | | {{public:module:mariadb_database:image015.png?800}} | | ||
| - | |||
| - | For some older MariaDB database versions check the MySQL, which is the MariaDB database, instance is online. | ||
| - | |||
| - | Example: MariaDB database version 10.1.22 | ||
| - | |||
| - | | {{public:module:mariadb_database:image017.png?800}} | | ||
| - | |||
| - | ===== TCP/IP Port ===== | ||
| - | ---- | ||
| - | |||
| - | Check the listening port of the MariaDB database instance (default is 3306) using the command **netstat –an** | ||
| - | |||
| - | <code> | ||
| - | C:\>netstat -an | ||
| - | |||
| - | Active Connections | ||
| - | |||
| - | Proto Local Address Foreign Address State | ||
| - | TCP 0.0.0.0:135 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:445 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:2179 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:5985 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:47001 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:49664 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:49665 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:49666 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:49668 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:49669 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:49670 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:49671 0.0.0.0:0 LISTENING | ||
| - | TCP 0.0.0.0:50000 0.0.0.0:0 LISTENING | ||
| - | TCP 10.16.10.88:139 0.0.0.0:0 LISTENING | ||
| - | </code> | ||
| - | |||
| - | ===== Mysqldump Utility ===== | ||
| - | ---- | ||
| - | |||
| - | The mysqldump utility is installed on the MariaDB database server. | ||
| - | |||
| - | Example: The default location for the mysqldump utitlity for MariaDB v10.4 is located in the following folder **C:\Program Files\MariaDB 10.4\bin** | ||
| - | |||
| - | ===== Mysqldump Utility Version ===== | ||
| - | ---- | ||
| - | |||
| - | The mysqldump utility is the same version as the MariaDB database. | ||
| - | |||
| - | To check the mysqldump version use the **mysqldump ––version** command. | ||
| - | |||
| - | <code> | ||
| - | C:\Program Files\MariaDB 10.4\bin>mysqldump --version | ||
| - | mysqldump Ver 10.17 Distrib 10.4.12-MariaDB, for Win64 (AMD64) | ||
| - | |||
| - | C:\Program Files\ MariaDB 10.4\bin> | ||
| - | </code> | ||
| - | |||
| - | ===== User Account Privileges ===== | ||
| - | ---- | ||
| - | |||
| - | A MariaDB database user account with the following privileges must be setup for the backup operation. | ||
| - | |||
| - | <code> | ||
| - | MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO "username"@"localhost" IDENTIFIED BY "password"; | ||
| - | Query OK, 0 rows affected (0.003 sec) | ||
| - | |||
| - | MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO "username"@"localhost.localdomain" IDENTIFIED BY "password"; | ||
| - | Query OK, 0 rows affected (0.002 sec) | ||
| - | |||
| - | MariaDB [(none)]> FLUSH PRIVILEGES; | ||
| - | Query OK, 0 rows affected (0.002 sec) | ||
| - | |||
| - | MariaDB [(none)]> | ||
| - | </code> | ||
| - | |||
| - | ===== Localhost ===== | ||
| - | ---- | ||
| - | |||
| - | Verify that ‘localhost’ on the MariaDB database server is resolvable using the **ping localhost** command. | ||
| - | |||
public/module/mariadb_database/preparation.1612244017.txt.gz · Last modified: 2021/02/02 13:33 by ronnie.chan
Page Tools
