High MySql InnoDb cluster memory usage
barreto0
PROOP

a year ago

I know that high availability and high memory usage goes hand in hand, but all three nodes using 3+ gbs of memory is weighing on the usage bill. Is there a way to tweak the node settings to decrease this? Ive read that lowering the buffer pool can improve this, but the literature only covers single node implementations. Any advice on this?

Solved

3 Replies

echohack
EMPLOYEE

a year ago

Can you share your MySQL Config file?

I'd definitely start by looking at your max connections and any connection pooling you have going on.


Status changed to Awaiting User Response Railway about 1 year ago


echohack

Can you share your MySQL Config file? I'd definitely start by looking at your max connections and any connection pooling you have going on.

barreto0
PROOP

a year ago

how do i access the config file? is there a way to ssh to the machine that hosts the cluster?


Status changed to Awaiting Railway Response Railway about 1 year ago


a year ago

Hello,

You can Eject from the template with the Edject button found here -

And then you can tweak the config file in your repo, example -

https://github.com/railwayapp-templates/mysql-cluster/blob/main/nodes/my.cnf

Best,

Brody

Attachments


Status changed to Awaiting User Response Railway about 1 year ago


Railway
BOT

a year ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway 11 months ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...