MySQL error: masterandslavehaveequalMySQLserverUUIDs

MySQL error: masterandslavehaveequalMySQLserverUUIDs

MySQL error: master and slave have equal MySQL server UUIDs

Homepage → Database Technology

Background:

Read News

MySQL error: master and slave have equal MySQL server UUIDs

[Date:] Source: Linux community Author: doiido [Font:]

The MySQL error message is as follows:

Last_IO_Errno: 1593

Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.

Query the relevant information and find that this is mainly because the two servers are copied together, so the File auto Under data. the UUID in cnf is the same, so to solve this problem, you only need to modify auto. UUID in cnf

# Vi/main/mysql/data/auto. cnf
[Auto]
Server-uuid = f4863bcf-1d28-11e4-8657-000c29eec7bf
# You can change one or two values at will, or re-write one according to the preceding format.

-------------------------------------- Split line --------------------------------------

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

MySQL-5.5.38 universal binary Installation

-------------------------------------- Split line --------------------------------------

0

In Linux, MySQL is configured with master-slave nodes.

MySQL user database creation method

MySQL Error

MySQL startup error solving example (07:32:10)

Error error1045 (14:30:27) when MySQL is used for the first time)

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2015 Linux community All rights reserved Shanghai ICP filing no. 15008072-1

,