{"id":19423,"date":"2015-05-06T10:51:50","date_gmt":"2015-05-06T05:21:50","guid":{"rendered":"http:\/\/www.tothenew.com\/blog\/?p=19423"},"modified":"2016-08-30T10:47:08","modified_gmt":"2016-08-30T05:17:08","slug":"load-blancing-of-amazon-rds-read-replica","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/load-blancing-of-amazon-rds-read-replica\/","title":{"rendered":"Load Blancing of Amazon RDS Read Replica"},"content":{"rendered":"

AWS provide some intensive services and these are easily manageable and as being admin there is less overhead to scale up your application infrastructure. In automated deployments<\/a> if we are planing to horizontally scale your database, with help of a single click we can populate read replica of our running database.<\/p>\n

But to handle large volume of traffic we have to scale database with two or more read instance. To trading off availability and consistency it’s necessary to put all read instance under single load balancer. So, the traffic would be equally distributed and manageable. We will configure haproxy as load balancer on Ec2 instance to serve read requests.<\/p>\n

Here is common architecture which we are using:-<\/h3>\n

1. Web application:- Deployed on Web Server.
\n2. Load balancer:- Ec2 instance with ubuntu 14.
\n3. RDS:- Two Read Replica of master RDS.<\/p>\n

\"\"<\/p>\n

Configuration Steps:-<\/h3>\n

1. RDS Configuration.
\n2. HA PROXY Configuration.
\n3. Load Balance testing.<\/p>\n

1. RDS Configuration.<\/strong>
\nWe need two users on database, the first user (ha_check) for haproxy active check and second user (ha_read) for integration within application. We will create these users on master database as changes will replicate to slave servers by itself. First off all create “ha_check” user which will be accessible from load balancer (10.0.0.204)<\/p>\n

[js]mysql -uroot -pPASSWORD -hmaster.xxxxxxx.ap-southeast-1.rds.amazonaws.com
\n> create user ‘ha_check’@’10.0.0.204’;
\n> flush privileges;[\/js]<\/p>\n

Now create second user with read only privileges.<\/p>\n

[js]
\n>grant select, show view on test.* to ‘ha_read’@’10.0.0.204’ identified by ‘password’;
\n> flush privileges;
\n[\/js]<\/p>\n

2. HA PROXY Configuration.:-<\/strong>
\nInstall haproxy package using apt-get.<\/p>\n

[js]
\napt-get install haproxy
\n[\/js]<\/p>\n

By Default the proxy mode is disabled and to enable it change \/etc\/default\/haproxy file.<\/p>\n

[js]
\nENABLED=1
\n[\/js]<\/p>\n

The main config file is \/etc\/haproxy\/haproxy.cfg and after editing the final file looks like:-<\/p>\n

[js]
\nglobal
\n log 127.0.0.1 local0 notice
\n user haproxy
\n group haproxy
\n daemon #Makes the process fork into background.<\/p>\n

defaults
\n log global
\n retries 2
\n timeout connect 3000
\n timeout server 5000
\n timeout client 5000
\n# Both salve server defined under this section
\n#listen <ANY NAME>
\n# bind <Load balancer Ip Address>:3306
\n# mode tcp
\n# option mysql-check user <haproxy check user name> # ha proxiy active check user
\n# balance <load distribution algoritham>
\n# server <any_name> <Read replica end point>:3306 check weight <no of request to be sent> fall <connect retry to declare dead> fastinter <interval between checks in ms><\/p>\n

listen rds-cluster
\n bind 10.0.0.204:3306
\n mode tcp
\n option mysql-check user ha_check
\n balance roundrobin
\n server mysql-1 ha1.xxxxxxx.ap-southeast-1.rds.amazonaws.com:3306 check weight 1 fall 2 fastinter 1000
\n server mysql-2 ha2.xxxxxxx.ap-southeast-1.rds.amazonaws.com:3306 check weight 1 fall 2 fastinter 1000<\/p>\n

# To chck load balancer status
\n#listen <ANY NAME>
\n# bind <Server IP>:8080
\n# mode http
\n# stats enable
\n# stats uri \/
\n# stats realm Strictly\\ Private
\n# stats <USERNAME>:<PASSWORD> <\/p>\n

listen cluster-check
\n bind 10.0.0.204:8080
\n mode http
\n stats enable
\n stats uri \/
\n stats realm Strictly\\ Private
\n stats auth admin:password
\n[\/js]<\/p>\n

Restart haproxy service to apply changes.<\/p>\n

[js]
\nservice haproxy restart
\n[\/js]<\/p>\n

3. Load balance testing:-<\/strong><\/p>\n

To check haproxy setup, login into your web server and run this command.<\/p>\n

[js]
\nmysql -h10.0.0.204 -uha_read -ppassword -e "show variables like ‘server_id’"
\n‘
\n[\/js]<\/p>\n

\"\"<\/p>\n

Each time we are requesting server_id the response value is different. It stats haproxy equally distributing traffic between two nodes. You can test the results while changing weight parameter in \/etc\/haproxy\/haproxy.cfg.<\/p>\n

It is also important to keep your eyes on load balancer health. Login into your browser to see real time load balancer status.<\/p>\n

\"\"<\/p>\n

Here we tested the scenario with two slave servers. You can add as much server as you want, but creating more read replica bring more work head on master server.<\/p>\n","protected":false},"excerpt":{"rendered":"

AWS provide some intensive services and these are easily manageable and as being admin there is less overhead to scale up your application infrastructure. In automated deployments if we are planing to horizontally scale your database, with help of a single click we can populate read replica of our running database. But to handle large […]<\/p>\n","protected":false},"author":165,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":13},"categories":[1174,2348],"tags":[1257,2366,1749],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/19423"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/165"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=19423"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/19423\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=19423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=19423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=19423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}