Monday, May 9, 2011

Slavereadahead 1.3 available

Version 1.3 of Slave read-Ahead is available for download. If you don't know what this tool is about, it is a tool that runs in the background, reads the incoming replication log on a slave and converts INSERT, UPDATE and INSERT ... SELECT statements into SELECT statements and executes these before the statement in question is executed on the server, the idea being that this will "prewarm" the MySQL caches for this date, for example the rows that an UPDATE is affecting will already be in the cache when the UPDATE arrives on the slave. Because of the way replication data is read, this tool only works with MySQL5.5 and up.

Version 1.3 introduces the auto-reconnect feature. This will reconnect to the MySQL server if the connection fails. To be sure that we restart, all existing connectings are released before a reconnect attempt is made. This version also has some more log printouts, mainly operations per second.

In addition, Version 1.3 fixes a few minor bugs, and one semi-major one, which caued not all INSERT ... SELECT statements to be handled properly.

/Karlsson

4 comments:

john hawk said...

Hi i like it this blog. Keep it up.............

marko said...

Facilitating anxiety starts with recognizing that you are without a doubt being antagonistically influenced by a circumstance. You have to pinpoint the issue's wellspring. A few individuals flourish in unpleasant circumstances, while others just don't know how to manage them. You have to make sense of which of the two you are. payday loans

Jessica Arianna said...

You may be uneasy cognizance that advances are besides achievable for getting motorbikes. In any case, the hard and fast's energy is that with experts bicycle progresses, you can aback any regarding of bicycle models. In like route, on the off unessential that you charge to securing an old bike, these credits other than associate you in such way. Check Cashing

Sarah Theresa said...

its in like manner better to show demand, delights or affiliations. Dialogs are welcome if fitting. One should consider talking and acting framework for one's characters; its to a degree possessing when little children look at like adults or working people use academician's vocabulary. car title loans