RDS

AWS RDS Metrics of Interest To Me

AWS RDS Metrics of Interest To Me – The really important ones – not that others are not at all relevant DatabaseConnections DiskQueueDepth FreeStorageSpace ReplicaLag ReadIOPS WriteIOPS ReadLatency WriteLatency More from LonzoDB on AWS

Two Easy Ways to Determine MySQL Database File Location

Two Easy Ways to Determine MySQL Database File Location: mysql -u root -p select @@datadir; +—————–+ | @@datadir | +—————–+ | /var/lib/mysql/ | +—————–+ 1 row in set (0.00 sec) Or simply edit the my.cnf file – which in my case on this RHEL VM is in /etc/my.cnf datadir=/var/lib/mysql More from LonzoDB on AWS

Multi-Availability Zone RDS Replication and Failover Versus Read Replicas

The main differences between Multi-Availability Zone RDS Database Replication and Failover Versus Read Replicas are that Multi-Availability Zones RDS databases are synchronous and provide failover capabilities Read replicas are asynchronous – and meant for READING – and do NOT provide failover capability. You can do both Multi-Zone and Read Replicas simultaneously at an increased cost. Note: …

Multi-Availability Zone RDS Replication and Failover Versus Read Replicas Read More »

AWS RDS Quick Tip For Solutions Architect Associate Test – Database what is RTO versus RPO

Per Amazon White Paper: Recovery time objective (RTO) — How long does it take to recover after an outage?  The time it takes after a disruption / outage to restore a business process to normal service levels.  For example, if a outage occurs at 8AM and the RTO is 2 hours, the DR process should restore …

AWS RDS Quick Tip For Solutions Architect Associate Test – Database what is RTO versus RPO Read More »

connect to an AWS RDS / MySQL instance from the mysql shell on remotely

connect to an RDS / MySQL instance from the mysql shell on remotely – per the AWS documentation – buried… mysql -h mysql–instance1.123456789012.us-east-1.rds.amazonaws.com -P 3306 -u mymasteruser -p or if the “badboy/mysql” shell is not in your path… you have to add the path… “C:\Program Files\MySQL\MySQL Shell 1.0\bin\mysqlsh.exe” -h myend-point.us-west-1.rds.amazonaws.com -P 3306 -u clouddb -p …

connect to an AWS RDS / MySQL instance from the mysql shell on remotely Read More »