@Amimoto_Ami amimoto-ami.com AMIMOTO (HHVM) + AMAZON RDS

WHAT IS AMAZON RDS

Scalable 6 database engines Relational Database Easy to set up and operate

ADVANTAGES • Scale your CPU, IOPS, and storage space
 • Snapshot-based on demand 
 and automatic backups
 • Multi Availability Zones deployment
 • Secondery synchronous instance in 
 case the primary fails

DISADVANTAGES • No shell access to the DB instance
 • Restricted user privileges
 • Disabled replication in MySQL
 • Weekly 4-hour maintenance window
 • RDS Instance cannot be stopped

MOVING YOUR
 DATABASE TO RDS

Architecture without RDS

Architecture with RDS

Login to your AWS Console

Creating a MySQL server in Amazon RDS

Database Engine

Database Engine

Specify database details

Advanced Settings

Creating DB

DB created

Login to your instance

Connecting your EC2 to RDS 1. Log into the root of your server using SSH:
 
 $ ssh -i /Users/macpil/Desktop/example.pem ec2-user@instance_ip or domain
 2. Run the following command:
 
 $ mysql -h {endpoint} -P 3306 -u {mymasteruser} -p 


{endpoint} can be found in the RDS information of AWS Management Console
 {mymasteruser} and password are specified when you want to create RDS

Data migration Export data via wp-cli:
 
 $ wp --path=/path/to/wordpress db export
 
 
 /path/to/wordpress is the directory where WordPress is installed
 In AMIMOTO AMI it’s usually /var/www/vhosts/{instance_id} 


Data migration Import data to RDS:
 
 $ mysql -h {endpoint} -P 3306 -u {mymasteruser} -p {databasename} < dump.sql
 
 {endpoint} can be found in the RDS information of AWS Management Console
 {mymasteruser} and {databasename} are specified when you want to create RDS

Rewriting wp-config.php // ** MySQL settings - You can get this info from your web host ** // $db_data = false; if ( file_exists('/opt/aws/cloud_formation.json') ) { $db_data = json_decode(file_get_contents('/opt/aws/ cloud_formation.json'), true); if ( isset($db_data['rds']) ) { $db_data = $db_data['rds']; $db_data['host'] = $db_data['endpoint'] . ':' . $db_data['port']; } } if ( !$db_data ) { $db_data = array( 'database' => 'RDS_DATABASE_NAME_HERE', 'username' => 'RDS_USER_NAME_HERE', 'password' => 'RDS_PASSWORD_HERE', 'host' => 'RDS_ENDPOINT_HERE', ); }

Rewriting wp-config.php RDS_DATABASE_NAME_HERE Database Name which was set in Configure Advanced Settings RDS_USER_NAME_HERE Master Username which was set in Specify DB Details RDS_PASSWORD_HERE Master Password which was set in Specify DB Details RDS_ENDPOINT_HERE RDS endpoint When you set as above in wp-config.php, let’s check if you can connect to WordPress.

Stoping MySQL in the AMIMOTO AMI Since MySQL was moved to RDS, MySQL process in AMIMOTO AMI is no longer necessary. Rewrite the configuration file, in AMIMOTO AMI, the middleware settings use chef-solo, where they are described in /opt/local/amimoto.json

Stoping MySQL in the AMIMOTO AMI Since MySQL was moved to RDS, MySQL process in AMIMOTO AMI is no longer necessary. Rewrite the configuration file, in AMIMOTO AMI, the middleware settings use chef-solo, where they are described in /opt/local/amimoto.json 
 To stop starting MySQL, please rewrite the file:
 
 {
 "nginx" : { "config" : { "user" : "nginx", "group" : "nginx" } },
 "php" : { "config" : { "user" : "nginx", "group" : "nginx" } },
 "mysql" : { "enabled" : false },
 "phpfpm" : { "enabled" : true },
 "run_list" : [ "recipe[amimoto]" ]
 }

Stoping MySQL in the AMIMOTO AMI For AMIMOTO AMI HHVM version, rewrite as follows: { "nginx" : { "config" : { "user" : "nginx", "group" : "nginx" } }, "php" : { "config" : { "user" : "nginx", "group" : "nginx" } }, "mysql" : { "enabled" : false }, "hhvm" : { "enabled" : true }, "run_list" : [ "recipe[amimoto]" ] }

Stoping MySQL in the AMIMOTO AMI Finally run the following command:
 
 $ sudo /opt/local/proviosion 
 $ mysql stop service

http://amimoto-ami.com/slack/ Questions:

@Amimoto_Ami amimoto-ami.com THANK YOU! AMIMOTO (HHVM) + AMAZON RDS