[MXS-4412] Add ability to use SkySQL for backends Created: 2022-11-23 Updated: 2023-10-04 Resolved: 2023-10-04 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | New Feature | Priority: | Major |
| Reporter: | Manjot Singh (Inactive) | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | None | ||
| Description |
|
This means working with the restricted permissions model for monitors and routers. Also any failover action should utilize the skysql replication procs vs commands like CHANGE MASTER TO: https://mariadb.com/docs/skysql/data-operations/replication/ |
| Comments |
| Comment by markus makela [ 2022-12-02 ] |
|
Is this about using SkySQL as replicas of on-prem primaries? |
| Comment by Manjot Singh (Inactive) [ 2022-12-02 ] |
|
Yes but also to use skysql as a replica of skysql or on-prem as a replica of skysql. |
| Comment by Todd Stoffel (Inactive) [ 2023-04-04 ] |
|
Can you provide more details on how you'd like this to work? |
| Comment by Manjot Singh (Inactive) [ 2023-05-19 ] |
|
The same way it would work if you had 2 MariaDB servers. If one endpoint goes down, it should go to the second one. The only difference here is, its possibly going through another set of maxscales and has less permissions. |