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.

Our pleasure to inform & invite you to the MySQL Virtual Meetup hold next week - just before Christmas. Please find details below:

• Date: December 22, 2020
• Time: 6:30 PM to 8:30 PM GMT+4
• Place: VIRTUAL event
• URL with more details: MySQL User Group U.A.E
• Speaker(s): 
  • Chetan Rao, the Territory Manager MySQL Enterprise Middle East & Africa
  • Abdullah Zarour, the MySQL Principal Solution Engineer
  • Carsten Thalheimer the MySQL Cloud Evangelist
• Covered topics: MySQL InnoDB Cluster and InnoDB ReplicaSets & Oracle MySQL Cloud Services as two main topics or themes of this meetup.

You are more than welcome to join!

Our pleasure to inform & invite you to the MySQL Virtual Meetup hold next week - just before Christmas. Please find details below: Date: December 22, 2020 Time: 6:30 PM to 8:30 PM GMT+4 Place: VIRTUAL event URL with more details: MySQL User Group U.A.E Speaker(s): Chetan Rao, the Territory Manager M...