[MDEV-15790] how to connect 3 node cluster from MySQL workbench (DB is MariaDB) Created: 2018-04-05 Updated: 2018-04-05 Resolved: 2018-04-05 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Critical |
| Reporter: | Kishor Bhagat | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Description |
|
i have setup 3 node mariadb galera cluster. i can connect to database using DBArtisan and provide all 3 nodes as host, so, when one host goes down, DBARtisan still continue to stay connected to database using other live nodes. i like to provide same or similar connect string when connecting from MySQL Workbench, however i am not aware of how to put all server names as hostname when connecting from MySQL Workbecnh. Can someone help, how we can connect to nodes of Galera so, that, when one node is down mysql work bench can connect to other nodes. i need to show a demo to management how mariadb can continue to stay connected to other nodes when any node is crashed. |
| Comments |
| Comment by Daniel Black [ 2018-04-05 ] |
|
Galera provides HA of the cluster. It doesn't provide a client -> cluster failover. MaxScale, TCP proxies, Corosync IP migration, multi-database aware application and connections (and probably others) provide that form of HA. Please note this issue tracker isn't a support forum. Please use IRC, the maria-discuss email list or a consultant. |