[MXS-1857] Maxscale configuration needed for master<->master replication Created: 2018-05-07 Updated: 2018-05-10 Resolved: 2018-05-07 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | failover |
| Affects Version/s: | 2.2.5 |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Venkatarao Beru | Assignee: | Unassigned |
| Resolution: | Won't Do | Votes: | 0 |
| Labels: | Maxscale, replication | ||
| Environment: |
Development |
||
| Description |
|
We have installed Mariadb 10.2.12 on two servers A and B then setup Master< FYI, Server A is on ReadWrite mode and Server B is in ReadOnly mode. Our intention is to pass write operations to Server A and read operations to Server B only. Please let me know the configuration of Maxscale about this replication setup. Thanks, |
| Comments |
| Comment by markus makela [ 2018-05-07 ] |
|
As this is not a technical task, I will close this issue. Please took at the MaxScale tutorials for examples on how to configure your cluster. If you would like to receive help with your configuration or setup, I would recommend contacting the MariaDB Corporation who offer such assistance. |
| Comment by Venkatarao Beru [ 2018-05-08 ] |
|
Thank you Markus makela. Just would like to get a confirmation,is it possible to perform switch over and failover in MASTER<->MASTER replication configuration by using Maxscale 2.2.5 or not? Thanks, |
| Comment by Venkatarao Beru [ 2018-05-09 ] |
|
Waiting for your updates/suggestions about my last comment... Thanks, |
| Comment by markus makela [ 2018-05-10 ] |
|
The MariaDBMon failover mechanism does not support multi-master configurations (mainly because it is redundant if all connections go though MaxScale). The recommended approach would be to instead use normal Master→Slave replication and allow MaxScale to control who is the master. Read the section on automated failover in the MaxScale documentation, it should give you insight into what is possible with MaxScale. There is also a MaxScale tutorial on automatic failover, I'd recommend reading it for a practical viewpoint to automated failover. |
| Comment by Venkatarao Beru [ 2018-05-10 ] |
|
Thank you Makela for your confirmation. |