After cautiously stepping into replication database as my solution to managing one database across two locations - my server error logs continuously show this type of warnings every read/write
Code: Select all
2015-12-22 11:36:34, 2040, Warning, Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them. Statement: UPDATE tempagingEM0nsDaoOiO6L5 a [truncated, 474 bytes total]
---------
In other logs when starting the salve - this comes up as well
Code: Select all
Timestamp, Thread, Type, Details
2015-12-19 20:22:24, 1888, Warning, Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual f [truncated, 276 bytes total]
While in the logs I have caught this error as well - which was solved once I restarted the slave properly with adequate credentials
Code: Select all
Timestamp, Thread, Type, Details
2015-12-19 20:22:24, 1888, ERROR, Native table 'performance_schema'.'cond_instances' has the wrong structure