MySQL replikacia

Tomas TPS Ulej tps at freebsd.sk
Sun Feb 17 01:03:38 CET 2002


Neviete kde je problem? (pohlad na slave serveriku)

mysql> show slave status;
+-------------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
| Master_Host       | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter |
+-------------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
| daba.slovanet.net | repl        | 3306        | 60            |          | 2   | No            |                 |                     | 0          |            | 0            |
+-------------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
1 row in set (0.00 sec)

mysql> slave start;
ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO
mysql>

Co mi kde chyba? Nejak neviem ako nastavit, ze chcem replikovat len
DB session...


Na mastrovi mi bezi:

mysql> show master status;
+--------------+----------+--------------+------------------+
| File         | Position | Binlog_do_db | Binlog_ignore_db |
+--------------+----------+--------------+------------------+
| daba-bin.002 | 14663    | session      |                  |
+--------------+----------+--------------+------------------+
1 row in set (0.00 sec)

mysql> show slave status;
+-------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter |
+-------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
|             |             | 0           | 0             |          | 0   | No            |                 |                     | 0          |            | 0            |
+-------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
1 row in set (0.01 sec)

--
TPS




More information about the Users-l mailing list