ProxySQL is a high performance database aware proxy for MySQL and MariaDB servers. ProxySQL can be deployed in a cluster and supports dynamic routing of SQL traffic to multiple backend database servers for high availability and efficient workload management. ProxySQL Installation The following deployment is based on Ubuntu 22.04 with…
Redis is an open-source in-memory key-value data store. It can be used as a database, cache, and message broker. It supports various data structures such as strings, hashes, lists, sets, and sorted sets, with atomic operations for manipulating them. Redis also supports simple, powerful commands for working with data, such…
Database High Availability can be done in two modes. One is Primary-Secondary configuration which allows one DB server to act as Primary and perform Read-Write operations. The data is replicated to Secondary nodes which can perform Read-Only operations. Another mode is Multi-Master configuration which allows Multiple DB Servers to act…
Safe Shutdown and Startup of NDB Cluster To shut down the cluster, enter the following command in a shell on one of the machine hosting the management node: $ ndb_mgm -e shutdownConnected to Management Server at: 192.168.100.11:11864 NDB Cluster node(s) have shutdown.Disconnecting to allow management server to shutdown. The command…
The following guide outlines installation of MYSQL NDB Cluster on UBUNTU Linux 20.04 (64 Bit). The NDB Cluster requires minimum of 3 machines, 2 for SQL Data Nodes and 1 for Management and SQL Node combined. This installation guide covers installation of NDB Cluster on 4 machines, 2 for Data…
