Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database
    • Development
    • Servers

    MySQL 5 Arrives

    By
    Steven J. Vaughan-Nichols
    -
    October 24, 2005
    Share
    Facebook
    Twitter
    Linkedin

      Three years in the making, MySQL 5.0 was finally released on Monday.

      MySQL AB delivers new, and long-awaited, ANSI SQL features in this latest version of the popular open-source DBMS.

      These new features include both read-only and updated views, stored procedures row-level triggers, both read-only and non-scrolling server-side cursors, and stored functions that rely on the SQL:2003 syntax. This is the same version of SQL that is used in IBM DB2.

      “Implementing ANSI SQL standard ways of using existing MySQL features means there will be fewer unpleasant surprises (“gotchas”) for those migrating to MySQL from other database systems,” wrote MySQL Vice President of Community Relations Kaj Arnouml on the companys site.

      For example, MySQL 5.0 adds a mode that enables strict data-type checking. Thus, the database will issue errors for invalid dates, numbers and strings without requiring additional programming.

      The new MySQL also include an ANSI SQL-compliant Data Dictionary to access metadata and a new library for arithmetic that will give high accuracy on financial and mathematical operations.

      MySQL 5.0 also packs new storage engines, tools and extensions. For example, the Archive Storage Engine is designed for storing large amounts of data without indexes in a very small footprint. Thats intended to handle historical data to keep enterprises in compliance with audits, such as with Sarbanes-Oxley regulations.

      The new MySQL 5.0 also includes an Instance Manager tool for starting and stopping the MySQL Server both locally or remotely.

      /zimages/1/28571.gifClick here to read more from columnist Charles Garry about Oracles alleged plans to destroy MySQL.

      “We are quite proud to deliver this new version of MySQL,” said Marten Mickos, MySQLs CEO. “It includes the most-requested features from our users, customers and partners. With their feedback, we have been able to provide important enterprise-class features while staying true to MySQLs renowned heritage of high-performance, reliability and ease-of-use.”

      The new version also comes with broad industry support. Over 30 enterprise software and database tool vendors have already expressed support for MySQL 5.0.

      The production version of MySQL 5.0 is available now for Linux, Windows, Solaris, Mac OS X, FreeBSD, HP-UX, IBM AIX 5L and several other operating systems.

      As before, all MySQL database software is available under a dual licensing model. Developers and organizations can choose between an open-source (GPL) or a commercial MySQL license, depending on their deployment requirements.

      Commercial customers are already planning on moving to 5.0.

      “MySQL 5.0 represents a huge leap in features and functionality for the MySQL database,” said Gunter Rombauts, European IT manager for Chicago Metallic, in a statement.

      “As a worldwide leader in metal ceiling systems, its critical that our database supports heavy-duty enterprise applications with speed and reliability. We are looking forward to using MySQL 5.0 as a key component of Chicago Metallics global IT infrastructure.”

      MySQL 5.0 can be downloaded from the companys site.

      Additional details on 5.0s best and brightest can be found at the sites nutshell page.

      /zimages/1/28571.gifCheck out eWEEK.coms for the latest database news, reviews and analysis.

      Steven J. Vaughan-Nichols
      I'm editor-at-large for Ziff Davis Enterprise. That's a fancy title that means I write about whatever topic strikes my fancy or needs written about across the Ziff Davis Enterprise family of publications. You'll find most of my stories in Linux-Watch, DesktopLinux and eWEEK. Prior to becoming a technology journalist, I worked at NASA and the Department of Defense on numerous major technological projects.

      MOST POPULAR ARTICLES

      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Cloud

      Yotascale CEO Asim Razzaq on Controlling Multicloud...

      James Maguire - May 5, 2022 0
      Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×