2011/9/28 Ike Devolder

2011/9/28 Ángel Velásquez

...

2011/9/28 Sven-Hendrik Haase :

...

Hi,

Due to Oracle's recent and absolutely unforeseeable new plans with MySQL, I thought it might be a good opportunity to put mariadb into community for those that depend on MySQL. Mariadb is designed to be a drop-in replacement for MySQL and as such I wondered whether it would make sense if mariadb replaced MySQL. Mariadb also conflicts with MySQL files which at least necessitates installing them to an alternative path.

I'm willing to maintain mariadb in community.

I'd like opinions on this.

I agree even bringing other forks of mysql to community, my unique concern is, how qualified do you feel to maintain them? I hope you're not bringing mariadb just because oracle, else because you feel a master (relatively speaking) with mariadb.

That said, if you feel you're qualified, i don't have any concern to have mariadb in community under your responsability.

...

-- Sven-Hendrik

-- Angel Velásquez angvp @ irc.freenode.net Arch Linux Developer / Trusted User Linux Counter: #359909 http://www.angvp.com

Why you should introduce mariadb but not drop mysql:

- mariadb has nicer debug stuff - mariadb has some small performance improvements for charset conversions - mariadb should have (i cannot confirm myself) better and more stable replication (less replication breakage than mysql (my experience is with mysql 5.1 <-> mariadb 5.1, i cant speak for newer versions)

small correction :: i cannot confirm myself for newer versions than mentioned

- and last but not least, mariadb has a more open development and is not tied by any vendor (might be an advantage)

for more info http://kb.askmonty.org/en/mariadb-versus-mysql-features

-- Ike

On 09/28/2011 09:07 AM, Sven-Hendrik Haase wrote:

"Ángel Velásquez" wrote:

2011/9/28 Sven-Hendrik Haase :

...

Hi,

Due to Oracle's recent and absolutely unforeseeable new plans with MySQL, I thought it might be a good opportunity to put mariadb into community for those that depend on MySQL. Mariadb is designed to be a drop-in replacement for MySQL and as such I wondered whether it would make sense if mariadb replaced MySQL. Mariadb also conflicts with MySQL files which at least necessitates installing them to an alternative path.

I'm willing to maintain mariadb in community.

I'd like opinions on this. I agree even bringing other forks of mysql to community, my unique concern is, how qualified do you feel to maintain them? I hope you're not bringing mariadb just because oracle, else because you feel a master (relatively speaking) with mariadb.

That said, if you feel you're qualified, i don't have any concern to have mariadb in community under your responsability.

...

-- Sven-Hendrik

My android K-9 mail fails at proper quoting.

2011/9/28 Massimiliano Torromeo :

Hi.

Hi Massimiliano, thanks for joining the conversation.

Being a sysadmin with a lot of experience on database servers I thought I would share my experience on this case.

Sven. that kind of guy is who should maintain a package like that (*tsk* ask him if he want to be a TU *tsk*).

I'm using mariadb as a MySQL replacement on a few servers using a custom package[1] that uses standard mysql paths and configurations. I've had a few inconsistencies with mysql in certain cases. MariaDB seemed to be afflicted by old bugs that were fixed on MySQL. On the other hand I never had a problem using percona-server [2], even though it took me a while to tweak the package to be a functional replacement.

I said to the guys on #archlinux-tu channel that check percona, i've used it a year ago and ran some tests and got better performance than mysql and mariadb, again, that was on our environment we're far to know if this is the same in all the cases.

Obviously the tipycal environments in which I deployed this servers do not cover all possible situations. For instance, I don't know if they play nicely with kde (amarok uses an embedded mysql server, akonadi spawns a mysql server to store its data).

Yes, Andrea (the actually mysql maintainer and one of the KDE maintainer) should try this, cc'ing him. I think he is aware, but just in case.

[1] https://github.com/mtorromeo/archlinux-packages/tree/master/mariadb-mysql-re... [2] https://aur.archlinux.org/packages.php?ID=40803

On Wed, Sep 28, 2011 at 9:20 AM, Sven-Hendrik Haase wrote:

...

On 09/28/2011 09:07 AM, Sven-Hendrik Haase wrote:

...

"Ángel Velásquez" wrote:

2011/9/28 Sven-Hendrik Haase :

...

Hi,

Due to Oracle's recent and absolutely unforeseeable new plans with MySQL, I thought it might be a good opportunity to put mariadb into community for those that depend on MySQL. Mariadb is designed to be a drop-in replacement for MySQL and as such I wondered whether it would make sense if mariadb replaced MySQL. Mariadb also conflicts with MySQL files which at least necessitates installing them to an alternative path.

I'm willing to maintain mariadb in community.

I'd like opinions on this. I agree even bringing other forks of mysql to community, my unique concern is, how qualified do you feel to maintain them? I hope you're not bringing mariadb just because oracle, else because you feel a master (relatively speaking) with mariadb.

That said, if you feel you're qualified, i don't have any concern to have mariadb in community under your responsability.

...

-- Sven-Hendrik

My android K-9 mail fails at proper quoting.

-- Angel Velásquez angvp @ irc.freenode.net Arch Linux Developer / Trusted User Linux Counter: #359909 http://www.angvp.com

AFAIK percona only modifies the server component. The server speaks the same protocol as the official MySQL distribution, so it is fully compatible with libraries and tools that have already been deployed. This being the case I thought it didn't really make any sense to have a practically identical package as mysql-clients. My experience using percona with mysql-clients has been flawless up till now. On Thursday, September 29, 2011, Evangelos Foutras wrote:

On 28/09/11 16:26, Massimiliano Torromeo wrote:

...

Hi. Being a sysadmin with a lot of experience on database servers I thought I would share my experience on this case.

I'm using mariadb as a MySQL replacement on a few servers using a custom package[1] that uses standard mysql paths and configurations. I've had a few inconsistencies with mysql in certain cases. MariaDB seemed to be afflicted by old bugs that were fixed on MySQL. On the other hand I never had a problem using percona-server [2], even though it took me a while to tweak the package to be a functional replacement.

Obviously the tipycal environments in which I deployed this servers do not cover all possible situations. For instance, I don't know if they play nicely with kde (amarok uses an embedded mysql server, akonadi spawns a mysql server to store its data).

[1] https://github.com/mtorromeo/archlinux-packages/tree/master/mariadb-mysql-re... [2] https://aur.archlinux.org/packages.php?ID=40803

The percona-server package looks great, and I'd be interested to see it in the repos. However, may I ask why it depends on mysql-clients instead of keeping its own client utilities? Is it done for compatibility reasons?