4.10.3
MySQL-.
,
. ,
.
,
. , ,
ID ,
,
(
See section 4.10.7 .
MySQL,
, , See section 4.10.6 SQL-, .
`my.cnf' See section 4.10.5 `my.cnf'.
-
, ()
MySQL. 3.23.29 .
, .
: , , ,
.
-
FILE ( MySQL 4.0.2) REPLICATION SLAVE
MySQL.
.
(),
- . ,
repl,
, :
mysql> GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY '<password>';
-
MySQL .
mysqladmin -u root -p<password> shutdown
-
.
( Unix), tar .
.
tar -cvf /tmp/mysql-snapshot.tar /path/to/data-dir
Windows
WinZIP .
-
my.cnf
[mysqld]
log-bin server-id= [mysqld]
. , ID
ID . , server-id
IP- -
.
[mysqld]
log-bin
server-id=1
-
MySQL .
-
my.cnf () :
master-host=< >
master-user=< >
master-password=< >
master-port=< TCP/IP >
server-id=< 2 2^32-1>
<> , .
server-id ,
. server-id ,
1, master-host,
2. , server-id ,
,
- .
, server-id
.
-
(). .
, MySQL,
,
.
-
() ().
() () ()
, .
server-id ,
:
Warning: one should set server_id to a non-0 value if master_host is set.
The server will not act as a slave.
(: master_host, server_id
.
.)
,
.
-
,
.
,
, ,
`master.info'. `master.info'
,
. ,
, . ,
CHANGE MASTER TO.