maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

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@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>