Dear MySQL users,
The MySQL developer tools team announces 8.0.21 as our General Availability
(GA) for MySQL Workbench 8.0.
For discussion, join the MySQL Workbench Forums:
The release is now available in source and binary form for a number of
platforms from our download pages at:
10 Older Entries »
Dear MySQL users,
Passwords lists abound on the net. They exist to: Get a laugh out of silly passwords… 123456 anyone? Develop a dictionary file to check user passwords either for validation or cracking. From MySQL 5.6 the validate_password plugin has been available. … Continue reading →
Just recently, I have been asked to look into what a Disaster Recovery site for InnoDB Cluster would look like.
If you’re reading this, then I assume you’re familiar with what MySQL InnoDB Cluster is, and how it is configured, components, etc.
Reminder: InnoDB Cluster (Group Replication, Shell & Router) in version 8.0 has had serious improvements from 5.7. Please try it out.
So, given that, and given that we want to consider how best to fulfill the need, i.e. create a DR site for our InnoDB Cluster, let’s get started.
Basically I’ll be looking at the following scenario:
InnoDB Cluster Source site with a Group Replication Disaster Recovery Site.
Now, just before we get into the nitty-gritty, here’s the scope.
Life is already hard enough, so we want as much automated as possible, so, yes, InnoDB Cluster gets some of that done, but there are other parts we will still have …[Read more]
From my last blog , I have explained the details about the configuration of InnoDB Cluster ( Group Replication + MySQL shell ) . You can find the link below .
In this blog, I am going to explain How to integrate the MySQL router with the existing cluster setup .
As I explained in Tutorial 1 , I already have configured the cluster setup with MySQL shell and group replication,
MySQL 192.168.33.11:3306 ssl JS > cluster.getName();
MySQL 192.168.33.11:3306 ssl JS > \sql
Switching to SQL mode… Commands end with ;
MySQL 192.168.33.11:3306 ssl SQL > select channel_name,member_host,member_state,member_role,member_version from …[Read more]
MySQL InnoDB Cluster has introduced by the MySQL team for the High Availability ( HA ) purpose . It provides a complete high availability solution for MySQL.
Alright, I am planning to write the series of the blogs about the InnoDB Cluster configurations / Management with MySQL Shell / Monitoring etc …
In this blog I am going to show the InnoDB Cluster configuration with three nodes .
What is InnoDB Cluster ?
MySQL InnoDB Cluster is the Combination of,
- MySQL shell
- Group Replication ( GR )
- MySQL Router
Lab Environment :
I have prepared my lab with three servers,
- OS : Centos 7.7
- MySQL 8.0.18 ( latest version )
The server details are ,
- 192.168.91.11 ( hostname : sakthilabs11 )
- 192.168.91.12 ( hostname : sakthilabs12 ) …
I started my IT career (way back in 1989) using a (dumb) terminal and a 2400-baud modem to access a server. While I still use a terminal window and the command-line, it is always nice to have access to a GUI. In this post, I will show you how to install and use a GUI on your Oracle Cloud …[Read more]
In a previous post, I explained how you can take advantage of Oracle’s “Always Free” Cloud instance to obtain a free Oracle Cloud compute instance (virtual machine) and install a copy of MySQL – without having to pay a setup fee and without incurring any monthly charges. And, you can have two free compute instances per account.
This free Cloud option from Oracle is great. I can think of a lot of ways to utilize a free Oracle Cloud compute instance – but the first one that came to …[Read more]
Most other hyperscale cloud vendors offer a free 12-month trial before they start charging you, so to see Oracle provide a “truly free” service is really great. And the free services are not just limited to one or two choices – you get a wide variety of free services to choose from. As of this blog post, here is a brief summary of free services (these are subject to change in the future):
Databases – Your choice of Autonomous Transaction Processing …[Read more]
Those who build SaaS know that you’re actually providing an experience. You’re building long-term relationships and aiming for recurring revenue. Therefore, your product must be flexible, resilient, and consistent.
Many companies find it hard to take time, acquire the right ingredients, and design truly great software from the bottom-up. This is understandable given how fast the SaaS industry moves.
But firstly, who am I to be talking about this subject? My education was in Economics and Complex Systems, and I’ve been fortunate to gain exposure to various IT trends and tools working almost a decade mostly in Tech. I started interviewing customers at Continuent (majority SaaS) over five years ago, and I have listened to a number of …[Read more]
10 Older Entries »