MySQL Forums
Forum List  »  Replication

Re: CREATE DATABASE not replicated (v.5.0)
Posted by: Dmitri Minaev
Date: October 13, 2014 12:10AM

The problem seems to be fixed after the replication had been rebuilt from scratch. So, unfortunately, I cannot provide information from that couple of servers. But there's another replica from the same master which has the same problem. This time it's MySQL 5.0.89 on the master (192.168.1.2) and 5.5.39 on the slave (192.168.1.1). Replication is one way.

Here's SHOW MASTER STATUS:

*************************** 1. row ***************************
File: mysql-binlog.005343
Position: 419792727
Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.00 sec)

and SHOW SLAVE HOSTS:

*************************** 1. row ***************************
Server_id: 3
Host:
Port: 3306
Rpl_recovery_rank: 0
Master_id: 2
1 row in set (0.00 sec)

And this is SHOW SLAVE STATUS:

*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.1.2
Master_User: slave
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-binlog.005343
Read_Master_Log_Pos: 423364055
Relay_Log_File: pravo3-relay-bin.000736
Relay_Log_Pos: 423364204
Relay_Master_Log_File: mysql-binlog.005343
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 36002407
Exec_Master_Log_Pos: 423364055
Relay_Log_Space: 423364407
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 2
1 row in set (0.00 sec)

Here are prvileges for user 'slave':
GRANT REPLICATION SLAVE ON *.* TO 'slave'@'192.168.1.1'...

Now, I create a database on the master server:
mysql> show databases like 'z%';
Empty set (0.00 sec)

mysql> create database zzz;
Query OK, 1 row affected (0.01 sec)

mysql> show databases like 'z%';
+---------------+
| Database (z%) |
+---------------+
| zzz |
+---------------+
1 row in set (0.00 sec)

The slave server still has no tracees of this database:
mysql> show databases like 'z%';
Empty set (0.00 sec)

During this operation there were no new messages in error logs.

DML statements seem to replicate correctly, as long as they work with old, existing databases and tables.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: CREATE DATABASE not replicated (v.5.0)
1142
October 13, 2014 12:10AM


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.