Severalnines.com

Automate Database Health Check Severalnines

ClusterControl is an ops platform for databases, it shows server health, performance, or availability problems within their … See more

Actived: 1 days ago

URL: https://severalnines.com/blog/automate-database-health-check/

Newly Updated “MySQL Load Balancing with HAProxy” Tutorial

WEBIn short, there are 3 health check methods that can be used with MySQL: mysql-check. tcp-check. httpchk. Some health check methods require a health check …

Category: Health Go Health

InnoDB and NDB Performance Optimization – Severalnines Support

WEBIn the Health Report, look at the Innodb Buffer Pool Hit Ratio. It should be 998/1000 or more. The impact of a too small innodb buffer pool is that you will end up with having …

Category: Health Go Health

PostgreSQL Database Monitoring: Tips for What to Monitor

WEBWhat to Monitor in PostgreSQL. When monitoring a database cluster or node, there are two main things to take into account: the operating system and the database itself. You will …

Category: Health Go Health

Using NGINX as a Database Load Balancer for Galera Cluster

WEBNginx is well-known for its ability to act as a reverse-proxy with small memory footprint. It usually sits in the front-end web tier to redirect connections to available backend …

Category: Health Go Health

How ClusterControl Configures Virtual IP and What to Expect …

WEBClusterControl configures the VRRP instance to communicate through unicast. With unicast, we must define all unicast peers of the other Keepalived nodes. It is less dynamic but …

Category: Health Go Health

Introduction to Failover for MySQL Replication – the 101 Blog

WEBHere’s how the failover process usually works: 1. Master crash is detected. For starters, a master has to crash before the failover will be performed. Once it is not available, it’s …

Category: Health Go Health

Best Practices for Enabling Database Alarms & Notifications

WEBThe database health includes not only the state of being online or availability. It has a lot of things covered. For example, in MySQL/PostgreSQL/MongoDB, this involves replication …

Category: Health Go Health

An Overview of PostgreSQL Query Caching & Load Balancing

WEBHealth checks ensure that queries are only sent to alive nodes. Compared to pgpool-II, applications using HAProxy as a load balancer, must be made aware of the endpoint …

Category: Health Go Health

Top Common Issues with MHA and How to Fix Them Severalnines

WEBThis is a recommended approach especially for those setups where MHA Manager is running on a different datacenter or different network than the database nodes. The …

Category: Health Go Health

MySQL load balancing with HAProxy Severalnines

WEBEvery 2 seconds, HAProxy performs health check on port 9200 of the backend server (port 9200 inter 2s). If the health check fails, the fall count starts and it will check for the next …

Category: Health Go Health

PostgreSQL load balancing with HAProxy Severalnines

WEBThis health check script is out of the scope of this tutorial since it is built for TCP-load balancers (other than HAProxy) with limited health-check capabilities to monitor the …

Category: Health Go Health

How to Run and Configure ProxySQL 2.0 for MySQL Galera Cluster …

WEBProxySQL performs Galera health checks by monitoring the following MySQL status/variable: read_only – If ON, then ProxySQL will group the defined host into …

Category: Health Go Health

Exploring Synchronous Commit Mode for SQL Server Always On

WEBSQL Server Always On Synchronous commit mode focuses on high availability over performance. The performance trade-off could be due to the increased transaction …

Category: Health Go Health

Swarm Mode Limitations for Galera Cluster in Production Setups

WEBHealth check – Each of the stateful containers must pass the Docker health checks, to ensure it achieves the correct state before being included into the active load balancing …

Category: Health Go Health

How to use the ClusterControl REST API to Automate Your …

WEBFor ops folks with multiple environments and instances to manage, a fully programmable infrastructure is the basis for automation. ClusterControl exposes all functionality …

Category: Health Go Health

A Message from Our CEO on the COVID-19 Pandemic

WEBTo Severalnines, families come first, so we encourage our teams to work when their schedules allow and to focus on the health and security of their family as the priority. …

Category: Health Go Health

How to Benchmark Performance of MySQL & MariaDB Using …

WEBSysBench is a C binary which uses LUA scripts to execute benchmarks. Those scripts have to: Handle input from command line parameters. Define all of the modes which the …

Category: Health Go Health

DATABASE AUTOMATION BEHIND SWEDEN’S NEW …

WEBensure the entire system was in good health, and procedures could be easily automated - e.g., upgrades, backup and restore, anomaly detection and automatic recovery. The …

Category: Health Go Health

Database load balancing for MySQL and MariaDB with ProxySQL

WEBIt can be personal data about users like name, address, bank account number, health records etc. On the other hand, you want to follow good practices and use your real data …

Category: Health Go Health

Deploying MariaDB Replication for High Availability Severalnines

WEBNow, sitting on top of them is the ClusterControl.ClusterControl is set up with a high availability i.e. CMON HA.Alternatively, the proxy layer can be chosen from either …

Category: Health Go Health