Re: [debian-mysql] [Maria-discuss] MySQL's future in Debian and Ubuntu

2012-02-16 Thread Colin Charles
Hi!

On 16 Feb 2012, at 17:24, Henrik Ingo wrote:

 Clearly I was unclear in my previous email. The 2 year support is not
 true for any of the alternatives. MySQL gives 5 years (and more for
 customers that pay), Percona trails MySQL so they also end up doing 5
 years (and more for paying customers). MariaDB also does 5,
 apparently.

Oracle supports MySQL for 5 years from date of release commercially. There is 
supposedly only two GA releases supported at any one given time (in active 
support for community use). Of course we have no idea if this is true yet or 
not since 5.1 and 5.5 are still supported. We will know firmly what their 
plans are when 5.6 is released. Will it then be that 5.1 will drop from active 
GA support? I have no idea (as I don't work for Oracle). Only time can/will tell

--
Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: 
colincharles
MariaDB: Community developed. Feature enhanced. Backward compatible.
Download it at: http://www.mariadb.org/
Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/


-- 
Ubuntu-devel-discuss mailing list
Ubuntu-devel-discuss@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-devel-discuss


Re: [Maria-discuss] MySQL's future in Debian and Ubuntu

2012-02-15 Thread Colin Charles
Hi!

On 14 Feb 2012, at 20:28, Fabio T. Leitao wrote:

 Remember that MariaDB is not just compatible with MySQL, but it kind of IS 
 MySQL, forked and re-branded.

I like to say that it is MySQL, branched and re-branded with additional 
features. It is not a fork. We rebase with MySQL on a regular basis, so you get 
MySQL + all the additional features we've included

cheers,
-c
--
Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: 
colincharles
MariaDB: Community developed. Feature enhanced. Backward compatible.
Download it at: http://www.mariadb.org/
Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/


-- 
Ubuntu-devel-discuss mailing list
Ubuntu-devel-discuss@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-devel-discuss


Re: [Maria-discuss] MySQL's future in Debian and Ubuntu

2012-02-15 Thread Colin Charles
Hi!

On 15 Feb 2012, at 00:49, Marc Deslauriers wrote:

 We are unable to determine what the recent MySQL security fixes are due
 to lack of details, and unclear commit messages.

Based on our analysis of commits and bugs, we believe the CPU (critical patch 
update) that Oracle released was actually for a lot of bugs that have already 
been fixed in past versions of MySQL. They just seemed to have decided to bulk 
it up and place it in one update. Of course Oracle has not come up with an 
official statement and don't seem to be interested to do so. What is clear is 
that these bugs are not new, and were not found from October 2011 - January 
2012. Of course we cannot be sure, but it would seem irresponsible of Oracle to 
state that the bugs referenced current community releases of MySQL (5.5.21, 
5.1.61 - eg. http://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2012-0492). In 
fact the current GA is 5.5.20, and that advisory is listed as high in the CPU

From a blog post by an Oracle employee that is now not online, the reference 
to fixed bugs were:
1. Bug #11759688
2. Bug #52020
3. Bug #13358468
4. Bug #54082
5. Bug #11761576
6. Bug #51252
7. Bug #11758979
8. Bug #48726
9. Bug #11756764
10. Bug #42784
11. Bug #11751793
12. Bug #45546
13. Bug #11754011
14. Bug #13427949
15. Bug #11745230
16. Bug #12133
17. Bug #13116225
18. Bug #11759688
19. Bug #13358468
20. Bug #63020
21. Bug #13344643

Sadly, even in his reference, there are lots of bugs that are only kept in a 
closed bug system that Oracle has (basically anything with more than 5 digits 
in the bug number reference the closed bug system)

--
Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: 
colincharles
MariaDB: Community developed. Feature enhanced. Backward compatible.
Download it at: http://www.mariadb.org/
Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/


-- 
Ubuntu-devel-discuss mailing list
Ubuntu-devel-discuss@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-devel-discuss


Re: [Maria-discuss] MySQL's future in Debian and Ubuntu

2012-02-15 Thread Colin Charles
Hi!

On 16 Feb 2012, at 07:57, Henrik Ingo wrote:

 On Tue, Feb 14, 2012 at 2:28 PM, Fabio T. Leitao
 fabio.tlei...@gmail.com wrote:
 For those who have not followed this up closely, a little history.
 
 Remember that MariaDB is not just compatible with MySQL, but it kind of IS
 MySQL, forked and re-branded.
 
 In 2009, even before Oracle has purchased Sun, Monty Widenius (one of the
 original creators of MySQL and architects) has left the Sun (than the owner
 of MySQL) and started MariaDB, intended as a replacement for the full MySQL
 server.
 
 It seems that since that, most of the MySQL developers left and joined
 either Drizzle or MariaDB. Drizzle is another fork, but was targeted to a
 “limited but important market”, created by Brian Aker almost the same time
 when MySQL was bought by Sun (back in 2008)
 
 
 Hi Fabio
 
 You contributed a fairly good history, so it inspired me to fill in
 missing pieces.
 
 There is also a fourth MySQL fork: Percona Server. It is interesting
 to note people in this thread and in general the Linux distro people
 seem to omit this when talking about MySQL forks. As far as I'm aware
 it is the most popular of the forks (after MySQL itself), and used by
 many demanding Percona customers, especially the big and sexy Web
 companies (but not only).

I don't think this is a fair statement as MariaDB also has many popular users 
out there. Let's not make this a popularity contest either

 Out of these four it should first be mentioned that Drizzle is not at
 all a compatible fork of MySQL. Some would say the things that are not
 compatible are enhancements :-) But nevertheless, while Drizzle feels
 very familiar to a MySQL user, you couldn't take away MySQL, drop in
 Drizzle and expect that nobody would notice.

Nobody? WordPress users for example, might (see: 
https://launchpad.net/wordpress-drizzle a plugin that you will require). I 
think there's a Drupal patch that's almost quite ready also...

 Personally I think the main benefit of Percona Server is that they
 have a 5.5 version out there for some time - exactly a year ago it
 seems! While MariaDB has focused more on their own work (and perhaps
 also therefore the merge effort for them is much larger) they haven't
 yet produced a 5.5 release (even alpha). This should be taken into
 account, since many MySQL users already use MySQL 5.5 and features
 like semi-sync replication, they would consider MariaDB a downgrade.

MariaDB 5.5 beta should be out by the end of this month. It will not be GA in 
time for the LTS release, but it will be out soon (its worth noting that all 
these discussions is what has put the team to work on milestones in a quicker 
fashion). It will also include all enhancements up to MariaDB 5.3 naturally, so 
you get all the improvements that come with it

What should also be taken into consideration is support for an existing GA 
release. I've asked Percona (Stewart Smith, Director, Server Development) what 
the plans are and generally Percona will officially support 2 GA releases just 
like Oracle. Unless a customer asks for it, there wouldn't be a fix. LTS 
releases might I remind you need 5 years of support.  Percona Server 5.1 will 
remain supported till Percona Server 5.6 is released, and beyond that, its just 
a customer request possibly. There is no defined policy yet to be fair

 The other strong advantage Percona has at the moment is their recent
 adoption of Galera clustering technology (see Percona XtraDB Cluster).
 This is a revolutionary technology when it comes to High-Availability
 with MySQL and even scalability of MySQL. In fact it has many of the
 good properties seen in many NoSQL solutions (but is still good old
 SQL, Galera is just about the clustering). I'm personally a big fan of
 Galera and don't intend to use anything else going forward.

This alpha feature is very interesting, but the idea of having a 3-node cluster 
pitches this as a NDB replacement rather than just a MySQL replacement. But as 
an aside, I do agree with you - I am totally stoked with the Galera technology 
coming out of Codership!

cheers,
-c
--
Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: 
colincharles
MariaDB: Community developed. Feature enhanced. Backward compatible.
Download it at: http://www.mariadb.org/
Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/


-- 
Ubuntu-devel-discuss mailing list
Ubuntu-devel-discuss@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-devel-discuss