MySQL Newsletter November 2010
Articles in this newsletter:
- 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 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)
- 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
- 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)
- 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)
- Live Webinar: MySQL Backup Essentials (November 23)
- Live Webinar: MySQL Backup to Cloud (November 30)
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.
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.
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.
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.
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.
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
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.
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.
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.
The binary version for MySQL Cluster 7.1.8 has been released.
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.
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
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://www.mysql.com/why-mysql/white-papers/mysql-replication-scalability-and-availability-with-mysql-5-5/)
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.
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.
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".
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.
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.
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.
This post describes how to make a custom cursor returning rows as dictionaries using MySQL Connector/Python v0.2 (or later).
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.
MySQL Replication is incredibly simple to get up and running and this (short) post steps you through it.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.