Recently Jack asked me for a Sysbench package for OL9.
In this post, you can find the RPM packages of Sysbench 1.1.0 build for Oracle Linux 9, RedHat Enterprise 9 and any RPM compatible system.
Sysbench’s binary is linked with
libmysqlclient.so.21 and
libssl.so.3.
Here are the two files, one for x86_64 and one for aarch64 (ARM):
sysbench-1.1.0-2.el9.x86_64Download
…
[Read more]For a future article, I was again looking into the possibility of using sysbench to generate data and load on a MySQL database. However, I needed an SSL connection which only version 1.1.0 supports (see issue 308).
Alexey didn’t create a branch and/or release for the version 1.1.0. The code is the master branch.
As you know, I like to install software using the Operating System’s packaging and so I created a rpm for sysbench 1.1.0.
If you are also interested to use this version, here are the rpms for some popular OS and architecture (including Arm):
sysbench-1.1.0-1.fc35.x86_64 …
[Read more]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], [ …
As you could read in this previous post, PHP 7.4 is now completely supporting MySQL 8.0 and the new default authentication plugin.
I wanted to make a summary table providing and overview of all PHP versions and how they supported MySQL 8.0 and the different authentication plugins.
As I am a RPM based distribution user, I’m using the famous repository of remi since a lot of years, and I use it then also to install PHP 7.4.0 and 7.4.1…
I created a new user to test to …
[Read more]MySQL 8.0 is now part of RedHat Enterprise 8 and other distros based on it like CentOS and Oracle Linux.. This is a very good thing !
However if for any reason you want to use the latest version of MySQL from the Community Repository, you may encounter some frustration if you are not familiar with the new way the package manager works.
Let’s start by verifying our system:
LSB Version: :core-4.1-amd64:core-4.1-noarch Distributor ID: OracleServer Description: Oracle Linux Server release 8.0 Release: 8.0 Codename: n/a
We can see that we are on Oracle Linux 8.0. So now let’s try to install MySQL Server:
[root@localhost ~]# dnf install mysql-server Last metadata expiration check: 0:08:15 ago on Sat 02 Nov 2019 09:54:07 AM UTC. Dependencies resolved. ============================================================================================ Package Arch Version …[Read more]
Today I started to check ripple the new MySQL binlog server. I don’t want to give yet any feedback neither I want to answer THE question: Is this the Binlog Server we were all waiting for ?
But I had some difficulties to build it on my test machines (rpm based as mostly everybody knows). I think this might be a limitation for people wanting to evaluate it. Therefor, with the help of Daniël van Eeden, I made a rpm that will facilitate the installation on your system.
The rpm is made for EL7 compatible Linux distributions and
includes libssl and libcrypto libraries
in version 1.1
mysql-ripple-0.3-1.el7.x86_64 …
[Read more]
Alexey
made this amazing tool that the majority of MySQL DBAs are using,
but if you use sysbench provided with your GNU/Linux
distribution or its repository on packagecloud.io you won’t be able to use it
with the new default authentication plugin in MySQL 8.0
(caching_sha2_password).
This is because most of the sysbench binaries are compiled with the MySQL 5.7 client library or MariaDB ones. There is an issue on github where Alexey explains this.
So if you want to use sysbench with MySQL 8.0 …
[Read more]
In this series of blogs I will do my best to demonstrate how to
set up and run Cluster in Cloud environment by hand and by
utilizing MCC. For detailed configuration, I
will use MCC (Auto-installer). Some of the
information regarding this setup is provided in post by Mikael. Information regarding
Auto-installer is available in our documentation, HTML help files
in share/MCC distribution directory and in my blog post.
Cloud setup It might come as surprise but for initial testing any
instance should do. I started with 1CPU/1GB RAM ones. The target
topology was:
In this blog, we’ll look at how to manually build Percona Server for MySQL RPM packages.
Several customers and other people from the open source community have asked us how they could make their own Percona Server for MySQL RPM binaries from scratch.
This request is often made by companies that want to add custom patches to our release. To do this, you need to make some modifications to the
percona-server.spec
file in the source tree, and some preparation is necessary.
This post covers how you can make your own RPMs from GIT or source tarball so that you can build RPMs from your own modified branch, or by applying patches. In this example, we’ll build Percona Server 5.7.16-10.
Making your own RPMs is not a recommended practice, and should rarely be …
[Read more]Travis-CI is a crucial component in Continuous Integration/Continuous Deployment. We use it a lot to run unit tests and building/uploading Python modules. Recently I had to solve a problem of building RPMs on Travis-CI with Docker containers. In this post I will describe step-by-step how to do that. We distribute our backup tool as RPM packages […]
The post Building RPM on Travis-CI in Docker containers appeared first on TwinDB.
