MySQL Forums
Forum List  »  InnoDB clusters

Re: New innodb mysql instance fails to go online
Posted by: Peter Hutchison
Date: July 09, 2019 08:57AM

I found the cause of some of my problems.
1) The my.cnf did not have both conf.d and MySQL.conf.d include lines, so that fixed the empty error.log.

2) On the instance, you have to make sure that not bin logs are not created when making changes to local databases, as MySQL cluster will not like this. This is esp. true when creating users for MySQL. So to stop this, run
set sql_bin_log = OFF, before creating or updating users or other commands that might change the db's, run set sql_bin_log = ON at the end.

3) Run 'flush logs' and 'reset master' to ensure any transactions are cleared before adding the instance.

If all else fails, stop the MySQL service, delete contents of /var/lib/MySQL and /var/log/MySQL to clear DBs and logs, restart the MySQL service and start again.

Hope these tips help others.

Options: ReplyQuote

Written By
Re: New innodb mysql instance fails to go online
July 09, 2019 08:57AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.