Layer-4 Load Balancing with HAProxy for MariaSQL Rumi, May 25, 2020 If you have a MariaSQL Galera Cluster (All master) deployed, you can use HAProxy L-4 load balancing proxy. Configure HAProxy on Layer4 Mode. On this example, configure MariaDB backend like the following environment. Configure HAProxy. root@dlp:~# vi /etc/haproxy/haproxy.cfg # change defaults section like follows defaults log global mode tcp timeout connect 5000 timeout client 50000 timeout server 50000 # define MariaDB for frontend, backend frontend mysql-in bind *:3306 default_backend backend_servers backend backend_servers balance roundrobin server node01 10.0.0.51:3306 check server node02 10.0.0.52:3306 check root@dlp:~# systemctl restart haproxy Verify working normally to access to frontend HAproxy Server. debian@client:~# mysql -u root -p -h 10.0.0.30 -e "show variables like 'hostname';" Enter password: +---------------+------------------+ | Variable_name | Value | +---------------+------------------+ | hostname | node02.srv.world | +---------------+------------------+ debian@client:~# mysql -u root -p -h 10.0.0.30 -e "show variables like 'hostname';" Enter password: +---------------+------------------+ | Variable_name | Value | +---------------+------------------+ | hostname | node01.srv.world | +---------------+------------------+ Related Administrations Configurations (Linux) GaleraGalera ClusterHAProxyMariaDB
Perfect Squid with Transparent proxy and SSL log September 5, 2017September 5, 2017 This will be a transparent SQUID proxy for your home or corporate network , it will transparently intercept all traffic http and https , for https you will need to push to clients the CA certificate of the SQUID server, it has been tested to be working without problems with… Read More
SSH to use two-factor authentication using Google Authenticator on Debian or Ubuntu Server November 19, 2023 A computer running Ubuntu 16.04 LTS or above A phone running Android or iOS A configured SSH connection You should understand the danger of stolen passwords. You don’t need to know what two-factor authentication is and how it works. 🙂 Installing and configuring required packages Start a terminal session and… Read More
Step by Step Zimbra 6.x installation on CetOS 5.x June 11, 2012June 11, 2012 First you need to install a fresh CentOS operating system, keeping almost everything as default state. In this installation note I'm assuming few things- There is either a LARGE '/' partion or a LARGE '/opt' partition. Zimbra by default is installed on /opt directory I'm also assuming that the server… Read More