Drop in Mariadb for Mysql [Solved]

Discussions Regarding Software

Moderator: Moderators

Post Reply
nobicycle
Simple Hen
Posts: 77
Joined: Fri Nov 20, 2009 13:55

Drop in Mariadb for Mysql [Solved]

Post by nobicycle » Thu Feb 07, 2013 10:35

Fedora and Suse have dropped Mysql for Mariadb (a mysql drop-in replacement).

Maybe it is time for Sabayon to include Mariadb in Equo (where do I request this?)

Currently Mariadb is only available in Portage. So:

1.Backup Mysql databases
2.sudo /etc/init.d/mysql stop
3.sudo equo remove dev-db/mysql --nodeps
4.sudo emerge dev-db/mariadb

Unfortunately step 4. produces a blocking situation:

Calculating dependencies... done!
[ebuild N ] dev-db/mysql-5.5.29-r1 USE="community embedded extraengine perl ssl -berkdb -cluster -debug -jemalloc -latin1 -max-idx-128 -minimal -profiling (-selinux) -static -systemtap -tcmalloc {-test}"
[ebuild N ] dev-db/mariadb-5.5.28a USE="berkdb community perl ssl -cluster -debug -embedded -extraengine -jemalloc -latin1 -max-idx-128 -minimal -oqgraph -pbxt -profiling (-selinux) -sphinx -static -systemtap -tcmalloc {-test}"
[blocks B ] dev-db/mysql ("dev-db/mysql" is blocking dev-db/mariadb-5.5.28a)
[blocks B ] dev-db/mariadb ("dev-db/mariadb" is blocking dev-db/mysql-5.5.29-r1)


This Gentoo site http://forums.gentoo.org/viewtopic-p-7214710.html said
It seems like mariadb is tied in when using the "minimal" use flag, at least with 5.1.66.

Solved it by masking >virtual/mysql-5.1.
That did not work for me.

I also commented out the following in /etc/portage/package.unmask
# We want MySQL 5.5, do we?
#=dev-db/mariadb-5.5*
#=dev-db/mysql-5.5*
#=virtual/mysql-5.5*
Still the block persists.

Any ideas?

Best wishes.
Last edited by nobicycle on Mon Feb 11, 2013 15:29, edited 1 time in total.

Ryuno-Ki
Old Dear Hen
Posts: 494
Joined: Mon Feb 27, 2012 22:15
Location: Southern Germany
Contact:

Re: Drop in Mariadb for Mysql

Post by Ryuno-Ki » Thu Feb 07, 2013 11:51

nobicycle wrote:Maybe it is time for Sabayon to include Mariadb in Equo (where do I request this?)
It can be done on Bugzilla.
German Wiki translator ◆ Want to contribute on the wiki? Ask the Bureaucrats!
Please, mark solved threads ◆ Posts unread and unansweredPackage requests

User avatar
sabayonino
Sagely Hen
Posts: 3251
Joined: Sun Sep 21, 2008 1:12
Location: Italy
Contact:

Re: Drop in Mariadb for Mysql

Post by sabayonino » Thu Feb 07, 2013 12:52

remove mysql from entropy. then install mariadb

good luck
Last edited by sabayonino on Thu Feb 07, 2013 13:02, edited 1 time in total.
[Che Cos'è Il Calcolo Distribuito (BOINC)

BOINC ready ! Sabayon+BOINC = BILD ,my Sabayon spin :cyclops: - Ready to crunch for the Science everywhere :)

joost
Sagely Hen
Posts: 2694
Joined: Fri Nov 17, 2006 12:11
Location: The Netherlands
Contact:

Re: Drop in Mariadb for Mysql

Post by joost » Thu Feb 07, 2013 12:53

I wonder WHY we would wanna replace it in Entropy.
Please provide some technical (non political) arguements.

8) If it ain't broken don't fix it. 8)
Image
My blog | Twitter | Please support Sabayon: Image

nobicycle
Simple Hen
Posts: 77
Joined: Fri Nov 20, 2009 13:55

Re: Drop in Mariadb for Mysql

Post by nobicycle » Thu Feb 07, 2013 12:55

hi sabayonino
that was done in step 3.
3.sudo equo remove dev-db/mysql --nodeps

nobicycle
Simple Hen
Posts: 77
Joined: Fri Nov 20, 2009 13:55

Re: Drop in Mariadb for Mysql

Post by nobicycle » Thu Feb 07, 2013 13:09

joost wrote:I wonder WHY we would wanna replace it in Entropy.
Please provide some technical (non political) arguements.

8) If it ain't broken don't fix it. 8)
1. Technical
Mariadb "goodies" include speed improvements, new features, and support for additional storage engines. These include Aria, OQGRAPH, and SphinxSE.
2. Open Source
Oracle are no longer publishing any useful information about security issues (CVEs) and they are not providing complete regression tests any more, and a very large fraction of the MySQL bug database is now not public."
http://www.zdnet.com/oracle-who-fedora- ... 000010640/
3. Critical mass of Fedora+Almost certainly Redhat+Suse+Others makes this a similar case to LibreOffice versus OpenOffice - it is not a case of if to switch but when.

Regarding " WHY we would wanna replace it in Entropy.", I didn't suggest that. I would like to have Mariadb in addition.

joost
Sagely Hen
Posts: 2694
Joined: Fri Nov 17, 2006 12:11
Location: The Netherlands
Contact:

Re: Drop in Mariadb for Mysql

Post by joost » Thu Feb 07, 2013 14:33

Technically we should pick one since it is at Portage level controlled by a virtual. We do have a workaround for that (package injection) but it is a bit messy to maintain. So asking for MariaDB in Entropy would come down to asking to replace MySQL with MariaDB. :D

I did bring up the discussion months ago and at the time we decided to stick with MySQL because at the time there was no immediate need for the swap. Maybe it is time to once again have a look at this, so feel free to open up a bug for this request.
Image
My blog | Twitter | Please support Sabayon: Image

nobicycle
Simple Hen
Posts: 77
Joined: Fri Nov 20, 2009 13:55

Re: Drop in Mariadb for Mysql

Post by nobicycle » Fri Feb 08, 2013 2:39

joost wrote:feel free to open up a bug for this request.
https://bugs.sabayon.org/show_bug.cgi?id=3980

nobicycle
Simple Hen
Posts: 77
Joined: Fri Nov 20, 2009 13:55

Re: Drop in Mariadb for Mysql

Post by nobicycle » Mon Feb 11, 2013 15:28

mariadb is now in the Limbo repo, thanks to our Benevolent Dictator.

Post Reply