Running Queries on railway
jaytonbye
PROOP

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?

Solved

16 Replies

jaytonbye
PROOP

9 months ago

1fc9ac5f-29f8-4b23-ab28-1eebdaeb8c06/service/15c2f9f5-0672-4675-8459-5d989069a106/data?environmentId=87adcc32-cf45-44c4-bd23-7de68500165a


medim
MODERATOR

9 months ago

Hi! Can you access your db normally through a db explorer client like Beekeeper or DBeaver?


medim
MODERATOR

9 months ago

Or can your apps retrieve data from it? I see two services in your canvas


medim
MODERATOR

9 months ago

And why aren't you using the private network to communicate between your services?


jaytonbye
PROOP

9 months ago

I use MySqlWorkbench, it works fine; our app works as well.


jaytonbye
PROOP

9 months ago

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.


medim
MODERATOR

9 months ago

The data tab is a bit unreliable (it needs some love), keep using the MySqlWorkbench if possible 😆


medim
MODERATOR

9 months ago

By using the private network you will get reduced latency and reduced egress cost
https://docs.railway.com/reference/private-networking



medim
MODERATOR

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


jaytonbye
PROOP

9 months ago

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.


jaytonbye
PROOP

9 months ago

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?


medim
MODERATOR

9 months ago

They need to be on the same project to be able to use private networking


jaytonbye
PROOP

9 months ago

That's what I thought, ok, we'll leave it as it is then. Thank you.


medim
MODERATOR

9 months ago

No problem! I will mark this thread as solved


medim
MODERATOR

9 months ago

!s


Status changed to Solved medim 9 months ago


Loading...