Re: New innodb mysql instance fails to go online

[Peter Hutchison]

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.