DR Drill in MySQL 8 - InnoDB Cluster to DR environment
Hi,
We have 3 node (A,B,C) InnoDB cluster environment and 1 dedicated node/server (D) for router i.e. A-primary, B-secondary, C-secondary, D-router. There is 1 DR server (E) outside the 3 node cluster zone and it points to the primary node of the cluster. i.e. E is the slave of A.
Now we want to perform the DR drill between the cluster primary node A and DR server E. Please assist on how to achieve this. Also, suggest the alternate architecture if it is not achievable in the current setup.