RBL nontransactional tables-opracowanie

RBL nontransactional tables, and stopped slaves. When using row-based logging, if the
slave server is stopped while a slave thread is updating a nontransactional table, the slave database
may reaches an inconsistent state. For this reason, it is recommended that you use a transactional
storage engine such as InnoDB for all tables replicated using the row-based format.
Use of STOP SLAVE or STOP SLAVE SQL_THREAD prior to shutting down the slave MySQL server
helps prevent such issues from occurring, and is always recommended regardless of the logging
format or storage engines employed.
... zobacz całą notatkę