How to scale with MySql on Railway
marcellov7
PROOP

a year ago

Hi, my question is pretty generic and concerns how to scale MySql with Railway, I don't think it's possible to use replicas on volumes and I can't find any templates related to replicas for MySql.

On the other hand we have been testing the MySql Cluster offered as a template by Railway all day, but it does not seem stable, the connection is lost, this happens if you increase the size of the volume of one of the mysql or if you change region, true these are not frequent operations, but it may happen that you have to do them.

We like using Railway and are evaluating it for our database as well, but we can't find a way to scale it, it would be enough to have read replicas.

Any suggestions from those with more experience?

Thanks

Solved

5 Replies

Hey! Would you be able to elaborate on your use case and what scale you require? Are you running a read-heavy app or write-heavy?

On the other hand we have been testing the MySql Cluster offered as a template by Railway all day, but it does not seem stable, the connection is lost, this happens if you increase the size of the volume of one of the mysql or if you change region, true these are not frequent operations, but it may happen that you have to do them.

Can you link me the template you tried please?


Status changed to Awaiting User Response Railway about 1 year ago


ray-chen

Hey! Would you be able to elaborate on your use case and what scale you require? Are you running a read-heavy app or write-heavy?On the other hand we have been testing the MySql Cluster offered as a template by Railway all day, but it does not seem stable, the connection is lost, this happens if you increase the size of the volume of one of the mysql or if you change region, true these are not frequent operations, but it may happen that you have to do them.Can you link me the template you tried please?

marcellov7
PROOP

a year ago

this one
https://railway.com/template/ha-mysql
but it was just deleted.



But it is not important for us to use this, if it was also possible to have replicas on the mysql master it would already be enough.

If not, how do you scale?

Do you have any use cases of companies using MySQL without replication with high volumes of data / users? If so we might reconsider using even one machine--but I don't think that's the case.

Thanks

Attachments


Status changed to Awaiting Railway Response Railway about 1 year ago


marcellov7
PROOP

a year ago

Is there no way to create replicas for mysql easily on railway?


Not easily. We'd love to support native easy HA/replication but we don't have it on our roadmap at the moment.

Most of our customers including larger ones all use a single instance at the moment, but they have access to higher specs (>64vCPU/>64GB RAM in some configurations and 2x that in others) as Enterprise customers.


Status changed to Awaiting User Response Railway about 1 year ago


ray-chen

Not easily. We'd love to support native easy HA/replication but we don't have it on our roadmap at the moment.Most of our customers including larger ones all use a single instance at the moment, but they have access to higher specs (>64vCPU/>64GB RAM in some configurations and 2x that in others) as Enterprise customers.

marcellov7
PROOP

a year ago

ok, it would be great to have in the future something like pg_easy_replicate for mysql

thanks


Status changed to Awaiting Railway Response Railway about 1 year ago


Status changed to Solved ray-chen about 1 year ago


Loading...