maria-discuss team mailing list archive

[Umarzuki Mochlis <umarzuki@xxxxxxxxx>]

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?

2016-07-11 17:14 GMT+08:00 Guillaume Lefranc <guillaume.lefranc@xxxxxxxxxxx>:
> Hi Umarzuki,
>
> the following blog post should help you:
>
> http://severalnines.com/blog/multi-source-replication-mariadb-galera-cluster
>
> Regards,
>
> On Mon, Jul 11, 2016 at 10:23 AM Umarzuki Mochlis <umarzuki@xxxxxxxxx>
> wrote:
>>
>> Hi,
>>
>> I have a single Mariadb server 10.1 on Ubuntu 14.04 and 3 Mariadb 10.1
>> servers on Ubuntu 16.04 with multimaster setup (galera).
>>
>> Is it possible to setup replication from single server to one of
>> multimasters to keep databases and grants updated on multimaster
>> servers?
>>
>> Or should I export databases and grants from single server to any
>> member os multimaster servers?
>>
>> Thanks for any tips/hints.
>>
>> _______________________________________________
>> 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
>
> --
> Guillaume Lefranc
> Remote DBA Services Manager
> MariaDB Corporation