[root@alias mysql-install]# ./bin/mysql -uroot -proot -h127.0.0.1 -e "reset master;" Warning: Using a password on the command line interface can be insecure. [root@alias mysql-install]# ./bin/mysql -uroot -proot -h127.0.0.1 -e "SET @@GLOBAL.GTID_PURGED='02a40191-d65c-11e3-b8a8-2a89acfaf29c:1-89314:89316-100557:100559-152263:152265-215574:215576-305700:305702-344770:344772-431664:431666-453195,24cba8dd-da43-11e3-921c-0a98756bb836:1-689,7e67ed6b-d660-11e3-b8c6-0a98756bb836:1-1791233:1791235-1791239:1791241-1791245:1791247-1816883:1816885-1846563:1846565-1869802:1869804-1874203:1874205-1903278:1903280-1929061:1929063-1957685:1957687-1971884:1971886-1984132:1984134-1985937:1985939-2012894:2012896-2043049:2043051-2069478:2069480-2094102:2094104-2099572:2099574-2127296:2127298-2154710:2154712-2177817:2177819-2192156:2192158-2211021:2211023-2230039:2230041-2231280:2231282-2232228:2232230-2233615:2233617-2234852:2234854-2240504:2240506-2251421:2251423-2265007:2265009-2280667:2280669-2300586:2300588-2311953:2311955-2314202:2314204-2330894:2330896-2345420:2345422-2362415:2362417-2377365:2377367-2403223:2403225-2424741:2424743-2444902:2444904-2466773:2466775-2469526:2469528-2489219:2489221-2502093:2502095-2521095:2521097-2527414:2527416-2544664:2544666-2566413:2566415-2591500:2591502-2612981:2612983-2617988:2617990-2641328:2641330-2668401:2668403-2697540:2697542-2711747:2711749-2741519:2741521-2771312:2771314-2799560:2799562-2822744:2822746-2827100:2827102-2857056:2857058-2884225:2884227-2913394:2913396-2927212:2927214-2953959:2953961-2983588:2983590-3011673:3011675-3034166:3034168-3039080:3039082-3068448:3068450-3095644:3095646-3124703:3124705-3138502:3138504-3167751:3167753-3196840:3196842-3221839:3221841-3245132:3245134-3249604:3249606-3278467:3278469-3304940:3304942-3334071:3334073-3347429:3347431-3376206:3376208-3405138:3405140-3426886,96740795-d760-11e3-bf4b-2a89acfaf29c:1-127:129-133:135-139:141-145:147-151:153-157:159-163:165-169:171-175:177-181:183-187:189-193:195-199:201-205:207-211:213-217:219-223:225-229:231-235:237-241:243-247:249-253:255-259:261-265:267-271:273-277:279-283:285-289:291-295:297-301:303-307:309-313:315-319:321-325:327-331:333-337:339-343:345-349:351-355:357-361:363-367:369-373:375-379:381-385:387-391:393-397:399-403:405-409:411-415:417-421:423-427:429-433:435-439:441-445:447-451:453-457:459-463:465-469:471-475:477-481:483-487:489-493:495-499:501-505:507-511:513-517:519-523:525-529:531-535:537-541:543-547:549-553:555-559:561-565:567-571:573-577:579-583:585-589:591-595:597-601:603-607:609-613:615-619:621-625:627-631:633-637:639-643:645-649:651-655:657-661:663-667:669-673:675-679:681-685:687-691:693-697:699-703:705-709:711-715:717-721:723-727:729-733:735-739:741-745:747-751:753-757:759-763:765-769:771-775:777-781:783-787:789-793:795-799:801-805:807-811:813-817:819-823:825-829:831-835:837-841:843-847:849-853:855-859:861-865:867-871:873-877:879-883:885-889:891-895:897-901:903-907:909-913:915-919:921-925:927-931:933-937:939-943:945-949:951-955:957-961:963-967:969-973:975-979:981-985:987-991:993-997:999-1003:1005-1009:1011-1015:1017-1021:1023-1027:1029-1033:1035-1039:1041-1045:1047-1051:1053-1057:1059-1063:1065-1069:1071-1075:1077-1081:1083-1087:1089-1093:1095-1099:1101-1105:1107-1111:1113-1117:1119-1123:1125-1129:1131-1135:1137-1141:1143-1147:1149-1153:1155-1159:1161-1165:1167-1171:1173-1177:1179-1183:1185-1189:1191-1195:1197-1201:1203-1207:1209-1213:1215-1219:1221-1225:1227-1231:1233-1237:1239-1243:1245-1249:1251-1255:1257-1261:1263-1267:1269-1273:1275-1279:1281-1285:1287-1291:1293-1297:1299-1303:1305-1309:1311-1315:1317-1321:1323-1327:1329-1333:1335-1339:1341-1345:1347-1351:1353-1357:1359-1363:1365-1369:1371-1375:1377-1381:1383-1387:1389-1393:1395-1399:1401-1405:1407-1411:1413-1417:1419-1423:1425-1429:1431-1435:1437-1441:1443-1447:1449-1453:1455-1459:1461-1465:1467-1471:1473-1477:1479-1483:1485-1489:1491-1495:1497-1501:1503-1507:1509-1513:1515-1519:1521-1525:1527-1531:1533-1537:1539-1543:1545-1549:1551-1555:1557-1561:1563-1567:1569-1573:1575-1579:1581-1585:1587-1591:1593-1597:1599-1603:1605-1609:1611-1615:1617-1621:1623-1627:1629-1633:1635-1639:1641-1645:1647-1651:1653-1657:1659-1663:1665-1669:1671-1675:1677-1681:1683-1687:1689-1693:1695-1699:1701-1705:1707-1711:1713-1717:1719-1723:1725-1729:1731-1735:1737-1741:1743-1747:1749-1753:1755-1759:1761';" Warning: Using a password on the command line interface can be insecure. [root@alias mysql-install]# mkdir backup-dir [root@alias mysql-install]# /opt/actiontech-ha/bin/mysqlbackup --user=root --password=root --host=127.0.0.1 --backup-dir=$(pwd)/backup-dir --backup-image=$(pwd)/full --compress backup-to-imageMySQL Enterprise Backup version 3.9.0 [2013/08/23] Copyright (c) 2003, 2013, Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... /opt/actiontech-ha/bin/mysqlbackup --user=root --password=xxxx --host=127.0.0.1 --backup-dir=/home/ACTIONTECH-HA/mysql-install/backup-dir --backup-image=/home/ACTIONTECH-HA/mysql-install/full --compress backup-to-image mysqlbackup: INFO: MySQL server version is '5.6.17-log'. mysqlbackup: INFO: Got some server configuration information from running server. IMPORTANT: Please check that mysqlbackup run completes successfully. At the end of a successful 'backup-to-image' run mysqlbackup prints "mysqlbackup completed OK!". 140611 08:24:43 mysqlbackup: INFO: MEB logfile created at /home/ACTIONTECH-HA/mysql-install/backup-dir/meta/MEB_2014-06-11.08-24-43_compress_img_backup.log -------------------------------------------------------------------- Server Repository Options: -------------------------------------------------------------------- datadir = /home/ACTIONTECH-HA/mysql-install/data/ innodb_data_home_dir = innodb_data_file_path = ibdata1:1G:autoextend innodb_log_group_home_dir = /home/ACTIONTECH-HA/mysql-install/data/ innodb_log_files_in_group = 2 innodb_log_file_size = 268435456 innodb_page_size = 16384 innodb_checksum_algorithm = innodb innodb_undo_directory = /home/ACTIONTECH-HA/mysql-install/data/ innodb_undo_tablespaces = 0 innodb_undo_logs = 128 -------------------------------------------------------------------- Backup Config Options: -------------------------------------------------------------------- datadir = /home/ACTIONTECH-HA/mysql-install/backup-dir/datadir innodb_data_home_dir = /home/ACTIONTECH-HA/mysql-install/backup-dir/datadir innodb_data_file_path = ibdata1:1G:autoextend innodb_log_group_home_dir = /home/ACTIONTECH-HA/mysql-install/backup-dir/datadir innodb_log_files_in_group = 2 innodb_log_file_size = 268435456 innodb_page_size = 16384 innodb_checksum_algorithm = innodb innodb_undo_directory = /home/ACTIONTECH-HA/mysql-install/backup-dir/datadir innodb_undo_tablespaces = 0 innodb_undo_logs = 128 Backup Image Path = /home/ACTIONTECH-HA/mysql-install/full mysqlbackup: INFO: Unique generated backup id for this is 14024750833951121 mysqlbackup: INFO: Uses posix_fadvise() for performance optimization. mysqlbackup: INFO: Creating 18 buffers each of size 16794070. 140611 08:24:45 mysqlbackup: INFO: Compress Image Backup operation starts with following threads 1 read-threads 6 process-threads 1 write-threads 140611 08:24:45 mysqlbackup: INFO: System tablespace file format is Antelope. 140611 08:24:45 mysqlbackup: INFO: Starting to copy all innodb files... mysqlbackup: INFO: Copying meta file /home/ACTIONTECH-HA/mysql-install/backup-dir/backup-my.cnf. mysqlbackup: INFO: Copying meta file /home/ACTIONTECH-HA/mysql-install/backup-dir/meta/backup_create.xml. 140611 08:24:45 mysqlbackup: INFO: Copying /home/ACTIONTECH-HA/mysql-install/data/ibdata1 (Antelope file format). 140611 08:24:45 mysqlbackup: INFO: Found checkpoint at lsn 1655916. 140611 08:24:45 mysqlbackup: INFO: Starting log scan from lsn 1655808. 140611 08:24:45 mysqlbackup: INFO: Copying log... 140611 08:24:45 mysqlbackup: INFO: Log copied, lsn 1655916. mysqlbackup: Progress in MB: 200 400 600 800 1000 140611 08:24:50 mysqlbackup: INFO: Copying /home/ACTIONTECH-HA/mysql-install/data/mysql/innodb_index_stats.ibd (Antelope file format). 140611 08:24:50 mysqlbackup: INFO: Copying /home/ACTIONTECH-HA/mysql-install/data/mysql/innodb_table_stats.ibd (Antelope file format). 140611 08:24:50 mysqlbackup: INFO: Copying /home/ACTIONTECH-HA/mysql-install/data/mysql/slave_master_info.ibd (Antelope file format). 140611 08:24:50 mysqlbackup: INFO: Copying /home/ACTIONTECH-HA/mysql-install/data/mysql/slave_relay_log_info.ibd (Antelope file format). 140611 08:24:50 mysqlbackup: INFO: Copying /home/ACTIONTECH-HA/mysql-install/data/mysql/slave_worker_info.ibd (Antelope file format). 140611 08:24:50 mysqlbackup: INFO: Completing the copy of innodb files. 140611 08:24:51 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server. 140611 08:24:51 mysqlbackup: INFO: Starting to lock all the tables... 140611 08:24:51 mysqlbackup: INFO: All tables are locked and flushed to disk 140611 08:24:51 mysqlbackup: INFO: Opening backup source directory '/home/ACTIONTECH-HA/mysql-install/data/' 140611 08:24:51 mysqlbackup: INFO: Starting to backup all non-innodb files in subdirectories of '/home/ACTIONTECH-HA/mysql-install/data/' 140611 08:24:51 mysqlbackup: INFO: Adding database directory: datadir/mysql 140611 08:24:51 mysqlbackup: INFO: Adding database directory: datadir/performance_schema 140611 08:24:51 mysqlbackup: INFO: Completing the copy of all non-innodb files. 140611 08:24:51 mysqlbackup: INFO: Adding database directory: datadir/test 140611 08:24:53 mysqlbackup: INFO: A copied database page was modified at 1655916. (This is the highest lsn found on page) Scanned log up to lsn 1661496. Was able to parse the log up to lsn 1661496. Maximum page number for a log record 333 140611 08:24:53 mysqlbackup: INFO: All tables unlocked 140611 08:24:53 mysqlbackup: INFO: All MySQL tables were locked for 1.915 seconds. 140611 08:24:53 mysqlbackup: INFO: Reading all global variables from the server. 140611 08:24:53 mysqlbackup: INFO: Completed reading of all global variables from the server. 140611 08:24:53 mysqlbackup: INFO: Creating server config files server-my.cnf and server-all.cnf in /home/ACTIONTECH-HA/mysql-install/backup-dir mysqlbackup: INFO: Copying meta file /home/ACTIONTECH-HA/mysql-install/backup-dir/meta/backup_variables.txt. mysqlbackup: INFO: Copying meta file /home/ACTIONTECH-HA/mysql-install/backup-dir/datadir/ibbackup_logfile. mysqlbackup: INFO: Copying meta file /home/ACTIONTECH-HA/mysql-install/backup-dir/server-all.cnf. mysqlbackup: INFO: Copying meta file /home/ACTIONTECH-HA/mysql-install/backup-dir/server-my.cnf. mysqlbackup: INFO: Copying meta file /home/ACTIONTECH-HA/mysql-install/backup-dir/meta/backup_gtid_executed.sql. mysqlbackup: INFO: Copying meta file /home/ACTIONTECH-HA/mysql-install/backup-dir/meta/backup_content.xml. mysqlbackup: INFO: Copying meta file /home/ACTIONTECH-HA/mysql-install/backup-dir/meta/image_files.xml. 140611 08:24:54 mysqlbackup: INFO: Compressed 1024 MB of data files to 4611 kbytes (compression 99.56%). 140611 08:24:54 mysqlbackup: INFO: Compress Image Backup operation completed successfully. mysqlbackup: INFO: Image Path = /home/ACTIONTECH-HA/mysql-install/full 140611 08:24:54 mysqlbackup: INFO: MySQL binlog position: filename mysql-bin.000002, position 8849 ------------------------------------------------------------- Parameters Summary ------------------------------------------------------------- Start LSN : 1655808 End LSN : 1661496 ------------------------------------------------------------- mysqlbackup completed OK! [root@alias mysql-install]# cat backup-dir/meta/backup_gtid_executed.sql # On a new slave, issue the following command if GTIDs are enabled: SET @@GLOBAL.GTID_PURGED='02a40191-d65c-11e3-b8a8-2a89acfaf29c:1-89314:89316-100557:100559-152263:152265-215574:215576-305700:305702-344770:344772-431664:431666-453195,24cba8dd-da43-11e3-921c-0a98756bb836:1-689,7e67ed6b-d660-11e3-b8c6-0a98756bb836:1-1791233:1791235-1791239:1791241-1791245:1791247-1816883:1816885-1846563:1846565-1869802:1869804-1874203:1874205-1903278:1903280-1929061:1929063-1957685:1957687-1971884:1971886-1984132:1984134-1985937:1985939-2012894:2012896-2043049:2043051-2069478:2069480-2094102:2094104-2099572:2099574-2127296:2127298-2154710:2154712-2177817:2177819-2192156:2192158-2211021:2211023-2230039:2230041-2231280:2231282-2232228:2232230-2233615:2233617-2234852:2234854-2240504:2240506-2251421:2251423-2265007:2265009-2280667:2280669-2300586:2300588-2311953:2311955-2314202:2314204-2330894:2330896-2345420:2345422-2362415:2362417-2377365:2377367-2403223:2403225-2424741:2424743-2444902:2444904-2466773:2466775-2469526:2469528-2489219:2489221-2502093:2502095-2521095:2521097-2527414:2527416-2544664:2544666-2566413:2566415-2591500:2591502-2612981:2612983-2617988:2617990-2641328:2641330-2668401:2668403-2697540:2697542-2711747:2711749-2741519:2741521-2771312:2771314-2799560:2799562-2822744:2822746-2827100:2827102-2857056:2857058-2884225:2884227-2913394:2913396-2927212:2927214-2953959:2953961-2983588:2983590-3011673:3011675-3034166:3034168-3039080:3039082-3068448:3068450-3095644:3095646-3124703:3124705-3138502:3138504-3167751:3167753-3196840:3196842-3221839:3221841-3245132:3245134-3249604:3249606-3278467:3278469-3304940:3304942-3334071:3334073-3347429:3347431-3376206:3376208-3405138:3405140-3426886,96740795-d760-11e3-bf4b-2a89acfaf29c:1-127:129-133:135-139:141-145:147-151:153-157:159-163:165-169:171-175:177-181:183-187:189-193:195-199:201-205:207-211:213-217:219-223:225-229:231-235:237-241:243-247:249-253:255-259:261-265:267-271:273-277:279-283:285-289:291-295:297-301:303-307:309-313:315-319:321-325:327-331:333-337:339-343:345-349:351-355:357-361:363-367:369-373:375-379:381-385:387-391:393-397:399-403:405-409:411-415:417-421:423-427:429-433:435-439:441-445:447-451:453-457:459-463:465-469:471-475:477-481:483-487:489-493:495-499:501-505:507-511:513-517:519-523:525-529:531-535:537-541:543-547:549-553:555-559:561-565:567-571:573-577:579-583:585-589:591-595:597-601:603-607:609-613:615-619:621-625:627-631:633-637:639-643:645-649:651-655:657-661:663-667:669-673:675-679:681-685:687-691:693-697:699-703:705-709:711-715:717-721:723-727:729-733:735-739:741-745:747-751:753-757:759-763:765-769:771-775:777-781:783-787:789-793:795-799:801-805:807-811:813-817:819-823:825-829:831-835:837-841:843-847:849-853:855-859:861-865:867-871:873-877:879-883:885-889:891-895:897-901:903-907:909-913:915-919:921-925:927-931:933-937:939-943:945-949:951-955:957-961:963-967:969-973:975-979:981-985:987-991:993-997:999-1003:1005-1009:1011-1015:1017-1021:1023-1027:1029-1033:1035-1039:1041-1045:1047-1051:1053-1057:1059-1063:1065-1069:1071-1075:1077-1081:1083-1087:1089-1093:1095-1099:1101-1105:1107-1111:1113-1117:1119-1123:1125-1129:1131-1135:1137-1141:1143-1147:1149-1153:1155-1159:1161-1165:1167-1171:1173-1177:1179-1183:1185-1189:1191-1195:1197-1201:1203-1207:1209-1213:1215-1219:1221-1225:1227-1231:1233-1237:1239-1243:1245-1249:1251-1255:1257-1261:1263-1267:1269-1273:1275-1279:1281-1285:1287-1291:1293-1297:1299-1303:1305-1309:1311-1315:1317-1321:1323-1327:1329-1333:1335-1339:1341-1345:1347-1351:1353-1357:1359-1363:1365-1369:1371-1375:1377-1381:1383-1387:1389-1393:1395-1399:1401-1405:1407-1411:1413-1417:1419-1423:1425-1429:1431-1435:1437-1441:1443-1447:1449-1453:1455-1459:1461-1465:1467-1471:1473-1477:1479-1483:1485-1489:1491-1495:1497-1501:1503-1507:1509-1513:1515-1519:1521-1525:1527-1531:1533-1537:1539-1543:1545-1549:1551-1555:1557-1561:1563-1567:1569-1573:1575-1579:1581-1585:1587-1591:1593-1597:1599-1603:1605-1609:1611-1615:1617-1621:1623-1627:1629-1633:1635-1639:1641-1645:1647-1651:1653-1657:1659-1663:1665-1669:1671-1675:1677-1681:1683-1687:1689-1693:1695-1699:1701-1705:1707-1711:1713-1717:1719-1723:1725-1729:1731-1735:1737-1741:1743-1747:1749-1753:1755-1759:1761,ddc72234-f12b-11e3-a77f-080027956067:1-8'; # Use the following command if you want to use the GTID handshake protocol: # CHANGE MASTER TO MASTER_AUTO_POSITION=1; [root@alias mysql-install]# mkdir full-dir [root@alias mysql-install]# /opt/actiontech-ha/bin/mysqlbackup --backup-dir=$(pwd)/full-dir --backup-image=$(pwd)/full image-to-backup-dir MySQL Enterprise Backup version 3.9.0 [2013/08/23] Copyright (c) 2003, 2013, Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... /opt/actiontech-ha/bin/mysqlbackup --backup-dir=/home/ACTIONTECH-HA/mysql-install/full-dir --backup-image=/home/ACTIONTECH-HA/mysql-install/full image-to-backup-dir IMPORTANT: Please check that mysqlbackup run completes successfully. At the end of a successful 'image-to-backup-dir' run mysqlbackup prints "mysqlbackup completed OK!". 140611 08:28:48 mysqlbackup: INFO: MEB logfile created at /home/ACTIONTECH-HA/mysql-install/full-dir/meta/MEB_2014-06-11.08-28-48_image_to_backup_dir.log mysqlbackup: INFO: Uses posix_fadvise() for performance optimization. mysqlbackup: INFO: Creating 14 buffers each of size 16777216. mysqlbackup: INFO: Backup Image MEB version string: 3.9.0 [2013/08/23] mysqlbackup: INFO: The input backup image contains compressed backup. 140611 08:28:48 mysqlbackup: INFO: Image to backup-dir operation starts with following threads 1 read-threads 6 process-threads 1 write-threads 140611 08:28:48 mysqlbackup: INFO: Copying datadir/ibdata1.ibz. 140611 08:28:48 mysqlbackup: INFO: Extract: [Dir]: /home/ACTIONTECH-HA/mysql-install/full-dir/meta 140611 08:28:48 mysqlbackup: INFO: Copying datadir/mysql/innodb_index_stats.ibz. 140611 08:28:48 mysqlbackup: INFO: Copying datadir/mysql/innodb_table_stats.ibz. 140611 08:28:48 mysqlbackup: INFO: Copying datadir/mysql/slave_master_info.ibz. 140611 08:28:48 mysqlbackup: INFO: Copying datadir/mysql/slave_relay_log_info.ibz. 140611 08:28:48 mysqlbackup: INFO: Copying datadir/mysql/slave_worker_info.ibz. 140611 08:28:48 mysqlbackup: INFO: Extract: [Dir]: /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/mysql 140611 08:28:48 mysqlbackup: INFO: Extract: [Dir]: /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/performance_schema 140611 08:28:48 mysqlbackup: INFO: Extract: [Dir]: /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/test 140611 08:28:48 mysqlbackup: INFO: Extract: [Dir]: /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/mysql 140611 08:28:48 mysqlbackup: INFO: Extract: [Dir]: /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/performance_schema 140611 08:28:48 mysqlbackup: INFO: Extract: [Dir]: /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/test 140611 08:28:48 mysqlbackup: INFO: Total files as specified in image: 152 140611 08:28:48 mysqlbackup: INFO: Image to backup-dir operation completed successfully. 140611 08:28:48 mysqlbackup: INFO: Backup Image contents extracted successfully into backup-dir. Backup directory: /home/ACTIONTECH-HA/mysql-install/full-dir mysqlbackup: INFO: Source Image Path = /home/ACTIONTECH-HA/mysql-install/full mysqlbackup completed OK! [root@alias mysql-install]# cat full-dir/meta/backup_gtid_executed.sql # On a new slave, issue the following command if GTIDs are enabled: SET @@GLOBAL.GTID_PURGED='02a40191-d65c-11e3-b8a8-2a89acfaf29c:1-89314:89316-100557:100559-152263:152265-215574:215576-305700:305702-344770:344772-431664:431666-453195,24cba8dd-da43-11e3-921c-0a98756bb836:1-689,7e67ed6b-d660-11e3-b8c6-0a98756bb836:1-1791233:1791235-1791239:1791241-1791245:1791247-1816883:1816885-1846563:1846565-1869802:1869804-1874203:1874205-1903278:1903280-1929061:1929063-1957685:1957687-1971884:1971886-1984132:1984134-1985937:1985939-2012894:2012896-2043049:2043051-2069478:2069480-2094102:2094104-2099572:2099574-2127296:2127298-2154710:2154712-2177817:2177819-2192156:2192158-2211021:2211023-2230039:2230041-2231280:2231282-2232228:2232230-2233615:2233617-2234852:2234854-2240504:2240506-2251421:2251423-2265007:2265009-2280667:2280669-2300586:2300588-2311953:2311955-2314202:2314204-2330894:2330896-2345420:2345422-2362415:2362417-2377365:2377367-2403223:2403225-2424741:2424743-2444902:2444904-2466773:2466775-2469526:2469528-2489219:2489221-2502093:2502095-2521095:2521097-2527414:2527416-2544664:2544666-2566413:2566415-2591500:2591502-2612981:2612983-2617988:2617990-2641328:2641330-2668401:2668403-2697540:2697542-2711747:2711749-2741519:2741521-2771312:2771314-2799560:2799562-2822744:2822746-2827100:2827102-2857056:2857058-2884225:2884227-2913394:2913396-2927212:2927214-2953959:2953961-2983588:2983590-3011673:3011675-3034166:3034168-3039080:3039082-3068448:3068450-3095644:3095646-3124703:3124705-3138502:3138504-3167751:3167753-3196840:3196842-3221839:3221841-3245132:3245134-3249604:3249606-3278467:3278469-3304940:3304942-3334071:3334073-3347429:3347431-3376206:3376208-3405138:3405140-3426886,96740795-d760-11e3-bf4b-2a89acfaf29c:1-127:129-133:135-139:141-145:147-151:153-157:159-163:165-169:171-175:177-181:183-187:189-193:195-199:201-205:207-211:213-217:219-223:225-229:231-235:237-241:243-247:249-253:255-259:261-265:267-271:273-277:279-283:285-289:291-295:297-301:303-307:309-313:315-319:321-325:327-331:333-337:339-343:345-349:351-355:357-361:363-367:369-373:375-379:381-385:387-391:393-397:399-403:405-409:411-415:417-421:423-427:429-433:435-439:441-445:447-451:453-457:459-463:465-469:471-475:477-481:483-487:489-493:495-499:501-505:507-511:513-517:519-523:525-529:531-535:537-541:543-547:549-553:555-559:561-565:567-571:573-577:579-583:585-589:591-595:597-601:603-607:609-613:615-619:621-625:627-631:633-637:639-643:645-649:651-655:657-661:663-667:669-673:675-679:681-685:687-691:693-697:699-703:705-709:711-715:717-721:723-727:729-733:735-739:741-745:747-751:753-757:759-763:765-769:771-775:777-781:783-787:789-793:795-799:801-805:807-811:813-817:819-823:825-829:831-835:837-841:843-847:849-853:855-859:861-865:867-871:873-877:879-883:885-889:891-895:897-901:903-907:909-913:915-919:921-925:927-931:933-937:939-943:945-949:951-955:957-961:963-967:969-973:975-979:981-985:987-991:993-997:999-1003:1005-1009:1011-1015:1017-1021:1023-1027:1029-1033:1035-1039:1041-1045:1047-1051:1053-1057:1059-1063:1065-1069:1071-1075:1077-1081:1083-1087:1089-1093:1095-1099:1101-1105:1107-1111:1113-1117:1119-1123:1125-1129:1131-1135:1137-1141:1143-1147:1149-1153:1155-1159:1161-1165:1167-1171:1173-1177:1179-1183:1185-1189:1191-1195:1197-1201:1203-1207:1209-1213:1215-1219:1221-1225:1227-1231:1233-1237:1239-1243:1245-1249:1251-1255:1257-1261:1263-1267:1269-1273:1275-1279:1281-1285:1287-1291:1293-1297:1299-1303:1305-1309:1311-1315:1317-1321:1323-1327:1329-1333:1335-1339:1341-1345:1347-1351:1353-1357:1359-1363:1365-1369:1371-1375:1377-1381:1383-1387:1389-1393:1395-1399:1401-1405:1407-1411:1413-1417:1419-1423:1425-1429:1431-1435:1437-1441:1443-1447:1449-1453:1455-1459:1461-1465:1467-1471:1473-1477:1479-1483:1485-1489:1491-1495:1497-1501:1503-1507:1509-1513:1515-1519:1521-1525:1527-1531:1533-1537:1539-1543:1545-1549:1551-1555:1557-1561:1563-1567:1569-1573:1575-1579:1581-1585:1587-1591:1593-1597:1599-1603:1605-1609:1611-1615:1617-1621:1623-1627:1629-1633:1635-1639:1641-1645:1647-1651:1653-1657:1659-1663:1665-1669:1671-1675:1677-1681:1683-1687:1689-1693:1695-1699:1701-1705:1707-1711:1713-1717:1719-1723:1725-1729:1731-1735:1737-1741:1743-1747:1749-1753:1755-1759:1761,ddc72234-f12b-11e3-a77f-080027956067:1-8'; # Use the following command if you want to use the GTID handshake protocol: # CHANGE MASTER TO MASTER_AUTO_POSITION=1; [root@alias mysql-install]# /opt/actiontech-ha/bin/mysqlbackup --backup-dir=$(pwd)/full-dir --uncompress apply-log MySQL Enterprise Backup version 3.9.0 [2013/08/23] Copyright (c) 2003, 2013, Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... /opt/actiontech-ha/bin/mysqlbackup --backup-dir=/home/ACTIONTECH-HA/mysql-install/full-dir --uncompress apply-log IMPORTANT: Please check that mysqlbackup run completes successfully. At the end of a successful 'apply-log' run mysqlbackup prints "mysqlbackup completed OK!". 140611 08:29:33 mysqlbackup: INFO: MEB logfile created at /home/ACTIONTECH-HA/mysql-install/full-dir/meta/MEB_2014-06-11.08-29-33_uncompress_apply_log.log mysqlbackup: WARNING: Unknown meta variable name found and ignored. Meta file path = /home/ACTIONTECH-HA/mysql-install/full-dir/meta/backup_variables.txt Variable name = 1761,ddc72234-f12b-11e3-a77f-080027956067:1-8 -------------------------------------------------------------------- Backup Config Options: -------------------------------------------------------------------- datadir = /home/ACTIONTECH-HA/mysql-install/full-dir/datadir innodb_data_home_dir = /home/ACTIONTECH-HA/mysql-install/full-dir/datadir innodb_data_file_path = ibdata1:1G:autoextend innodb_log_group_home_dir = /home/ACTIONTECH-HA/mysql-install/full-dir/datadir innodb_log_files_in_group = 2 innodb_log_file_size = 268435456 innodb_page_size = 16384 innodb_checksum_algorithm = innodb mysqlbackup: INFO: Uses posix_fadvise() for performance optimization. mysqlbackup: INFO: Creating 18 buffers each of size 16794070. 140611 08:29:33 mysqlbackup: INFO: Uncompress operation starts with following threads 1 read-threads 6 process-threads 1 write-threads 140611 08:29:33 mysqlbackup: INFO: Uncompressing /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/ibdata1.ibz. 140611 08:29:36 mysqlbackup: INFO: Uncompressing /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/mysql/innodb_index_stats.ibz. 140611 08:29:36 mysqlbackup: INFO: Uncompressing /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/mysql/innodb_table_stats.ibz. 140611 08:29:36 mysqlbackup: INFO: Uncompressing /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/mysql/slave_master_info.ibz. 140611 08:29:36 mysqlbackup: INFO: Uncompressing /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/mysql/slave_relay_log_info.ibz. 140611 08:29:36 mysqlbackup: INFO: Uncompressing /home/ACTIONTECH-HA/mysql-install/full-dir/datadir/mysql/slave_worker_info.ibz. 140611 08:29:37 mysqlbackup: INFO: Uncompress operation completed successfully. mysqlbackup: INFO: Creating 12 buffers each of size 65678. 140611 08:29:37 mysqlbackup: INFO: Apply-log operation starts with following threads 1 read-threads 1 process-threads 140611 08:29:37 mysqlbackup: INFO: ibbackup_logfile's creation parameters: start lsn 1655808, end lsn 1661496, start checkpoint 1655916. InnoDB: Doing recovery: scanned up to log sequence number 1661496 mysqlbackup: INFO: InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 mysqlbackup: INFO: InnoDB: Setting log file size to 268435456 InnoDB: Progress in MB: 100 200 mysqlbackup: INFO: InnoDB: Setting log file size to 268435456 InnoDB: Progress in MB: 100 200 140611 08:29:38 mysqlbackup: INFO: We were able to parse ibbackup_logfile up to lsn 1661496. mysqlbackup: INFO: Last MySQL binlog file position 0 8716, file name mysql-bin.000002 140611 08:29:38 mysqlbackup: INFO: The first data file is '/home/ACTIONTECH-HA/mysql-install/full-dir/datadir/ibdata1' and the new created log files are at '/home/ACTIONTECH-HA/mysql-install/full-dir/datadir' 140611 08:29:38 mysqlbackup: INFO: Apply-log operation completed successfully. 140611 08:29:38 mysqlbackup: INFO: Full backup prepared for recovery successfully. mysqlbackup completed OK! with 1 warnings [root@alias mysql-install]# cat full-dir/meta/backup_gtid_executed.sql # On a new slave, issue the following command if GTIDs are enabled: SET @@GLOBAL.GTID_PURGED='02a40191-d65c-11e3-b8a8-2a89acfaf29c:1-89314:89316-100557:100559-152263:152265-215574:215576-305700:305702-344770:344772-431664:431666-453195,24cba8dd-da43-11e3-921c-0a98756bb836:1-689,7e67ed6b-d660-11e3-b8c6-0a98756bb836:1-1791233:1791235-1791239:1791241-1791245:1791247-1816883:1816885-1846563:1846565-1869802:1869804-1874203:1874205-1903278:1903280-1929061:1929063-1957685:1957687-1971884:1971886-1984132:1984134-1985937:1985939-2012894:2012896-2043049:2043051-2069478:2069480-2094102:2094104-2099572:2099574-2127296:2127298-2154710:2154712-2177817:2177819-2192156:2192158-2211021:2211023-2230039:2230041-2231280:2231282-2232228:2232230-2233615:2233617-2234852:2234854-2240504:2240506-2251421:2251423-2265007:2265009-2280667:2280669-2300586:2300588-2311953:2311955-2314202:2314204-2330894:2330896-2345420:2345422-2362415:2362417-2377365:2377367-2403223:2403225-2424741:2424743-2444902:2444904-2466773:2466775-2469526:2469528-2489219:2489221-2502093:2502095-2521095:2521097-2527414:2527416-2544664:2544666-2566413:2566415-2591500:2591502-2612981:2612983-2617988:2617990-2641328:2641330-2668401:2668403-2697540:2697542-2711747:2711749-2741519:2741521-2771312:2771314-2799560:2799562-2822744:2822746-2827100:2827102-2857056:2857058-2884225:2884227-2913394:2913396-2927212:2927214-2953959:2953961-2983588:2983590-3011673:3011675-3034166:3034168-3039080:3039082-3068448:3068450-3095644:3095646-3124703:3124705-3138502:3138504-3167751:3167753-3196840:3196842-3221839:3221841-3245132:3245134-3249604:3249606-3278467:3278469-3304940:3304942-3334071:3334073-3347429:3347431-3376206:3376208-3405138:3405140-3426886,96740795-d760-11e3-bf4b-2a89acfaf29c:1-127:129-133:135-139:141-145:147-151:153-157:159-163:165-169:171-175:177-181:183-187:189-193:195-199:201-205:207-211:213-217:219-223:225-229:231-235:237-241:243-247:249-253:255-259:261-265:267-271:273-277:279-283:285-289:291-295:297-301:303-307:309-313:315-319:321-325:327-331:333-337:339-343:345-349:351-355:357-361:363-367:369-373:375-379:381-385:387-391:393-397:399-403:405-409:411-415:417-421:423-427:429-433:435-439:441-445:447-451:453-457:459-463:465-469:471-475:477-481:483-487:489-493:495-499:501-505:507-511:513-517:519-523:525-529:531-535:537-541:543-547:549-553:555-559:561-565:567-571:573-577:579-583:585-589:591-595:597-601:603-607:609-613:615-619:621-625:627-631:633-637:639-643:645-649:651-655:657-661:663-667:669-673:675-679:681-685:687-691:693-697:699-703:705-709:711-715:717-721:723-727:729-733:735-739:741-745:747-751:753-757:759-763:765-769:771-775:777-781:783-787:789-793:795-799:801-805:807-811:813-817:819-823:825-829:831-835:837-841:843-847:849-853:855-859:861-865:867-871:873-877:879-883:885-889:891-895:897-901:903-907:909-913:915-919:921-925:927-931:933-937:939-943:945-949:951-955:957-961:963-967:969-973:975-979:981-985:987-991:993-997:999-1003:1005-1009:1011-1015:1017-1021:1023-1027:1029-1033:1035-1039:1041-1045:1047-1051:1053-1057:1059-1063:1065-1069:1071-1075:1077-1081:1083-1087:1089-1093:1095-1099:1101-1105:1107-1111:1113-1117:1119-1123:1125-1129:1131-1135:1137-1141:1143-1147:1149-1153:1155-1159:1161-1165:1167-1171:1173-1177:1179-1183:1185-1189:1191-1195:1197-1201:1203-1207:1209-1213:1215-1219:1221-1225:1227-1231:1233-1237:1239-1243:1245-1249:1251-1255:1257-1261:1263-1267:1269-1273:1275-1279:1281-1285:1287-1291:1293-1297:1299-1303:1305-1309:1311-1315:1317-1321:1323-1327:1329-1333:1335-1339:1341-1345:1347-1351:1353-1357:1359-1363:1365-1369:1371-1375:1377-1381:1383-1387:1389-1393:1395-1399:1401-1405:1407-1411:1413-1417:1419-1423:1425-1429:1431-1435:1437-1441:1443-1447:1449-1453:1455-1459:1461-1465:1467-1471:1473-1477:1479-1483:1485-1489:1491-1495:1497-1501:1503-1507:1509-1513:1515-1519:1521-1525:1527-1531:1533-1537:1539-1543:1545-1549:1551-1555:1557-1561:1563-1567:1569-1573:1575-1579:1581-1585:1587-1591:1593-1597:1599-1603:1605-1609:1611-1615:1617-1621:1623-1627:1629-1633:1635-1639:1641-1645:1647-1651:1653-1657:1659-1663:1665-1669:1671-1675:1677-1681:1683-1687:1689-1693:1695-1699:1701-1705:1707-1711:1713-1717:1719-1723:1725-1729:1731-1735:1737-1741:1743-1747:1749-1753:1755-1759:'; # Use the following command if you want to use the GTID handshake protocol: # CHANGE MASTER TO MASTER_AUTO_POSITION=1;