chadr

7 ms·

31.
by chadr 18y ago
Here is what I do with mysql 5.1 and my innodb tables on Linux... mysqldump --single-transaction --skip-lock-tables --all-databases | gzip > "/some/directory/backup-`hostname`-hourly-`date +%H`.sql.gz" These two options are important: -
32.
by chadr 18y ago
Do you have any more info on the corruption? I have found bdb to be very reliable. I used it as the backend storage engine for Sun's LDAP server product.
33.
by chadr 18y ago
Perhaps memcachedb would be better for this scenario (vs regular memcached) since it is persistent. It's memcached with berkley db.
34.
by chadr 18y ago
Which tool(s) do you recommend that do this?
35.
by chadr 18y ago
If you are starting out with linode you should be aware of the backup policy. Basically you have to roll your own. Let me know if you have any linode questions. I've been using them for about a year now. I think backups are the only fea
36.
by chadr 18y ago
Just out of curiosity, why did you go with Slicehost instead of Linode? For Rails hosting, RAM seems to be limiting factor if you only want to spend $20/month. On a Linode 360 I'm running 3 mongrels, nginx, and MySQL with some RAM to spar
37.
by chadr 18y ago
I've been using linode for the last 8 months and so far it has been a wonderful low cost, high performance solution. My only complaint is that they don't appear to offer any backup solutions. I an under the assumption that I'll be rebuild
38.
by chadr 18y ago
Fixed. Thanks for finding the bug.
39.
by chadr 18y ago
There are tie breaker rules on the Rules tab.