2 months ago
I need to increase the number of connections my mysql instance can accept, but I'm not sure how to provide this configuration in a way that is resilient after Railway deployments, or service restarts.
Following the MySQL documentation I could create the file below:
/etc/mysql/conf.d/max_connections.cnf
With this content:
[mysqld]
max_connections = 200
Restart the mysql service to make it effective.
Does this approch persist if a new deploy is triggered for the service?
Pinned Solution
2 months ago
Hi @ilvalerione you'll want to add a --max_connections=200 flag to the Custom Start command for your MySQL service, like this:
That should work, unless Railway has some undocumented limitations around connection counts with their SQL services. It will be persisted across deploys. Good luck!
Attachments
1 Replies
2 months ago
Hi @ilvalerione you'll want to add a --max_connections=200 flag to the Custom Start command for your MySQL service, like this:
That should work, unless Railway has some undocumented limitations around connection counts with their SQL services. It will be persisted across deploys. Good luck!
Attachments
Status changed to Solved noahd • about 2 months ago