Re: New innodb mysql instance fails to go online
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.
Subject
Views
Written By
Posted
1020
July 03, 2019 06:41AM
Re: New innodb mysql instance fails to go online
403
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.