多可用區亞馬遜云 RDB數據故障轉移 _生活百科

RDB關系數據庫（Relational Database，RDB）
創建名為VPC for RDS的vpc兩個可用區，兩組公內網

文章插圖

文章插圖
創建安全組

文章插圖
創建RDS數據庫實例用的數據庫子網組

文章插圖

文章插圖
創建RDS數據庫實例

文章插圖

文章插圖
創建數據庫

文章插圖
連接RDS數據庫實例并給數據庫test添加數據1.創建安全組

文章插圖
2.創建用來連接數據庫實例的EC2

文章插圖
選擇vpc for rds那個vpc的public subnet2，因為mysql的安全組只允許這一個網段，然后自動分配公有IP
3.連接并修改數據庫復制endpoint，去到ec2的終端連接數據庫
[ec2-user@ip-10-1-3-139 ~]$ sudo -i[root@ip-10-1-3-139 ~]# yum -y install mysql
配置數據庫
【多可用區亞馬遜云 RDB數據故障轉移】[root@ip-10-1-3-139 ~]# mysql -h hello-db.c9d168zhminz.rds.cn-northwest-1.amazonaws.com.cn -u cstor -p12345678Welcome to the MariaDB monitor. Commands end with ; or \g.Your MySQL connection id is 19Server version: 8.0.28 Source distributionCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MySQL [(none)]>MySQL [(none)]>MySQL [(none)]> use testDatabase changedMySQL [test]> create table user (name varchar(20), address varchar(20), primary key (name));Query OK, 0 rows affected (0.10 sec)MySQL [test]> show tables;+----------------+| Tables_in_test |+----------------+| user |+----------------+1 row in set (0.00 sec)MySQL [test]> insert into user (name, address) values ("mqy12", "wuhan" );Query OK, 1 row affected (0.01 sec)MySQL [test]> select * from user;+-------+---------+| name | address |+-------+---------+| mqy12 | wuhan |+-------+---------+1 row in set (0.00 sec)MySQL [test]>部署web應用上傳文件

文章插圖
部署
[root@ip-10-1-3-139 ~]# cd /home/ec2-user/[root@ip-10-1-3-139 ec2-user]# lsserver.conf webServer[root@ip-10-1-3-139 ec2-user]# chmod a+x webServer[root@ip-10-1-3-139 ec2-user]# vim server.conf[root@ip-10-1-3-139 ec2-user]# cat server.conf[mysql_server]mysql_host = "hello-db.c9d168zhminz.rds.cn-northwest-1.amazonaws.com.cn"mysql_port = "3306"mysql_user = "cstor"mysql_password = "12345678"mysql_db = "test"[root@ip-10-1-3-139 ec2-user]# nohup ./webServer &[1] 2787[root@ip-10-1-3-139 ec2-user]# nohup: ignoring input and appending output to ‘nohup.out’[root@ip-10-1-3-139 ec2-user]#[root@ip-10-1-3-139 ec2-user]# curl localhosthello mqy12, from wuhan[root@ip-10-1-3-139 ec2-user]# curl localhosthello mqy12, from wuhan[root@ip-10-1-3-139 ec2-user]# curl localhosthello mqy12, from wuhan[root@ip-10-1-3-139 ec2-user]#