{"id":3677,"date":"2022-05-01T16:50:40","date_gmt":"2022-05-02T00:50:40","guid":{"rendered":"https:\/\/tungle.ca\/?p=3677"},"modified":"2022-10-24T19:29:57","modified_gmt":"2022-10-25T03:29:57","slug":"aws-rds-multi-az-failover","status":"publish","type":"post","link":"https:\/\/tungle.ca\/?p=3677","title":{"rendered":"AWS RDS MySQL on Multi-AZ Test Failover"},"content":{"rendered":"\n

This is a diagram that I have used to deploy this lab.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Create your VPC with two different subnets on different AZs.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Create a Linux instance.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Copy it into the User data setting.<\/p>\n\n\n\n

#!\/bin\/bash\nyum update -y\nyum install httpd -y\nwget https:\/\/wordpress.org\/latest.tar.gz\ntar -zxf latest.tar.gz\namazon-linux-extras install php7.4 -y<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Create a WordPress-SG Security Group.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
SSH to the Linux instance, and check httpd, php is installed on the machine.<\/p>\n\n\n\n
rpm -qa | grep httpd\nrpm -qa | grep php\nsudo yum install php -y\nsudo systemctl start httpd\nsudo systemctl enable httpd\nnetstat -antp<\/code><\/pre>\n\n\n\n
Copy all files on WordPress directory to \/var\/www\/html.<\/p>\n\n\n\n
cd wordpress\nsudo cp -r * \/var\/www\/html\ncd \/var\/www\/html<\/code><\/pre>\n\n\n\n
Check HTTP service is running on the Linux instance.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Next, create a database subnet on your Amazon RDS by using both AZs.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Create a new DS database.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Enable “Multi-AZ DB instance”.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Create a wordpress database, username, and passowrd.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Open http:\/\/44.205.13.154 on your web browser to set up WordPress.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Create a new wp-config.php under \/var\/www\/html directory, and paste the information on the screen to this file. Click \u201cRun the installation\u201d<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The master RDS MySQL instance is on the IP address 10.0.1.187 on Availability zone 2.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Run the command below to verify RDS MYSQL failover.<\/p>\n\n\n\n
while true; do host wordpress.c60vdekov0up.us-east-1.rds.amazonaws.com ; sleep 1; done<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Then select Actions-Reboot to reboot the RDS instance. Enable the “Reboot with Failover” option.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Wait for around 1 to 2 minutes and refresh the WP web link. The WordPress site will be offline for around 1 minute when doing RDS failover. It can be seen that the RDS MySQL Endpoint has changed from 10.0.2.187 to 10.0.0.254.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
RDS Endpoint has updated with the new address is 10.0.0.254 on us-east-1a.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The master RDS MySQL instance is on the IP address 10.0.0.254 on Availability zone 1.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Checking the WordPress site.<\/p>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
This is a diagram that I have used to deploy this lab. Create your VPC with two different subnets on different AZs. Create a Linux instance. Copy it into the User data setting. Create a WordPress-SG Security Group. SSH to the Linux instance, and check httpd, php is installed on the machine. Copy all files […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[20],"class_list":["post-3677","post","type-post","status-publish","format-standard","hentry","category-cloud","tag-cloud"],"_links":{"self":[{"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/posts\/3677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tungle.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3677"}],"version-history":[{"count":8,"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/posts\/3677\/revisions"}],"predecessor-version":[{"id":4330,"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/posts\/3677\/revisions\/4330"}],"wp:attachment":[{"href":"https:\/\/tungle.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tungle.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tungle.ca\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}