Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter August 2004

Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links.

Articles in this newsletter:

Highlights

Products

Tips & Hints

Events

Training & Certification

Partner's Corner

Highlights

New Support Offerings - Basic & Premier (coming September 1, 2004)

MySQL AB's new Basic Support (http://www.mysql.com/support/basic.html) is for organizations that are developing and deploying simple database solutions, requiring affordable support from MySQL AB.

Our Premier Support (http://www.mysql.com/support/premier.html) is for organizations developing complex database solutions across the enterprise. These projects may require a higher level of support from MySQL AB to ensure your solutions are delivered on time and optimized for your organization. MySQL AB technical professionals resolve your problems 24×7.

Learn more about MySQL AB's new support offerings (http://www.mysql.com/support/)

Certified MySQL Hosting Now Available - Special Offer

MySQL Hosting is a reliable, secure and cost-effective way to host your Web site, email and MySQL database applications and is the only hosting offering certified by MySQL. A high-availability hosting infrastructure built on the LAMP stack and optimized for MySQL enables you to instantly deploy your applications with 99.9% uptime guaranteed.

Sign up now and receive free 1 year domain name registration (http://www.mysql.com/hosting/)

MySQL Migration Seminar Series - San Francisco, New York & London

Migrate Your Database to MySQL with Embarcadero DT/Studio. An easy path to cutting your database costs by 90%. Please join Embarcadero Technologies, MySQL, and CapGemini/Sogeti for this exclusive free seminar on migrating to MySQL and learn how you can:

  • Significantly reduce database licensing costs, hardware costs, and overall total cost of ownership of your database platform
  • Eliminate the risk associated with data migration and successfully complete even the most complex data migration projects
  • Rapidly migrate data from your existing database platform to MySQL.

Space is limited — Sign up Today

Case Study: Pivex Uses MySQL to Make Travel and Hospitality Profits Soars

Pivex developed Folio Exchange using MySQL which has processed over $200 million in billings for some of the world's leading travel wholesalers including American Airlines Vacations, Pleasant Hawaiian Holidays, and Outrigger Hotels. Folio Exchange is a complete turn-key solution which eliminates up to 90% of the costs of submitting invoices and remitting payments between hotels and travel wholesalers.

The reliability, performance, cost, and the pluggable storage engine architecture of MySQL are the distinguishing factors behind the success of Pivex and Folio Exchange.

Download the Case Study (http://www.mysql.com/it-resources/case-studies/mysql-pivex-casestudy.pdf)

Open Source Against Software Patents
In the arms race of software patents, it's innovation that's losing

Marten Mickos, MySQL CEO, discusses software patents and how they stifle the innovation that the open source movement has helped foster.

Read the article

Securities Industry News: Special Report, Open-Source Technology

Wall Street firms have been bullish on Linux the past couple of years, moving increasing number of applications over to the low-cost, easily customizable open-source operating system. While giants like HP and IBM are offering support putting their marketing might behind open-source, other vendors are taking steps to fill in other pieces of the puzzle. And according to Joe Dennick, IS director at Omaha-based Securities America, MySQL is ready for prime time.

Download the Article (PDF)

Products

New Release of MySQL (4.1.4 Gamma) is Now Available

This is a new gamma development release, adding new features and fixing recently discovered bugs. This release includes:

  • The mysqld-opt Windows server was renamed to mysqld. This completes the Windows server renaming begun in MySQL 4.1.2.
  • Added --start-datetime, --stop-datetime, --start-position, and --stop-position options to mysqlbinlog. These make point-in-time recovery easier.
  • Numerous bug fixes.

For detailed information on what is new visit

Source and binaries are available to download

MySQL Cluster is available in the binary release of MySQL 4.1.4 Max version

MySQL Cluster provides a clustered distributed database management system for delivering highly scalable, mission-critical database applications with 99.999% availability. MySQL Cluster is built on a shared-nothing architecture and includes advanced features such as failover, node recovery, synchronous data replication and no single-point-of failure.

To read the MySQL Cluster documentation, visit

To read the Quick Start Guide, visit

Binaries are available for download

New Release of MySQL Administrator (1.0.12) is Now Available

This is a maintenance release of the current production version of MySQL Administrator and contains a few bug fixes relating to user administration, and the table editor.

Source and binaries are available to download

New Release of MySQL (5.0.1 Alpha Snapshot) is Now Available

This is a snapshot of the alpha development release, adding new features and fixing recently discovered bugs. This release introduces:

  • Added support of read only updateable VIEWS based on a single table or other updateable VIEWs.
  • New "greedy" query optimizer that can significantly reduce the time spent on optimizing the query in some many-table joins.
  • Various improvements in the stored procedure and replication code.

For detailed information on what is new visit

Source and binaries are available to download

MaxDB by MySQL 7.5.00.16 is Now Available

This is a maintenance release of the production version of MaxDB. This version includes:

  • The monitor table includes now 5 additional rows to get more information about usage of new join features like hash join and parallel join.
  • In a hot standby system the backup history is distributed automatically.
  • The performance of the precompiler runtime was significantly improved by using a hash based data structure for the internal data container

For detailed information on what is new visit

Download

Tips & Hints

Interview: Catching up with Monty

Michael "Monty" Widenius is the CTO and co-founder of MySQL AB, and the original developer of much of the MySQL code base. Before Monty went into hiding to dive into work on new features for MySQL 5.0 (and spend time with his newborn daughter), we caught up with him on MySQL 4.1 and the state of the company from his point of view.

Read the interview

Database Migration from FileMaker to MySQL

David Simpson describes the procedures involved with migrating a FileMaker 6 database running on Windows to a MySQL database running on any platform. Additional info is included regarding changes to this procedure which are required to convert FileMaker 7 to MySQL.

Read the article

MySQL Tutorial
Chapter 10: Using Transactions with InnoDB Tables

In this sample chapter from MySQL Tutorial, published by MySQL Press, authors Luke Welling and Laura Thomson explain the basics of transactions, and how the InnoDB storage engine can be used to achieve ACID compliance.

Read the chapter

Events

Web Seminar: The LAMP Stack
September 9, 2004 at 7:00am PDT, 10:00am EDT, 16:00 CET

Join Hans Zaunere, MySQL Sales Engineer in the educational web seminar as he defines and discusses the benefits of the LAMP (Linux, Apache, MySQL, PHP-Python-Perl) stack. You will also learn how leading organizations, including Lycos Europe are using LAMP to cost-effectively implement their high performance, secure and reliable applications.

Sign up now

Web Seminar: Clustering with MySQL
Weekly Throughout September

Join Vinay Joosery, MySQL Cluster Product Manager, and get a detailed understanding of the high availability and reliability features of MySQL Cluster. You will gain an understanding of various usage scenarios and lean how MySQL Cluster uses advanced features such as failover, node recovery, synchronous data replication and no single-point-of failure to achieve high-availability.

Sign up now

MySQL Meetups - September 6th

Meet other MySQL users in your local community. MySQL Meetups are free and informal, face-to-face meetings that happen in hundreds of cities around the world. These meetings are a great opportunity to share your interest over a coffee or a beer.

Find a MySQL Meetup day near you

AUUG 2004 Conference
29 August - 3 September 2004
Melbourne VIC, Australia

Join MySQL at AUUG'2004, the annual technical conference of AUUG, the Australian UNIX and Open Systems User Group. Arjen Lentz, Technical Writer/Trainer, MySQL AB, will also be giving multiple talks:

  • Tutorial (Monday): MySQL Installation, Security, and Maintenance
  • Tutorial (Tuesday): Optimizing MySQL
  • Keynote (Thursday): How to Eat an Elephant

To register, visit

SANE 2004 Conference
September 27 - October 1, 2004
Amsterdam, The Netherlands

Join MySQL at the 4th International System Administration and Network Engineering Conference. Organised by the NLUUG (Dutch UNIX User Group). Arjen Lentz, Technical Writer/Trainer, MySQL AB, will also be giving multiple talks:

  • Tutorial (Tuesday): MySQL Installation, Security, and Maintenance
  • Tutorial (Tuesday): Optimizing MySQL
  • Presentation (Thursday): MySQL RoadMap - What we have now and where we are heading

To register, visit

MySQL Swell Geek Cruise
October 10-17, Eastern Mediterranean

Join the founders of MySQL Monty Widenius, David Axmark and other technical experts from MySQL on this unique 7 day high-tech Mediterranean cruise. This is a great opportunity to get comprehensive technical insight into MySQL and attend hands-on workshops with the developers of MySQL and combine it with fantastic sightseeing and world-renowned travel.

Read more and sign up now (http://www.mysql.com/geekcruises)

Training & Certification

Free Certification Voucher - Offer extended through September 30th

Register for the 'Introduction to MySQL' or 'Using and Managing MySQL' training classes and receive a Certification Exam voucher for free. Offer expires September 30th. MySQL AB is holding training courses in the following countries: USA, Germany, Canada, France, UK, Australia, India and Sweden.

Check out dates and locations (http://www.mysql.com/training/free-certification.html)

Partner's Corner

MySQL is Now Available on MontaVista Linux

MySQL database is now available for the MontaVista Linux Carrier Grade (CGE) Edition for the telecommunications and Network Equipment Provider (NEP) markets and MontaVista's Linux Professional Edition for the traditional embedded market.

Read the Press Release (http://www.mysql.com/news-and-events/press-release/release_657.html)