MySQL Newsletter May 2010
Articles in this newsletter:
- 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 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)
- 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
- 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
Edward Screven, Oracle's Chief Corporate Architect, discussed the current and future state of MySQL in his keynote at the MySQL Conference & Expo.
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!
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://www.mysql.com/why-mysql/white-papers/mysql_wp_web20.php)
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://www.mysql.com/why-mysql/white-papers/mysql_wp_51_OEM.php)
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.
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.
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://www.mysql.com/why-mysql/case-studies/mysql_cs_contactlab.php)
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.
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.
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.
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.
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.
We're announcing the first Release Candidate of MySQL Workbench. MySQL Workbench 5.2 RC provides:
- Data Modeling
- Query (upgrade from MySQL Query Browser)
- 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.
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!
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Huge performance improvement has come with MySQL 5.5.4, and looking at the following picture it's very easy to see why.
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.
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.
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.
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
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.
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.
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.
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.
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.
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.