Comments - MariaDB Galera
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
How application point to cluster? Eg. On Oracle RAC we point to instance.
it uses a hostname, username and password with maybe an optional port number and other connection parameters, and is the same for mariadb galera as any mysql instance. This will form part of your application settings.
Can be write/read on both node?
yes. you can read/write to all nodes. I've answered this before.
Let say i have 3 node.
xxx.xxx.xxx.10 xxx.xxx.xxx.11 xxx.xxx.xxx.12
From application with ip do i need to point? Is there any manager that can manage query and route to those ip? Like load balance or something like that?
The application can talk to any IP.
Load balancing is outside galera - see: http://galeracluster.com/documentation-webpages/loadbalancing.html
Maybe you not understand what i mean. If i point to .10 in application and suddenly cluster .10 is down, i need to change on application. What i mean is, who will control traffic to route on 3 node cluster.
Mean virtual ip will point 3 node at the same time. And this traffic control, does mariadb have it? Or need to use third party?
You really not understand. this is controlled either by:
- application (JDBC can do it)
- TCP Load-Balancer (see link above)
- SQL Proxies (there is not much out there... sql-relay is nice, but misses something, MySQL Proxy is at alpha status)