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.
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 with Replication:
My MySQL database setup has 1 Master 4 Read Replica and the 3’rd replica is an intermediate Master for Replica 4. I don’t want to archive this data on Replica 3 and 4. Because these replicas are using for generating historical reports also some internal application.
Disable Log-Bin:
To prevent archive data on Replica 3 and 4, I decided to disable binlog on my archive session. But another challenge is, it won’t replicate to Replica 1 and 2. So my final solution is Archive the data on Master, then execute the …
[Read more]This blog post completes the series that we have been composing to detail every single new feature added in the latest MySQL InnoDB Cluster release, as mentioned in the release announcement of 8.0.14. We’ll close the series now with the details about the new features that improve the management capabilities of MySQL Shell: “Extended status information available from <Cluster.>status()” and “Redesigned and extended <Cluster.>rescan()”.…
Facebook Twitter Google+ LinkedIn
Introduction :
Ansible is an open-source IT automation engine which can remove drudgery from your work life, and will also dramatically improve the scalability, consistency, and reliability of your IT environment.
Nowadays without automation to manage the Databases is very tricky. We are using Ansible as an infra automation tool to install, configure and manage DB infra at Mydbops.
For example, you have 10 Linux server’s which needs MySQL latest version 8.0 to be installed. Anyone can install MySQL using yum or apt-get. But the manual installation is a time-consuming process.
In this blog, I am going to describe the installation of MySQL 8.0 using Ansible.
Ansible Architecture :
Host …
[Read more]This blog post follows the series that we have been composing to detail every single new feature added in the latest MySQL InnoDB Cluster release. As listed in the release announcement of 8.0.14, we’re very happy with new features that greatly enhance the whole experience and capabilities of InnoDB cluster!…
Facebook Twitter Google+ LinkedIn
As listed in the release announcement of the latest MySQL InnoDB Cluster release, 8.0.14 brings exciting new features! This blog post integrates a series detailing every single new feature added. We’ll follow up now with two very desired and useful features: “Checking current cluster configuration options” and “Changing cluster members or global cluster options ‘live'”.…
Facebook Twitter Google+ LinkedIn
As listed in the release announcement of the latest MySQL InnoDB Cluster release, 8.0.14 brings exciting new features! This blog post is the first of a series detailing every single new feature added, starting by: “Changing cluster topology modes ‘live‘”.…
The MySQL Development Team is very happy to announce a new 8.0 Maintenance Release of InnoDB Cluster – 8.0.14!
In addition to bug fixes, 8.0.14 brings exciting new features!
MySQL Shell
For this release, we have focused on extending the AdminAPI with several highly desired features.…
For the third year in a row, we will take advantage of the mass presence of our MySQL Engineers during FOSDEM to organize the pre-FOSDEM MySQL Day.
The program of this 3rd edition is already on track, thank you to all the speakers who already confirmed their participation.
| Start | End | Event | Speaker | Company | Topic |
|---|---|---|---|---|---|
| Friday 1st February | |||||
| 09:30 | 10:00 | MySQL Community Team Welcome | |||
| 10:00 | …
MySQL Shell is a command-line shell for MySQL Server that has the
capability for
interactive and batch code execution. It also
offers a wealth of APIs that make it easier and more efficient to
work with and manage MySQL servers. In 8.0.13, we made an effort
to make those APIs easily accessible straight from the command
line.…