89459
Replication and blackhole Tables
The BLACKHOLE storage engine accepts data but discards it and does not storę it. When performing
binary logging, all inserts to such tables are always logged, regardless of the logging format in use.
Updates and deletes are handled differently depending on whether statement based or row based
logging is in use. With the statement based logging format, all statements affecting BLACKHOLE tables
are logged. buttheir effects ignored. When using row-based logging, updates and deletes to such
tables are simply skipped—they are not written to the binary log. In MySQL 5.6.12 and later, a warning
is logged whenever this occurs (Bug #13004581)
For this reason we recommend when you replicate to tables using the BLACKHOLE storage engine that
you have the binlog_format [2047] server variable set to STATEMENT, and not to either ROW or
MIXED.
Wyszukiwarka
Podobne podstrony:
Physical Characteristics of memory Tables The MEMORY storage engine associates each table with one d
The csv Storage Engine The CSV storage engine Stores data in text files using comma-separated values
Indexes The MEMORY storage engine supports both HASH and BTREE indexes. You can specify one or the o
Federated Storage Engine Overview When you create a table using one of the standard storage engines
The example Storage Engine The example storage engine is a stub engine that does nothing. Its purpos
The merge Storage Engine The MERGE storage engine, also known as the MRG_MyISAM engine, is a collect
25 Ok Kiugutg Changes on the Bdis. Thei e is, probably, no ringei, however accomphshed, who does not
In the event of an obligatory self-quarantine A negative test result does not guarantee that an indi
Using different storage engines on master and slave. It is possible to replicate transactional table
Using Replication with Different Master and Slave Storage Engines It does not matter for the replica
Federated Storage Engine Notes and Tips You should be aware of the foliowing points when using the F
memory Tables and Replication A server s MEMORY tables become empty when it is shut down and restart
Replication and Temporary Tables The discussion in the following paragraphs does notapply
61. B.96689 THE ECONOMIC growth engine : how energy and work drive materiał prospe
do dzisiajtekst "The New Industrial Engineering: Information Technology and Business Process
Replication • As of MySQL 5.6, the relay-log. info file contains a linę count and
About Tables The table is the basie unit of data storage in an Oracle database. It holds all user-ac
OtherStorage Engines Other storage engines may be available from third parties and community members
więcej podobnych podstron