CentOS 6
Sponsored Link

Pen : MySQL Load Balancing2015/01/31

 
Configure Pen to Load Balance to 2 MySQL backends.
       |
-------+-----------------------------------------------
       |
       +-------------------+--------------------+
       |10.0.0.30          |10.0.0.51           |10.0.0.52
 +-----+------+    +-------+------+     +-------+------+
 |  Frontend  |    |   Backend#1  |     |   Backend#2  |
 | Pen Server |    | MySQL Server |     | MySQL Server |
 +------------+    +--------------+     +--------------+

[1] Configure Pen. Before this section, configure basic settings.
[root@dlp ~]#
vi /etc/pen.conf
# create new

LOGFILE=/var/log/pen.log
WEBFILE=/var/www/pen/webstats.html
CONTROL=127.0.0.1:10080
MAX_CONNECTIONS=256
ROUNDROBIN=true
# listening port

PORT=3306
# number of backends

BACKEND=2
# define backend servers

SERVER1=10.0.0.51:3306
SERVER2=10.0.0.52:3306
[root@dlp ~]#
/etc/rc.d/init.d/pend restart

Stopping Pend: [ OK ]
Starting Pend: [ OK ]
[2] Make sure all works fine to access to the frontend server from a Client with SQL like follows.
[root@desktop ~]#
mysql -u keystone -p -h 10.0.0.30 keystone -e "select * from table01;"

Enter password:
+------+-------------------+
| id   | name              |
+------+-------------------+
|    1 | db01.srv.world |
+------+-------------------+

[root@desktop ~]#
mysql -u keystone -p -h 10.0.0.30 keystone -e "select * from table01;"

Enter password:
+------+-------------------+
| id   | name              |
+------+-------------------+
|    1 | db02.srv.world |
+------+-------------------+
Matched Content