Next badge 6/10
~3k people reached
- 0 posts edited
- 0 helpful flags
- 14 votes cast
Is syncing a MySQL database with Dropbox this easy, and is it a backup solution?
What they are most likely achieving is a false sense of security. Yes, I suspect a backup is the intended outcome, but unless the server has very low traffic and Dropbox's algorithm is very aggressive, it's unlikely that the backups will be viable. Even then, the server, during startup from such a backup, is likely to need some time to recover from what it sees as evidence (in the files) of a crash occurring... best case.
Local folder for specific MySQL databases with symlinks
Nothing in the mysql error log? You did move the files and set up the symlinks with mysqld stopped, I trust...
Ubuntu virtual memory overcommit apparently hitting MySql performance
Where is /dev/sdb mounted? I don't see a memory issue here, but 100% disk saturation seems to be telling you something. Does the performance of MySQL improve after it has been running for a while?