lefred's blog


There Are 10 Types of People in the World....

Setup 2 MySQL InnoDB Clusters on 2 DCs and link them for DR

This article is an update of a previous post explaining how to setup a second cluster on a second data center to be used as disaster recovery (or to run some off site queries, like long reports, etc..). This new article covers also the CLONE plugin. Before you ask, CLONE plugin and Replication Channel Based Filters are only available in … Read More


How to integrate ProxySQL in MySQL InnoDB Cluster

MySQL InnoDB Cluster is the most easy and integrated High Availability solution for MySQL. The solution is composed of: MySQL Server MySQL Group Replication Plugin MySQL Clone Plugin MySQL Router MySQL Shell All those components are developed and tested together to provide the easiest and best experience to the MySQL users. As the MySQL Router is a TCP Level 4 … Read More


Join the Code ONE MySQL Track at Oracle Open World in San Francisco

Mid September, MySQL Community, MySQL Customers and MySQL Engineers will be in San Francisco to share their experience and present the new features of your favorite database ! The event will be held in Moscone South (just Mirko Ortensi‘s Hands-on Lab will be delivered in Moscone West). During the week, the MySQL Community Team will host the traditional MySQL Reception. … Read More


MySQL InnoDB Cluster, automatic provisioning, firewall and SELinux

You may have noticed that in many of my demos, I disable firewall and SELinux (I even use –initialize-insecure sometimes 😉 ). This is just to make things easier… But in fact enabling iptables and SELinux are not complicated.


MySQL Router 8.0.17’s REST API & MySQL Shell Extensions

You have seen in this previous post, that since 8.0.17, it’s now possible to query the MySQL Router using its REST API. Additionally, we also saw in this post, that since 8.0.17, we are now able to write extensions to MySQL Shell using the Extension Framework. Let’s combine both and see how we can integrate the MySQL Router’s REST API … Read More


recent
categories