Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter September 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

MySQL Users Conference 2005 - Call for Papers is Open
Silicon Valley, California
April 18-21, 2005

The MySQL Users Conference 2005 will be the largest gathering of MySQL developers and users. Individuals and companies interested in making presentations or giving tutorials are invited to submit proposals. The theme this year is "MySQL Everywhere." Proposals should be focused on helping attendees:

  • Harness the full power of MySQL, including best practices
  • Learn and use new features in MySQL 5.0
  • Learn from experts who have used MySQL in various application architectures (Web, Data Warehouse, Cluster, Embedded, etc.)
  • Migrate from proprietary databases to MySQL

Submit a Proposal

Article Series: New in MySQL 4.1

"New in MySQL 4.1" is an on-going series of articles that explain some the new features in MySQL 4.1, which is in the gamma phase of its development cycle, on the way to a production-ready release in the near future.

Read the articles:

MySQL in Retail, Telecom, and Travel & Hospitality

MySQL allows organizations across multiple industries to deliver applications that help them gain a competitive edge. In particular, MySQL offers organizations in Retail, Telecom, and Travel & Hospitality unique advantages:

Learn how customers like Suzuki and Sabre Holdings are using MySQL (http://www.mysql.com/industry/)

Case Study: craigslist Uses MySQL to Serve Millions of Classified Ads

craigslist revolutionized the ease and speed with which people could create an online community that would facilitate the exchange of ideas, goods and services. According to Alexa Traffic Rankings, craigslist is one of the Top 100 most trafficked web sites in the world. Every month, craigslist receives 5 million unique visitors, and serves about 1 billion page views. In less than 4 years, MySQL has enabled craigslist to grow from 250,000 page views to over 27 million page views daily - virtually all of which are generated out of MySQL.

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

Case Study: Evite Relies on MySQL to Deliver Millions of Invitations

The Evite Web site serves 6 million users and delivers up to 9 million invitations each month. Evite had been using Oracle for four years to try to meet all of their data management requirements. However, they found that the Oracle software was very expensive and difficult for less-experienced staff to use. After only one year, MySQL has become a key part of the IT infrastructure of Evite, taking the place of expensive, proprietary solutions.

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

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/)

Products

New Release of MySQL (4.1.5 Gamma) is Now Available

This is the second 4.1 gamma release, mainly fixing recently discovered bugs in preparation for the upcoming production release. This release includes:

  • InnoDB: Added configuration option innodb_autoextend_increment for setting the size in megabytes by which InnoDB tablespaces are extended when they become full. The default value is 8, corresponding to the fixed increment of 8MB in previous versions of MySQL.
  • The Windows Installer packages are now making use of the Windows Installer (MSI) and include a new MySQL Server Instance Configuration Wizard that can be used to easily generate an optimized server.

For detailed information on what is new visit

Source and binaries are available to download

New Release of MySQL Query Browser (1.0.7 Beta) is Now Available

MySQL Query Browser is a visual query tool for creating, executing and optimizing MySQL database queries in a GUI environment. MySQL Query Browser is available for Linux and Windows. Features include:

  • Query history and bookmarking
  • Tabular visualization of results
  • Side-by-side result set comparisons

To read the documentation, visit

Source and binaries are available to download

New Release of MySQL Connector/J (3.1.4 Beta) is Now Available

This is the second Beta release that is suitable for use with either MySQL-4.1 or MySQL-5.0 (and is required when using server-side prepared statements on MySQL-4.1.2 or newer). This release includes:

  • Added support in DatabaseMetaData.getTables() and getTableTypes() for VIEWs which are now available in MySQL server version 5.0.x.
  • Added 'useOnlyServerErrorMessages' property, which causes message text in exceptions generated by the server to only contain the text sent by the server (as opposed to the SQLState's 'standard' description, followed by the server's error message). This property is set to 'true' by default.

For detailed information on what is new visit

Source and binaries are available to download

MySQL Connector/Net (1.0.0 Beta) is Now Available

MySQL Connector/Net is a fully-managed .NET driver for MySQL. Connector/Net is suitable for use with all versions of MySQL from 3.23 to 5.0!

For detailed information on what is new visit

Source and binaries are available to download

MySQL Connector/MXJ (1.0.5 Alpha) is Now Available

MySQL Connector/MXJ is a JMX MBean for deploying and managing a MySQL database. This makes it easy for Java developers to deploy applications which require a database by reducing installation barriers for their end-users. Connector/MXJ requires a JMX v1.2 compliant MBean container, such as JBoss version 4. As a JMX MBean, Connector/MXJ makes the MySQL database appear to be a Java-based component. This release includes:

  • The ability to have the MBean start the MySQL database upon startup.
  • If you're using JBoss, we've taken advantage of the JBoss life- cycle extension methods so that the database will gracefully shut down when JBoss is shutdown.

For detailed information on what is new visit

Source and binaries are available to download

Tips & Hints

Migrating to MySQL
Eliminating Risks and Hidden Costs Using Specialized Migration Software
Dmitry Tolpeko, Ispirer Systems

For successful migration of enterprise databases running on Oracle, SQL Server, Informix and Sybase to MySQL, you have to choose tools that automate the entire migration process and avoid the risks and hidden costs associated with partial conversion.

Read the article

Migration White Paper: Practical Case Report on the Migration of AmazonTech's Flight Operations Management Solution to MySQL (SQL Server to MySQL)

FPAssistant Flight Operations Management (FOM) is AmazonTech's solution that integrates all flight dispatching activities into a single and user-friendly map-based system, which includes fleet management, flight planning, dispatch control and flight tracking. This White Paper details all the steps taken to successfully migrate FPAssistant FOM's data tier from the popular, yet highly license restrictive Microsoft SQL Server 2000 to the world?s most popular open source RDBMS: MySQL.

Download the White Paper (http://www.mysql.com/it-resources/white-papers/mysql_amazontech_mssql2mysql_paper.pdf)

Book Review: MySQL Tutorial

"MySQL Press has published an excellent book on learning the basics of MySQL called MySQL Tutorial. It's written by Luke Welling and Laura Thomson, the authors of PHP and MySQL Web Development (Sams 2003). Their tutorial has a simple style and a relaxed pace that's ideal for MySQL beginners."

Read the full review

Events

Conference: MySQL ComCon Europe 2004
November 8-10
Frankfurt, Germany

The MySQL ComCon Europe 2004 brings together the vigor and excitement of a community event (like LinuxTag) with the structure of MySQL mission-critical business event. Sessions on diverse topics such as "Performance Tuning J2EE Applications deployed on MySQL", "Lowering TCOs for SAP Environments with MaxDB" and a two-part introduction to MySQL Cluster will be presented by MySQL core developers, expert trainers and MySQL community leaders.

Take this excellent opportunity to meet, mingle, learn, and also talk business. Don't miss out and register today! For more details on the conference program and speakers, visit http://mysqlcomconeurope.com/.

MySQL Meetups - October 4th

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

Web Seminar: Creating Custom Storage Engines MySQL
Thursday, October 7, 2004 at 2:00pm PDT, 5:00pm EDT, 23:00 CEST

Sign up now

Web Seminar: New Features in MySQL 4.1
Thursday, October 7, 2004 at 7:00am PDT, 10:00am EDT, 16:00 CEST

Sign up now

Conference: Systems
October 18-22, 2004
München, Germany

Register and view the Schedule

Conference: MySQL Swell Geek Cruise - Almost Sold Out
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)

Conference: Linux World
October 26-28, 2004
Frankfurt, Germany

Join MySQL at Linux World where MySQL will be giving multiple talks:

  • Softwarepatente, gegen Open Source und Mittelstand, Florian Müller
  • MySQL Cluster, Jan Kneschke
  • Workshop: LAMP für Business Applications, Gaylord Aulke, 100 Days and Jan Kneschke, MySQL

Register before September 30, 2004 and receive free exhibits only and our Early-bird conference discount

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

MYdbPAL for MySQL is Now Available - Free Edition for MySQL Users

IT Map International presents the latest release of its' widely acclaimed database design and migration product: MYdbPAL for MySQL. This product provides a single integrated master console workplace for the database administration and database designers for database migrations and conversion, database development, data modeling, data ETL and database documentation.

Download a special free edition for MySQL users

MT Studio FOR MySQL - Free to MySQL Users

MT Studio, Mart Technology's highly acclaimed RAD environment for Rich Web Applications, is now free for MySQL Users. Build advanced desk-top style Web applications in timeframes you never imagined possible. Described by Mike James, editor of VSJ, as, "The easiest way I've seen of creating client/server systems..."

Read more