Checking Whether the max_allowed_packet Value of the Destination Database Is too Small

In MySQLor MariaDB migration and synchronization scenarios, if the value of max_allowed_packet of the destination database is less than 100 MB, data cannot be written to the destination database. As a result, the full migration fails.

Failure Cause

The max_allowed_packet value of the destination database is too small, which may cause data fails to be written during the migration.

Handling Suggestion

Set the max_allowed_packet value greater than 100 MB in the destination database.

For a self-managed database, run the following command to change the value.
```
SET GLOBAL max_allowed_packet=Size;
```
For an RDS for MySQL instance, change the parameter by referring to Modifying Parameters of an RDS for MySQL Instance.

Parent topic: Database Parameters

Previous topic: Checking Whether the Values in the Source Oracle Database Are Out of the Ranges of the MySQL Database

Next topic: Checking Whether the Source Database User Has the Permission to Parse Logs