Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
9
Impact
~5k people reached

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
Dec
6
comment MySQLdump on specific db date
Well explained!
Feb
22
comment Should master and slave have same mysql version?
You shouldn't worry much. As I said, test before using 5.5.30. If you can run this setup for some time, you will have more confidence that the different versions solution works fine (for your setup always). I guess you cannot upgrade the master to 5.5.30, this would be the best option.
Jan
20
comment MariaDB and XtraDB/InnoDB plugins
You're right. I've just issued the command and it shows: | InnoDB | DEFAULT | XtraDB engine based on InnoDB plugin. Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
Jun
12
comment MySQL Error Reading Communication Packets
Very good explanation.
Jun
3
comment MySQL lost records in a master slave scheme
No problem, don't worry about it. :-)
Jun
3
comment MySQL lost records in a master slave scheme
We are already using the InnoDB plugin (I said it in my initial question) and as I recall, the InnoDB log buffer size is set to 48M, so both your suggestions were already set from the beginning. Thanks.
Jun
3
comment MySQL lost records in a master slave scheme
Hi, thanks for your detailed answer and sorry for the delay to reply. At the moment, I can't upgrade to MySQL 5.5, because I'm using the stable Debian Squeeze branch. Maybe when Debian 7.0 is released, the upgrade will probably be possible. What I did is to reinstall Debian in a new machine and delete all files from /var/lib/mysql and re-create from scratch (using MySQL 5.1.61). We created a batch test script to simulate the insertion procedure and this time, no records were lost. It seems that the issue went away. Thanks.