Hi, Have you considered using Xtrabackup to create a replication slave? This is essentially a binary copy kept in sync with the innodb transaction log, and it works great.
On Wed, Jan 17, 2018 at 12:55 PM, Conor Murphy < [email protected]> wrote: > > Hi Marko, > > > I don't think that's an option > > - It would interfere with the normal operations on the master, currently > we use a "FLUSH TABLES WITH READ LOCK" with an LVM snapshot to get a > consistent copy of the database while the system is up and running. > Changing the PARTITIONs to TABLEs would mean having to stop the running > system. > > - I haven't checked this in a while (> a year), but the last time we > looked at swapping a TABLE back to a PARTITION, it took hours, I think it's > because it validates that the rows in the TABLE belong in the PARTITION > according to the partitioning scheme. MySQL has the "WITHOUT VALIDATION" > option to overcome this > > Regards, > Conor > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
