Unable to Start MySQL Enterprise Monitor Agent on Linux

Posted on by baironnie

I just completed installing the MySQL Enterprise Monitor agent but when I started, it got failed.

[dbadmin@lnxmysqlgr-db1 ~]$ /home/dbadmin/mem_agent/etc/init.d/mysql-monitor-agent start 
Starting MySQL Enterprise Agent service... ERROR! MySQL Enterprise Agent failed to start. 
[dbadmin@lnxmysqlgr-db1 ~]

—>

My Journey to Cloud Computing.

Posted on by baironnie

We know that cloud computing is where we are going.. to keep abreast on current technology.

4 months ago i started to learning AWS technology and last June i cleared my first AWS Badge.
1. AWS Certified Solutions Architect – Associate.

Screen Shot 2017-07-26 at 9.04.21 PM

As part of my ongoing learning on AWS, I’m using qwiklabs for doing some activity.

Screen Shot 2017-07-26 at 8.59.01 PM

As an IT professional, continuous learning is very important no matter how busy we are in our current work.

My Next Goal is Big Data specialty exam and the Professional exam.

 

 

How To : Recover the InnoDB Cluster from complete outage.

Posted on by baironnie

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

How To : Creating an InnoDB Cluster From an Existing Group Replication Deployment

Posted on by baironnie

#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. —>

How To : Setup MySQL Group Replication

Posted on by baironnie

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.

—>