Avatar of marrowyung
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?


LinuxMySQL ServerLinux Distributions

Avatar of undefined
Last Comment
marrowyung
ASKER CERTIFIED SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Blurred text
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.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of David Favor
David Favor
Flag of United States of America image

Blurred text
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.
Avatar of marrowyung
marrowyung

ASKER

Tomas ,

 DR is possible on all of these DBMS. So your statement that they can't do it is false. 

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 .

Using MariaDB MaxScale will simplify the application development and take care of a lot of what David mentions. 

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 ?

Avatar of marrowyung
marrowyung

ASKER

from you link:

User generated image

they are not the same but galara cluster is itself the replication, confusing.


Not so confusing. The text says it all.
User generated image
Best regards,
    Tomas Helgi

Avatar of marrowyung
marrowyung

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.
Avatar of marrowyung
marrowyung

ASKER

tks both.
Linux
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
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo