/etc/mysql/conf.d/myserver:
[mysqld]
innodb_file_per_table
datadir = /elastidb/lib/mysql
#log-bin = /elastiblockdb/log/mysql/mysql-bin.log
general_log = true
log = /elastiblockdb/log/mysql/mysql_general.log
log-error = /elastiblockdb/log/mysql/mysql_error.log
max_binlog_size = 1000M
log-slow-queries = /elastiblockdb/log/mysql/mysql-slow.log
long_query_time = 10
innodb_buffer_pool_size = 4500M
innodb_additional_mem_pool_size = 200M
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
i have two identical ubuntu machine on amazon servers. two of the machines have identical /etc/mysql configuration files. the problem is that when i unmount /elastidb (mysql data) on one server and remount it on the other, when i try to start mysql on the other server i get the following error:
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
091104 13:53:13 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
091104 13:53:14 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
091104 13:53:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
when i remove the directive datadir from my configuration file then mysql server starts but without loading the appropriate db data from my desired location.
I want to be able to quickly move that mysql data storage from one machine to the other. what may be the problem ?
both machines are on ubuntu 9.04 jaunty 64 bits.