Database News: MySQL Newsletter: May 2010

MySQL Newsletter
May 2010
mysql-newsletter@sun.com

Articles in this newsletter:

Highlights

- Oracle Outlines Strategy for MySQL
- MySQL track at Oracle Development Tools User Group Conference
- White Paper: How MySQL Powers Web 2.0
- White Paper: MySQL 5.1 for ISV/OEM Solutions
- Evaluation Guide: Evaluating MySQL Cluster 7.1
- Case Study: UCR Selects MySQL Enterprise to Power the Medical Registries of 1.5 Million Patients
- Case Study: ContactLab Supports its High-Performance e-marketing tools with MySQL Enterprise
- Live Webinar: Building an Architecture for Scalability: myLifetime.com on MySQL (Tuesday, May 18)
- Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA (Thursday, May 20)
- Live Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL (Thursday, May 27)
- Upcoming MySQL University Sessions

New Product Releases

- New Release of MySQL Community Server 5.1.46 (GA)
- New Release of MySQL Workbench 5.2.21 (RC)
- New Release of MySQL Connector/Net 6.1.4 (GA)

Hints & Tips

- White Paper: Designing and Implementing Scalable Applications with Memcached and MySQL
- White Paper: A Guide for ISVs and OEMs: Migrating From Microsoft Access To MySQL Embedded Server
- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- Tutorial: Developing Database Applications Using MySQL Connector/C++
- Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the MySQL Query Analyzer
- Case Study: Aito Technologies Selects MySQL to Manage Mobile Traffic Data and Customer Information
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL 5.5.4 is Very Exciting
- PlanetMySQL Blog: Two quick performance tips with MySQL 5.1 partitions
- PlanetMySQL Blog: MySQL: The maximum value of an integer
- PlanetMySQL Blog: MySQL Cluster - SPJ Preview - Feedback welcome
- PlanetMySQL Blog: Trying out MySQL Push-Down-Join (SPJ) preview
- PlanetMySQL Blog: Simulating server-side cursors with MySQL Connector/Python
- PlanetMySQL Blog: The MySQL Community meets the Independent Oracle Users Group
- PlanetMySQL Blog: Reducing locks by narrowing primary key
- PlanetMySQL Blog: MySQL Performance: Improving Stability
- PlanetMySQL Blog: MySQL Random Data Selection
- PlanetMySQL Blog: A backup today saves you tomorrow
- PlanetMySQL Blog: Choosing the right data type makes a big difference

Events

- Live Webinar: Better Java Application Scalability and Reliability Using MySQL Connector/J Features (Tuesday, May 25)
- Live Webinar: Getting started with MySQL Replication - Italian (Tuesday, May 25)
- Live Webinar: MySQL Performance Tuning Best Practices - French (Wednesday, May 26)
- Live Webinar: MySQL Replication - Part 2 - German (Thursday, May 27)
- On-Demand Webinar: Introducing MySQL Cluster 7.1
- On-Demand Webinar: Using the latest Java Persistence API 2.0 features with MySQL

-------------------------------------------------------------------

Highlights

Oracle Outlines Strategy for MySQL

Edward Screven, Oracle's Chief Corporate Architect, discussed the current and future state of MySQL in his keynote at the MySQL Conference & Expo.

Watch the Video:
http://www.youtube.com/watch?v=C0OkjtlbqVs&feature=PlayList&p=57E661D0569B26EE&playnext_from=PL&index=0

MySQL track at Oracle Development Tools User Group Conference

The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. By popular demand, there will be a MySQL track organized by the MySQL community. The event includes free sessions. Join us and meet with the MySQL experts!

Learn more:
http://blogs.sun.com/MySQL/entry/mysql_track_with_free_event

White Paper: How MySQL Powers Web 2.0

MySQL enables up-and-coming Web 2.0 sites like Wikipedia, Facebook and Twitter, as well as established web properties like Craigslist, Google and Yahoo!, to scale out and meet the ever-increasing volume of users, transactions and data.

You will gain an understanding of how MySQL can be used in conjunction with other open source components to deliver low-cost, reliable, scalable, high performance Web 2.0 applications.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_web20.php

White Paper: MySQL 5.1 for ISV/OEM Solutions

The MySQL 5.1 server continues to move MySQL ahead in its mission to make sophisticated database management available and affordable to all. With the release of MySQL 5.1, the MySQL database server provides more enterprise-caliber enhancements that greatly assist those wanting to use MySQL for:

- Managing larger volumes of data
- Applications that have high-availability requirements
- Systems needing a powerful but autonomous-running database

that requires little attention and continually services anywhere from one to thousands of user requests per second.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_51_OEM.php

Evaluation Guide: Evaluating MySQL Cluster 7.1

In this white paper 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, and work through basic functional testing and evaluation best practices.

Read the Evaluation Guide:
http://dev.mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php

Case Study: UCR Selects MySQL Enterprise to Power the Medical Registries of 1.5 Million Patients

Uppsala Clinical Research Center, UCR, is a national center of competence for healthcare quality registries in Sweden, and is an independent unit under Uppsala University Hospital and the Disciplinary Domain of Medicine and Pharmacy at the University of Uppsala. UCR's National Quality Registries include treatment and outcome data based on all hospital patients in Sweden, and is used by thousands of doctors, nurses, medical secretaries and representatives within county councils.

Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_ucr.php

Case Study: ContactLab Supports its High-Performance e-marketing tools with MySQL Enterprise

ContactLab is a leading Italian provider of digital direct marketing services, with offices in Milan, Madrid, Paris, London and Munich. ContactLab chose to subscribe to MySQL Enterprise to help support the security, availability and scalability of its market-leading platform. Today ContactLab manages more than 3 Terabytes of data with MySQL for sending, tracking and analyzing hundreds of millions of messages every month.

Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_contactlab.php

Live Webinar: Building an Architecture for Scalability: myLifetime.com on MySQL
Tuesday, May 18, 2010 - 9:00am PT

Among the top 500 most visited sites on the Internet, myLifetime.com, which is built on Drupal, receives 6.5 million visitors (3.6 million unique) and 50 million page views per month. Because of online campaigns, and the popularity of associated television shows, the Lifetime family of sites must be prepared to accommodate significant volume spikes.

Nathan Potter, VP of Digital Media Technology at myLifetime.com, cites show-related volume spikes of 150,000 page views per hour as within the normal range of traffic. In this webinar, Nathan will cover the architecture they've developed for scalability as well as the techniques they've used for optimizing their site, including MySQL, for scalability and performance.

Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA
Thursday, May 20, 2010 - 9:00am PT

Join Jimmy Guerrero and Mike Frank of Oracle for an overview of MySQL's internal architecture including storage engines, security and datatypes. Also covered will be replication, migration strategies, tools and product comparisons to SQL Server, SQL Server Express and Access. If you are a SQL Server DBA interested in learning how to leverage your current knowledge against MySQL, this webinar is for you.

Live Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL
Thursday, May 27, 2010 - 9:00am PT

Join us for Part 1 of the "MySQL Essentials" webinar series with Jimmy Guerrero and Mike Frank from the MySQL Product Management group at Oracle. In this presentation we'll demonstrate how to setup an environment for building MySQL from source on Windows and Linux, leveraging free or open source tools in the build environment. We'll also examine the various MySQL downloads, packages, distributions and installers available to get up and running in 15 minutes or less. Finally, we'll cover the initial configuration of MySQL including memory allocation, connection limits, security and other options.

Upcoming MySQL University Sessions

MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Oracle employees. Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.

View Upcoming and Previous Sessions:
http://forge.mysql.com/wiki/MySQL_University

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.1.46 (GA)

MySQL Community Server 5.1.46, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.46 is recommended for use on production systems.

View the complete list of changes:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-46.html

Download now:
http://dev.mysql.com/downloads/mysql/5.1.html#downloads

New Release of MySQL Workbench 5.2.21 (RC)

We're announcing the first Release Candidate of MySQL Workbench. MySQL Workbench 5.2 RC provides:

1. Data Modeling
2. Query (upgrade from MySQL Query Browser)
3. Admin (upgrade from MySQL Administrator)

If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench.

View the complete list of changes:
http://dev.mysql.com/doc/workbench/en/wb-news-5-2-21.html

Download now:
http://dev.mysql.com/downloads/workbench/5.2.html

New Release of MySQL Connector/Net 6.1.4 (GA)

MySQL Connector/Net 6.1.4, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against MySQL servers ranging from version 4.1 to 5.5!

View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.5/en/connector-net-news-6-1-4.html

Download Now:
http://dev.mysql.com/downloads/connector/net/6.1.html#downloads

-------------------------------------------------------------------

Hints & Tips

White Paper: Designing and Implementing Scalable Applications with Memcached and MySQL

Memached is an open-source, distributed memory caching system designed to tackle today's web-scale performance and scalability challenges. Many of the largest and most heavily trafficked web properties on the Internet like Facebook, Fotolog, YouTube, Mixi.jp, Yahoo, and Wikipedia deploy Memcached and MySQL to satisfy the demands of millions of users and billions of page views every month. By integrating a caching tier into their web-scale architectures, these organizations have improved their application performance while minimizing database load.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_memcached.php

White Paper: A Guide for ISVs and OEMs: Migrating From Microsoft Access To MySQL Embedded Server

Many ISVs and OEMs have seen that MySQL Embedded Server's superior scalability -- in both concurrent userload and overall data volume, cost-savings, platform freedom, and feature set combine to provide a compelling business case to move some or all of their Access applications to MySQL Embedded Server. This paper provides insight into what is needed when considering a move from Microsoft Access to MySQL Embedded Server and presents a number of options that ease the transition.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_msaccess_to_oem.php

White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how the MySQL Workbench product from MySQL can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php

Tutorial: Developing Database Applications Using MySQL Connector/C++

This tutorial will show you the essential steps to build and install the new, elegant MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Application developers who are new to MySQL Connector/C++ but not to C++ programming and the MySQL database, are the target audience of this tutorial. Because the focus is on database connectivity from a C++ application, this document assumes that some kind of MySQL database is already up and accessible from the client machine.

Read this Tutorial:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_dbapps_connector-c.php

Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the MySQL Query Analyzer

Launched in 1998, Promovacances is a brand of the Karavel group, the leading provider of vacation packages online in France. Promovacances.com gets about 40 million individual visitors per year and 250,000 per day during the high season.

The MySQL Enterprise Platinum subscription gives Karavel access to 24/7 technical support as well as to the MySQL Enterprise Monitor including the new MySQL Query Analyzer.

Read the Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_karavel_travelling.php

Case Study: Aito Technologies Selects MySQL to Manage Mobile Traffic Data and Customer Information

Aito Technologies has chosen to employ the MySQL Embedded Database Server in order to successfully analyze up to billions of daily phone calls, text messages and mobile data sessions.

With reference clients such as Nokia, TDC, Blyk, Elisa and Muxlim, Aito's daily traffic load entails several terabytes of data. Consequently, the vendor's application has strict requirements for high database performance and scalability on a multiprocessor architecture.

Read the Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_Aito.php

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 about MySQL, including technical tips and best practices.

Visit PlanetMySQL:
http://planet.mysql.com/

Submit Your Blog Feed:
http://planet.mysql.com/new

PlanetMySQL Blog: MySQL 5.5.4 is Very Exciting
Jeremy Zawodny

Yesterday at the MySQL Conference, I spent time in a few sessions discussing the performance enhancements in the MySQL 5.5.3 and 5.5.4 milestone releases. What I saw made me very, very happy. In fact, the timing couldn't be better.

Read the PlanetMySQL BlogPost:
http://blog.zawodny.com/2010/04/14/mysql-5-5-4-is-very-exicting/

PlanetMySQL Blog: Two quick performance tips with MySQL 5.1 partitions
Giuseppe Maxia

While I was researching for my partitions tutorial, I came across two hidden problems, which may happen often, but are somehow difficult to detect and even more difficult to fix, unless you know what's going on, and why. I presented both cases during my tutorial, but there were no pictures to convey the mechanics of the problem. Here is the full story.

Read the PlanetMySQL BlogPost:
http://datacharmer.blogspot.com/2010/05/two-quick-performance-tips-with-mysql.html

PlanetMySQL Blog: MySQL: The maximum value of an integer
Roland Bouman

Did you ever have the need to find the maximum value of an integer in MySQL? Yeah, me neither. Anyway, some people seem to need this, and this is what I came up with.

Read the PlanetMySQL BlogPost:
http://rpbouman.blogspot.com/2010/05/mysql-maximum-value-of-integer.html

PlanetMySQL Blog: MySQL Cluster - SPJ Preview - Feedback welcome
Johan Andersson

SPJ (preview, not production ready) is a new feature allowing some types of JOINs to be pushed down and executed inside the data nodes! This allows for, in many cases, much faster JOIN execution.

Read the PlanetMySQL BlogPost:
http://johanandersson.blogspot.com/2010/04/mysql-cluster-spj-preview-feedback_27.html

PlanetMySQL Blog: Trying out MySQL Cluster Push-Down-Join (SPJ) preview
Andrew Morgan

At the 2010 MySQL User Conference, Jonas Oreland presented on the work he's been doing on improving the performance of joins when using MySQL Cluster - the slides are available for download. While not ready for production systems, a preview version is available for you to try out. The purpose of this blog is to step through testing an example query as well as presenting the results.

Read the PlanetMySQL BlogPost:
http://www.clusterdb.com/mysql-cluster/trying-out-mysql-push-down-join-spj-preview/

PlanetMySQL Blog: Simulating server-side cursors with MySQL Connector/Python
Geert JM Vanderkelen

Last week, my colleague Massimo and I discussed how to handle big result sets coming from MySQL in Python. The problem is that MySQL doesn't support server-side cursors, so you need to select everything and then read it. You can do it either buffered or not. MySQL Connector/Python defaults to non-buffered, meaning that you need to fetch all rows after issuing a SELECT statement. You can also turn on the buffering, mimicking what MySQL for Python (MySQLdb) does.

Read the PlanetMySQL BlogPost:
http://geert.vanderkelen.org/2010/04/simulating-server-side-cursors-with.html

PlanetMySQL Blog: The MySQL Community meets the Independent Oracle Users Group
Giuseppe Maxia

Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting, for me, a new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured along the immense corridors of the Mandalay Bay convention center.

Read the PlanetMySQL BlogPost:
http://blogs.sun.com/datacharmer/entry/mysql_community_meets_the_independent

PlanetMySQL Blog: Reducing locks by narrowing primary key
Shlomi Noach

In a period of two weeks, I had two cases with the exact same symptoms. Database users were experiencing low responsiveness. DBAs were seeing locks occurring on seemingly normal tables. In particular, looking at Innotop, it seemed that INSERTs were causing the locks.

Read the PlanetMySQL BlogPost:
http://code.openark.org/blog/mysql/reducing-locks-by-narrowing-primary-key

PlanetMySQL Blog: MySQL Performance: Improving Stability
Dimitri Kravtchuk

Huge performance improvement has come with MySQL 5.5.4, and looking at the following picture it's very easy to see why.

Read the PlanetMySQL BlogPost:
http://dimitrik.free.fr/blog/archives/2010/05/mysql-performance-improving-stability.html

PlanetMySQL Blog: MySQL Random Data Selection
Mahmud Ahsan

Some days ago I was working in a vocabulary game and dictionary. The dictionary contains 1,10,000 words and meanings. I developed a vocabulary game where I had to randomly choose 10 words out of 1,10,000 dataset. Here I'm describing the possible solutions for this problem and which solution I used.

Read the PlanetMySQL BlogPost:
http://thinkdiff.net/mysql/mysql-random-data-selection/

PlanetMySQL Blog: A backup today saves you tomorrow
Ben Mildren

Whether you're working with MySQL, MySQL Cluster, or any other RDBMS, every database with a requirement for persistent data should always have a backup. As a Production DBA you're the insurance policy to safeguard the data. Bad things do happen. Backups are your safety net to ensure you always have a way to recover should the worst happen and the database becomes irreparable.

Read the PlanetMySQL BlogPost:
http://www.productiondba.com/2010/04/a-backup-today-saves-you-tomorrow/

PlanetMySQL Blog: Choosing the right data type makes a big difference
Venu Anuganti

Today evening one of my friend asked me in the IM to look into one of his production server where a query was taking about 11 seconds to run on 20 million row table, even though the query is using the right index and the plan as shown below.

Read the PlanetMySQL BlogPost:
http://venublog.com/2010/04/19/choosing-the-right-data-type-makes-a-big-difference/

-------------------------------------------------------------------

Events

Live Webinar: Better Java Application Scalability and Reliability Using MySQL Connector/J Features
Tuesday, May 25, 2010 - 9:00am PT

Join MySQL and Java experts, Mark Matthews and Todd Farmer, for an encore performance of their MySQL 2010 User Conference Session. In this technical presentation they will explain how to use the scalability and reliability features that are built into MySQL Connector/J to do

- Fault tolerant load balancing
- Replication-aware load balancing with slave fail-over
- Custom exception handling
- Sharding through some creative use of statement interceptors mixed with the built-in load balancer

Live Webinar: Getting started with MySQL Replication - Italian
Tuesday, May 25, 2010 - 10:00 CET/8:00 UTC

MySQL Replication is widely used to deploy scalable and highly available database architecture. In this presentation we will demonstrate how to get started with configuring MySQL Replication. We will also cover how replication works, supported replication topologies and how to perform management and administration tasks.

Live Webinar: MySQL Performance Tuning Best Practices - French
Wednesday, May 26, 2010 - 10:00 CET/8:00 UTC

You will get expert insight and learn best practices from the experts at MySQL to help you improve performance! We will discuss the main performance optimization opportunities, including schema optimization, server options tuning, storage engine selection, and more.

Live Webinar: MySQL Replication - Part 2 - German
Thursday, May 27, 2010 - 15:00 CET/13:00 UTC

In this presentation we will look at more advanced MySQL Replication techniques. We will cover master-master configurations, semi-synchronous replication, fail-over and resynchronization.

On-Demand Webinar: Introducing MySQL Cluster 7.1

In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO; MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.

Watch the On-Demand Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-527.html

On-Demand Webinar: Using the latest Java Persistence API 2.0 features with MySQL

The Java Persistence API is the Java API for the management of persistence for Java EE and Java SE applications. It provides an object/relational mapping facility for the Java application developer using a Java domain model to manage a relational database. The release 2.0 has been expanded to include several key new features.

This session will provide an introduction to the Java Persistence API and then a presentation of some of the new features available in Java Persistence 2.0. The talk will provide an overview of the object-relational mapping and modeling additions, the query language facilities, the new criteria API, pessimistic locking, and support for validation.

Watch this On-Demand Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-504.html

More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars:
http://dev.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter:
http://twitter.com/mysql

Follow MySQL Community on Twitter:
http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
http://dev.mysql.com/contact/

You can unsubscribe from this newsletter online:
http://dev.mysql.com/unsub?email=johandontmessup@gmail.com

Read more about the newsletter and view previous issues.
http://dev.mysql.com/news-and-events/newsletter/

--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Database News

Wednesday, May 12, 2010

MySQL Newsletter: May 2010

No comments:

Post a Comment

Followers

Blog Archive

About Me