89471
Replication and Temporary Tables
The discussion in the following paragraphs does notapply when
binlog_format=ROW [2047]
because, in that case, temporary tables are not replicated; this means that there are never any
temporary tables on the slave to be lost in the event of an unplanned shutdown by the slave. The
remainder of this section applies only when using statement-based or mixed-format replication. Loss
of replicated temporary tables on the slave can be an issue, whenever
binlog_format[2047] is
STATEMENT or MIXED, for statements involving temporary tables that can be logged safely using
statement-based format. For morę information about row-based replication and temporary tables, see
RBL, RBR, and temporary tables.statement-based format. For morę information about row-based replication and temporary tables, see RBL, RBR, and temporary tables.
Wyszukiwarka
Podobne podstrony:
Replication and blackhole Tables The BLACKHOLE storage engine accepts data but discards it and does
RBL, RBR, and temporary tables. As noted in Section 16.4.1.22, “Replication and Temporary Tables”, t
Replication and Character Sets The following applies to replication between MySQL servers that use d
Replication and Time Zones The same system time zonę should be set for both master and slave. Otherw
<Ethemet module and commumcation model> The following shows the software configuration of the
5) in Artide 10, the following paragraph shall be added: ‘6. Paragraphs 1 to 4 sha
79672 Suzuki RM250 GENERAL INFORMATION 1-11COUNTRY AND AREA CODES The following codes stand for the
SYS and SYSTEM Users The following administrative user accounts are automatically created when you i
not fit 1 FiND AND CROSS OUT THE OBJECT, THAT DOES NOT FIT INTO THE GROUP. for morę printables visit
36047 Suzuki RM125 1-6 GENERAL INSTRUCTIONSCOUNTRY AND AREA CODES The following codes stand for the
36,37 Understanding the patient When a patient says the following, what does he/she mean? Circle the
Safe slave shutdown when using temporary tables. Temporary tables are replicated except in the case
114 A. Świeca CONCLUSIONS AND DISCUSSION 1. In the years 1989-1992 about 6.5 milli
memory Tables and Replication A server s MEMORY tables become empty when it is shut down and restart
12 Wojciech Bożek Originality/value - the assortment of ideas discussed in the article handles signi
CeII Transport Lab Series GLUE IN THE FOLLOWING PROCEDURES AND CREATE DATA TABLES IN YOUR LAB MANUAŁ
więcej podobnych podstron