[aur-general] Putting mariadb into community
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. -- Sven-Hendrik
2011/9/28 Sven-Hendrik Haase <sh@lutzhaase.com>
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.
-- Sven-Hendrik
This would be super. (thx if you make this come in to community) In my opinion it would be no problem that mysql and mariadb conflict, most of the people use innodb or myisam as data engine and both support those flawlessly. If you are in a case where you use an exotic data engine, you probably know which one of the two supports it or if it is supported in both mysql and mariadb. And my guess is if there are severe "drop-in" issues the mariadb developers might be a lot faster fixing issues than mysql is at the moment. -- Ike
2011/9/28 Sven-Hendrik Haase <sh@lutzhaase.com>:
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
2011/9/28 Ángel Velásquez <angvp@archlinux.org>
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
2011/9/28 Sven-Hendrik Haase <sh@lutzhaase.com>: 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) - 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
2011/9/28 Ike Devolder <ike.devolder@gmail.com>
2011/9/28 Ángel Velásquez <angvp@archlinux.org>
2011/9/28 Sven-Hendrik Haase <sh@lutzhaase.com>:
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
"Ángel Velásquez" <angvp@archlinux.org> wrote: 2011/9/28 Sven-Hendrik Haase <sh@lutzhaase.com>:
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 I have never maintained a database before but I figured that since nobody else seemed interested I'd get started. I currently maintain the fairly complex courier suite in community and also depend on it for my own mail server. So far I kept it working fine. Same would go for mariadb since it would replace MySQL for me. I'm well aware of the responsibility. However, I'm a fairly casual user of MySQL and don't do anything exotic with it. If any database wizard would like to maintain mariadb then by all means do that. In fact it would likely be better if mariadb eventually entered extra. -- Sven-Hendrik
On 09/28/2011 09:07 AM, Sven-Hendrik Haase wrote:
"Ángel Velásquez" <angvp@archlinux.org> wrote:
2011/9/28 Sven-Hendrik Haase <sh@lutzhaase.com>:
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.
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 On Wed, Sep 28, 2011 at 9:20 AM, Sven-Hendrik Haase <sh@lutzhaase.com> wrote:
On 09/28/2011 09:07 AM, Sven-Hendrik Haase wrote:
"Ángel Velásquez" <angvp@archlinux.org> wrote:
2011/9/28 Sven-Hendrik Haase <sh@lutzhaase.com>:
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 <massimiliano.torromeo@gmail.com>:
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 <sh@lutzhaase.com> wrote:
On 09/28/2011 09:07 AM, Sven-Hendrik Haase wrote:
"Ángel Velásquez" <angvp@archlinux.org> wrote:
2011/9/28 Sven-Hendrik Haase <sh@lutzhaase.com>:
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
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?
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?
This seemed like the hot-topic in my TU application thread, but OT so I'm continuing the conversation here. I'm probably gonna test in the near future, the percona-server + galera plugin [1]. The promise is: real (awesome) parallel per-server replication. I wonder how this will affect performance. [1] http://www.mysqlperformanceblog.com/2011/10/03/percona-server-5-5-15-galera-...
participants (5)
-
Evangelos Foutras
-
Ike Devolder
-
Massimiliano Torromeo
-
Sven-Hendrik Haase
-
Ángel Velásquez