R
Railway17mo ago
bmariano

Multiple Projects, single database?

Hey, i have like 10 projects that all of them requires a database. Can i use a single mysql database instance for all of them? Can i just change the database at the end of the url of the instance? These projects require a really little usage per month, it'd be a waste to deploy a single instance per project, example: mysql://user:password@127.0.0.1:3306/project1 mysql://user:password@127.0.0.1:3306/project2
10 Replies
Percy
Percy17mo ago
Project ID: N/A
Brody
Brody17mo ago
you would need to use the public domain from the database instead of the local address, and you would need to add the desired database beforehand, but yes.
bmariano
bmariano17mo ago
Yes, sure. Thanks for your answer. Do you know why for example, you can't do this in platforms like planetscale?
Brody
Brody17mo ago
huh Why'd you tag yourself
bmariano
bmariano17mo ago
Mistake New in discord
Brody
Brody17mo ago
either way, maybe planetscale doesn't allow you to add more than one database into a database and tbh idk if railway does either but if they do, then you can do what you speak of
bmariano
bmariano17mo ago
Do you know if the database region can be changed in railway?
Brody
Brody17mo ago
it can't, we are limited to us-west1 right now
bmariano
bmariano17mo ago
Thanks
Brody
Brody17mo ago
no need for the ping, but you're welcome!
Want results from more Discord servers?
Add your server