View previous topic :: View next topic |
Author |
Message |
ts77 Apprentice
Joined: 23 Mar 2003 Posts: 200 Location: Berlin, Germany
|
Posted: Tue Oct 13, 2009 8:20 am Post subject: State of MySQL in Gentoo? |
|
|
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 |
|
Back to top |
|
|
audiodef Watchman
Joined: 06 Jul 2005 Posts: 6639 Location: The soundosphere
|
|
Back to top |
|
|
desultory Bodhisattva
Joined: 04 Nov 2005 Posts: 9410
|
|
Back to top |
|
|
ts77 Apprentice
Joined: 23 Mar 2003 Posts: 200 Location: Berlin, Germany
|
Posted: Wed Oct 14, 2009 10:13 am Post subject: |
|
|
which had its latest update 3 years ago? |
|
Back to top |
|
|
ts77 Apprentice
Joined: 23 Mar 2003 Posts: 200 Location: Berlin, Germany
|
|
Back to top |
|
|
John R. Graham Administrator
Joined: 08 Mar 2005 Posts: 10587 Location: Somewhere over Atlanta, Georgia
|
Posted: Wed Oct 14, 2009 1:06 pm Post subject: |
|
|
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 can confirm that I have received between 0 and 499 National Security Letters. |
|
Back to top |
|
|
desultory Bodhisattva
Joined: 04 Nov 2005 Posts: 9410
|
Posted: Thu Oct 15, 2009 7:03 am Post subject: |
|
|
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. |
|
Back to top |
|
|
ts77 Apprentice
Joined: 23 Mar 2003 Posts: 200 Location: Berlin, Germany
|
Posted: Thu Oct 15, 2009 10:07 am Post subject: |
|
|
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 |
|
Back to top |
|
|
nmp0906 n00b
Joined: 31 Jan 2008 Posts: 71 Location: United States
|
Posted: Thu Nov 26, 2009 2:07 pm Post subject: |
|
|
Read through this bug and you will get an idea of the primary maintainer's position on MySQL builds:
https://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: | vi /etc/layman/layman.cfg |
add overlay: http://ftp.mars.arge.at/pub/overlay/geos_one-overlay.xml
Code: | 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: | # 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.
Last edited by nmp0906 on Thu Dec 03, 2009 5:50 pm; edited 1 time in total |
|
Back to top |
|
|
kos n00b
Joined: 28 May 2003 Posts: 71 Location: Mountain View, CA
|
Posted: Thu Dec 03, 2009 4:45 pm Post subject: |
|
|
nmp0906: aclocal fails for me.
Code: |
-- 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.
|
_________________ /KoS |
|
Back to top |
|
|
nmp0906 n00b
Joined: 31 Jan 2008 Posts: 71 Location: United States
|
Posted: Thu Dec 03, 2009 5:53 pm Post subject: |
|
|
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. |
|
Back to top |
|
|
himpierre l33t
Joined: 31 Aug 2002 Posts: 865 Location: Berlin
|
Posted: Tue Dec 22, 2009 11:01 am Post subject: |
|
|
Does this still work for someone? Just tried to install 5.1.41 but the emerge process bumps out while patching. |
|
Back to top |
|
|
nmp0906 n00b
Joined: 31 Jan 2008 Posts: 71 Location: United States
|
Posted: Tue Dec 22, 2009 3:02 pm Post subject: |
|
|
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? |
|
Back to top |
|
|
yngwin Retired Dev
Joined: 19 Dec 2002 Posts: 4572 Location: Suzhou, China
|
Posted: Tue Dec 22, 2009 10:03 pm Post subject: |
|
|
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. _________________ "Those who deny freedom to others deserve it not for themselves." - Abraham Lincoln
Free Culture | Defective by Design | EFF |
|
Back to top |
|
|
nmp0906 n00b
Joined: 31 Jan 2008 Posts: 71 Location: United States
|
Posted: Wed Dec 23, 2009 5:09 pm Post subject: |
|
|
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. |
|
Back to top |
|
|
Geos_One Apprentice
Joined: 15 Sep 2005 Posts: 250 Location: Austria,Graz
|
Posted: Fri Jan 08, 2010 9:28 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
robbat2 Developer
Joined: 19 Feb 2003 Posts: 82
|
|
Back to top |
|
|
ToeiRei Veteran
Joined: 03 Jan 2005 Posts: 1191 Location: Austria
|
Posted: Thu Feb 04, 2010 1:01 pm Post subject: |
|
|
Any news on 5.1 so far? Is it still that bad regarding mysql itself?
Rei _________________ Please stand by - The mailer daemon is busy burning your messages in hell... |
|
Back to top |
|
|
robbat2 Developer
Joined: 19 Feb 2003 Posts: 82
|
Posted: Thu Feb 04, 2010 8:20 pm Post subject: |
|
|
It's in the tree. Unmasking 2010/02/08, as per the -dev mailing list. Be prepared to revdep-rebuild. |
|
Back to top |
|
|
ToeiRei Veteran
Joined: 03 Jan 2005 Posts: 1191 Location: Austria
|
Posted: Thu Feb 04, 2010 8:50 pm Post subject: |
|
|
I manually unmasked today. It wasn't that scary at all. Just two packages rebuilt and we were rolling again. _________________ Please stand by - The mailer daemon is busy burning your messages in hell... |
|
Back to top |
|
|
Ivanich_ Tux's lil' helper
Joined: 10 Feb 2006 Posts: 104 Location: Ukraine, Odessa
|
Posted: Thu Feb 11, 2010 9:44 am Post subject: |
|
|
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: | 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/)" |
|
|
Back to top |
|
|
|