MEMORY Tables and Replication-opracowanie

MEMORY Tables and Replication
A server's MEMORY tables become empty when it is shut down and restarted. If the server is a
replication master, its slaves are not aware that these tables have become empty, so you see out-ofdate
content if you select data from the tables on the slaves. To synchronize master and slave MEMORY
tables, when a MEMORY table is used on a master for the first time since it was started, a DELETE
statement is written to the master's binary log, to empty the table on the slaves also. The slave still
has outdated data in the table during the interval between the master's restart and its first use of the
table. To avoid this interval when a direct query to the slave could return stale data, use the --initfile
[438] option to populate the MEMORY table on the master at startup.
... zobacz całą notatkę