Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: MySQL5.1. Some INSERT,UPDATE SQL didn"t log to master bin log. Somestatements on master didn"t rerli

Posted on 2011-08-02 17:04:36 by Misha

--0016368e35a4ee141a04a98710e2
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: quoted-printable

Hello,
I'm using MySQL5.1. MASTER-SLAVE repilcate configuration, which run wihout
errors.

My problem is some insert/update statements didn't replicate on slave
server.
Even more i had check log in binary log in master server, and there is was
not such sql there.
i had check this in binary log of slave server, and tehre is was not such
sql there.

I want to make it clear, lot of insert/update statements was replecated to
slave.
But some insert/update statements missings on slave.

I know that they don't contanin any errors for sure.
They wasn't deleted with another statements for sure.


Does some one noticed the same problem ever?

Please help, i spent days for this problem, and still can't get what goes
wrong?

I will be glad to chat with you on email or skype (skypename: michael.oft)
if you have some ideas which can fix it...


on MASTER:

mysql> show master status;
+------------------+----------+--------------+-------------- ------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+-------------- ------------+
| mysql-bin.000001 | 979986 | internet | mysql,information_schema |
+------------------+----------+--------------+-------------- ------------+

config:
[mysqld]
sync_binlog=3D1
log-bin=3D/var/log/mysql/mysql-bin.log
binlog-do-db=3Dinternet
binlog-ignore-db=3Dmysql
binlog-ignore-db=3Dinformation_schema
server-id=3D1

on SLAVE:

mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 195.27.249.18
Master_User: slaveuser
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 1291593
Relay_Log_File: sql-nbg-001-relay-bin.000003
Relay_Log_Pos: 1291738
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: internet
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 1291593
Relay_Log_Space: 1291899
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:
1 row in set (0.00 sec)


report-host=3Dyyy.yy.yy.yy
master-host=3Dxxx.xx.xx.xx
master-user=3Dslaveuser
master-password=3DXXXXXX
master-port=3D3306
#master-log-file=3D'mysql-log.000001'
server-id=3D2
sync_binlog=3D1
log-bin =3D /var/log/mysql/bin.log
log-bin-index =3D /var/log/mysql/log-bin.index
log-error =3D /var/log/mysql/error.log
replicate-do-db=3Dinternet





--=20
----
íÃÃÃÃÃ,
éÃÃÃÃÃ=D2 Ãà ÃÃÃÃÃÃÃÃÃà ðï ïï=
=EF "ïæ=F4-íÃÃÃ=C1"
E-mail: misha@oft-media.ru
Skype: Michael.oft
ICQ: 1086688

--0016368e35a4ee141a04a98710e2--

Report this message