maestoso
Production database practices
I'm currently running a MySQL database in production. Here's what I'm curious about:
- It's not great to leave the database open to the public internet. The TCP proxy is convenient, but is it recommended to disable it in production?
- If the TCP proxy is disabled, what's the best way to restore from backups? I'm currently working on setting up a cron job to back the database up to S3, but I'm not sure what the restore process would look like. If I'd need to restore by connecting from local, I would need it to be exposed to the public internet somehow, correct? Maybe need a jumpbox or something similar?
11 replies