Databases Reference
In-Depth Information
phpMyAdmin's interface offers a
Replication
page; however, other pages contain
either information about replication or links to control replication actions. We will
point to each appropriate location when covering the related subject.
How to use this section depends on how many servers we have at our disposal.
If we have at least two servers and want to configure them via phpMyAdmin in
a master/slave relationship, we can follow the
Configuring replication
section. If
instead we only have one server to play with, then we should take advice from the
Setting up a test environment
section to install many instances of the MySQL server on
the same machine.
The Replication menu
In
Server
view, the
Replication
menu is only shown to privileged users, such as
the MySQL root user. When a server is already configured as a master server or a
slave server (or both), the
Replication
page is used to display status information and
provide links that send commands.
Configuring replication
For this exercise, we assume that the server does not currently occupy the role of
master or slave server. phpMyAdmin cannot directly configure all aspects of MySQL
replication. The reason is that, contrary to manipulating database structure and
data by sending queries to the MySQL server, replication configuration consists (in
part) of command lines stored in a MySQL configuration file, often named
my.cnf
.
phpMyAdmin, being a web application, does not have access to this file. This is how
the MySQL server's developers intended the configuration to be—at a configuration
file level.
The best that phpMyAdmin can do in this situation is to guide us by generating (on
screen) the proper command lines in reaction to our preferences, then it's up to us
to copy these lines where they need to go and to restart the server(s). phpMyAdmin
cannot even read the current replication configuration lines; it can only deduce
server status via some
SHOW
commands.
Search WWH ::
Custom Search