MySQL Newsletter February 2007

Articles in this newsletter:

Training, Consulting & Certification

Partner Corner

Showcase Your Solution at the 2007 MySQL Conference and Expo

Highlights

MySQL Conference & Expo: Register Now, Save $200

The MySQL Users Conference and Expo 2007, April 23-26, in Santa Clara, California will be the largest gathering with over 1500 MySQL developers, DBAs and users. New sessions are being added weekly. Session highlights include:

MySQL Performance Cookbook
Peter Zaitsev, Co-Founder, Percona Ltd
Managing MySQL the Slack Way: How Google Deploys New MySQL Servers
Michael Still, Corporate Reliability Engineer, Google Inc
Grant Allen, Google, Inc.
Federation at flickr: Doing Billions of Queries Per Day
Dathan Pattishall, Senior Support Engineer, flickr.com
The 7 Stages of Scaling Web Applications: Strategies for Architects
John Engates, CTO, Rackspace Managed Hosting

MySQL Cluster Carrier Grade Edition for Telecom

MySQL Cluster Carrier Grade Edition is a cost-effective, open source database solution that is ideally suited for the telecom industry's top carriers, operators and equipment manufacturers building Subscriber Databases and Service Delivery Platforms (SDPs). For example, it provides the extreme scalability and performance to centrally store dynamic session data, subscriber data, call detail records, configuration data and more in real-time.

Learn More » (http://www.mysql.com/telecom)

Case Study: Alcatel-Lucent Uses MySQL Cluster Carrier Grade Edition to Handle over 60 million Subscribers

Alcatel's legacy HLR system was been based on proprietary database technology. However given the enormous growth in the number of subscribers it became apparent to Alcatel that they needed a new solution. After an extensive evaluation period and numerous performance benchmark tests, Alcatel selected MySQL Cluster Carrier Grade Edition as their database of choice for their next generation HLR solution.

Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_alcatel_lucent.pdf)

White Paper: New Enhancements to the MySQL Monitoring & Advisory Services

MySQL AB is proud to announce the newest update to the MySQL Network Monitoring and Advisory Service. This latest release extends the advanced monitoring and expert advisory services to include even more enterprise ready features and functionality, including:

New Notification Option - SNMP traps allow you to send notifications using your existing infrastructure such as HP OpenView, Tivoli, and others.
New Advanced Graphing - A new Graphs tab allows you to view more MySQL and operating system specific metrics.
New Advisor Rules - 20 new Advisor Rules enable you to monitor and leverage expert advice on 600 + MySQL and operating system specific variables.

Any many more including easier installation & configuration, FreeBSD & SuSE 10 support, and custom Advisor categories.

Read the What's New White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_enterprise_whatsnew_spring2007.php)

MySQL Enterprise Unlimited

MySQL Enterprise Unlimited is a unique offering that enables you to accelerate your open source initiative and gain control of your software budget by significantly reducing the cost of deploying and managing database software. For the price of a single CPU of Oracle Enterprise Edition ($40,000 per CPU), you can deploy an unlimited number of MySQL Enterprise Servers, with full 24x7 production support.

Learn More » (http://www.mysql.com/products/enterprise/unlimited.html)

Article: Understanding the Falcon Transaction Storage Engine - Part 1

MySQL has also just introduced a new transactional storage engine - code named Falcon - that is currently available in an alpha release. Falcon is a next-generation transactional management engine designed to run on all popular hardware/architecture platforms, but it is especially designed to take advantage of the large memory caches available in 64-bit environments.

Read the Article »

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:

Senior Software Developers
QA Engineer
Senior Sales Executive - Telecom Sales
Product Marketing Manager - OEM and Telecom
Support Consultants - Professional Services
Senior Instructor
IT Support Services
Accountant - Revenue

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

New Product Releases

New Release of MySQL Enterprise Server 5.0.30 sp1 (GA)

This is a Service Pack release of the MySQL Enterprise Server 5.0. The following is a partial list of bugs fixed:

Bug Fix: In MySQL 5.0.13 and up, InnoDB rolls back only the last statement on a transaction timeout. A new option, --innodb_rollback_on_timeout, causes InnoDB to abort and roll back the entire transaction if a transaction timeout occurs (the same behavior as before MySQL 5.0.13). (Bug#24200)
Bug Fix: CONCURRENT did not work correctly for LOAD DATA INFILE.
Bug Fix: Calculation of COUNT(DISTINCT), AVG(DISTINCT), or SUM(DISTINCT) when they are referenced more than once in a single query with GROUP BY could cause a server crash.

View the complete list of changes »

Download Now (login required) »

New Release of MySQL 5.1.15 (Beta)

This is a new Beta development release, fixing recently discovered bugs. The following is a partial list of changes: When using MERGE tables the definition of the MERGE table and the MyISAM tables are checked each time the tables are opened for access (including any SELECT or INSERT statement. Each table is compared for column order, types, sizes and associated. If there is a difference in any one of the tables then the statement will fail.

Remote servers for use with the FEDERATED storage engine now can be managed with the new CREATE/ALTER/DROP SERVER syntax. The --skip-thread-priority option now is enabled by default for binary Mac OS X distributions. Use of thread priorities degrades performance on Mac OS X.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/ODBC 5.00.11 (Beta)

MySQL Connector/ODBC is our next generation ODBC driver which allows access to the MySQL 5.x server using the widely used ODBC standard. The ODBC standard is a cross-platform, cross-database, C language, Call Level Interface. The following is a partial list of changes:

Changed internals to support SQLParamData/SQLPutData and chunking of inputs.
Fixed connection string parsing for DSN-less connections.
Fixed certain cases of handling SQL_NUMERIC_C

View the complete list of changes »

Download Now »

New Release MySQL Native Driver for PHP: mysqlnd-5.0.0 (Alpha)

The MySQL native driver for PHP is an additional, alternative way to connect from PHP 6 to the MySQL Server 4.1 or newer. The MySQL native driver for PHP requires PHP 6 and can connect to MySQL Servers 4.1 or newer.

View the complete list of changes »

Download Now »

Hints & Tips

Documentation: New MySQL Replication Chapter

We have completely reworked the replication chapter for the 5.1 manual. This targets a number of issues, including a major redesign (to make it easier to read and find topics), some updates to the information and processes, and incorporation of numerous bug fixes.

Read the Updated Documentation »

MySQL Podcasts for the Community, by the Community

Sheeri Kritzer

Hosted by Sheeri Kritzer of the Boston MySQL User Group, the weekly 10-20 minute podcast features interviews, performance tips, news and learning resources. Podcast topics include:

MySQL Security
Performance Tips
Backups
MySQL Cluster

View all the podcasts »

PlanetMySQL Blog: MySQL: Transactions and Autocommit

Roland Bouman

Some people believe that the ability to commit or rollback multiple statements as a single unit is a defining characteristic of the concept of transactions. They draw the -false- conclusion that enabling autocommit is the same as disabling transactions. It is easy to demonstrate why this is not true.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: MySQL: MySQL Spanning Different Timezones

Paolo Magnoli

So, what if you are planning a centralized MySQL server and many clients all around the world? First of all, check the manual. Then install timezone description tables. Then run a small example to see how the server and client timezones can interact. Here is the standard server setup.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: Getting Use of Slave in MySQL Replication

Peter Zaitsev

MySQL Replication is asynchronous which causes problems if you would like to use a MySQL Slave, since it can contain old data. I'll list some techniques here which I found to be helpful for offloading workloads to the slave. The same approach can be used in Master-Master replication in Active-Passive mode, just think about passive node as a slave.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: Subqueries

Sergey Petrunia

MySQL evaluates queries "from outside to inside", i.e. we first get the values of (oe1, .. oeN) and then we run the subquery and capture the rows it produces. An apparent and very useful optimization is to "inform" the subquery that we're looking only for rows that have "ie1=oe1", "ie2=oe2" and so on. This is done by injecting appropriate equalities into subquery's WHERE (or HAVING) clause.

Read the PlanetMySQL Blog post »

Events

Live Web Seminar: An Introduction to MySQL Cluster Carrier Grade Edition for Telecom's Next-Generation of Subscriber-Centric Networks

February 27, 2007, 9:00am PST

MySQL Cluster Carrier Grade Edition is a version of the MySQL Cluster product. It is specifically designed to better serve the business and technical challenges currently facing Telecom Equipment Manufacturers (TEM) and Network Service Providers (NSP) developing subscriber databases for the next-generation of services and applications on converged networks.

Join us for this webinar where you can learn about how MySQL Cluster Carrier Grade Edition is powering telecom's next-generation of converged subscriber-centric networks.

Live Web Seminar: MySQL Enterprise for DBAs

March 1, 2007, 9:00am PST

This web presentation will focus on how DBAs can utilize all the features and functionality of MySQL Enterprise to ensure their database servers provide the highest possible amounts of uptime, the tightest possible security, and the fastest possible performance. Tactics and strategies will be presented that focus on how DBAs can effectively manage anywhere from one to hundreds of servers with MySQL's new monitoring and advisory service.

Turning Today's Web 2.0 into Tomorrow's Enterprise

March 7, 2007, 10:00am PST

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 are deploying Web 2.0 architectures and applications using MySQL and MySQL Cluster.

Live Web Seminar (German): Cost-effective Scale-out with MySQL

March, 14, 2007, 14:00 Central European Time Zone

Scaling out (or Horizontal Scaling) means distributing the computing and data workload among multiple commodity servers by load balancing, with the ability to add servers to increase capacity. By distributing the workload, processing resources are spread among multiple low-cost servers, which improves both performance and the availability of the overall service at a dramatically lower cost.

Training, Consulting and Certification

Online Training: Database Design with Joe Celko (4 Hours)

Multiple Dates in March & April

Do you want to learn how to design databases with solid foundations built on good SQL practices?
Do you want to avoid creating databases with poor structure leading to difficulties in scaling and maintenance?

The online instructor-led course is designed for developers who wish to use sound database design principles while creating MySQL databases.

Training: MySQL 5.0 for Database Administrators (5 Days)

London, Zurich, Paris, Dallas, Vancouver, 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

Showcase Your Solution at the 2007 MySQL Conference and Expo

April, 23-26, 2007

The MySQL Conference & Expo is one of the most targeted events in the industry to expose your products and services to the growing open source marketplace. You can enjoy meeting with the hundreds of attendees, speakers, press, and MySQL staff - all with the common goal of promoting the open source community and MySQL database applications.

Download the Brochure (PDF) » (http://solutions.mysql.com/MySQLExpo2007_prospectus.pdf)

The MySQL Team