Planet MySQL HA Blog
Some InnoDB Cluster troubleshooting commands
Different ways to get the status:
Set the Primary Instance (switching):
mysqlsh --login-path=icadmin -h${HOSTNAME} --redirect-primary -- cluJemalloc install & config for MySQL
So, we’ve heard that jemalloc is better than malloc for MySQL usage, and in fact, certain versions / forks of mysql already include this, eg. Percona Server (https://github.com/percona/jemalloc).
But, how can I install and configure my system to use it?
Here’s a quick push in the, hopefully, right direction.
First things first, what is “jemalloc” and how does it affect my system? I think it’s quite well explained here: https://www.percona.com/blog/impact-of-memory-a
MySQL Inside: Using the PS error_log table for a quick peak!
Just thought I’d share a script I use daily and helps me redirect my attention if needed.
This is but a mere pointer, guideline and starting point in any task. I just thought I’d share and hope someone else’s day becomes slightly easier thanks to some brief investigation and command tweaking.
Now the really handy thing here is that I only hard code the router01 node name, as I’m using that as a potential endpoint (thinking cloud, XaaS, etc…) where it could als
MySQL Router quick’n’simple troubleshooting
I thought I’d share some quick intro steps into how we can monitor the MySQL Router.
This can be useful if we’re observing intermittent outages, network packet drops or you’re just not sure if everythings fine in your MySQL InnoDB Cluster.
My scenario: The drupal servers are connecting and sometimes the users are getting connection errors. I don’0t see anything at MySQL server level of any instance nor cluster problem. Let’s review the Routers.
On all MySQ