The Oracle Cloud has a lot to offer with it’s Security Focused 2nd Generation OCI environment. My previous blog on OCI IaaS walks us through some of the great IaaS features such as compartments and VCN Subnets where you can run services across private ip addresses. What I’d like to look at this time is… Read More »
In this blog post I’ll be starting another series with MySQL on the Oracle Cloud, but focusing this post on IaaS initial setups. In “the series” I’ll review at a high level, building an InnoDB Cluster on IaaS Compute in the Oracle Cloud, mostly focusing certain cloud characteristics as they pertain to building, staging and managing… Read More »
This is a quick blog demonstrating a couple backup Restore uses cases within a MySQL InnoDB Cluster 8.0 setup. The backup used was completed in a previous blog (part 2 in this series) with the MySQL Enterprise Backup 8.0 utility. I’ll then use that backup to build an additional member to add to the cluster. This blog… Read More »
In this blog post, I’ll highlight new Backup Support in the MySQL Enterprise Backup 8.0 utility for Group Replication and InnoDB Cluster. This will also include usage of the MySQL login-path utility for accessing credentials for the backup process as highlighted in this other blog post on Devops ideas with MySQL and Scripting for Binary Log… Read More »
Features and capabilities continue to arrive in MySQL 8.0, most recently noted in the GA release of MySQL 8.0.13. The mysql-shell 8.0.12 release introduced a number of things, an important part was a cross-platform mysql-shell secure password handling facility. The MySQL Login-paths are a part of that security focus. Here we will look at where InnoDB Cluster 8.0,… Read More »
In Jesper’s blog on Persisted Variables …he introduced us to this new capability using the PERSIST and PERSIST_ONLY keywords. With new MySQL features, such as PERSIST come new areas that we need to pay attention to when doing backup and restore activities. Namely to manage the log file that the PERSIST capability uses, as it’s a… Read More »
There are numerous ways to filter your replication stream in MySQL. So many, that the documentation team has created guided “walk-through” pages for considering the various complex DB Filtering and subsequent Table Filtering paths folks have used for the “global” filtering options. But now there are “channel specific” options that can be implemented at startup with enhanced… Read More »
MySQL Package Management Options In this blog we will explore some interesting ways to install MySQL Community and Enterprise Edition binaries using your associated Linux package manager. In this case we’ll look mostly at the Yum package manager on Oracle Linux. The benefit of these package managers is that you can install software packages easily,… Read More »
Recently MySQL launched the General Availability of their Group Replication enhancements via the MySQL Shell and MySQL Router. Although these URLs just noted go to their respective documentation pages, these collectively are part of the InnoDB Cluster offering. The MySQL shell provides sophisticated provisioning, monitored insight and management of a Group Replication setup. When provisioned as such, you… Read More »
In this blog, I intend to present the MySQL Enterprise Monitor (MEM), and also to present a multi-machine vagrant setup by adding a vagrant-hostmanager plugin to configure the /etc/hosts on the VMs. To start, I begin by installing the hostmanager plugin on my mac where I manage my environments.
vajra-light:mem-demo my$ vagrant plugin install vagrant-hostmanager
Installing the 'vagrant-hostmanager' plugin. This can take a few minutes...
Installed the plugin 'vagrant-hostmanager (1.8.1)'!
OK, so that was easy.… Read More »