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:[email protected]:3306/project1 mysql://user:[email protected]:3306/project2
10 Replies
Percy
Percy2y ago
Project ID: N/A
Brody
Brody2y 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
bmarianoOP2y ago
Yes, sure. Thanks for your answer. Do you know why for example, you can't do this in platforms like planetscale?
Brody
Brody2y ago
huh Why'd you tag yourself
bmariano
bmarianoOP2y ago
Mistake New in discord
Brody
Brody2y 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
bmarianoOP2y ago
Do you know if the database region can be changed in railway?
Brody
Brody2y ago
it can't, we are limited to us-west1 right now
bmariano
bmarianoOP2y ago
Thanks
Brody
Brody2y ago
no need for the ping, but you're welcome!
Want results from more Discord servers?
Add your server