Importing and Exporting Data into Amazon RDS We had a business need to load ~ Billion rows of Data into MySQL or Aurora Database. These are the information I gathered on optimizing load process. Load Data Infile Link to MySQL Amazon Recommendations based on their …
Amazon RDS Information
Aurora RDS: AWS Released encryption for Aurora Instances. Encryption is not available as of now. Amazon RDS Encryption Links Encrypting Amazon RDS Resources You can encrypt your Amazon RDS instances and snapshots at rest by enabling the encryption option for your Amazon RDS DB instance. …
MySQL Ramp Up
MYSQL: Add Column to Existing Table and Make it Auto Increment and Add Primary Key Constraint Link : Alter Table and Add Column ALTER TABLE StudentPortalData ADD StudentPortalDataID INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (StudentPortalDataID); Query Plan and Query Profile for Executed Queries …
Attaching Volume to EC2 Instance
Attaching Volume to EC2 Instance To list the partitions $ cat /proc/partitions major minor #blocks name 202 1 52428800 xvda1 Create a Volume in EC2 Instance and attach it to the instance. $ cat /proc/partitions major minor #blocks name 202 …
MySQL and phpMyAdmin Setup
MySQL and phpMyAdmin Setup sudo yum install mysql sudo yum install mysql-server sudo yum install mysql-devel sudo chgrp -R mysql /var/lib/mysql sudo chmod -R 770 /var/lib/mysql sudo service mysqld start sudo yum install phpmyadmin Errors: # tail -f error.log 2014/03/06 20:11:05 [error] 2833#0: *1 directory …
Install S3CMD tools on EC2 Instance.
Install S3CMD tools on EC2 Instance. SSH Into your EC2 Box and you run the following command to install S3CMD. $ sudo yum install s3cmd Loaded plugins: priorities, update-motd, upgrade-helper Bad id for repo: datastax , byte = 8 amzn-main/latest | 2.1 kB 00:00 amzn-updates/latest …