Databases Reference
In-Depth Information
This is because this server is configured with a binary log and these databases are not
excluded from replication.
As we have the following line of code in the
[mysqld]
section within the master's
configuration file, we can exclude from the binary log all transactions that affect the
mysql
database:
binlog_ignore_db=mysql
Therefore, the output of the
Databases
page shows a red icon next to the
mysql
database.
If this is a slave server, a
Server replication
column is shown.
Note that a slave server can itself have a binary log; therefore,
in this case, both
Master replication
and
Slave replication
columns are shown. This means that this slave could in turn be
a master server for another slave server.
Replicated tables
Let us suppose that on the master server, we create a table named
employee
in the
test
database. At this point, replication does its magic and we can have a look at the
test
database on a slave server:
Here, the
Replication
column is shown as a reminder. We should not modify this
table on the slave server directly, because its existence is for replication purpose only.
If we decide to alter it directly, our changes will be done only in this table, introducing
inconsistencies between the master and this slave, which is not a good idea.
Search WWH ::
Custom Search