[Maria-discuss] Replication to galera cluster
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. Does anyone have experience with a similar configuration? Igor
On Tue, Nov 17, 2015 at 11:57 AM, Igor Mazur <igor.kozlov@gmail.com> 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-v... - Nirbhay
Does anyone have experience with a similar configuration?
Igor
_______________________________________________ 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
Yes, I missed this parameter. Thank you! 2015-11-17 19:35 GMT+02:00 Nirbhay Choubey <nirbhay@mariadb.com>:
On Tue, Nov 17, 2015 at 11:57 AM, Igor Mazur <igor.kozlov@gmail.com> 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-v...
- Nirbhay
Does anyone have experience with a similar configuration?
Igor
_______________________________________________ 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
participants (2)
-
Igor Mazur -
Nirbhay Choubey