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.

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.

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.

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

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.

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.

Hints & Tips

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.

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.

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.

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.

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.

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.

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

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.

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.

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.