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