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?