4. Mysql FAQs

Problem description :

MySQL recovery failed, the log prompt is similar to:

img

Solution :

The main version of Mysql on the target and backup sides should be consistent, and there is no requirement for the minor version. For example, Mysql5.7 cannot be restored to Mysql8.4. However, Mysql8.4.1 can be restored to Mysql8.4.2

Problem description:

Mysql 8.0 adds caching_sha2_password password authentication mode, does AvatarStor support it?

Solution:

Early AvatarStor did not support caching_sha2_password, but the current version already supports it. And it automatically determines the verification mode without user selection.

There are two different authentication modes for MySql account passwords, one is mysql_native_password and the other is caching_sha2_password.

Login to MySql and execute (using querying the root account as an example):

mysql> select user,host,plugin from mysql.user where user="root";

+------+-----------+-----------------------+

| user | host | plugin |

+------+-----------+-----------------------+

| root | localhost | caching_sha2_password |

+------+-----------+-----------------------+

1 row in set (0.03 sec)

The plugin column is the password authentication mode used by the current root.

Problem description:

Does AvatarStor support MySQL physical backup?

Solution:

Stay tuned for AvatarStor's Xtrabackup for MySQL.

Problem description:

Mysql recovery error, the log is similar to:

[11:26:54.129]|[10680]|[d:\01.work\cloudbackup\trunk\backup\window\src\win32\filed\plugins\common\redirectoutput.cpp:41]|[Error]|[LogHandler::CheckScriptStatus]|ERROR 2013 (HY000) at line 938392: Lost connection to MySQL server during query

Solution:

One possibility is that the target MySQL max_allowed_packet is set too small.

To set the MySQL max_allowed_packet option to 1GB, you need to modify the MySQL configuration file (my.cnf or my.ini) and then restart the MySQL server. Here are the detailed steps:

1. Find the MySQL configuration file

   1. MySQL configuration files are usually located at:

   2. Linux : /etc/mysql/my.cnf or /etc/my.cnf

   3. Windows: C:\ProgramData\MySQL\MySQL Server 5.7\my.ini

2. Edit configuration file

   1. Open the configuration file with a text editor. You need to add or modify max_allowed_packet settings in the [mysqld] section.

   2. [mysqld]
      max_allowed_packet = 1G

3. Restart the MySQL server

4. After saving the changes to the configuration file, restart the MySQL server to apply the new settings.

   1. Linux:

   2. sudo service mysql restart

   3. Windows : You can restart the MySQL service using the Service Management Console ( services.msc ) or via the command line:

   4. net stop mysql
      net start mysql