Description:
MySQL Enterprise backup does not correctly restore server uuid.
IMHO server_uuid after restore should be automatically set back to the old value. That is at least the expected behaviour.
How to repeat:
+----------------+--------------------------------------+
| Variable_name | Value |
+----------------+--------------------------------------+
| server_uuid | 16a8bd0f-3632-11e7-991b-d0509970f88e |
+----------------+--------------------------------------+
./bin/mysqlbackup --user=root --backup-dir=/tmp/tape backup
./bin/mysqlbackup --user=root --backup-dir=/tmp/tape apply-log
grep uuid /tmp/tape/server-all.cnf
# server_uuid=16a8bd0f-3632-11e7-991b-d0509970f88e
./bin/mysqlbackup --user=root --datadir=/home/mysql/data/mysql-5.7 --backup-dir=/tmp/tape copy-back
./bin/mysqlbackup --version
MySQL Enterprise Backup version 4.1.0 Linux-2.6.39-400.215.10.el5uek-x86_64 [2017/03/01]
auto.cnf does not exist
2017-05-11T10:21:47.382382Z 0 [Note] Salting uuid generator variables, current_pid: 10598, server_start_time: 1494498107, bytes_sent: 0,
2017-05-11T10:21:47.382410Z 0 [Note] Generated uuid: 'a395c95c-3633-11e7-a1aa-d0509970f88e', server_start_time: 2983071804674040993, bytes_sent: 66216416
2017-05-11T10:21:47.382417Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a395c95c-3633-11e7-a1aa-d0509970f88e.
cat auto.cnf
[auto]
server-uuid=a395c95c-3633-11e7-a1aa-d0509970f88e
Suggested fix:
Create auto.cnf from server_uuid