Slashdot Mirror

← Back to Stories (view on slashdot.org)

MySQL AB Calls v4.1.7 Production Ready

Posted by timothy on from the world's-fastest-recipe-book dept.

puppetman writes "MySQL announced a few hours ago that 4.1 has been deemed production ready with the release of 4.1.7. The major enhancements of 4.1 include sub-selects, faster communication between client and server (thanks to parameter binding), replication over SSL, and lots more. A full list can be found here. Time to rehash those tired arguments about why MySQL is not a real database, and (Postgres/Oracle/SQL Server/Access/SAPDB/Ingres/etc) is the only real database out there."

4 of 59 comments (clear)

  1. wheelbarrow? by Vaevictis666 · · Score: 3, Interesting

    Ok, I'll bite. Why is the Databases icon a wheelbarrow?

  2. Have its developers' attitudes changed? by Anonymous Coward · · Score: 5, Interesting

    Does MySQL still silently substitute its best guess when you try and insert an invalid value into a column?

    Does MySQL still silently substitute a non-ACID table type when you ask for an ACID table type and it isn't available?

    Does MySQL still silently alter the data you insert into varchar columns by stripping trailing spaces?

    MySQL used to be riddled with all kinds of behaviours that the MySQL developers thought might be handy in some circumstances, but that silently alter or ignore the programmer's/DBA's instructions and the SQL specifications. Have the developers gained enough of a clue to fix these (intentional, documented) problems?

  3. Re:MySQL by digerata · · Score: 3, Interesting

    Ditto.

    Our main application was originally on MySQL. Started off at around 3 million records spread across 78 taables. The largest table had around 575,000 records. Now we are much larger running on Oracle.

    MySQL handled the load and all of our queries on multiple servers in our app cluster just fine. But when we needed more advanced things that MySQL doesn't provide (and won't for another decade or so) we moved to Oracle.

    We defined "more advanced things" as master-master replication (that is easy to setup and maintain and is provided by the DB vendor), real DB clustering, Natural Language searching, complex sub-queries, recycling sequences (auto_increment keys), and a host of administration tools among other things. Granted, some of these MySQL is just now putting out there. But it certainly doesn't have all.

    Notice, I never mentioned stored procedures, triggers, or views.

    Its funny, way back when we were justifying using MySQL in a production enterprise environment, speed comaprisons against Oracle was a huge argument. But if MySQL ever throws in everything Oracle has feature wise, they will be just as slow if not slower.

    --

    1;
  4. apt-get install mysql-server by lorcha · · Score: 2, Interesting
    will give you a mysql installation with "skip-networking" in my.cnf. In other words, no one is going to hack you remotely without your explicitly enabling networking.

    I'm not sure what the other distros do. I do remember that the mysql install doc tells you to change your root password.

    Or maybe your "coworker" did not read the docs?

    --
    "Avoid employing unlucky people - throw half of the pile of CVs in the bin without reading them." -- David Brent