Database News: MySQL Newsletter: July 2010

MySQL Newsletter
July 2010
mysql-newsletter@sun.com

Articles in this newsletter:

Highlights

- Tutorial: Getting Started with MySQL Workbench
- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- White Paper: Guide to MySQL for Microsoft Windows
- Case Study: MySQL Cluster Scores at the 2010 FIFA World Cup
- Live Webinar: MySQL Essentials Series - Part 2: SQL Scripting Essentials (Thursday, July 22)

New Product Releases

- New Release of MySQL Workbench 5.2.25 (GA)
- New Release of MySQL Community Server 5.1.48 (GA)
- New Release of MySQL Connector/J 5.1.13 (GA)

Hints & Tips

- Documentation: InnoDB INFORMATION_SCHEMA Tables
- Case Study: MySQL Enterprise Powers 2 Million Referrals in Central Hospital Registry
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL Sunday tracks at Oracle OpenWorld 2010
- PlanetMySQL Blog: MySQL Workbench 5.2 goes GA - partial support for MySQL Cluster
- PlanetMySQL Blog: 5 Steps to Get Started with MySQL Cluster in less than 15 minutes
- PlanetMySQL Blog: mysqlnd plugins: alternative to MySQL Proxy?!
- PlanetMySQL Blog: PHP: Client side caching for all MySQL extensions
- PlanetMySQL Blog: Running MySQL Cluster as a service on Windows
- PlanetMySQL Blog: Ease of Switching to the InnoDB Plugin and the Numerous Benefits
- PlanetMySQL Blog: Oracle MySQL Storage Engine Advisory Board - It's Happening
- PlanetMySQL Blog: How read_buffer_size Impacts Write Buffering and Write Performance
- PlanetMySQL Blog: How many IOPs can InnoDB do?
- PlanetMySQL Blog: Lock wait timeout on slaves

Spotlight: MySQL Embedded Server in Network Management

- On Demand Webinar: Inserts at Drive Speed: Designing a Custom Storage Engine
- Case Study: NetQoS Delivers Distributed Network Management Solution with Embedded MySQL
- Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
- Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance

Events

- Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine (Wednesday, July 14)
- Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals (Thursday, July 15)
- Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA - EMEA
- Live Webinar: What's New in MySQL - Japanese (Thursday, July 22)
- On Demand Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL
- On Demand Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached

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

Highlights

Tutorial: Getting Started with MySQL Workbench

This tutorial provides a quick hands-on introduction to using MySQL Workbench for beginners. In order to complete this tutorial you will need to have a locally installed MySQL Server. This tutorial requires MySQL Workbench version 5.2.16 or above.

View the Tutorial:
http://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial.html

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

This paper looks at 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 MySQL Workbench 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

White Paper: Guide to MySQL for Microsoft Windows

As we will discover over the course of this paper, MySQL on Windows continues to be a popular choice for independent software vendors, original equipment manufacturers, hosting providers and organizations developing custom web, departmental and enterprise applications.

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

Case Study: MySQL Cluster Scores at the 2010 FIFA World Cup

The Pyro Group has selected the MySQL Cluster database to power their InRoam SDP (Service Delivery Platform). InRoam enables Cell C and their network partners to provide low cost, border-less mobile communications services to hundreds of thousands of football fans from around the world as they descend on South Africa for the 2010 FIFA World Cup tournament.

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

Live Webinar: MySQL Essentials Series - Part 2: SQL Scripting Essentials
Thursday, July 22, 2010 - 9am PT

Join us for Part 2 of the "MySQL Essentials" webinar series with Mike Frank from the MySQL Product Management group at Oracle. In this presentation, we'll demonstrate the fundamentals of SQL scripting with MySQL. We will cover SELECTs, JOINs, CREATE, DELETE, INSERTs and a host of other DML and DDL operations. Also covered will be essential management commands for administering and monitoring MySQL. We will be demonstrating how to accomplish these tasks both at the command line and in an automated fashion using MySQL's built-in scheduler, MySQL Workbench and MySQL Enterprise Monitor.

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

New Product Releases

New Release of MySQL Workbench 5.2.25 (GA)

We're pleased to announce the release of MySQL Workbench 5.2.25. This release is GA (Generally Available). We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications. MySQL Workbench 5.2 GA provides:

- Database Design & Modeling
- SQL Development (replacing MySQL Query Browser)
- Database Administration (replacing MySQL Administrator)

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

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

Read the Documentation:
http://dev.mysql.com/doc/workbench/en/index.html

New Release of MySQL Community Server 5.1.48 (GA)

MySQL Community Server 5.1.48, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.48 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-48.html

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

New Release of MySQL Connector/J 5.1.13 (GA)

MySQL Connector/J 5.1.13, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.13 is suitable for use with any MySQL version including MySQL-5.0, MySQL-5.1 or MySQL-5.5.

View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-13.html

Download Now:
http://dev.mysql.com/downloads/connector/j/5.1.html

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

Hints & Tips

Documentation: InnoDB INFORMATION_SCHEMA Tables

There are seven INFORMATION_SCHEMA tables that contain live information about compressed InnoDB tables, the compressed InnoDB buffer pool, all transactions currently executing inside InnoDB, the locks that transactions hold and those that are blocking transactions waiting for access to a resource.

Read the Documentation:
http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-information-schema-overview.html

Case Study: MySQL Enterprise Powers 2 Million Referrals in Central Hospital Registry

Sahlgrenska University Hospital (SU) is one of the major hospitals in Europe and was founded in 1997 when three hospitals in Sweden merged. Every year, Sahlgrenska University Hospital records two million referrals and comments through the Central Registry system which is powered by MySQL.

Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs-enterprise-sahlgrenska_hospital.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 Sunday tracks at Oracle OpenWorld 2010
Giuseppe Maxia

Oracle OpenWorld is the conference of everything related to Oracle. This year's edition, running from September 19th to 23rd, is expected to have more than 45,000 attendees, making it one of the biggest IT events worldwide.

Now that MySQL is part of the Oracle portfolio, it is going to be part of the Oracle OpenWorld show. In the spirit of the user groups events, there will be a MySQL Sunday event on Sunday afternoon, with four highly technical tracks, with well known speakers.

Read the PlanetMySQL BlogPost:
http://blogs.sun.com/MySQL/entry/mysql_sunday_tracks_at_oracle

PlanetMySQL Blog: MySQL Workbench 5.2 goes GA - partial support for MySQL Cluster
Andrew Morgan

The new version of MySQL Workbench (5.2.25) has just gone GA - see the Workbench Blog for details. So what's the relevance to MySQL Cluster? If you have a Cluster that uses MySQL Servers to provide SQL access then you can now use MySQL Workbench to manage those nodes.

Read the PlanetMySQL BlogPost:
http://www.clusterdb.com/mysql/mysql-workbench-5-2-goes-ga-partial-support-for-mysql-cluster/

PlanetMySQL Blog: 5 Steps to Get Started with MySQL Cluster in less than 15 minutes
Andrew Morgan

A series of quick-start guides are now available to get you up and running with MySQL Cluster in as little time as possible; they are available for LINUX/Mac OS X, Windows and Solaris. The configuration is intentionally a simple 1 - 2 data nodes, 1 management node and 1 MySQL Server. Once you have this up and running, your next experiment may be to extend this over multiple hosts.

Read the PlanetMySQL BlogPost:
http://www.clusterdb.com/mysql/download-install-configure-run-and-test-mysql-cluster-in-under-15-minutes/

PlanetMySQL Blog: mysqlnd plugins: alternative to MySQL Proxy?!
Ulf Wendel

The mysqlnd plugin API is a well hidden gem of mysqlnd. Mysqlnd plugins operate on a layer between PHP applications and the MySQL server. This is comparable to MySQL Proxy. MySQL Proxy operates on a layer between any MySQL client application, for example, a PHP application, and the MySQL server.

Read the PlanetMySQL BlogPost:
http://blog.ulf-wendel.de/?p=284

PlanetMySQL Blog: PHP: Client side caching for all MySQL extensions
Ulf Wendel

The first public mysqlnd plugin adds client side query result caching to all MySQL extensions of PHP. The cache is written in C. It does not change any of the PHP MySQL APIs and works with any PHP application using MySQL. Query results are stored on the client.

Read the PlanetMySQL BlogPost:
http://blog.ulf-wendel.de/?p=286

PlanetMySQL Blog: Running MySQL Cluster as a service on Windows
Anders Karlsson

The MySQL Cluster daemon for MySQL Cluster (ndbd and ndb_mgmd) doesn't by themselves yet let them run as a service. But there are ways to fix this, using some simple Windows tools and some registry hacking.

Read the PlanetMySQL BlogPost:
http://karlssonondatabases.blogspot.com/2010/06/running-mysql-cluster-as-service-on.html

PlanetMySQL Blog: Ease of Switching to the InnoDB Plugin and the Numerous Benefits
Chris Calender

There are many advantages to using the plugin as opposed to the built-in version (aside from just the new I_S tables, and more importantly, numerous performance enhancements), and it's breeze to set up, so I wanted to provide a quick start guide to using the new InnoDB plugin.

Read the PlanetMySQL BlogPost:
http://www.chriscalender.com/?p=99

PlanetMySQL Blog: Oracle MySQL Storage Engine Advisory Board - It's Happening
Bob Zurek

Over a month ago, Infobright was invited to join the Oracle MySQL Storage Engine Advisory Board and last week was the first in a series of meetings that Oracle will be hosting for the Advisor Board members. Oracle did a terrific job stepping up to the task of assembling a well known group of companies as part of the board. The meeting last week was clearly a sign of commitment by Oracle to work closely with the storage engine vendors in the market. This resonated very well with the advisory board members.

Read the PlanetMySQL BlogPost:
http://www.infobright.org/Blog/Entry/oracle_mysql_storage_engine_advisory_board_-_its_happening/

PlanetMySQL Blog: How read_buffer_size Impacts Write Buffering and Write Performance
Venu Anuganti

Even though the name read_buffer_size implies that the variable controls only read buffering, but it actually does dual purpose by providing sequential IO buffering for both reads and writes.

Read the PlanetMySQL BlogPost:
http://venublog.com/2010/06/23/how-read_buffer_size-impacts-write-buffering-and-write-performance/

PlanetMySQL Blog: How many IOPs can InnoDB do?
Mark Callaghan

I previously tested InnoDB on an 8-core server to determine how many IOPs it can do for a simple IO-bound workload. The limits were ~12k disk reads/second for MySQL 5.0 and ~18k reads/second for MySQL 5.1. I just repeated the tests using a 16-core server and the results are much better. I can get 20,000 to 30,000 disk reads/second using InnoDB 5.1.

Read the PlanetMySQL BlogPost:
http://www.facebook.com/note.php?note_id=403975340932

PlanetMySQL Blog: Lock wait timeout on slaves
Alex Lurthu

We had one of our slave servers frequently stops replicating with the "Innodb Lock Wait Timeout" error. The slave IO thread would continue to fetch the binlogs while the slave SQL thread kept stopping with the above mentioned error.

Read the PlanetMySQL BlogPost:
http://alexlurthu.wordpress.com/2010/06/07/lock-wait-timeout-on-slaves/

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

Spotlight: MySQL Embedded Server in Network Management

Many new technologies and applications are creating a significant increase in network traffic volume and complexity, making it more difficult to maintain a high performance network that doesn't disrupt application availability. MySQL enables ISVs and OEMs to overcome these limitations and build modern network management products by providing high performance, cost-effectiveness, ease of installation, zero administration, and much more.

On Demand Webinar: Inserts at Drive Speed: Designing a Custom Storage Engine

MySQL offers a variety of storage engines that can be matched to application requirements. Data can be integrated seamlessly between storage engines. When none of the existing engines look like a perfect match to your requirements, you can add your own. MySQL provides a SQL stack for your data. By leveraging the integration between storage engines, you are free to concentrate on just the design of key tables.

Case Study: NetQoS Delivers Distributed Network Management Solution with Embedded MySQL

NetQoS delivers products and services that enable some of the world's most demanding enterprises, including American Express, Boeing, and Chevron, to improve network performance. NetQoS ReporterAnalyzer relies on MySQL and tells IT organizations which applications and users are consuming bandwidth, and when, so they can optimize the wide area network and improve IT service delivery.

NetQoS found that MySQL provided the ideal combination of performance, reliability, and ease of administration for ReporterAnalyzer. In addition, MySQL's affordable licensing model enabled NetQoS to reduce its database costs by several thousand dollars per network appliance.

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

Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server

CONCEIVIUM Business Solutions ensures that BlackBerry Enterprise Servers are up and performing optimally 24X7 for three of the world's top five banks, The Coca Cola Company, IBM Global Services and many other primarily Fortune 500 organizations. With MySQL Embedded Server, CONCEIVIUM's Mobile Monitor/Analyzer Agents have achieved a 70% performance gain and are now able to analyze over two gigabytes of data per day and perform thousands of transactions per second.

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

Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance

To give the entire IT organization better visibility and control over the performance and availability of their networks, systems and applications, ScienceLogic relies on the performance and scalability of MySQL to process real-time information from thousands of networked devices.

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

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

Events

Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine
Wednesday, July 14, 2010 - 9am PT

The MEMORY storage engine has been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management. The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address these evolving web service demands.

Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals
Thursday, July 15, 2010 - 9am PT

In Part I of a three-part performance series, MySQL performance expert Brian Miezejewski will take you through the fundamentals of architecting your product's MySQL embedded or bundled database for higher performance and customer satisfaction.

In this session, Brian will go through the first steps to take when designing your database for high performances. He will also show you how to spot and quickly resolve the most common performance bottlenecks.

Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA - EMEA

Join this technical webinar 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.

Live Webinar: What's New in MySQL - Japanese
Thursday, July 22, 2010 - 2pm JST

As a result of the acquisition of Sun Microsystems and Oracle, MySQL is now part of Oracle's product portfolio. Oracle invests in MySQL, the world's most popular open source database, and further drives its innovation.

The latest release of MySQL Enterprise includes many new features and improvements, which are designed to save DBAs and Developers time and effort in keeping MySQL systems running at the highest levels of security, performance and availability. In this webinar, we will share the latest updates from MySQL, including exciting new product development.

On Demand Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL

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.

On Demand Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached

MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web. There are classes of web services, however, that are update-intensive, demanding real-time responsiveness and continuous availability. In these cases, MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency and 99.999% availability.

Read the White Paper "Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached":
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_ScalingWebServices.php

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

Friday, July 9, 2010

MySQL Newsletter: July 2010

No comments:

Post a Comment

Followers

Blog Archive

About Me