2 years ago
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?
8 Replies
2 years ago
correct, it's not great and for that reason all my templates come without the tcp proxy on the databases.
you could spin up a ubuntu ttyd image in the same project with the required cli tools to download and restore the backup.
2 years ago
though the web browser
oh I see what you mean, web browser to connect to ttyd, not the railway web app
2 years ago
correct
Interesting, okay. It'd be nice to see better management tools in the future, but this should work for now