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@mariadb.com>:

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

-- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation