Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?

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