State of MySQL in Gentoo?

Message

ts77 · Post by **ts77** » Tue Oct 13, 2009 8:20 am

Hello folks,

I'm wondering, whats the current state of MySQL in Gentoo?

Current "GA" release is 5.1.39 but only older releases are available as beta (mysql-community).
No trace of MySQL-5.4.x or the like for testing. No idea either about how the new release model from mysql is coming along either.
Also there are some neat patchsets (percona, google, ourdelta ... ) out there and other storage engines (XtraDB ...).
Are there any plans to include stuff like that?

Whats planned for the mysql support in Gentoo?

If that question was answered anywhere already please point me to it.

Thanks,

thomas

audiodef · Post by **audiodef** » Tue Oct 13, 2009 7:08 pm

I don't know the answer to that, but if you want the latest anything and it's not available in Portage, either there might be an overlay or you can compile it yourself.

desultory · Post by **desultory** » Wed Oct 14, 2009 7:43 am

Like mysql-testing?

ts77 · Post by **ts77** » Wed Oct 14, 2009 10:13 am

desultory wrote:Like mysql-testing?

which had its latest update 3 years ago?

ts77 · Post by **ts77** » Wed Oct 14, 2009 11:44 am

Looked a bit around at the bugtracker and made a blog post about what I found so far ...
http://ts77.wordpress.com/2009/10/14/mysql-in-gentoo/

Post by **John R. Graham** » Wed Oct 14, 2009 1:06 pm

Most Portage ebuilds are only a few dozen lines long. The mysql ebuild and its supporting eclasses are collectively over one thousand lines long. So, it's one of those packages with a complicated--and perhaps non-standard--build process. My only point is that it appears to be nontrivial to release a new version in Gentoo, especially on major releases.

- John

desultory · Post by **desultory** » Thu Oct 15, 2009 7:03 am

ts77 wrote:which had its latest update 3 years ago?

Which was rather the point, the only readily located public overlay which contains ebuilds for the packages in question does not contain any more recent ebuilds than tree.

ts77 · Post by **ts77** » Thu Oct 15, 2009 10:07 am

john_r_graham wrote:Most Portage ebuilds are only a few dozen lines long. The mysql ebuild and its supporting eclasses are collectively over one thousand lines long. So, it's one of those packages with a complicated--and perhaps non-standard--build process. My only point is that it appears to be nontrivial to release a new version in Gentoo, especially on major releases.

- John

I didn't want to play down the work put in by the Gentoo maintainers. I was simply curious about the state of mysql in portage as the stable version is a bit oldish and the recent GA releases from mysql aren't even anywhere to be found in the tree. From reading the bugtracker comments I quoted its getting more clear to me why thats the way it is and that 5.1 will come in when its really stable.
Also the percona patches are included in the unstable mysql ebuilds in the tree so there is a way for that too.

desultory wrote: Which was rather the point, the only readily located public overlay which contains ebuilds for the packages in question does not contain any more recent ebuilds than tree.

Sorry, I just misunderstood your reply.

Thanks,

thomas

nmp0906 · Post by **nmp0906** » Thu Nov 26, 2009 2:07 pm

Read through this bug and you will get an idea of the primary maintainer's position on MySQL builds:
http://bugs.gentoo.org/194561

Apparently, they don't pass the quality checks/testing done. However, I disagree in that these versions shouldn't even be added to the tree. They should, and ones that don't work should be masked or at least marked unstable. This way end users can test/use the latest versions at their own risk. This used to be what made Gentoo so great, the ability to use the bleeding edge/latest versions through keywords/unmasking. MySQL is in a rather poor state with regards to this.

Solution:

Code: Select all

vi /etc/layman/layman.cfg

add overlay: http://ftp.mars.arge.at/pub/overlay/geo ... verlay.xml

Code: Select all

layman -L
layman -a go-mysql
echo "dev-db/mysql" >> /etc/portage/package.unmask
emerge -C virtual/mysql dev-db/mysql dev-db/mysql-init-scripts
emerge mysql

Also, you should probably add go-mysql as an eclass override:

Code: Select all

# cat /etc/portage/repos.conf 
[gentoo]
eclass-overrides = hardened-dev go-mysql

EDIT: Added the unmerging of mysql-init-scripts. These need to come from the overlay if you want them to work with 5.1.x
EDIT: Removed manual fetch. Mirrors have the source now it appears.

kos · Post by **kos** » Thu Dec 03, 2009 4:45 pm

nmp0906: aclocal fails for me.

Code: Select all

-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
CMake Error at CMakeLists.txt:18 (INCLUDE):
  include could not find load file:

    /var/tmp/portage/dev-db/mysql-5.1.41-r2/work/mysql/storage/innobase/storage/mysql_storage_engine.cmake


CMake Error at CMakeLists.txt:66 (MYSQL_STORAGE_ENGINE):
  Unknown CMake command "MYSQL_STORAGE_ENGINE".


CMake Warning (dev) in CMakeLists.txt:
  No cmake_minimum_required command is present.  A line of code such as

    cmake_minimum_required(VERSION 2.6)
  
  should be added at the top of the file.  The version specified may be lower
  if you wish to support older CMake versions for this project.  For more
  information run "cmake --help-policy CMP0000".
This warning is for project developers.  Use -Wno-dev to suppress it.

nmp0906 · Post by **nmp0906** » Thu Dec 03, 2009 5:53 pm

I didn't even notice that in my upgrade to -r2. It appears to still compile and run fine. I'd imagine it would need to be reported to the overlay maintainer, whose contact info I don't know.

himpierre · Post by **himpierre** » Tue Dec 22, 2009 11:01 am

Does this still work for someone? Just tried to install 5.1.41 but the emerge process bumps out while patching.

nmp0906 · Post by **nmp0906** » Tue Dec 22, 2009 3:02 pm

No. I have -r2 installed, but it wants to downgrade to 5.1.41 and fails on patching. -r2 has been removed from the repo and I'm not sure why. Does anybody know how to contact this overlay maintainer?

yngwin · Post by **yngwin** » Tue Dec 22, 2009 10:03 pm

nmp0906 wrote:However, I disagree in that these versions shouldn't even be added to the tree. They should, and ones that don't work should be masked or at least marked unstable. This way end users can test/use the latest versions at their own risk. This used to be what made Gentoo so great, the ability to use the bleeding edge/latest versions through keywords/unmasking. MySQL is in a rather poor state with regards to this.

So step up and help maintain mysql in portage.

nmp0906 · Post by **nmp0906** » Wed Dec 23, 2009 5:09 pm

himpierre wrote:Does this still work for someone? Just tried to install 5.1.41 but the emerge process bumps out while patching.

The overlay was just updated with what appears to be 5.1.41-r1 which compiles successfully for me.

yngwin wrote:So step up and help maintain mysql in portage.

I would consider doing this, however as long as this overlay is maintained and usable, then all the ebuild work is done. Getting said work out of an overlay and into Portage unstable/masked is another issue altogether.

Geos_One · Post by **Geos_One** » Fri Jan 08, 2010 9:28 pm

nmp0906 wrote:No. I have -r2 installed, but it wants to downgrade to 5.1.41 and fails on patching. -r2 has been removed from the repo and I'm not sure why. Does anybody know how to contact this overlay maintainer?

yes its me

thx
Mario

Post by **robbat2** » Sat Jan 09, 2010 3:54 am

The official Gentoo MySQL overlay moved from SVN to Git. It's here:
http://git.overlays.gentoo.org/gitweb/? ... ;a=summary

It will be in the main tree once we deal with some testsuite failures with upstream.

ToeiRei · Post by **ToeiRei** » Thu Feb 04, 2010 1:01 pm

Any news on 5.1 so far? Is it still that bad regarding mysql itself?

Rei

Post by **robbat2** » Thu Feb 04, 2010 8:20 pm

It's in the tree. Unmasking 2010/02/08, as per the -dev mailing list. Be prepared to revdep-rebuild.

ToeiRei · Post by **ToeiRei** » Thu Feb 04, 2010 8:50 pm

I manually unmasked today. It wasn't that scary at all. Just two packages rebuilt and we were rolling again.

Ivanich_ · Post by **Ivanich_** » Thu Feb 11, 2010 9:44 am

In my.cnf default-character-set=utf8, but there is no /usr/share/mysql/charsets/utf8.xml file, and maybe therefore akonadi in kde4.4 sometimes stop working with error

Code: Select all

Database error: Cannot open database.
  Last driver error: "QMYSQL: Unable to connect"
  Last database error: "Can't initialize character set utf8 (path: /usr/share/mysql/charsets/)"