Skip navigation links

MySQL Newsletter - Subscribe Today!

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

Hints & Tips

Events

New Discussion Forums

Training, Consulting, & Certification

Partner Corner



Highlights

White Paper: A Practical Guide to Migrating From Microsoft SQL Server to MySQL

This paper provides insight into what is needed for considering a move from SQL Server 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 the world's most popular open source database - MySQL.

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

Webinar: Web 2.0 and MySQL

Web 2.0 is the second generation of services available on the Web that lets people collaborate and share information online. One of the defining characteristics of Web 2.0 is the fact that it's the data that is driving this evolution. In this web seminar we explore how companies can increase performance, scalability and availability for Web 2.0 architectures using MySQL and MySQL Cluster.

Register for the Webinar »

MySQL European Customer Conferences
Northern Europe Customer Conference: London, October 17th, 2006
Central Europe Customer Conference: Munich, October 19th, 2006

The MySQL European Customer Conferences are a great way to:

  • Meet and network with the MySQL team including executives and engineers
  • Learn a lot in only one day about the MySQL roadmap, MySQL Cluster, Web 2.0 strategy with MySQL, performance tuning, and more
  • Discover how other MySQL customers are leveraging MySQL for their mission critical applications

Early Registration Discounts Available » (http://www.mysql.com/news-and-events/european-conferences/)

MySQL Joins Microsoft Visual Studio Industry Partner Program

MySQL announced its participation in the Microsoft Visual Studio Industry Partner (VSIP) program as an Alliance-level partner. As part of the VSIP program, MySQL AB is developing a downloadable plug-in for Visual Studio 2005 that will allow Windows developers to quickly build MySQL data-driven applications with Visual Studio. With this plug-in, developers will be able to create, modify and manage MySQL database objects with an easy-to-use interface from within the Visual Studio IDE.

Read the Press Release » (http://www.mysql.com/news-and-events/press-release/release_2006_29.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:

  • Senior Software Developers
  • Senior Consultants
  • Sales Representatives
  • Support Engineers
  • Senior Instructors
  • And More..

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

Products

New Release of MySQL Connector/J 5.0.2 (Beta)

Version 5.0.2 is a new release suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0 or MySQL-5.1 beta. Changes include:

  • Added connection/datasource property "pinGlobalTxToPhysicalConnection" (defaults to "false"). When set to "true", when using XAConnections, the driver ensures that operations on a given XID are always routed to the same physical connection.
  • MysqlXaConnection.recover(int flags) now allows combinations of XAResource.TMSTARTRSCAN and TMENDRSCAN.
  • Numerous bug fixes

Download Now »

New Release of MySQL Connector/MXJ 5.0.3 (Beta)

MySQL Connector/MXJ 5.0.3-beta is a Java utility package for deploying and managing a MySQL RDBMS.

New in the 5.0.3-beta version are MySQL 5.0.22 server binaries and related resources for the following platforms:

  • Linux x86
  • Mac OS X 10.3/10.4 ppc
  • Windows XP/2K/NT x86
  • SunOS sparc

Download Now »

Hints & Tips

Article: Partitioning with Dates in MySQL 5.1

It's clear that a lot of MySQL users are excited about the upcoming MySQL 5.1 release, and in particular, the new data partitioning feature that's being offered. Let's take a look at how to properly partition by dates in MySQL 5.1 and also showcase how not to try and partition by date, so you won't waste time and effort on something that doesn't give you the results that you're looking for

Read the Article »

Documentation: MySQL Cluster NDB API Developers Guide

The MySQL NDB API Guide covers two low-level APIs for writing applications that work with MySQL's NDB Cluster storage engine:

The NDB API is an object-oriented application programming interface for MySQL Cluster. The API provides ACID-compliant transactions, table and row scans that are similar in many ways to SQL cursors, and event handling. It also features object-oriented error-handling facilities.

The other API is the MySQL Cluster Management API (MGM API), a programming interface intended to provide administrative services for the cluster, such as starting and stopping Cluster nodes, Cluster logging, backups, and restoration from backups.

Read the Documentation »

Documentation: MySQL Test Framework

MySQL is shipped with a MySQL test framework that provides a means for verifying that MySQL Server and its client programs operate according to expectations. That's handy for anybody developing MySQL or contributing code to MySQL. In case the preconfigured test cases (there are hundreds) don't suffice the MySQL test framework can be extended by writing test cases using the mysqltest language.

Comprehensive documentation is now available for the MySQL test framework. For anyone contributing code to MySQL it's a must-read.

Read the Documentation »

Documentation: Chinese Translation 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 Chinese Reference Manual Online »

Documentation: New Connector/.Net Chapter Online

Connector/NET enables developers to easily create .NET applications that require secure, high-performance data connectivity with MySQL. It implements the required ADO.NET interfaces and integrates into ADO.NET aware tools. Developers can build applications using their choice of .NET languages. Connector/NET is a fully managed ADO.NET driver written in 100% pure C#. We've completely reworked the Connector/NET documentation. It's over 180 pages and contains more than 50 pages of examples.

Read the Documentation »

Events

Live Web Seminar: A Practical Guide to Migrating From Microsoft SQL Server to MySQL
Thursday, Aug 3, 2006: 10:00am PDT, 1:00 EDT, 17:00 GMT

Many MySQL customers are migrating from Microsoft SQL Server because they have reached the conclusion that the combination of cost-savings and feature set of MySQL make for a compelling business case to offload some or all their database-driven applications to the MySQL database server. This web seminar will provide insight into what is needed for considering a move from Microsoft SQL Server to MySQL, and presents a number of options that help make the transition easy.

Register for the Webinar »

Live Web Seminar (in German): High Availability Solutions for MySQL
Thursday, August 10th - 10:00am, Berlin Time

High availability solutions for MySQL enable organizations to achieve more predictable uptime and reliability by leveraging cost-effective, commodity hardware and software. In this presentation we will examine the requirements of a high availability MySQL solution and recommend architectures to implement them. In addition, we will discuss multiple High Availability products and services to choose from.

Register for the Webinar »

New Discussion Forums

New International Discussion Forums are available in the following languages:

  • German
  • French
  • Italian
  • Portuguese
  • Spanish
  • Russian
  • Chinese
  • Korean
  • Japanese

Visit the Forums »

Training, Consulting, and Certification

MySQL 5.0 Performance Tuning (4 days)
Chicago, Paris, Washington, D.C.

The MySQL 5.0 Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. Students will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.

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

Training: MySQL for Beginners (4 days)
Atlanta, Toronto, Seattle, Stuttgart, Paris

Want to join the wonderful world of MySQL? Here's your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation.

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

Partner Corner

New MySQL Partner and Solution Site

The MySQL Partner and Solution Site has been significantly updated and has a new look and feel. Check it out! Here MySQL users can find what they need around MySQL including applications, tools, add-ons, training, consulting, resellers, and more.

Partners, here's your opportunity to position your company at the forefront of the open source market, offer a high-performance, modern database option to your customers and help them cut the database tax.

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

Join the MySQL Partner Program » (http://solutions.mysql.com/partners/)

The MySQL Team