Assuming I create a table such as below on Server A on stand alone mode:
CREATE TABLE external (x int unsigned not null primary key) DATA DIRECTORY = ‘/mnt/external1/data’;
The new server that joins the cluster (Server A) does not apply the location of table into “/mnt/external1/data”
The table “x” must be save be saved in “/mnt/external1/data” but instead it is saving in default “datadir” path ("/var/lib/mysql") .
How to overcome this?