For my presentation for the next FOSDEM MySQL Devroom, I needed to create some load.
As usual, for this task, what better than sysbench ?
The “problem” was that my system was already setup and I used OL7 on the always free Ampere compute instance on OCI.
As you may know, this is an ARM architecture
(aarch64) and there was not sysbench
rpm package available for this OS and architecture.
I also wanted to have sysbench compiled and linked
with MySQL 8.0 libraries [1], [ …
There are plenty of articles on the Internet that tell you to setup a Galera Cluster by disabling an OS based firewall and also disabling SELinux. While we agree that this might be the fastest way to get your Galera Cluster setup, it is not necessarily good security hygiene, and we would prefer if you started 2022 with a bit more secure Galera Cluster!
What is SELinux? Is is Security-Enhanced Linux that allows administrators to allow who has more control over the system. It has permissive and enforcing mode, and is turned on by default in Red Hat Enterprise Linux and derivatives. It is important to remember that if you install Galera Cluster via a package that we provide, we have provided all the necessary contexts for it. You effectively do not have to disable SELinux to get started.
However, if you are using the rsync method for a …
[Read more]MySQL Database Service with HeatWave is now available globally in 30 regions Oracle Cloud Infrastructure commercial regions. The most recent addition is Johannesburg in South Africa.
Hello,
Due to a complete misunderstanding about the available slots, FOSDEM’s organization had to remove 2 talks from the previous planned agenda.
However, we didn’t want to announce to previously accepted speakers that their talks were cancelled ! Therefore, we decided, with FOSDEM’s approval, to extend the FOSDEM 2022 MySQL Devroom, opening our room on Saturday afternoon.
Two talks were then moved to Saturday and the two backup talks were immediately added to the schedule !
More work for us and our speakers but more pleasure for all the MySQL fans !
Don’t miss FOSDEM MySQL Devroom’s 2022 edition, free online conference.
Here is the new updated schedule (the official one …
[Read more]This post is the sixth post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:
I’m resharing a post I first published over on my Medium account for interested readers here. As you know, SQL is my passion and sweet spot. But, I also have an affinity for PHP and CodeIgniter. Continue reading and learn how I prototype Query Builder patterns in CodeIgniter 4…
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!
The Newsletter for PHP and MySQL Developers
CodeIgniter 4 Query Helper methods
I use the CodeIgniter 4 Query Helper, $db->getLastQuery() method a great deal to learn just how Query Builder methods are mapping to the actual SQL …
[Read more]This post is the fifth post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:
In April 2021, I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented.
Anyhow, in that article I have shown how an online DDL was de facto locking the whole cluster for a very long time even when using the consistency level set to EVENTUAL.
This article is to give justice to the work done by the MySQL/Oracle engineers to correct that annoying inconvenience.
Before going ahead, let us remember how an Online DDL was propagated in a group replication cluster, and identify the differences with what happens now, all with the consistency level set to EVENTUAL ( …
[Read more]Last April 2021 I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented.
Anyhow, in that article I have shown how an online DDL was de facto locking the whole cluster for a very long time even when using the consistency level set to EVENTUAL.
This article is to give justice to the work done by the MySQL/Oracle engineers to correct that annoying inconvenience.
Before going ahead, let us remember how an Online DDL was propagated in a group replication cluster, and identify the differences with what happens now, all with the consistency level set to EVENTUAL ( …
[Read more]Last April 2021 I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented.
Anyhow, in that article I have shown how an online DDL was de facto locking the whole cluster for a very long time even when using the consistency level set to EVENTUAL.
This article is to give justice to the work done by the MySQL/Oracle engineers to correct that annoying inconvenience.
Before going ahead, let us remember how an Online DDL was propagated in a group replication cluster, and identify the differences with what happens now, all with the consistency level set to EVENTUAL ( …
[Read more]