Amazon RDS interview questions

51. How can I delete historical data ?
Since Enhanced Monitoring delivers JSON payloads into a log in your CloudWatch Logs account, you can control its retention period just like any other CloudWatch Logs stream. The default retention period configured for Enhanced Monitoring in CloudWatch Logs is 30 days.

52. What is Amazon RDS Magnetic storage ?
Amazon RDS magnetic storage is useful for small database workloads where data is accessed less frequently. Magnetic storage is not recommended for production database instances.

53. How do I choose among the Amazon RDS storage types ?
High-performance OLTP workloads: Amazon RDS Provisioned IOPS (SSD) Storage
Database workloads with moderate I/O requirements: Amazon RDS General Purpose (SSD) Storage

54. How to output Mysql query results in CSV format ?
Option : 1
SELECT cust_id,cust_name,age
FROM customer
WHERE foo = ‘bar’
INTO OUTFILE ‘/var/lib/files/cust.csv’
FIELDS TERMINATED BY ‘,’
ENCLOSED BY ‘”‘
LINES TERMINATED BY ‘\n’;
Option : 2
mysql -u username -p –database=dbname –host=rdshostname –port=rdsport –batch
-e “select * from yourtable”
| sed ‘s/\t/”,”/g;s/^/”/;s/$/”/;s/\n//g’ > yourlocalfilename

55. Is Amazon RDS instances upgradable ?
Yes, Amazon RDS instances are upgradeable via the modify-db-instance command. There is no need for data migration.

Author: user

Leave a Reply