MySQL Forums
Forum List  »  Replication

Re: waiting for master to send event
Posted by: Jordi Maicas
Date: October 24, 2012 09:58AM

From the slave:

mysql> show master status;
Empty set (0.00 sec)

mysql> show slave status;
+----------------------------------+-------------+-------------+-------------+--
-------------+--------------------+---------------------+-----------------------
+---------------+-----------------------+------------------+-------------------+
-----------------+---------------------+--------------------+-------------------
-----+-------------------------+-----------------------------+------------+-----
-------+--------------+---------------------+-----------------+-----------------
+----------------+---------------+--------------------+--------------------+----
----------------+-----------------+-------------------+----------------+--------
---------------+-------------------------------+---------------+---------------+
----------------+----------------+-----------------------------+----------------
--+
| Slave_IO_State | Master_Host | Master_User | Master_Port | C
onnect_Retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File
| Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running |
Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_T
able | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last
_Error | Skip_Counter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition
| Until_Log_File | Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Mas
ter_SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | Seconds
_Behind_Master | Master_SSL_Verify_Server_Cert | Last_IO_Errno | Last_IO_Error |
Last_SQL_Errno | Last_SQL_Error | Replicate_Ignore_Server_Ids | Master_Server_I
d |
+----------------------------------+-------------+-------------+-------------+--
-------------+--------------------+---------------------+-----------------------
+---------------+-----------------------+------------------+-------------------+
-----------------+---------------------+--------------------+-------------------
-----+-------------------------+-----------------------------+------------+-----
-------+--------------+---------------------+-----------------+-----------------
+----------------+---------------+--------------------+--------------------+----
----------------+-----------------+-------------------+----------------+--------
---------------+-------------------------------+---------------+---------------+
----------------+----------------+-----------------------------+----------------
--+
| Waiting for master to send event | 192.168.0.2 | jmaicas | 3306 |
60 | replication.000014 | 107 | X-PC-relay-bin.000008
| 255 | replication.000014 | Yes | Yes |
| | |
| | | 0 |
| 0 | 107 | 558 | None
| | 0 | No | |
| | | |
0 | No | 0 | |
0 | | |
1 |

Options: ReplyQuote


Subject
Views
Written By
Posted
4946
October 24, 2012 09:44AM
Re: waiting for master to send event
1983
October 24, 2012 09:58AM
1635
October 24, 2012 10:00AM
1615
October 24, 2012 10:02AM
1601
October 25, 2012 09:16AM
1548
October 25, 2012 11:04AM
1388
October 26, 2012 08:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.