asked on
ASKER
ASKER
ASKER
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.
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 ?