marrowyung
asked on
Maria HA and DR guide
hi,
Any compressive HA and DR guide for MariaDB?
I know from MySQL, and PXC that this kind of OSDB can't do DR at all, they must be setting up 2 x cluster on each site and setup replication between them.
how about MariaDB? the same thing?
usually how many nodes minimum need for MariaDB cluster? still 2?
but I heard that MariaDB is the only MySQL variant that support replica across different network, so the Single cluster can across different site?
Any compressive HA and DR guide for MariaDB?
I know from MySQL, and PXC that this kind of OSDB can't do DR at all, they must be setting up 2 x cluster on each site and setup replication between them.
how about MariaDB? the same thing?
usually how many nodes minimum need for MariaDB cluster? still 2?
but I heard that MariaDB is the only MySQL variant that support replica across different network, so the Single cluster can across different site?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
from you link:
they are not the same but galara cluster is itself the replication, confusing.
they are not the same but galara cluster is itself the replication, confusing.
Not so confusing. The text says it all.
Best regards,
Tomas Helgi
Best regards,
Tomas Helgi
ASKER
if we use MariaDB cluster I don't think one should use MariaDB replication but Galera cluster,.
MariaDB cluster includes the Galera cluster.
so this is the only thing make the HA and DR for MariaDB.
MariaDB cluster includes the Galera cluster.
so this is the only thing make the HA and DR for MariaDB.
ASKER
tks both.
ASKER
do you have a reference on it ? in here the MySQL experts from oracle also said MySQL e.g., by default , do not have DR auto failover and I ask how can we archive that using MySQL
He said, must be using 2 x innoDB cluster , one in PROD and one in DR. then setup replication between them.
then on top setup mySQL router on PROD and DR site, then on top of MySQL router, VIP failovering. (sth like what David said)
this is how it architect for mYSQL, but for MariaDB, I know it is a bit different and one single cluster can across site but I never try that before.
I believe that PXC also the same thing as PXC is based on MariaDB .
why MariaDB maxscale can simplfiy that ? as maxscale is going to be the single point of contact and no need to worry about the HA code in application ?