Shulou(Shulou.com)06/01 Report--

Source of the question:

If the slave server is the cloned master server, then the value of server-uuid must be the same, otherwise the master-slave copy will report error 1593 and restart mysql after modification

Next, let's introduce the relevant solutions. Without saying much, let's take a look at the detailed introduction.

Solution method

1. The first step is to find the installation address of mysql

Show variables like 'datadir' +-+-+ | Variable_name | Value | +-+-+ | datadir | / var/lib/mysql/ | +-+-+ 1 Row in set (0.00 sec) / / then generate a uuid through mysql to record, etc. It will be used to modify select uuid () +-+ | uuid () | +-- -+ | 2674149f-5083-11e8-be4b-080027a1f331 | +-- +

two。 Then go to the datadir directory

Cd / var/lib/mysql/vi auto.cnf// modify server-uuid

3. Restart mysql

Service mysqld restart

Summary

The above is the whole content of this article, I hope that the content of this article has a certain reference and learning value for your study or work, if you have any questions, you can leave a message and exchange, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.