MySQL Forums
Forum List  »  Replication

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

From the master:

mysql> show master status;
+--------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--------------------+----------+--------------+------------------+
| replication.000014 | 107 | Carsoft | |
+--------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

mysql> show slave status;
+----------------+-------------+-------------+-------------+---------------+----
-------------+---------------------+---------------------------+---------------+
-----------------------+------------------+-------------------+-----------------
+---------------------+--------------------+------------------------+-----------
--------------+-----------------------------+------------+------------+---------
-----+---------------------+-----------------+-----------------+----------------
+---------------+--------------------+--------------------+--------------------+
-----------------+-------------------+----------------+-----------------------+-
------------------------------+---------------+---------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------+----------------+----------------+----------------------------
-+------------------+
| Slave_IO_State | Master_Host | Master_User | Master_Port | Connect_Retry | Mas
ter_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_Table | Replicate_
Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last_Error | Skip_Cou
nter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File
| Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Master_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_Id |

Options: ReplyQuote


Subject
Views
Written By
Posted
4946
October 24, 2012 09:44AM
1983
October 24, 2012 09:58AM
Re: waiting for master to send event
1634
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.