9 months ago
Hello, I would like to run queries on my database from the railway dashboard. For some reason, when I select the DB instance (MySQL), and the select the data tab, I get a loading spinner on Database connection… It just loads forever. Any idea how to fix this?
16 Replies
1fc9ac5f-29f8-4b23-ab28-1eebdaeb8c06/service/15c2f9f5-0672-4675-8459-5d989069a106/data?environmentId=87adcc32-cf45-44c4-bd23-7de68500165a
9 months ago
Hi! Can you access your db normally through a db explorer client like Beekeeper or DBeaver?
9 months ago
Or can your apps retrieve data from it? I see two services in your canvas
9 months ago
And why aren't you using the private network to communicate between your services?
I don't know about the private network? We have a product that is working, so I'm always a bit hesitant to try to make a change of that sort.
9 months ago
The data tab is a bit unreliable (it needs some love), keep using the MySqlWorkbench if possible 😆
9 months ago
By using the private network you will get reduced latency and reduced egress cost
https://docs.railway.com/reference/private-networking
9 months ago
9 months ago
And as far as I know you can't run queries on the data tab, you can just visualize and edit row data
I see. I was trying to figure out how to run Queries remotely, as I don't always have my laptop. I wanted to make sure we had access to the DB incase of an emergency. I will look into private-networking, thank you.
We have 3 projects, that are all connecting to the same MYSQL DB, which is in 1 of the 3 projects. Is private-networking possible for us?
9 months ago
They need to be on the same project to be able to use private networking
9 months ago
No problem! I will mark this thread as solved
9 months ago
!s
Status changed to Solved medim • 9 months ago