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