There is database server with ip-address in external zone with mysql instances and nas-storage existing in internal zone. I need that database file is located in storage. I want write in my.cnf for example:
[mysqld1] port = 3306 datadir = /data/sql/mysqld1 [mysqld2] port = 3307 datadir = /nasstorage/sql_on_storage/mysqld2 bind-address = 0.0.0.0
I am planning to mount directory from storage to database server. Which is technology is better for this puspose: iSCSI or NFS?