Database News: MySQL Newsletter: November 2010

MySQL Newsletter
November 2010
mysql-newsletter@sun.com

Articles in this newsletter:

Highlights

- Announcing the MySQL Italian Quarterly Newsletter
- White Paper: Top 10 Reasons to Choose MySQL for Online Retail
- Case Study: Adresseavisen, Leading News Site in Norway, relies on MySQL
- Case Study: Telemaque Deploys MySQL Cluster to Power Converged Call Center Services
- Live Webinar: In Pursuit of the Holy Grail - MySQL Cluster and Push Down JOINs (November 4)
- Live Webinar: MySQL and Oracle Database 11g: World Class Web Scalability and Infrastructure (November 18)
- Live Webinar: InnoDB Enhancements and Roadmap (December 14)
- Live Webinar: Accelerating Telecoms Transformation with Web 2.0 Data Management (December 15)
- Live Webinar: MySQL Essentials Part 6 - Develop Simple Java Applications with MySQL (December 16)

New Product Releases

- New Release of MySQL Cluster 7.1.8 Binary (GA)
- New Release of MySQL Workbench 5.2.29 (GA)
- New Release of MySQL Connector/NET 6.3.5 (GA)

Hints & Tips

- White Paper: MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5
- Article: A Look Inside MySQL Enterprise Monitor
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server
- PlanetMySQL Blog: How to find an errant MySQL client
- PlanetMySQL Blog: Setting up OpenLDAP for MySQL Enterprise Monitor
- PlanetMySQL Blog: InnoDB tablespace fragmentation (find it and fix it!)
- PlanetMySQL Blog: Fetching rows as dictionaries with MySQL Connector/Python
- PlanetMySQL Blog: Optimizing MySQL Cluster Performance: SELECT Operations
- PlanetMySQL Blog: Get MySQL Replication Up and Running in 5 minutes
- PlanetMySQL Blog: A Look at MySQL 5.5 Semi-Synchronous Replication

Spotlight: MySQL Webinar Series - Getting the Best MySQL Performance in Your Products

- On-Demand Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals
- On-Demand Webinar: Getting the Best MySQL Performance in Your Products: Part 2, Beyond the Basics
- Live Webinar: Getting the Best MySQL Performance in Your Products: Part 3, Query Tuning (November 23)

Events

- Live Webinar: Delivering Scalability and High Availability with MySQL 5.5 Replication Enhancements - EMEA (November 18 & 23)
- Live Webinar: MySQL Fine-Tuning Best Practices - Spanish (November 23)
- Live Webinar: MySQL Clustering and High Availability - Portuguese (November 23)
- Live Webinar: Designing MySQL Databases - Italian (November 25)
- Live Webinar: MySQL and Windows: Getting Started with MySQL on Windows - Chinese (November 25)
- Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine - German (December 7)

Partners

- Live Webinar: MySQL Backup Essentials (November 23)
- Live Webinar: MySQL Backup to Cloud (November 30)

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

Highlights

Announcing the MySQL Italian Quarterly Newsletter

Starting November 2010, a quarterly MySQL Italian Newsletter will be available with information relevant to the Italian MySQL users, including new Italian whitepapers, upcoming Italian webinars, MySQL events taking place in Italy, and more.

You can subscribe to the quarterly MySQL Italian Newsletter by editing newsletter subscriptions in your MySQL account profile.

Edit your MySQL Account (Log-in Required):
http://dev.mysql.com/profile/

White Paper: Top 10 Reasons to Choose MySQL for Online Retail

New technologies have offered people greater choice in the way they shop. Winning retailers adopt Web 2.0 technologies and best practices in order to improve their customers' online experience, cost-effectively create "buzz" about their offerings and boost their revenues.

This white paper will help you better understand how to leverage MySQL to get the most out of the opportunity the social web represents.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql-wp-top-10-online-retail.php

Case Study: Adresseavisen, Leading News Site in Norway, relies on MySQL

Adresseavisen is the largest web property in Polaris Media ASA, a Norway based media group with publishing, newspapers and digital services providing news via channels including radio and local-television (TV) stations, web TV and mobile phones. MySQL databases currently support 21 online newspaper publications in total within the group.

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

Case Study: Telemaque Deploys MySQL Cluster to Power Converged Call Center Services

Telemaque deployed MySQL Cluster to handle the growing call volume and stringent SLA requirements for their hosted call center services. MySQL Cluster powers their SIP Servers, Media Servers and proxy servers, handling call setup, routing tables, AAA and CDRs. MySQL Cluster sustains over 330,000 operations per second and has delivered continuous availability since initial deployment in 2008.

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

Live Webinar: In Pursuit of the Holy Grail - MySQL Cluster and Push Down JOINs
Thursday, November 4, 2010 - 9:00am PT

While distributed, shared nothing databases deliver high throughput for operations on primary keys, performance for complex multi-table JOIN operations can be lower as multiple nodes need to be accessed to fulfill the query.

Pushing down JOIN operations to the data nodes is intended to address such limitations and broaden the type of applications that can use the MySQL Cluster database. This work is currently in development and a pre-release version is available for users to try out with their own queries and provide feedback to the engineering team.

Live Webinar: MySQL and Oracle Database 11g: World Class Web Scalability and Infrastructure
Thursday, November 18, 2010 - 9:00am PT

Join us for this webinar to better understand:

- What makes MySQL the database of choice of leading Web properties including Facebook, Google, Wikipedia and thousands of others
- How to deliver highly scalable and highly available Web applications with MySQL
- How Oracle Database 11g is used for backend infrastructure by customers and partners

Live Webinar: InnoDB Enhancements and Roadmap
Tuesday, December 14, 2010 - 9:00am PT

Oracle's InnoDB is the most popular, reliable, and proven transactional storage engine for MySQL. In this session, you will learn about InnoDB architecture and some innovative technologies in InnoDB for performance and data protection. You will also hear about new performance-enhancing features to improve concurrency and scalability in InnoDB.

Live Webinar: Accelerating Telecoms Transformation with Web 2.0 Data Management
Wednesday, December 15, 2010 - 9:00am PT

The convergence of communication networks onto one which is IP (Internet Protocol) based is revolutionizing today's telecommunications industry. Attend this webinar to learn how leading Communications Service Providers, Network Equipment Manufacturers and ISVs are transforming telecommunications services with MySQL.

Live Webinar: MySQL Essentials Part 6 - Develop Simple Java Applications with MySQL
Thursday, December 16, 2010 - 9:00am PT

In Part 6 of the MySQL Essentials Webinar Series, Java and MySQL expert Mark Matthews will present the basic knowledge for you to get started developing and deploying simple Java applications with MySQL. He will guide you through the installation pre-requisites and process, discuss the options in architecture and frameworks, and show you how to handle transactions. He will also demonstrate the development steps with sample applications and share performance tips.

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

New Product Releases

New Release of MySQL Cluster 7.1.8 Binary (GA)

The binary version for MySQL Cluster 7.1.8 has been released.

View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-5-1-47-ndb-7-1-8.html

Download Now:
http://dev.mysql.com/downloads/cluster/

New Release of MySQL Workbench 5.2.29 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.29. This maintenance release focuses on general product improvement and usability.

View the Complete List of Changes:
http://dev.mysql.com/doc/workbench/en/wb-news-5-2-29.html

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

New Release of MySQL Connector/NET 6.3.5 (GA)

We're happy to announce the latest maintenance release of MySQL Connector/Net 6.3.5. MySQL Connector 6.3.5 provides:

- Secure, high-performance data connectivity with MySQL
- ADO.NET interfaces that integrate into ADO.NET aware tools
- A fully managed ADO.NET driver written in 100% pure C#
- Visual Studio Integration

View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-6-3-5.html

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

Read the Tutorials:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-tutorials.html

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

Hints & Tips

White Paper: MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5

MySQL Replication has been widely deployed by some of the leading properties on the web and in the enterprise to deliver extreme levels of database scalability. This white paper introduces the concepts behind replication and what can be achieved with MySQL Replication.

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

Article: A Look Inside MySQL Enterprise Monitor
Chris Schneider

MySQL Enterprise Monitor was highlighted during "MySQL Sunday" at the Oracle OpenWorld conference this past month. Given the ease of implementation and helpful GUI tools, MySQL Enterprise Monitor provides almost instant benefits for any MySQL shop.

Read this Article:
http://www.databasejournal.com/features/mysql/article.php/3905956/A-Look-Inside-MySQL-Enterprise-Monitor.htm

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: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server
Yoshinori Matsunobu

Most of high scale web applications use MySQL + memcached. Many of them use also NoSQL like TokyoCabinet/Tyrant. In some cases people have dropped MySQL and have shifted to NoSQL.

Like many other high scale web sites, we at DeNA had similar issues for years. But we reached a different conclusion. We are using "only MySQL".

Read the PlanetMySQL BlogPost:
http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html

PlanetMySQL Blog: How to find an errant MySQL client
Jeremy Cole

A common story: You've got some connection, either it's busy running something it shouldn't be, it's in Sleep but holding some important lock, or you just don't know why it's connected to your database server in the first place.

Read the PlanetMySQL BlogPost:
http://jcole.us/blog/archives/2010/10/02/how-to-find-an-errant-mysql-client/

PlanetMySQL Blog: Setting up OpenLDAP for MySQL Enterprise Monitor
Leandro Morgado

The latest 2.2 release of MySQL Enterprise Monitor has the ability to authenticate against LDAP. I decided to test this setup and for that, I had to create and populate an OpenLDAP server, including STARTTLS/SSL certificates. This guide was done on CentOS 5.5 but it shouldn't be much different in other Linux/Unix distributions.

Read the PlanetMySQL BlogPost:
http://lmorgado.com/blog/2010/10/11/setting-up-openldap-for-mysql-enterprise-monitor/

PlanetMySQL Blog: InnoDB tablespace fragmentation (find it and fix it!)
Sarah Novotny

If you frequently delete rows (or update rows with variable-length data types), you can end up with a lot of wasted space in your data file(s), similar to filesystem fragmentation.

Read the PlanetMySQL BlogPost:
http://www.bluegecko.net/mysql/innodb-tablespace-fragmentation-find-it-and-fix-it/

PlanetMySQL Blog: Fetching rows as dictionaries with MySQL Connector/Python
Geert Vanderkelen

This post describes how to make a custom cursor returning rows as dictionaries using MySQL Connector/Python v0.2 (or later).

Read the PlanetMySQL BlogPost:
http://geert.vanderkelen.org/post/356/

PlanetMySQL Blog: Optimizing MySQL Cluster Performance: SELECT Operations
Johan Andersson

This post follows on the previous post on SELECT performance. In this post I want to show three things: 1. How many single row UPDATEs per second you can do on a Cluster with two data nodes; 2. Show how MySQL Cluster scales with threads and MySQL servers; 3. How ndb_cluster_connection_pool affects performance.

Read the PlanetMySQL BlogPost:
http://johanandersson.blogspot.com/2010/10/mysql-cluster-performance-update-on-pk_11.html

PlanetMySQL Blog: Get MySQL Replication Up and Running in 5 minutes
Andrew Morgan

MySQL Replication is incredibly simple to get up and running and this (short) post steps you through it.

Read the PlanetMySQL BlogPost:
http://www.clusterdb.com/mysql-cluster/get-mysql-replication-up-and-running-in-5-minutes/

PlanetMySQL Blog: A Look at MySQL 5.5 Semi-Synchronous Replication
Erik Ljungstrom

Now that MySQL 5.5 is in RC, I decided to have a look at the semi synchronous replication. It's easy to get going, and from my very initial tests appear to be working a treat.

Read the PlanetMySQL BlogPost:
http://northernmost.org/blog/a-look-at-mysql-5-5-semi-synchronous-replication/

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

Spotlight: MySQL Webinar Series - Getting the Best MySQL Performance in Your Products

On-Demand Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals

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. 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.

On-Demand Webinar: Getting the Best MySQL Performance in Your Products: Part 2, Beyond the Basics

In Part 2 of a three-part performance series, MySQL performance expert Alexander Rubin will take you beyond the basics and show you the next set of steps to take when architecting your product's MySQL embedded or bundled database for higher performance and customer satisfaction.

Live Webinar: Getting the Best MySQL Performance in Your Products: Part 3, Query Tuning
Tuesday, November 23, 2010 - 9:00am PT

In Part 3 of a three-part performance series, MySQL Professional Services Principal Consultant, Alexander Rubin will show you the next set of steps to take when architecting your product's MySQL embedded or bundled database for higher performance and customer satisfaction. Alexander will focus on Query Tuning, building on the steps covered in Part 1 and Part II. He will cover the following topics, including monitoring your queries, understanding query performance, indexes, using temporary tables, and more.

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

Events

Live Webinar: Delivering Scalability and High Availability with MySQL 5.5 Replication Enhancements - EMEA

To scale the business, many organizations have large data centers with replicated MySQL servers. This session explains how to use MySQL replication for scalability and high availability, focusing on the new MySQL Release 5.5 features that have been implemented to support and simplify maintenance of such installations. Features include replication heartbeating, semi-synchronous replication, fsync tuning, and relay log corruption recovery.

Register for the French Webinar on November 18 at 10:00 CET:
http://dev.mysql.com/news-and-events/web-seminars/display-588.html?p=newsletter

Register for the German Webinar on November 23 at 15:00 CET:
http://dev.mysql.com/news-and-events/web-seminars/display-578.html?p=newsletter

Live Webinar: MySQL Fine-Tuning Best Practices - Spanish
Tuesday, November 23, 2010 - 17:00 Mexico City Time

Learn about MySQL fine-tuning best practices directly from the subject matter experts. Join this interactive session where you will also see the added value of MySQL Enterprise Edition, updated software with administrative tools, as well as support and consulting services that guarantee optimal performance and availability of your database.

Live Webinar: MySQL Clustering and High Availability - Portuguese
Tuesday, November 23, 2010 - 14:00 Sao Paulo Time

In this webinar you will learn about MySQL Clustering and High Availability. In particular we will review the following topics, including MySQL Replication, MySQL's customer case studies in Latin America & Worldwide, as well as what's new in the MySQL world.

Live Webinar: Designing MySQL Databases - Italian
Thursday, November 25, 2010 - 10:00 CET

Join us for this webinar to learn the design dos and don'ts for MySQL. We will show you how to design, forward and reverse engineer databases including discussions on datatypes, indexes, and foreign keys for various application scenarios. Whether you are developing commercial applications, Web-based applications, or in-house applications, and whether you are a novice or more advanced, you will benefit from this presentation and the given expertise.

Live Webinar: MySQL and Windows: Getting Started with MySQL on Windows - Chinese
Thursday, November 25, 2010 - 10:00am Beijing Time

Join us for this informative technical webinar with Ivan Tu, MySQL Sales Consultant at Oracle. In this presentation we'll cover the benefits of deploying MySQL on Windows. You will learn the basic "How-To's" of installation, security and configuration. We also will show you how to start using MySQL tools on Windows, such as MySQL Workbench and MySQL Enterprise Monitor with the Query Analyzer.

Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine - German
Tuesday, December 7, 2010 - 15:00 CET

MEMORY is a MySQL storage engine designed for in-memory operations. MySQL Cluster, which itself can be implemented as a MySQL storage engine, can perform all the same in-memory operations, and is faster, more reliable and uses less RAM for data, even on a single node.

In this webinar, comparisons between the MEMORY storage engine and MySQL Cluster are presented, including a performance study of the two technologies, followed by a step-by-step guide on how existing MEMORY storage engine users can upgrade to MySQL Cluster.

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

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

Partners

Live Webinar: MySQL Backup Essentials
Tuesday, November 23, 2010 - 10:00am PT

Join Zmanda for two webinars dedicated to hot backup of MySQL.

In this webinar, we will go over best practices for backing up live MySQL databases. We will also cover Zmanda Recovery Manager (ZRM) for MySQL product in detail, including a walk through the configuration and management processes. We will discuss various features of ZRM including full backups using snapshots, point-in-time recovery, monitoring and reporting. The webinar will be presented by Paddy Sreenivasan, Zmanda VP of Engineering.

Live Webinar: MySQL Backup to Cloud
Tuesday, November 30, 2010 - 10:00am PT

Join Zmanda for two webinars dedicated to hot backup of MySQL.

In this webinar, we will focus on backing up MySQL databases running on Windows to the cloud. We will provide live demonstration of the Zmanda Cloud Backup (ZCB) product backing up MySQL to Amazon S3 storage. We will also discuss recovering MySQL database in the cloud, creating a radically low cost disaster recovery solution for MySQL. The webinar will be presented by Paddy Sreenivasan, Zmanda VP of Engineering.

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

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/

Problems reading the newsletter in your email client? View the newsletter on the web.
http://dev.mysql.com/news-and-events/newsletter/2010/2010-11.html

--
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

Monday, November 1, 2010

MySQL Newsletter: November 2010

No comments:

Post a Comment

Followers

Blog Archive

About Me