I had the problem of unrelated data aborting in a HA cluster and my Mysql resource was in standalone on both nodes, I managed to solve the problem and both nodes are synchronized, the problem now is that when checking the var/lib/mysql directory
On the main node I have the following files:
but the mirror node I only have the clsstd2.err file that contains the following:
1.mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/usr/sbin/mysqld: Table ‘mysql.plugin’ doesn’t exist.
2.[ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
3.InnoBD: operating system error number 13 in a file operation.
4.InnoBD: The error means mysqld does not have access rights to the directory.
5.InnoBD: File name ./ibdata1
6.InnoBD: File operation call: ‘create’
7.InnoBD: Cannot continue operation
8.mysqld_safe mysqld from pid file /var/lib/mysql/clsstd2.pid ended.
How can I create these files on the mirror node to ensure replication?