ProxySQL for MariaDB Galera Clustering CentOS 7

Brijendra Sial

ProxySQL has an advanced multi-core architecture. It’s built from the ground up to support hundreds of thousands of concurrent connections, multiplexed to potentially hundreds of backend servers. The largest ProxySQL deployment spans several hundred proxies. Query Caching Forget applications that generate load by inefficiently accessing the same results over and over again. ProxySQL quickly jumps in with its advanced rule engine. Results can also be cached for a configurable timespan, in native MySQL packets format. Query Routing Take an advanced case, where different classes of queries need to be routed…

Read More

Creating MariaDB Galera Clustering

Brijendra Sial

MariaDB Galera Cluster is a synchronous multi-master cluster for MariaDB. It is available on Linux only, and only supports the XtraDB/InnoDB storage engines (although there is experimental support for MyISAM – see the wsrep_replicate_myisam system variable). Features Synchronous replication Active-active multi-master topology Read and write to any cluster node Automatic membership control, failed nodes drop from the cluster Automatic node joining True parallel replication, on row level Direct client connections, native MariaDB look & feel Benefits The above features yield several benefits for a DBMS clustering solution, including: No slave…

Read More

MariaDB Cluster With Haproxy

Brijendra Sial

HAProxy is a free, very fast and reliable solution offering high availability, load balancing, and proxying for TCP and HTTP-based applications. It is particularly suited for very high traffic web sites and powers quite a number of the world’s most visited ones. Over the years it has become the de-facto standard opensource load balancer, is now shipped with most mainstream Linux distributions, and is often deployed by default in cloud platforms. First Create 3 Nodes of Centminmod Installation Node1:192.168.1.1 (CMM Installed) (MariaDB Cluster 1)Node2:192.168.1.2 (CMM Installed) (MariaDB Cluster 2)Node3:192.168.1.3 (CMM…

Read More

Hands on Maxscale and Galera Cluster Centos7

Brijendra Sial

MariaDB MaxScale is a database proxy that extends the high availability, scalability, and security of MariaDB Server while at the same time simplifying application development by decoupling it from underlying database infrastructure. First Create 4 Nodes of Centminmod InstallationNode1:192.168.1.1 (CMM Installed) (MariaDB Cluster 1)Node2:192.168.1.2 (CMM Installed) (MariaDB Cluster 2)Node3:192.168.1.3 (CMM Installed) (MariaDB Cluster 3)Node4:192.168.1.4 (CMM Installed) (Maxscale) Open These ports 4567,4568,4444,3306 under TCP in your firewall (CSF or IPTABLES) on All MariaDB Cluster nodes. On 192.168.1.1 (CMM Installed) (MariaDB Cluster 1) Edit my.cnf file and at the end add lines…

Read More

Installing Mail Server on CentMinMod [Postfix, Dovecot, Opendkim, Spamassassin, Amavis-new and Clam-av]

Brijendra Sial

I wrote a small script for installing mail server on centminmod. The script supports only Centos 7. Just download the script from https://github.com/Brijendrasial/CentMinMod_MailServer/blob/master/CMM_Email.sh

Read More

Backup Script for CentMinMod

Brijendra Sial

I have written a backup script for centminmod users to backup their sites Locally, Amazons3, Dropbox or FTP. Also Centminmod to Centminmod site migration for WordPress is supported The script is also available on Github from https://github.com/Brijendrasial/CentMinMod_Backup/blob/master/CMM_backup.sh To download simply run below commands.

Read More