Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter November 2005

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

New Discussion Forums

Events

Consulting, Training & Certification

Partner Corner



Highlights

MySQL 5.0 Downloaded One Million Times in First Three Weeks

There has been record interest in MySQL 5.0, the newest version of the world's most popular open source database. MySQL 5.0 has already been downloaded over one million times since its introduction on October 24. MySQL 5.0 delivers new advanced SQL standard-compliant features including Stored Procedures, Triggers, Views & and new Pluggable Storage Engines.

Download MySQL 5.0 »

White Paper - A Practical Guide to Migrating to MySQL 5.0

This white paper addresses the major questions that naturally occur when one thinks about migrating a key database-driven system to MySQL. Both the business and technical sides of migrating to MySQL are discussed, so whether you are a manager or a seasoned DBA, you will find answers to your MySQL migration questions.

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

Case Study - NetQoS Delivers Distributed Network Management Solution

NetQoS ReporterAnalyzer relies on MySQL to tell IT organizations which applications and users are consuming bandwidth so they can optimize the network and improve service. NetQoS found that MySQL provided the ideal combination of performance, reliability, and ease of administration. In addition, MySQL's affordable licensing model enabled NetQoS to reduce its database costs by several thousand dollars per network appliance.

Download the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql-netqos-casestudy.pdf)

Products

New Release of MySQL 5.0.16 Community Edition (GA) is Now Available

This is a new production release of the MySQL Community Edition in the 5.0 series. Additional changes include:

  • The InnoDB, NDB, BDB, and ARCHIVE storage engines now support spatial columns.
  • Added a --hexdump option to mysqlbinlog that displays a hex dump of the log in comments. This output can be helpful for replication debugging.
  • Numerous bug fixes

For the complete list of changes visit »

Download Now »

New Release of MySQL Connector/Net 1.0.7 (GA) is Now Available

This release is the latest production release of the 1.0 series and supports MySQL 4.1 and 5.0. Now that .Net 2.0 and Visual Studio 2005 have been released, we are now including .Net 2.0 binaries in our distribution.

View the complete list of changes »

Download Now »

Tips & Hints

Article: Stored Procedures in MySQL 5.0

There is no direct support for dynamic declaration of details such as column or table names in MySQLs stored procedures. However, by utilizing user variables (which have been around for a while) and prepared statements (introduced in MySQL 4.1), we can do some trickery to get the results we want.

Read the Article »

Article: MySQL for the Oracle DBA

You're an Oracle DBA, and suddenly, as if it fell from the sky, a MySQL database is now in your lap, and it requires care and feeding. What to do? Take heart: Given your Oracle experience, you've probably learned many of the basic concepts you'll need to know for MySQL already, and they will, with careful attention, transfer to the open source world.

Read the Article »

Article: Using BIRT to Report On Bugzilla in MySQL

In this example, we are going to develop a BIRT listing report. We will use a bugzilla database installed on MySQL as our data source. What we would like to show in this report is a listing of all current bugs in the system. This will be a simple yet powerful report, showing groupings on Bugzilla Products and Components with totals, that should only take about 15 minutes to develop once you gain a modicum of familairty with BIRT.

Read the Article »

Sample Chapter: php|architect's Guide to PHP Security
Chapter 3, SQL Injection

SQL injection is yet another common vulnerability that is the result of lax input validation. Unlike cross-site scripting vulnerabilities that are ultimately directed at your site's visitors, SQL injection is an attack on the site itself - in particular its database.

Read the Chapter »

Interview: Linux Magazine Interview with Monty Widenius

Linux Magazine presents an exclusive interview with Monty Widenius who talks about the new MySQL 5.0 release.

Read the Interview »

Community Blogs: Excellent Blogs Dedicated to MySQL

The MySQL Community has started excellent blogs dedicated to MySQL. These blogs include valuable tips and sample code to make you more productive.

View all the MySQL Blogs »

New Discussion Forums

MySQL Optimizer

This forum is for anyone interested in query optimization to improve the performance of their MySQL applications.

Visit the Forum »

Ruby and MySQL

This forum is for anyone interested in Ruby and MySQL. Discuss issues related to the Ruby API for MySQL, Ruby on Rails, Using the Ruby DBI Module, and Using the Ruby MySQL Module.

Visit the Forum »

Events

Live Web Seminar: Upgrading to MySQL 5.0 for OEMs and ISVs

December 1, 2005, 10:00 am PDT, 1:00 pm EDT, 18:00 GMT

MySQL is the most popular database for ISVs, VARs, hardware vendors, and network appliance manufactures who want to cost-effectively embed or bundle a reliable, high-performance relational database. In this Webinar you will learn about:

  • New MySQL 5.0 features that OEMs and ISVs need to know about
  • What the new Archive Engine can do for you
  • Considerations for regulatory compliance (such as Sarbanes-Oxley and HIPAA)
  • Why your Product Releases should be on 5.0
  • Steps and tips to upgrading to MySQL 5.0
  • And more.

Learn more and Register Today »

Live Web Seminar: High Availability Clustering, How MySQL Supports 99.999% Availability

December 6, 2005, 10:00 am PST, 1:00 pm EDT, 18:00 GMT

MySQL Cluster combines the world's most popular open source database with a fault tolerant database clustering architecture so you can deliver mission-critical database applications with 99.999% availability. In this Webinar you will learn about:

  • MySQL Cluster parallel server architecture
  • How to implement MySQL Cluster for High Availability
  • MySQL Cluster management and administration
  • Applications ideally suited for MySQL Cluster
  • And more.

Learn more and Register Today »

Community Event: MySQL Users Groups

Meet other MySQL users in your local community and discuss the new features in MySQL 5.0. MySQL Users Groups 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.

For more information and to find a user group near you »

Consulting, Training & Certification

Training: MySQL 5.0 for Developers (5 days) - Save $500
Washington DC, San Francisco Bay Area, Los Angeles, Chicago, and more.

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/workshops/mysql_dev.html)

Training: MySQL 5.0 for DBAs (5 days) - Save $500
San Francisco, Chicago, London, Sydney, and more

This instructor led, hands-on class will teach you how to secure users privileges, set resource limitations, and access controls. In addition, you will learn new 5.0 features by creating and using Stored Procedures, Triggers and Views.

Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dba.html)

Partner Corner

EMS Releases SQL Manager for MySQL

EMS Database Management Solutions, the developer of the world known DBA tool SQL Manager, today announced it has joined the MySQL Partner Program to maximize integration between SQL Manager for MySQL and the MySQL Network.

Learn More »

Logicalware Releases MailManager for MySQL

Logicalware Ltd, publisher of MailManager the Open Source email response management solution announced that MailManager has now been ported to MySQL and has been tested and certified for MySQL Network.

Learn More »