89393

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 sińce 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.