I’ve been playing with InnoDB cluster the whole weekend. on this post i’m trying to start my cluster from complete outage.
i don’t have idea which is the primary to bootstrap. using the manual way i know how to do it.
But now, i want to use MySQL Shell.
after shutdown all my 3 node then start it again. below is the current status. —>
#MySQL #InnoDB cluster is a collection of products that work together to provide a complete High Availability solution for MySQL.
A group of MySQL servers can be configured to create a cluster using MySQL Shell.
In the default single-primary mode, the cluster of servers has a single read-write primary.
Multiple secondary servers are replicas of the primary.
Creating a cluster with at least three servers ensures a high availability cluster.
A client application is connected to the primary via MySQL Router.
If the primary fails, a secondary is automatically promoted to the role of primary,
and MySQL Router routes requests to the new primary.
Advanced users can also configure a cluster to have multiple-primaries.
On my previous post i already created my group replication, but to maximize the use feature of mysql router, we need a shell. —>
Group Replication is a new technology and from time to time we encounter issues.
Today my issue is the primary node server crash and it comes up again it didn’t join my cluster.
I logged in to the server manually start the group replication. but got and error. —>
MySQL Group Replication is a MySQL Server plugin that enables you to create elastic, highly-available, fault-tolerant replication topologies.
Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, for more advanced users, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued concurrently.
There is a built-in group membership service that keeps the view of the group consistent and available for all servers at any given point in time. Servers can leave and join the group and the view is updated accordingly. Sometimes servers can leave the group unexpectedly, in which case the failure detection mechanism detects this and notifies the group that the view has changed. This is all automatic.
As i prepare to roll out a 6 Node Group Replication in production, we are currently in the process of setting up our UAT environment.
It will be running 3 Node cluster.
On my previous post I intalled and configure a 3 node MariaDB 10.1 cluster for my evaluation purpose
for our current project…
Let install the latest MaxScale .. —>
Currently i’m on the process of choosing the matured product like galera clustering vs the new MySQL Group Replication.
I’m my past engagement, i only work on MariaDB 5.5 and 5.6 with galera cluster running on cloud.
The following are the step to create my test machine. —>
I’m on the process of deploying Oracle Enterprise Manager 13c on my new company since there is no proper monitoring currently setup. though at server level they are using solarwind.
when i’m trying to deploy oracle agent linux using the gui, i got some weird error, so i decided to go manual installation. —>
Currently been busy with doing some migration stuff from MySQL to NuoDB.
Since my binlog directory is almost full, decided to delete its content.
no issue on my database while its running but when i restarted my database got below error. —>
I’m just new in my current role in my new company. One of my task is to look for a new database technologies.. that will become our platform of choice, and maybe migrate our MySQL and Oracle.
So many many new DB Technologies now, one of them in NuoDB.
To do the test drive download the software required from NuoDB. http://www.nuodb.com/product/evaluate-nuodb
Today i’d been busy working on my cluster… its a 3 node running in Ubuntu.
this is a basic configuration of Neo4j cluster… on my next time let try anvance feature including backup and recovery.
First thing we need to check is the Java.
neo4j@lnxneo4j01:~$ java -version
openjdk version "1.8.0_91"
OpenJDK Runtime Environment (build 1.8.0_91-8u91-b14-3ubuntu1~16.04.1-b14)
OpenJDK 64-Bit Server VM (build 25.91-b14, mixed mode)