The cluster endpoint connects you to the primary instance for the DB cluster. You can perform both read and write operations using the cluster endpoint. The DB cluster can also have up to 15 Aurora Replicas that support read-only access to the data in the DB cluster. The primary instance and each Aurora Replica has…
Category: AWS
Backup and Purge RDS Snapshots in AWS
Here is a script I’ve put together to backup both cluster and non clustered databases in AWS. (Still in progress).
Everything Aurora (MySQL)
Recently AWS released their version of MySQL called Aurora, they claim it delivers up to five times the throughput of standard MySQL. This article explores some of the depths of this database technology, especially coming from an Oracle Database background. Character Sets In an Oracle system, you can define 2 character sets, one is used…
How to Perform a AWS Aurora Point In Time Recovery
AWS Aurora Point in time recovery Restore AWS Aurora from Point in time snapshot (go back to a specific point in time). These are the Steps Restoring to point in time snapshot of AWS RDS Aurora (to any time with-in the backup retention period irrespective of the frequency of automated backups). 1. In AWS console,…
How to Restore an RDS database in AWS
Restore from a snapshot (either manual or automated). NOTE: To restore the new instance with same as the original one, first the old/original instance must be renamed to something else then the new instance from snapshot can be restored with the required name (can be same as old). Restoring from manual/automated snapshot of AWS RDS…
How to stop and start RDS instance in AWS using Python
I’ve been working on a project that requires us to shutdown and startup our development databases to save costs.. I’ve come up with a python script to perform the tasks. This could be modified to your own requirements. Here is the code:
InnoDB Information
Displays extensive information from the standard InnoDB Monitor about the state of the InnoDB storage engine. There are four types of InnoDB monitors: • The standard InnoDB Monitor displays the following types of information: • Work done by the main background thread • Semaphore waits • Data about the most recent foreign key and…
Lambda Function in Aurora
How to create a lambda function to insert some records in an Aurora Database in AWS. Here is some sample code. This will enable us to link to databases in AWS to perform some functions. You also need to create a configuration file that contains the user name, password and database name You…
AWS Latency Ping
How to ping the AWS zones for latency