MyBB Community Forums

Full Version: DB_MySQLs' `table_exits()` should be executed on write link (usually source server)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
To get correct and consistent results on a replication, the table_exits() method should be executed on write link (usually the source server) for DB_MySQL / DB_MySQLi / MysqlPdoDbDriver, whereas on a random link now. The reason is explained at (limited access).

DB_MySQL, DB_MySQLi and MysqlPdoDbDriver using query() without writeQuery specified for table_exits():

DB_PgSQL and PostgresPdoDbDriver both using write_query() for table_exits(), which is the right way I think:

SQLite doesn't support replication so it doesn't have such problem.

Btw, MySQL calls a master server source server now.