I am try to reduce machine come to live in production.. MySQL is making bottleneck. What i trying. I update code in one machine and also MySQL restore everything is working fine after this i am making EC2 AMI and launched machine from autoscaling group. now in this instance i am not taking and any live dump. after start MySQL and make it replication but its showing me GTID error. these all processes taking 30 to 40 minutes.
> Last_IO_Error: Got fatal error 1236 from master when
> reading data from binary log: 'The slave is connecting using CHANGE
> MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary
> logs containing GTIDs that the slave requires.
any body can tell what i doing wrong. but if i take fresh dump and restore this in live machine its working. MySQL version 5.6.17.
Asked by Obivan
(119 rep)
Sep 22, 2016, 05:20 PM
Last activity: Apr 24, 2025, 10:06 AM
Last activity: Apr 24, 2025, 10:06 AM