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
5 Replies
a year ago
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?
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
a year ago
Is there no way to create replicas for mysql easily on railway?
a year ago
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.
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
