If your MySQL replication is stuck for example on
CREATE / ALTER TABLE ...
(or few others) because for example for the tables that already exist on the slave, there’s quick fix that can be applied on MySQL slave:
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;
This will force slave to skip one command (that is causing it to stop) and then replication is started back again.
Depending on the root cause of the problem of stopped replication there are other solutions – but this works in the case described above.
So my AWS EC2 free instance is running, for now I’ll use it as a Boinc maching, what is boinc?
I try to put it everywhere I can, and I have figured out few simple steps to get it working.
- <span style=“line-height: 14px;”>Install boinc on your server: apt-get install boinc-client (This works for Ubuntu / Debian)</span>
- Attach to boinc project, in my case: boinccmd –project_attach http://boinc.bakerlab.org/rosetta/ ac33820b6d74de35682d2ad98e7cede ( Your project key will be different)
- Add this entry to crontab (I have noticed that boinc process sometimes stops):
0 1 * * * root /etc/init.d/boinc-client restart
Not everyone knows, but Amazon actually has a free AWS tier for new customers for a year. Basically you can get a Micro instance for free for a year (that is 750 hours per month). I have not tested AWS before so I decided to give it a try. More details here: http://aws.amazon.com/free/