Client Area

How to Fix MySQL Error – ER_SYNC_MASTER_REJECTED_CERTIFICATION_TRANSACTION

How to Fix MySQL Error – ER_SYNC_MASTER_REJECTED_CERTIFICATION_TRANSACTION

MySQL is a popular open-source relational database management system used by many websites and applications. However, like any software, it can encounter errors that can disrupt its normal operation. One such error is the ER_SYNC_MASTER_REJECTED_CERTIFICATION_TRANSACTION error. In this article, we will explore what this error means and how to fix it.

Understanding the ER_SYNC_MASTER_REJECTED_CERTIFICATION_TRANSACTION Error

The ER_SYNC_MASTER_REJECTED_CERTIFICATION_TRANSACTION error occurs when a replication slave server fails to apply a transaction from the master server due to a certification failure. This error typically happens when the master server’s binary log is enabled with the –log-bin option and the slave server is configured to use SSL for replication.

When the slave server receives a transaction from the master server, it verifies the SSL certificate to ensure the authenticity of the connection. If the SSL certificate is invalid or does not match the expected certificate, the slave server rejects the transaction, resulting in the ER_SYNC_MASTER_REJECTED_CERTIFICATION_TRANSACTION error.

Fixing the ER_SYNC_MASTER_REJECTED_CERTIFICATION_TRANSACTION Error

To fix the ER_SYNC_MASTER_REJECTED_CERTIFICATION_TRANSACTION error, you need to ensure that the SSL certificate used by the master server is valid and matches the expected certificate on the slave server. Here are the steps to follow:

Step 1: Verify SSL Certificate

Check the SSL certificate used by the master server and ensure that it is valid and not expired. You can use OpenSSL to view the details of the certificate:

openssl x509 -in /path/to/certificate.crt -text -noout

If the certificate is invalid or expired, you need to obtain a valid certificate from a trusted certificate authority (CA) and replace the old certificate on the master server.

Step 2: Update Slave Server Configuration

On the slave server, update the MySQL configuration file (usually located at /etc/my.cnf or /etc/mysql/my.cnf) to include the SSL-related settings:

[mysqld]
ssl-ca=/path/to/ca.crt
ssl-cert=/path/to/server.crt
ssl-key=/path/to/server.key

Replace /path/to/ca.crt, /path/to/server.crt, and /path/to/server.key with the actual paths to the SSL certificate files on the slave server.

Step 3: Restart MySQL Service

After updating the configuration file, restart the MySQL service on the slave server to apply the changes:

sudo service mysql restart

Once the MySQL service is restarted, the slave server should be able to establish a secure SSL connection with the master server and successfully apply the transactions without encountering the ER_SYNC_MASTER_REJECTED_CERTIFICATION_TRANSACTION error.

Summary

The ER_SYNC_MASTER_REJECTED_CERTIFICATION_TRANSACTION error can occur when a replication slave server fails to apply a transaction from the master server due to a certification failure. To fix this error, you need to verify the SSL certificate used by the master server and update the slave server’s configuration to include the correct SSL settings. By following these steps, you can resolve the error and ensure smooth replication between the master and slave servers.

For more information about VPS hosting and how it can benefit your website or application, visit Server.HK. Our Hong Kong VPS hosting solutions offer high performance and reliability for your hosting needs.