Comments - MariaDB Galera

8 years, 11 months ago Zainal abidin Mamat

Can be write/read on both node?

8 years, 11 months ago Daniel Black

yes. you can read/write to all nodes. I've answered this before.

8 years, 11 months ago Zainal abidin Mamat

Let say i have 3 node.

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?

8 years, 11 months ago Daniel Black

The application can talk to any IP.

Load balancing is outside galera - see:

8 years, 11 months ago Zainal abidin Mamat

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?

8 years, 11 months ago Massimiliano Adamo

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)

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.