MySQL Newsletter September 2007

Articles in this newsletter:

Events

Live Web Seminar: What's New in the MySQL Enterprise Fall 2007 Release? (October)

Training, Consulting & Certification

Partner Corner

Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today.

Highlights

New MySQL Enterprise Replication Monitor: Fall 2007 Release

MySQL is proud to announce the Fall 2007 Release of the MySQL Enterprise Monitor making it easier for DBAs to manage MySQL Replication in scale-out environments. The following is a partial list of new features in the Fall 2007 Release:

Replication Monitor
Replication Topology Auto Detection and Grouping
New Advisor Rules for Replication, Performance & Administration
New Graphs

Learn What's New » (http://www.mysql.com/products/enterprise/whats_new.html)

Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-fall-whatsnew.php)

Conference: MySQL European Customer Conferences 2007 (October)

London, Munich, Paris

An annual event, the MySQL European Customer Conferences offer you the opportunity to:

Learn about MySQL Enterprise and the unique monitoring capabilities
Learn best practices to get the most out of MySQL
Network with fellow European customers and discover how they are leveraging MySQL
Meet with MySQL European executives, engineers, consultants and MySQL partners

Learn More » (http://www.mysql.com/news-and-events/events/emea-conference-2007/)

London, October 16 »

Munich, October 18 »

Paris, October 23 »

MySQL Conference & Expo 2008 - Call for Participation is Open

The 2008 MySQL Conference & Expo brings over 1,600 open source and database enthusiasts together to harness the power of MySQL and celebrate the huge MySQL ecosystem. Take an active role in shaping the future of MySQL and related open source technologies by leading sessions and tutorials at the 2008 MySQL Conference & Expo.

Submit Your Proposal (Deadline October 30th) »

30 Day Trials for MySQL Enterprise with Monitoring Services

You can experience the power of the MySQL Enterprise Monitor at no charge for 30 days. This Service continuously monitors your MySQL servers and alerts you to potential problems before they impact your system. It is like having a "Virtual DBA Assistant" at your side to recommend best practices to eliminate security vulnerabilities, improve replication, optimize performance and more.

MySQL for OEMs, ISVs & VARs: Industry Spotlight

Hundreds of Original Equipment Manufacturers (OEMs), Independent Software Vendors (ISVs) and Value Added Resellers (VARs) across multiple industries rely on MySQL for their success. Here are examples of industries and customer case studies that have adopted MySQL.

Learn More » (http://www.mysql.com/why-mysql/oem-isv-corner/industry.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 have openings for the following positions:

Support Engineers
Senior Software Developer - Storage Engines
Senior Software Developer - Replication
Senior Software Developer - Online Backup
QA Engineers
Training Course Developer
And More ...

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

New Product Releases

New Release of MySQL Community Server 6.0.2 (Alpha - Falcon Preview)

Falcon is a Storage Engine for the MySQL database server. The Falcon Storage Engine has been designed with modern database requirements in mind, and particularly for use within high-volume web serving or other environment that requires high performance, while still supporting the transactional and logging functionality required in this environment. It's currently released within a special alpha build of MySQL and will be updated regularly during the alpha process. The following is a partial list of enhancements and changes:

64-bit Windows support
Support for tablespaces
New performance settings, falcon_log_windows, falcon_index_chill_threshold, and falcon_record_chill_threshold.
The Falcon record cache parameters have been altered. The falcon_max_record_memory and falcon_min_record_memory are no longer supported.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/ODBC 5.1.0 (Alpha)

MySQL Connector/ODBC 5.1.0-alpha, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the first of the new 5.1 series and is suitable for use with any MySQL server version since MySQL 4.1, including MySQL 5.0, 5.1, and 6.0. (It will not work with 4.0 or earlier releases.) The following is a partial list of changes:

Added support for SQL_C_WCHAR.
Added support for Unicode functions (SQLConnectW, etc).
Added descriptor support (SQLGetDescField, SQLGetDescRec, etc)

View complete list of changes »

Download Now »

Hints & Tips

White Paper: MySQL Cluster Evaluation Guide

Designing, Evaluating and Benchmarking MySQL Cluster

In this whitepaper learn the fundamentals of how to design and select the proper components for a successful MySQL Cluster evaluation. We explore hardware, networking and software requirements. Work through basic functional testing and evaluation best practices.

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

White Paper: High Performance Database Solutions for Multiplay Service Architectures

What are multiplay services and what do they mean from an architectural perspective? Service oriented architectures for multiplay entail challenging database requirements. How can they deliver the necessary performance while maintaining the flexibility to support new features? This article answers these questions and explains how intelligent database design and tuning can improve performance many times over, using the high performance MySQL Cluster relational database as an example.

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

Article: A Primer on Falcon Tablespaces

Each storage engine has its own set of characteristics, some of which are shared with other storage engines, but some of which are unique to a particular engine. The Falcon transactional storage engine uses the concept of user-defined tablespaces that are more in line with what one would find in Oracle (tablespaces) or SQL Server (filegroups). Let's take a quick look at how tablespaces are used within Falcon and what you can and can't do with them.

Read the Article »

Article: How MySQL Treats Security Vulnerabilities

The phrase "security vulnerability" gives most of us the creeps. We are afraid of them. Looking at them rationally, they share a trait with other bugs: All are a pain, but some are a bigger pain than others. And instead of trying to avoid the evil by not talking about it, let's take a look at MySQL's security vulnerability track record over the years, and explain the rationale behind our actions using actual cases from past years.

Read the Article »

Article: Using MySQL with PDO

PDO is a PHP extension providing a data-access abstraction layer that can be used with a variety of databases. This gives you the flexibility of changing the database backend without having to alter your access methods. Even if you use MySQL exclusively, PDO can provide advantages; you can use the same data-access methods regardless of the MySQL version.

Read the Article »

PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things MySQL, including technical tips and best practices.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: Tips for MySQL Newbies

Ben Krug

Are you a brand-newbie to MySQL? Coming from another database (or databases)? If so, here are some concepts to read up on right away to ease your confusion down the road. These are the top things I wish someone had told me about before I did anything else with MySQL.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: My Take on the Enterprise Monitor

Colin Charles

MySQL has had this Enterprise Monitor around for a while. It wasn't until this week that I actually tried it (besides, it wasn't until the UC-J that it was re-launched with new features), and found some time to play with it. And I was blown away.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Baby Steps into Stored Procedures

Tim Soderstrom

Recently I have been taking a serious look at stored procedures in MySQL and, in particular, how I might go about implementing them in my website and, in particular, where they could be used and why. At present, I have really only gotten my feet wet with using stored procedures, but I think that is enough to make some conclusions that I thought might be helpful to others that are starting to look at stored procedures as well.

Read the PlanetMySQL Blog Post »

Using GROUP BY WITH ROLLUP for Reporting Performance Optimization

Peter Zaitsev

A typical query for reporting applications is to find the top X values. If you analyze Web Site logs you would look at most popular web pages or search engine keywords which bring you most of the traffic. If you're looking at ecommerce reporting you may be interested in best selling product or top sales people. This information may often need simple select query, however what if you would like to show percents not just absolute value?

Read the PlanetMySQL Blog Post »

Events

What's New in the MySQL Enterprise Fall 2007 Release

Tuesday, October 16, 2007 (Americas)
Thursday, October 18, 2007 (EMEA)
Thursday, October 25, 2007 (Germany)

The MySQL Enterprise 2007 Fall Update is designed to ease common pain points for those using MySQL Replication to scale-out on MySQL. In this new web seminar you'll learn and see how the MySQL Enterprise Fall 2007 Release provides:

Auto detection and grouping of all of your MySQL Replication topologies
Real-time monitoring of all your Master-Slave servers for performance and latency issues
Replication Advisors that identify and advise you on correcting Master/Slave sync, latency and configuration issues before they become costly outages
Security Advisors that proactively scan your MySQL servers for any unplanned security related change, identify hard to find loopholes and advice you on optimal security settings per MySQL best practices
Performance Advisors that monitor your MySQL servers over time and pinpoint and identify variable settings (optimization of caching, hit ratios, etc) that you can tune to keep them running at peak performance at all times

Training, Consulting and Certification

Consulting: MySQL Performance Tuning & Optimization (3+ Days)

Now is the best time to schedule your Performance Tuning & Optimization engagement to ensure your applications will perform and scale for the holiday shopping season. MySQL also offers High Availability consulting engagements so you don't experience downtime during the busiest shopping days of the year.

Schedule your Schedule Your Engagement Now » (http://www.mysql.com/consulting/packaged/performance.html)

Training: MySQL 5.0 for Database Administrators (5 Days)

Madrid, Milan, San Diego, Phoenix, New York, Toronto and more.

Is your MySQL database secure?
Do your users have the correct privileges and access rights?
Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
Do you want to save time using features like Stored Procedures, Triggers and Views?
Do you want to utilize the new enterprise features of MySQL 5.0?

Partners

Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today.

If you market a MySQL-based software application or hardware solution to end users, you can increase your business by advertising your product(s) in our Solutions Catalog. Join hundreds of existing partners and let millions of MySQL users find your solution by becoming a partner. All it takes is a few minutes to understand the program, and your company and product information.

The MySQL Team