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. 

…

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 i...

Disaster Recovery for Continuous MySQL Operations does not have to be hard, but it does have to be WAN: Multi-Site, Hybrid-Cloud, Multi-Cloud. This blog discusses Business Continuity, Disaster Recovery, or “DR,” and an overlooked clustering feature that makes continuous database operations easy, affordable, and manageable.

Tags: MySQLMariaDBmysql continuous operationsmysql clusteringHigh AvailabilityDisaster …

ProductIP has been a Continuent customer since November 2014 and is sharing its Continuent experience here: from initially setting up their infrastructure in Hong Kong to running a geographically distributed MySQL database replication and clustering environment with Continuent Tungsten, read about their journey with us in this guest post.

Tags: MySQLMySQL Replicationmysql clusteringgeo-distributedtungsten clusteringtungsten replicator …

In one of our previous articles - Setting up Replication with various methods for MySQL 8 - we reviewed how to create a replica with multiple tools.
Now, it is time to perform the same action but with MySQL Shell.

The post MySQL SHELL – The new era first appeared on dasini.net - Diary of a MySQL experts.

Learn how to safely rename a column in a MySQL database using a universal multi-featured tool – dbForge Studio for MySQL. To paraphrase Heraclitus, the only constant is change. That concerns databases too. With time, business requirements change forcing the database development process to adapt. Thus, database developers increasingly face the necessity to perform structural database […]

The post How to Change a Column Name in MySQL appeared first on Devart Blog.