MySQL to Get Injection of Google Code

inkslinger77 writes to mention that MySQL has published their software roadmap out through 2009 and it includes an injection of code from Google. Google remains relatively secretive about how their systems work but they are one of the largest users of MySQL. Earlier this year Google signed a Contributor License Agreement which provides a framework for them to contribute code to MySQL. "The search company has done a lot of work customizing MySQL to meet its special needs, which include better database replication, and tools to monitor a high volume of database instances, Axmark said in an interview at MySQL's user conference in Paris. MySQL will include some of those capabilities in future versions of its database, probably in point upgrades to MySQL 6.0, which is scheduled for general availability in late 2008, Axmark said."

Comments

Hells yeah

[rsborg]

Eat that, Oracle.
Seriously the database layer is being commoditized, and MySQL and PostgreSQL are leading the way.

My only question, was Google required to disclose these changes, or are they just doing the right thing (again)?

Re:Very Niiiice

[Chineseyes]

Why on earth would you compare MySQL with Access? I'm more of a Postgres guy myself but even Mysql deserves better than that.

6.0 in 2008?

[JumboMessiah]

Mysql 5.1 has been in preproduction since November 2005 and still isn't available as a GA release (aka don't use it in production). Are they sure they can get a 6.0 GA release out by next fall?

This is really good of Google to contribute this back, I'm just wondering how long it will be before we all can utilize their changes. I hate to see the code stay stuck in the devel cycle for three years when Goggle is using it to their advantage right now at this very moment.

Re:Injection?

[necro2607]

Yeah, who writes these headlines? It's like, let's throw together the most fucking sensationalist possible combination of words to evoke certain responses in peoples' minds when they read this headline. Instead of just writing something constructive like "MySQL adds code from Google", it has to be some sensationalistic crap so as to make people go "OMG SQL injection?!? Sum1 haxed MySQL??" and immediately read the article. What is this, FOX News or something? :P

Re:MySQL?

[marcansoft]

That's like saying PCs are toys, because banks use mainframes to handle your credit card transactions.

That a device or program isn't suited for a certain task doesn't mean it's a toy.

Re:MySQL?

[einhverfr]

Actually, there are several cases where you may think that MySQL has foreign keys when it doesn't. So the support of foreign keys is not entirely complete.

If innodb is not installed, you get a MyISAM table without the foriegn key enforcement and not even a warning is given on table creation (you do get a warning when you insert, but the application is unlikely to be watching).

CREATE TABLE table2 (
        id int autoincrement primary key,
        foreign_id int references table1(id),
        test text
) type=innodb;

CREATE TABLE table2 (
      id int autoincrement primary key,
      foreign_id int,
      test text,
      FOREIGN KEY foreign_id REFERENCES table1(id)
) type=innodb;

In one of the above examples (won't say which one ;-) ), you don't get foreign key enforcement. No warning. just no enforcement.

Yes, MySQL has foriegn keys. It doesn't have them 100% but it does have them.