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?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
Linux
Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.
71K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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 ?