Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter June 2006

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, Consulting & Certification

Partner Corner

Highlights

White Paper: Session Management with MySQL

Many web applications require knowledge of a user's interactions and current state on the website, as in online banking or ecommerce. In this paper we explore how MySQL and MySQL Cluster can be used as part of a cost-effective, high-performance, open-source solution for database-centric session management.

Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_session_mngmnt.php)

White Paper: A Practical Guide to Migrating From Oracle to MySQL

This paper provides insight into what is needed for considering a move from Oracle to MySQL, and presents a number of options that help make the transition easy. Both the business and technical sides of migrating to MySQL will be dealt with, so whether you are a manager or a seasoned DBA, you will find the needed answers to questions that revolve around migrating to MySQL.

Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_oracle2mysql.php)

MySQL Launches MySQL Forge

MySQL Forge, a new Web site and community directory designed to encourage and support active MySQL-related open source development. MySQL Forge is a central online resource for all MySQL users and developers to communicate collaborate and share MySQL code and applications.

For More Information visit »

MySQL Helps Set World Record in Java Application Server Benchmarks

A popular application server benchmark, featuring a complete open source software stack with MySQL 5.0 database, the Solaris™ 10 Operating System, and Sun Java™ Systems Application Server 9.0 Platform Edition has shattered the competition by offering up to 8.6 times lower cost of acquisition than the comparable solution.

Download the Benchmark Results »

MySQL Builds Momentum in Telecom Sector

MySQL is seeing growing momentum in the UK-Ireland telecommunications sector with Tiger Communications, XOU Solutions and Anam Mobile leading a growing number of businesses adopting MySQL open source database solutions. Plus, Alcatel, Nokia, Ericsson, Telio and Nortel have all recently selected MySQL products for important applications.

Learn More » (http://www.mysql.com/news-and-events/press-release/release_2006_28.html)

MySQL is Hiring

Apply today to join one of the largest and fastest growing open source companies! MySQL is a global organization with over 300 employees in 25 countries. We are looking for:

Apply Now » (http://www.mysql.com/company/jobs/)

Products

New Release of MySQL 5.0.22 Community Edition (GA)

This release 5.0.22 only includes the security fix described below:

  • Security fix: An SQL-injection security hole has been found in multibyte encoding processing. The bug was in the server, incorrectly parsing the string escaped with mysql_real_escape().

Download Now »

New Release of MySQL 5.1.11 Community Edition (Beta)

This is a bug fix release of MySQL 5.1 that includes the following new features and changes:

  • Security fix: An SQL-injection security hole has been found in multi-byte encoding processing. The bug was in the server, incorrectly parsing the string escaped with the mysql_real_escape_string() C API function.
  • Previously, to build MySQL from source with SSL support enabled, you would invoke configure with either the --with-openssl or --with-yassl option. Those options both have been replaced by the --with-ssl option.
  • Added the --ssl-verify-server-cert option to MySQL client programs.
  • MySQL Cluster: The limit of 2048 ordered indexes per cluster has been lifted. There is now no upper limit on the number of ordered indexes (including AUTO_INCREMENT columns) that may be used.
  • The ENABLE KEYS and DISABLE KEYS clauses for the ALTER TABLE statement are now supported for partitioned tables.

For the complete list of changes visit »

Download Now »

New Release of MySQL Connector/J 3.1.13

MySQL Connector/J 3.1.13 a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.1.13 is a bugfix release for the stable branch that is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0 or MySQL-5.1 beta.

For a complete list of changes visit »

Download Now »

Hints & Tips

Documentation: German and Spanish Translations of the MySQL 5.1 Reference Manual

MySQL 5.1 Reference Manual provides a comprehensive guide to virtually every aspect of the open source database's functionality and usage. The Reference Manual is available in multiple formats including HTML, PDF, and Windows Help.

View the German Reference Manual Online »

View the Spanish Reference Manual Online »

New Connector/ODBC Chapter Online

We have done a complete rewrite of the Connector/ODBC docs - making this one of the best chapters in the MySQL Reference Manual.

Download Now »

FAQ: CJK Language (Chinese, Japanese, Korean) Support

Managing CJK data can be particularly tricky. Therefore we've just added a FAQ section that answers the most common questions about handling CJK contents and provides hands-on solutions to common problems. This Frequently-Asked-Questions section comes from the experiences of MySQL's Support and Development groups, after handling many enquiries about CJK issues.

View the MySQL 5.1 FAQ online »

Visit the Forum (Character Sets, Collation, Unicode) »

Events

Live Web Seminar: Session Management with MySQL

Wednesday, June 28th - 10:00am PDT, 1:00 EDT, 17:00 GMT

Many web applications require knowledge of a user's interactions and current state on the website, as in online banking or ecommerce. This web seminar will explore how MySQL and MySQL Cluster can be used as part of a cost-effective, high-performance, open-source solution for database-centric session management.

Register for the Webinar »

Live Web Seminar: Optimizing MySQL 5.0 Stored Procedures

Wednesday June 29th - 10:00 am 10:00am PDT, 1:00 EDT, 17:00 GMT

MySQL 5.0 stored procedures represent an exciting new feature of the MySQL server that allow application logic or administrative routines to be run from with in the server itself. In this presentation you will learn:

  • How to optimize SQL statements within stored procedure code.
  • When to use stored procedures to accelerate application performance.
  • How to optimize stored procedure code.

Register for the Webinar »

What's New in MySQL Cluster 5.1

Thursday, July 13th - 10:00 am 10:00am PDT, 1:00 EDT, 17:00 GMT

In this presentation we will explore in technical detail the new features which have been introduced in MySQL Cluster 5.1. With the release of 5.1, many new features and improvements have been introduced to the already popular MySQL Cluster. These include:

    • Disk-based Data
    • Row-based Replication
    • Online ADD INDEX
    • Hardware Selection and Tuning
    • True VARCHAR support for memory data

View MySQL Webinars Now »

Training, Consulting & Certification

MySQL 5.1 High Availability (3 days)
Dallas, Edison, Amsterdam, London

This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.

Register Now for an Upcoming Date » (http://www.mysql.com/training/schedule.php?class=5500)

Training: MySQL 5.0 for Developers (5 days)
Atlanta, Toronto, Seattle, Stuttgart, Paris

This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification.

Register Now for an Upcoming Date » (http://www.mysql.com/training/schedule.php?class=5100)

Partner Corner

Linux Professional Institute to Offer MySQL 5.0 Certification Exams

The Linux Professional Institute announced a joint initiative to offer MySQL 5.0 certification exams through LPI's global proctor network, beginning with the C3 Expo, June 27th - 29th, 2006 at the Javits Center in New York City.

Learn More » (http://solutions.mysql.com/news/release_1110.html)

ExitCertified Corporation selected as first Authorized MySQL Education Center (AMEC) in Canada

ExitCertified will offer courses on MySQL 5.0

Learn More » (http://solutions.mysql.com/news/release_1103.html)

Smart Style (Japan) becomes a MySQL Network Platinum Certified Partner

Smart Style supports customers in MySQL integration, tuning, consultation, design.

Learn More » (http://solutions.mysql.com/news/release_1092.html)


The MySQL Team