Drop in Mariadb for Mysql [Solved]

Discussions Regarding Software

Moderator: Moderators

Drop in Mariadb for Mysql [Solved]

Postby 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.
nobicycle
Simple Hen
 
Posts: 77
Joined: Fri Nov 20, 2009 13:55

Re: Drop in Mariadb for Mysql

Postby 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.
HP-Pavilion ◆ AMD Athlon™ 64 Processor 4000+ ◆ GeForce 6150SE nForce 430 ◆ 1 GiB RAM
German Wiki translator ◆ Want to contribute on the wiki? Ask the Bureaucrats!
Please, mark solved threads ◆ Posts unread and unansweredPackage requests ◆ Sabayon XI with MATE
Ryuno-Ki
Technological Hen
 
Posts: 437
Joined: Mon Feb 27, 2012 22:15
Location: Southern Germany

Re: Drop in Mariadb for Mysql

Postby 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.
User avatar
sabayonino
Sagely Hen
 
Posts: 2464
Joined: Sun Sep 21, 2008 1:12
Location: Italy

Re: Drop in Mariadb for Mysql

Postby 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)
joost
Sagely Hen
 
Posts: 2549
Joined: Fri Nov 17, 2006 12:11
Location: The Netherlands

Re: Drop in Mariadb for Mysql

Postby 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

Postby 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.
nobicycle
Simple Hen
 
Posts: 77
Joined: Fri Nov 20, 2009 13:55

Re: Drop in Mariadb for Mysql

Postby 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.
joost
Sagely Hen
 
Posts: 2549
Joined: Fri Nov 17, 2006 12:11
Location: The Netherlands

Re: Drop in Mariadb for Mysql

Postby 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

Postby nobicycle » Mon Feb 11, 2013 15:28

mariadb is now in the Limbo repo, thanks to our Benevolent Dictator.
nobicycle
Simple Hen
 
Posts: 77
Joined: Fri Nov 20, 2009 13:55


Return to Software in General

Who is online

Users browsing this forum: No registered users and 1 guest