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.
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
Since MySQL 8.0.16, the Router as the possibility to launch an internal webserver (see Jan’s blog post). Even if this webserver could serve static files, it was the first piece of a much more interesting solution that is now available since 8.0.17. It’s possible now to query the MySQL Router via its REST API and get a lot of useful … Read More
Create a MySQL InnoDB Cluster using MySQL 8.0 has always been very easy. Certainly thanks to MySQL Shell and server enhancements like SET PERSIST and RESTART statement (see this post). The most complicated part to deal with was the existing and none existing data. In fact GTID sets must be compatible. Let me explain that with some examples: Example 1 … Read More
To operate more easily a MySQL Group Replication (InnoDB Cluster), the Group Replication plugins provides some UDFs. If you have read the recent article from Tiago Vale about the Group Replication Communication Protocol, you may have heard about two new UDFs allowing to get or set the communication protocol. So what are all the UDFs provided with the Group Replication … Read More