Every one showing MySQL clustering on youtube(percona xtradb ,Galera,group replication,etc). But I want to do simple write and read replicas and also integrate with a demo with frontend+backend app!. Load balance with all of them. Can someone show me the demo? Oh, I am frustrated.!!!! Please give me proper guide someone...
can a secondary instance reside in a DR location ? i.e can we have a 3-node innodb cluster with one secondary node in DR and the rest 2 in Primary site ?