← Back to team overview

maria-discuss team mailing list archive

Re: Replication to galera cluster

 

On Tue, Nov 17, 2015 at 11:57 AM, Igor Mazur <igor.kozlov@xxxxxxxxx> wrote:

> Hi,
>
> I've tried to setup replication from production MariaDB (lets name proddb)
> to a data warehouse on Galera cluster (dw1, dw2 and dwarbitrator - last is
> a node with garb).
>
> Made master-slave link between proddb and dw1. And on dw1 I have actual
> data, but they are not updated on dw2.
>
> Other schemas successfully transfer their updates between dw1 and dw2 as
> required. Looks like only difference that other schemas are updated with
> direct requests to dw1 and dw2, and replicated schema is updated only
> through replication.
>


Try turning on log-slave-updates on dw1.
https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-variables/#log_slave_updates

- Nirbhay


>
> Does anyone have experience with a similar configuration?
>
> Igor
>
> _______________________________________________
> 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
>
>

Follow ups

References