maria-discuss team mailing list archive

Thread
Date

Re: replicate to multimaster

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: Daniel Black <daniel.black@xxxxxxxxxxx>
Date: Tue, 12 Jul 2016 16:21:19 +1000
In-reply-to: <CAHW9mbx-SCup5aR6Ga+YuSHHFM3e91z-=C4tat1O2tozV-PGeg@mail.gmail.com>
Organization: IBM
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.1.1

On 12/07/16 15:10, Umarzuki Mochlis wrote:
> Guillaume Lefranc,
> 
> Thanks for that article.
> 
> If I only want to get all user grants from standalone server, would it
> be simpler to dump and restore mysq.user?

probably.

since MyISAM isn't replicated you'll need to have these in the form of
grants/create user statements.

https://www.percona.com/doc/percona-toolkit/2.1/pt-show-grants.html will
probably help.

References

replicate to multimaster
From: Umarzuki Mochlis, 2016-07-11
Re: replicate to multimaster
From: Guillaume Lefranc, 2016-07-11
Re: replicate to multimaster
From: Umarzuki Mochlis, 2016-07-12