The Workbench 2022-01

  • Posted on: 23 January 2022
  • By: tomww

Hi all,

A working package is ready now. Run MySQL 8.0 on your Solaris X86 machine (maybe run it in a zone?).
Instructions about starting with MySQL 8.0.27 / 8.0.28 on Solaris / OmniOS are here: https://sfe.opencsw.org/SFEmysql80
Make sure, you have installed at minimum these package timestamps:
S11.4 GA - mysql-80@8.0.28-0.11.4.0.0.1.15.0
or
S11.4+SRU - mysql-80@8.0.28-0.11.4.39
or
S11.3+SRU - mysql-80@8.0.28,5.11-0.0.175.3.33

OmniOS and OpenIndiana will follow...
Testing! OmniOS 151038 - mysql-80@8.0.28,5.11-0.151038.22

The package mysql-80 mimics the layout and integration like the good old MySQL 5.7 packages. I'll add more OS-platforms like Solaris 11.3, OmniOS and OpenIndiana a bit later (tell me if you want this packages for that OS). You want a mysql-8.0.27/8.0.28 package for sparc CPU? Drop me a note!
Mail me at: sfepackages at g mail dot com

Regards
Thomas

(Edit history)
(20220112-2140CET removed notes about solved db-init errors, testing done, so removed call for testers - well, you may still ask to volunteer, just test the package with the test-suite and remember to load all the needed plugins for the tests - drop me a note, if you have tested and how)
(20220115 added Solaris 11.3 package FMRI für mysql-80)
(20220119 updated to available 8.0.28 version)

Comments

predrag.zecevic's picture

predrag.zecevic

Mon, 01/10/2022 - 10:16

Hi Tom,
I can try to test openindiana version, if you have such package ATM.
Regards

tomww

Tue, 01/11/2022 - 23:36

Hi Predrag!
What version of OpenIndiana would be the one for your testing? I then update the build system to that version.
Spare time is up at the moment, so it can take a while until I can add mysql-8.0.27 package to OpenIndiana.
Out of interest, would you have a real application running on MySQL for your testing? I already have to people running NextCloud (!). Not that you would need to surpass this :) , any application would do. I just find it crazy cool to run NextCloud on native ZFS on Solaris...
Regards,
Thomas

predrag.zecevic's picture

predrag.zecevic

Mon, 01/17/2022 - 14:44

Hi Tom,
I have no preferences regarding version (latest one you have would be fine).

Just need to practice move away from version 5.7 (I have that option for Linux, but I am keen to check it on my OS).
Regards.

P.S: No problems, I can wait :-)

tomww

Wed, 01/19/2022 - 18:12

As a pre-work, we got a prelimiary fixed mman.h include file for for Illumos.
So MySQL 8.0.28 already works on OmniOS. The same fixed mman.h should work for OpenIndiana too. I expect to find a little bit time on February to work on MySQL 8.0.28 in OpenIndiana.
Regards,
Thomas

predrag.zecevic's picture

predrag.zecevic

Mon, 05/02/2022 - 16:27

Any news on MySQL 8 fo OI?

tomww

Sun, 05/08/2022 - 12:37

Hi Predrag,
currently there is no progress for MySQL 8.0.x on OpenIndiana. Unfortunatly my spare time is a bit short.
I want to update the build VM to a newer OI Release before starting with MySQL. There is a little bit of hope to get this done when migrating the build VM from the older SmartOS host to a newer one with more powerful CPU and more RAM.

Regards,
Thomas

predrag.zecevic's picture

predrag.zecevic

Thu, 01/20/2022 - 09:46

Thanks

predrag.zecevic's picture

predrag.zecevic

Wed, 10/25/2023 - 13:54

As you might find on openindiana-discuss mailing list:

---<QUOTE>---
After 10 years of DBD::mysql Perl module available in OpenIndiana we
need to obsolete it. If you need similar functionality you should
switch to DBD::MariaDB. The DBD::MariaDB Perl module is available in
the library/perl-5/dbd-mariadb package.

Starting with version 5.001 of DBD::mysql released on 2023-10-04 it is
no longer possible to build it on OpenIndiana because MySQL 8.x is
required for building. We do not have MySQL packaged for OpenIndiana.

If DBD::mysql is a must for you and you cannot switch to DBD::MariaDB
then you should contribute and package MySQL for OpenIndiana.
---</QUOTE>---

What are changes to get set of instructions, packages, patches and everything what was done to build MySQL 8 on Solaris 11, so I can try it on OpenIndiana?

Regards.

tomww

Sat, 11/11/2023 - 19:19

Hi Predrag,

sure, the proper way would be building MySQL8.0 on Openindiana as a sane SFE package. But unfortunately I have only ancient Build-VMs with Openindiana at hand. The new SmartOS install should be able to run a bhyve VM and with a little tweaking ansible would create a SFE build environment there. Where do I get time for it...

So the other option to learn how SFE builds MySQL8 on Omnios/Solaris 11.4 is looking at the file SFEmysql80.spec in the spec-files-extra repository. The referenced patches are there as well.
I'll try fetching the file ".pkgbuild.build" from the OmniOS SFE MySQL compilation, this is a shell script containing all variables and the resulting configure and build calls. With a little luck, this is not already purged form the build VMs.

If someone can verify that OpenIndiana recent build is able to do a clean install on Bhyve on SmartOS, that would lower the inhibition treshold to make a new OpenIndiana SFE instance and build MySQL8.0 as a first package, then add the perl-mysql module and other packages in need.

Thanks for asking and best Regards
Thomas