I am using MySQL 5.7 on RHEL 7.1. For cluster management I am using Pacemaker and corosync. For shared storage, I am using GFS2 file system with iSCSI server
I am trying to implement MySQL active-active cluster (both nodes running at the same time). I have two nodes with MySQL server running. I am not able to give same data directory (shared storage) for both the nodes.
I tried to change the data directory in my.cnf
file. After that the service didn't start. Currently, I am using the default storage engine i.e. InnoDB storage engine.
Is this a problem of the underlying storage engine or something else we need to change in the configuration?