High MySql InnoDb cluster memory usage
barreto0
PROOP

10 months 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

10 months 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 11 months 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

10 months 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 11 months ago


10 months 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 11 months ago


Railway
BOT

7 months 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 7 months ago


Loading...