Topics

Railway•4d ago

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?

Solution:

1. correct, it's not great and for that reason all my templates come without the tcp proxy on the databases. 2. you could spin up a ubuntu ttyd image in the same project with the required cli tools to download and restore the backup....

Jump to solution

8 Replies

Percy•4d ago

Project ID: N/A

maestoso•4d ago

N/A

Solution

Brody•4d ago

1. correct, it's not great and for that reason all my templates come without the tcp proxy on the databases. 2. you could spin up a ubuntu ttyd image in the same project with the required cli tools to download and restore the backup.

maestoso•4d ago

I like that option better How would you connect to that? Railway CLI?

Brody•4d ago

though the web browser

maestoso•4d ago

oh I see what you mean, web browser to connect to ttyd, not the railway web app

Brody•4d ago

correct

maestoso•4d ago

Interesting, okay. It'd be nice to see better management tools in the future, but this should work for now

Hang out with other likeminded developers & talk about all things https://railway.app on the Railway Community Server.

24KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

mongodb container keeps crashing today, no load on the server (no access at all...)project id: 3c844d3f-4881-4397-a46c-69c77b48fcc0 Billing: Payment Unsuccessful for EduBeyond (Pro Account)Hey guys, our bank is currently having problems and we can't pay for railway for the next few days. Considering Migrating from VercelHi i'm currently considering to migrate from Vercel for my apps, but i need some feedbacks and clari postgres DNS not resolvingIs this an internal DNS problem? Private url isn't resolving but works with DATABASE_URL ``` npm WA Railway sees old CNAME value and will not refreshProject ID: 1403d8a3-d1fc-487a-9eac-065da725466c I am switching my main production domain from Hero I need help with this errorHello, good morning, I have problems with a database that has been implemented and now I get an erro Is that any way to provide resources via api ?like aws cli, or something like this pricing for database hostingHey all! I'm hosting a postgres instance on Railway and I'm not too sure how the pricing there is ca Penetration Testing and Network Scanning Permissions and PolicyDoes Railway allow users to conduct penetration testing and network scanning of their web apps hoste Cost of replicasWhat is the cost of extra replicas for a service? (my node.js server)