How to set up MySQL password rotation with AWS Secrets Manager, AWS Lambda, and Terraform

How to set up MySQL password rotation with AWS Secrets Manager, AWS Lambda, and Terraform

A lot of elements take part in a good backup strategy. Two of them are:

• Where to store your backups – Never on the same server. Preferable not in the same datacenter. Ideally far enough so you can restore in case of a natural disaster (region flood, extended local power outage, etc…).
• Retention period – The longer, the better.

Those points relate directly to costs. Storing a backup on an off-site facility cost money. Keeping the backups available to fulfill your retention period policy costs money.

The main cloud providers have different layers of storage often called Storage Class. Each layer has its own particularities and policies, but they come with an important factor – Cost!

We are happy to announce that starting at …

You only have to choose your favorite flavour to setup, administer, configure, backup or attach an analytics cluster to your MDS DB System, as Oracle maintains SDKs in several languages to integrate your software with Oracle Cloud Infrastructure.

And in particular today I’d like to test the SDK for Python, you can find an introduction here (but you have also SDKs for Java, Go, Ruby, Javascript, .NET). Read an introduction to SDKs.

First of all let’s create a virtual environment (venv) to work in a containerized environment.

bash-3.2$ python3 -m venv .
bash-3.2$ ll
total 8
drwxr-xr-x  14 mortensi …

First we will talk about some of the other internal users of the technology that underpins the InnoDB Clone. MySQL Enterprise Backup (MEB) is an enterprise offering that provides backup and recovery for MySQL. Among various types of backups available, the following two types are of interest to us:

• Full Backup – A backup that backs up the entire MySQL instance – all the tables in each MySQL database.

… Facebook Twitter LinkedIn

MySQL 5.7, alongside other many improvements, brought bulk load for creating an index (WL#7277 to be specific), which made ADD INDEX operations much faster by disabling redo logging and making the changes directly to tablespace files. This change requires extra care for backup tools. To block DDL statements on an instance, Percona Server for MySQL implemented LOCK TABLES FOR BACKUP. Percona XtraBackup (PXB) uses this lock for the duration of the backup. This lock does not affect DML statements.

MySQL 5.7 doesn’t have an option to block an instance against DDL and to allow all MDL’s. Thus, Percona XtraBackup has also implemented –lock-ddl-per-table. Before we go into other details, let’s understand how –lock-ddl-per-table works up to now:

1. PXB …

As mentioned in the AWS discussion forum back in October, Amazon has started the end of life (EOL) process for RDS MySQL version 5.5. What this means is:

• AWS will upgrade RDS instances to MySQL 5.7 starting February 9 2021 00:00 UTC during your next defined maintenance window, provided you have one.
• If you don’t have a maintenance window defined, RDS will automatically upgrade you on March 9 00:00 UTC and there is no opt-out.

As any seasoned administrator knows, upgrades can be painful and things might go wrong.

Risks

I think we can safely assume that the upgrade will be performed in-place, as it would be too complex and time-consuming otherwise. Since a direct upgrade from 5.5 to 5.7 is not supported, we need to go through 5.6 first. This means instances need to be restarted twice; first to go from …

In this post we will see the unique features of MySQL Cluster i.e. Self healing and no single point of failure.

MySQL Cluster No Single Point Of Failure:

As we know that in MySQL Cluster, data nodes are logically grouped into nodegroups. All data nodes in a nodegroup contain the same data, kept in sync at all times. Different nodegroups contain different data. So in a single nodegroup, MySQL Cluster can sustain multiple node shutdown at the same time but at least one node must live in that nodegroup. Lets demonstrate this feature with a 4 replicas cluster where each nodegroup have 4 data nodes.

Lets create a MySQL Cluster with below environment.

• MySQL Cluster 8.0.22 version
• 2 Management servers
• 8 Data nodes servers
• 2 Mysqld servers
• 4 API nodes
• OS: Ubuntu 20.04 LTS
• NoOfReplicas = 4
  

…

In this post, we will see how easily we can install MySQL Cluster on different physical hosts. One can install MySQL Cluster on a single host too. If you are wondering what MySQL Cluster is then please look into my previous post.
MySQL Cluster Installation:

Lets create a MySQL Cluster with the following environment:

• MySQL Cluster 8.0.22 version

• 2 Management servers

• 4 Data nodes servers

• 2 Mysqld servers

• 4 API nodes

• OS: Ubuntu 20.04 LTS
  
  
  

Hostname and IP address of all the nodes in the MySQL Cluster:
Management Node1 (mgmt1):        Hostname: …

Today we announce the availability of MySQL Database Service with HeatWave in four additional regions: Australia East (Sydney), Saudi Arabia West (Jeddah), South Korea Central (Seoul) and South Korea North (Chuncheon).

With those new regions, you can now deploy MySQL Database Service with HeatWave in 12 Oracle Cloud Infrastructure regions, including Brazil East (Sao Paulo), Canada Southeast (Toronto), Germany Central (Frankfurt), India West (Mumbai), Japan East (Tokyo), UK South (London), US East (Ashburn), and US West (Phoenix).

If you want a free trial, go to oracle.com/cloud/free and get access to a wide range of Oracle Cloud services for 30 days. Check the documentation for the quick steps to create your MySQL databases. 

…