As announced in the previous blog post, MySQL InnoDB Cluster just got a very much requested feature which makes a complete, out-of-the-box, easy-to-use and versatile HA solution – Automatic Node Provisioning.
InnoDB cluster users can now rely on it for every single step of cluster deployment and management.…
Tweet Google Plus Share
The MySQL Development Team is very excited and proud of what was achieved in this 8.0.17 GA release!
The spotlight is on… A game-changer feature – Automatic Node provisioning!
This has been an extremely desired and important feature, and it has been accomplished, once again, with tight integration and cooperation of MySQL Components:
… Tweet Google Plus Share
The MySQL Development Team is very excited and proud to announce a new 8.0 Maintenance Release of InnoDB Cluster – 8.0.17!
In addition to important bug fixes and improvements, 8.0.17 brings a game-changer feature!
This blog post will cover MySQL Shell and the AdminAPI, for detailed information of what’s new in MySQL Router stay tuned for an upcoming blog post!…
Facebook Twitter Google+ LinkedIn
PORP LAB : ProxySQL/Orchestrator/Replication/PMM Summary PORP Lab will create 4 different nodes. Each node will have below packages/applications/db installed.
app
-- Percona Server 5.7
-- Percona Toolkit
-- Percona XtraBackup
-- Sysbench
-- ProxySQL
-- Orchestrator
-- PMM
mysql1 / mysql2 / mysql3
-- Percona Server 5.7
-- Percona Toolkit
-- pmm-client
-- Replication
PORP LAB have ProxySQL,Orchestrator and PMM properly configured,
we can just create this lab and use it.
Install VirtualBox
Version 5.2.22 or Later
Install Vagrant
Version 2.2.2 or Later
Install Vagrant plugin hostmanager
vagrant plugin install vagrant-hostmanager
Update Vagrant Plugin
vagrant …[Read more]
Create CentOS VM using Vagrant
1. Download and install the
latest Oracle VM VirtualBox.
https://www.oracle.com/technetwork/server-storage/virtualbox/downloads/index.html
Like (For Mac OS X)
https://download.oracle.com/virtualbox/6.0.6/VirtualBox-6.0.6-130049-OSX.dmg
2. Download and install the latest Vagrant.
https://www.vagrantup.com/downloads.html
Like (For Mac OS X) …
The MySQL Development Team is very happy to announce a new 8.0 GA Maintenance Release of InnoDB Cluster – 8.0.16!
In addition to important bug fixes, 8.0.16 brings very useful new features!
This blog post will cover MySQL Shell and the AdminAPI, for detailed information of what’s new in MySQL Router stay tuned for an upcoming blog post!…
Facebook Twitter Google+ LinkedIn
Write code, test and deploy
This is one of the common development cycles of any developer.
Most of the time testing and deployment steps do not change frequently and in order to keep the developer focus on writing code, we do the automation of testing and deployment.
This automation is called “continuous integration and deployment” OR CI/CD Pipeline.
In this tutorial, we will learn how to set up continuous integration and deployment (CI/CD) infrastructure for the Node.js project.
Prerequistics
I am going to use Jenkins as the automation tool and Github as source code management system.
Jenkins is free for use but we require public server in order to integrate the Github repository.
For the server, I will be using $5 droplet on Digitalocean. In case you wish to buy it, you …
[Read more]Continuent Tungsten is one of the few all-in-one solutions for MySQL high availability. In this post I will show you how to automate the upgrade process using Ansible. I will walk you through the individual tasks and, finally, give you the complete playbook.
We will use a rolling approach, upgrading the slaves first, and finally upgrading the former master. There is no need for a master switch, as the process is transparent to the application.
I am assuming you are using the .ini based installation method. If you are still using staging host, I suggest you update your set up.
Pre tasks
The first step is ensuring the cluster is healthy, because we don’t want to start taking nodes offline unless we are sure the cluster is in good shape. One way of doing that is by using the built-in script tungsten_monitor. When we run the playbook, we only need to validate the cluster status on one node, so I am adding …
[Read more]The latest release of the MySQL Shell 8.0.14 (GA) improved the JSON import utility to support the conversion of more BSON data types from the strict mode representation of MongoDB Extended JSON. This removes a previous limitation regarding the import of more complex MongoDB data types to MySQL, making it more reliable.…
Facebook Twitter Google+ LinkedIn
This is my next blog series. Im going to write about how I automated many complex tasks in MySQL with Rundeck. In my last series, I have explained RunDeck basics. You can find those articles here. In this blog Im writing about how I automated MySQL archive for multiple tables in one Rundeck job. Challeange …
The post MySQL With DevOps 1 – Automate Database Archive appeared first on SQLgossip.
