When I do mysql> show processlist;
I get the following
| 18966 | replicate | smtp.lantic.net | NULL | Binlog Dump | 2069 |
Slave connection: waiting for binlog update | NULL |
+-------+-----------+------------------+--------+-------------+-------+---------------------------------------------+-------------
What worries me is this
Slave connection: waiting for binlog update
Need I be worried?
Is this also right ?
The position on both is not the same.(quoted below)
2081006-->Master
2139693-->Slave
mysql> show master status;
+-------------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+-------------------+----------+--------------+------------------+
| ais-rad02-bin.001 | 2081006 | | |
+-------------------+----------+--------------+------------------+
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 |
+---------------+-------------+-------------+---------------+-------------------+
| 196.25.84.193 | replicate | 3306 | 60 |
ais-rad02-bin.001 | 2139693 | Yes | radius |
| 0 | | 0 |
+---------------+-------------+-------------+---------------+-------------------+
1 row in set (0.00 sec)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
