Showing entries 1 to 2
Displaying posts with tag: auto.cnf (reset)
Quick Look – MySQL Data Directory Files

Do you know what lies inside your MySQL Data Directory? This article is a quick guide about the files stored inside MySQL data directory. Data managed by the MySQL server…

The post Quick Look – MySQL Data Directory Files first appeared on Change Is Inevitable.

Resolving Error: master and slave have equal MySQL server UUIDs

If you’ve run into the following error, then there area couple quick fixes:

Errno: 1593
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.

To give some background first, starting in MySQL 5.6, the server generates a true UUID in addition to the –server-id supplied by the user. This is ultimately to help with new replication features.

From a under-the-hood view, when starting, the MySQL server automatically obtains a UUID as follows (per the manual):

  1. Attempt to read and use the UUID written in the file data_dir/auto.cnf (where data_dir is the server’s data directory); exit on success.
  2. Otherwise, generate a new UUID and save it to this file, creating the file if necessary.
[Read more]
Showing entries 1 to 2