HN user

ybrs

20 karma

solution developer

Posts2
Comments15
View on HN
    Location: Istanbul, Turkey
    Remote: Yes
    Willing to relocate: Maybe
    Technologies:
    - python, aws
    Résumé/CV: upon request
    Email: aybars.badur+hn@gmail.com
    Github: https://github.com/ybrs
    Website: https://dontpanicletsdeploy.com
    Currently: backend development lead
    I am looking for some consultancy/architecture gig for AWS/cloud for startups.

i was just going to write the exact same thing. one should at least have a simple master to master setup for redundancy imho - then these kind of problems are much easier to solve, just restart mysql.

also i think one should take care of Reliability into account as well, if you have only one app server it will fail - maybe eventually - and you'll find yourself trying to ssh into the server at 2am, have at least a few app servers load balanced, have 2 db servers replicating with auto failover etc..

i read until the backup process and gave up reading through, for cold backups of online databases, you should use percona's extrabackup, its open source and free and works perfectly. http://www.percona.com/doc/percona-xtrabackup/ if you are using mysql a simple googling "hot backup mysql" will lead to that, i guess author didn't even bother to search.

besides, you need to use replication and connect a couple of slaves if you care about being online and backup from one of the slaves - which is a common practice for all databases not for mysql. if you are trying to dump from the master without slaves good luck with any database.