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 <conor_mark_murphy@hotmail.com> 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     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp