As I wanted to test in my vagrant environment Yoshinori’s MySQL replication booster, I needed to create rpms to be able to install it quickly and easily on those virtual machine without compiling it on the vm’s.
So if you are interested in this nice replication solution and you are lazy to compile it, you can use my rpm’s listed bellow.
Some links about the project:
- http://yoshinorimatsunobu.blogspot.hu/2011/10/making-slave-pre-fetching-work-better.html
- https://github.com/yoshinorim/replication-booster-for-mysql
- https://code.launchpad.net/mysql-replication-listener
mysql replication listener’s rpm was built using modified specs from https://bitbucket.org/winebarrel/ruby-binlog/downloads
Update
I added the src.rpm as requested by nvidhive on #percona freenode.
Finally i found a nice replication solution. Now i wont have hard time doing my work. Thanks for the info. Cheers! – Michael Courouleau
Hello Mr.lefred
I have read your blog and got Replication Booster.
http://www.lefred.be/node/156
I am getting Special Characters and facing error while running it please check below lines
2014-10-31 14:03:19: Reading relay log file: /relaylog/relay.012290 from relay log pos: 113512241
2014-10-31 14:03:19: Replication Booster started.
2014-10-31 14:03:19: ERROR: Got error on query. Error code:1064 message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Îù’ at line 1. query:select * from [TABLENAME] WHERE [COLUMNNAME] = ‘(null)’Îù
2014-10-31 14:03:19: ERROR: Got error on query. Error code:1064 message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ÒÊÅ’ at line 1. query:select isnull(coalesce( [COLUMNNAME] = [COLUMNNAME] + 0.013000)) from [TABLENAME] where [COLUMNNAME] = “11”ÒÊÅ
Please help me as i want to use this feature on my production servers.
Waiting for your positive reply.
I have read blog and got Replication Booster.
I am getting Special Characters and facing error while running it please check below lines
2014-10-31 14:03:19: Reading relay log file: /relaylog/relay.012290 from relay log pos: 113512241
2014-10-31 14:03:19: Replication Booster started.
2014-10-31 14:03:19: ERROR: Got error on query. Error code:1064 message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Îù’ at line 1. query:select * from [TABLENAME] WHERE [COLUMNNAME] = ‘(null)’Îù
2014-10-31 14:03:19: ERROR: Got error on query. Error code:1064 message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ÒÊÅ’ at line 1. query:select isnull(coalesce( [COLUMNNAME] = [COLUMNNAME] + 0.013000)) from [TABLENAME] where [COLUMNNAME] = “11”ÒÊÅ
Please help me as i want to use this feature on my production servers.
Waiting for your positive reply.