Special Edition: Scaling with MySQL
mysql-newsletter@sun.com
This is a special edition of the MySQL Newsletter. In addition to the regular MySQL Monthly Newsletters, a MySQL Newsletter Special Edition is issued each quarter that highlights technical information on topics most relevant to MySQL DBAs and developers. This edition focuses on "Scalability", with resources to help you better scale your MySQL environment.
Highlights
- Webcast: MySQL Sunday Keynote from Edward Screven and Tomas Ulin
- Press Release: Oracle Announces MySQL 5.5 Release Candidate
- Product Release: MySQL Enterprise Monitor 2.2.3
- Call for MySQL Participation at Collaborate 11 (April 10 - 14, 2011)
- Event: MySQL Seminar: What's New with MySQL? (October 7) - Italian
- Event: MySQL Seminar: High Availability Applications with MySQL (October 5 & 27) - German
- Live Webinar: Delivering Scalability and High Availability with MySQL 5.5 Replication Enhancements (October 12)
- Live Webinar: Practical Partitioning With MySQL: When, Why and How (October 26)
White Papers
- How MySQL Powers Web 2.0
- Boosting MySQL Performance and Scalability with the InnoDB Plugin
- Designing and Implementing Scalable Applications with Memcached and MySQL
On Demand Webinars
- Building an Architecture for Scalability: myLifetime.com on MySQL
- Boosting Your Products' Performance and Scalability with InnoDB Upgrade for MySQL 5.1
- Best Practices for Deploying and Scaling MySQL in the Joyent Cloud
- Introduction to MySQL Scale Out and Replication Services
- Scaling and Tuning MySQL-backed PHP Applications
- Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached
- Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine
- MySQL Cluster: 5 Steps to Getting Started, then 5 More to Scale for the Web
- Getting Started with MySQL Replication on Windows
- Scaling to 200K Transactions per Second with Open Source - MySQL, Java, curl, PHP
- For ISVs and OEMs: Getting Maximum Scalability and Availability with Java and MySQL
- Better Java Application Scalability and Reliability Using MySQL Connector/J Features
- 37signals on MySQL Enterprise Data Growth and Scaling
Presentations
- Performance and Scalability Enhancements in MySQL Release 5.5
- Advanced MySQL Replication Techniques
- Boosting MySQL Performance with Partitioning
- Answers to the Scaling Challenge: A Case Study With Answers.com on Scaling With Memcached and MySQL
- MySQL Proxy Meets: Memcache
Case Studies
- Zappos.com Uses MySQL to Power its Growth and Exceptional Customer Service
- Zimbra Deploys Millions of Email Accounts Using MySQL
- Booking.com Serves One Million Visitors per Day with MySQL Enterprise Unlimited
- Wikipedia Enjoys Phenomenal Growth Thanks to MySQL
- MySQL Powers Cinnober's Financial Trading System
- ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance
- MySQL Cluster Powers Rapidly Growing eCommerce Service
- Italtel enables Networking Convergence using MySQL Cluster Carrier Grade Edition
MySQL Training
- MySQL and PHP - Developing Dynamic Web Applications
- MySQL for Developers
- MySQL for Database Administrators
-------------------------------------------------------------------
Highlights
Webcast: MySQL Sunday Keynote from Edward Screven and Tomas Ulin
Edward Screven, Oracle's Chief Corporate Architect, and Tomas Ulin, VP of MySQL Development, discussed Oracle's continuous investment in MySQL and announced the availability of MySQL 5.5 Release Candidate at MySQL Sunday, the first MySQL conference at Oracle OpenWorld.
Watch the Webcast:
http://medianetwork.oracle.com/media/show/15664?n=subCategory&nid=35
Press Release: Oracle Announces MySQL 5.5 Release Candidate
Announced during the first MySQL Sunday event at Oracle OpenWorld, the MySQL 5.5 release candidate showcases the latest enhancements in performance and scalability, availability and usability.
Read the Press Release:
http://www.oracle.com/us/corporate/press/173429
Product Release: MySQL Enterprise Monitor 2.2.3
MySQL Enterprise Monitor 2.2.3 has been released. This is a maintenance release of Enterprise Monitor 2.2. See the online documentation for a list of changes made in this release.
View the Complete List of Changes:
https://enterprise.mysql.com/docs/monitor/2.2/en/mem-news.html#mem-news-2-2-3
Download Now (Log-in Required):
https://enterprise.mysql.com/monitoring/download.php
Try MySQL Enterprise Monitor for 30 days for free:
http://www.mysql.com/trials
Call for MySQL Participation at Collaborate 11 (April 10 - 14, 2011)
The Independent Oracle User Group, focused on Oracle technology including database, security, and virtualization, will hold its annual conference in Orlando, Florida, on April 10 to 14, 2011. This event, co-hosted with OAUG and Quest user organizations, draws more than 5500 attendees.
In Collaborate 11 there will be dedicated MySQL technical tracks to host talks from worldwide MySQL experts, including customers, partners and engineers. Submit your proposals by October 11 to participate this community driven event!
Learn More:
http://collaborate11.ioug.org/mysql
Event: MySQL Seminar: What's New with MySQL? (October 7) - Italian
Join us for the MySQL seminar in Rome to better understand what's new with MySQL! You will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle's investment in MySQL technology as well as product news, aiming to make MySQL an even better MySQL.
Register for the MySQL Italian Seminar in Rome on October 7:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=120177&src=7011252&src=7011252&Act=39
Event: MySQL Seminar: High Availability Applications with MySQL (October 5 & 27) - German
In this half-day seminar delivered in German, we will cover use cases and best practices for implementing MySQL Replication, MySQL Cluster and other High Availability technologies. You will also learn how these technologies work and can be combined to create more scalable and highly available database infrastructures.
Register for the MySQL German Seminar in Munich on October 5:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=120123&src=7011250&src=7011250&Act=18
Register for the MySQL German Seminar in Langen on October 27:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=120578&src=7011250&src=7011250&Act=16
Live Webinar: Delivering Scalability and High Availability with MySQL 5.5 Replication Enhancements
Tuesday, October 12, 2010 - 9:00am PT
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 this Webinar:
http://www.mysql.com/news-and-events/web-seminars/display-572.html?p=newsletter
Live Webinar: Practical Partitioning With MySQL: When, Why and How
Tuesday, October 26, 2010 - 9:00am PT
MySQL Partitioning can dramatically improve the performance and scaling of your MySQL database; it can also cause heartaches and pain if implemented incorrectly. Focusing more on partitions and less on indexes may be what's needed in designing and implementing a large scale data warehouse. Partitioning can also be used in other, non data warehouse solutions to greatly improve both performance and uptime of common OLTP systems.
Join us for this technical webinar and learn when and how to implement MySQL Partitioning correctly and dramatically improve your application's performance and lower the load on your system.
Register for this Webinar:
http://www.mysql.com/news-and-events/web-seminars/display-571.html?p=newsletter
-------------------------------------------------------------------
White Papers
How MySQL Powers Web 2.0
In this paper, you will learn how MySQL enables Web 2.0 sites like Wikipedia, FeedBurner and Facebook - 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 also 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
Boosting MySQL Performance and Scalability with the InnoDB Plugin
MySQL 5.1 now ships with the new InnoDB Plugin - a combination that provides users with immediate access to performance and scalability gains while sustaining the current production-ready and stable feature set of the MySQL 5.1 server.
In this paper, we provide a technical overview of the MySQL pluggable storage engine architecture used by the new InnoDB Plugin, including the features, performance and scalability gains users can expect to see when enabling the InnoDB Plugin in MySQL 5.1.38 or later.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_51_InnoDBplugin.php
Designing and Implementing Scalable Applications with Memcached and MySQL
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. In doing so, they manage to increase their scalability to accommodate more concurrent users and spikes in traffic while at the same time making the most efficient use of their existing computing infrastructure.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_memcached.php
-------------------------------------------------------------------
On Demand Webinars
Building an Architecture for Scalability: myLifetime.com on MySQL
Lifetime Networks, the most powerful media brand targeted to women, is a diverse, multi-media company, committed to offering the highest quality entertainment and informational content that celebrates, entertains and supports women. 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. In this webinar, we will cover the architecture myLifetime.com has developed for scalability as well as the techniques used for optimizing the website, including MySQL, for scalability and performance.
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-535.html
Boosting Your Products' Performance and Scalability with InnoDB Upgrade for MySQL 5.1
Looking for ways to boost the performance and scalability of your MySQL applications? Ready to maximize your customers' investments in modern hardware with a version of MySQL that fully utilizes the processing power of multi-core architectures?
If so, join us for this webinar in which we will discuss how you can achieve immediate performance and scalability gains by enabling the free and easy InnoDB Upgrade for MySQL 5.1.
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-557.html
Best Practices for Deploying and Scaling MySQL in the Joyent Cloud
In this presentation we'll get an overview of the technical and business benefits of deploying MySQL-backed web applications in the cloud. Also presented will be a technical deep-dive into the best practices concerning load balancing, high availability, performance and scaling MySQL in the cloud. Finally, you'll learn how Context Optional leveraged Joyent's Virtual Appliance for MySQL to deliver their application quickly and cost-effectively in the Joyent Public Cloud.
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-414.html
Introduction to MySQL Scale Out and Replication Services
In this webinar we look at the basics for deploying MySQL for a scalable online application. You'll learn about choosing the right architecture, when, why and how to scale out, using MySQL Replication services, and MySQL solutions to help manage your high-growth business.
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-400.html
Scaling and Tuning MySQL-backed PHP Applications
This webinar is aimed at beginning and intermediate PHP developers ready to take their MySQL-backed site to the next phase of growth. Are you ready for what happens when your PHP application becomes popular? Are you ready to scale MySQL? Can you identify the pain points in your application? We'll cover basic identification of MySQL setups for different applications, using Memcached, xDebug and other tools to scale, identify pain points and monitor your application.
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-278.html
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. This webinar will discuss the use cases for both approaches, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-545.html
Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine
MEMORY is a basic 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, before providing a step-by-step guide on how existing MEMORY storage engine users can upgrade to MySQL Cluster.
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-551.html
MySQL Cluster: 5 Steps to Getting Started, then 5 More to Scale for the Web
This session will demonstrate how to start an evaluation of the MySQL Cluster database in 5 easy steps, and then how to expand your deployment for web and telecoms-scale services.
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-566.html
Getting Started with MySQL Replication on Windows
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.
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-505.html
Scaling to 200K Transactions per Second with Open Source - MySQL, Java, curl, PHP
It is possible to build an ad-engine that can serve up more ads than Twitter to an audience larger than Twitter's (19.2m unique US visitors in Oct 2009), using fewer than 10 MySQL servers producing more then 200K Transactions per Second across a Multi-Terabyte store with all open source software. Dathan Pattishall, Chief DataLayer architect at RockYou and former database architect at Friendster and Flickr, will tell you how to do this with real-world examples.
Register for this Webinar:
http://mysql.com/news-and-events/on-demand-webinars/display-od-475.html
For ISVs and OEMs: Getting Maximum Scalability and Availability with Java and MySQL
In this technical webinar, Mark Matthews will review the various MySQL-provided and third-party options for horizontally scaling J2EE applications that use MySQL on commodity hardware and making those applications highly available. He will provide the information you need to determine which option is best for your particular application.
Mark is the maintainer of MySQL's JDBC driver, and is an architect for the MySQL Enterprise Monitor team at Oracle. He is also author of the book, "MySQL and Java Developer's Guide."
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-462.html
Better Java Application Scalability and Reliability Using MySQL Connector/J Features
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, and sharding through some creative use of statement interceptors mixed with the built-in load balancer.
Register for this Webinar:
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-537.html
37signals on MySQL Enterprise Data Growth & Scaling
Listen to industry expert Mark Imbriaco from 37signals talk to Jeremy Cole at Schooner about how he successfully addressed MySQL scaling challenges and database performance issues.
Watch this Webcast:
http://info.schoonerinfotech.com/37signals1orclreg.html
-------------------------------------------------------------------
Presentations
Performance and Scalability Enhancements in MySQL Release 5.5
Thomas Anderson
In this technical, deep-dive talk, Thomas explains the performance features added to MySQL Server and the InnoDB 1.1 Plugin, including details on the scalability gains for multi-core systems.
View the Presentation Slides:
http://www.mysql.com/news-and-events/events/mysql-sunday.html#p08
Advanced MySQL Replication Techniques
Harrison Fisk
MySQL replication plays a critical role in most successful deployments of MySQL. Replication is relatively simple to setup, but takes much more mastery to optimize. Harrison will discuss some of the more advanced replication topologies, as well as practical tips and tricks designed to allow you to take your replication solution to the next level.
View the Presentation Slides:
http://www.mysql.com/news-and-events/events/mysql-sunday.html#p09
Boosting MySQL Performance with Partitioning
Giuseppe Maxia
This session explains with practical examples how to create and use MySQL partitions and how they will increase your application performance. This presentation also covers the recent additions from MySQL 5.5.
View the Presentation Slides:
http://www.mysql.com/news-and-events/events/mysql-sunday.html#p10
Answers to the Scaling Challenge: A Case Study With Answers.com on Scaling With Memcached and MySQL
Joaquin Ruiz and Dan Marriott
In this session, Dan Marriott of Answers.com and Joaquin Ruiz will discuss the pros and cons of implementing Memcached on your own or going with a commercial solution. They'll touch on how to integrate with a high-performance MySQL infrastructure; reduce costs involving servers, rack space, power, cooling, and the time and expertise required to deploy and manage servers; implement authentication and security features; and add capabilities for replication, clustering, optimized memory utilization and advance Memcached management.
View the Presentation Slides:
http://assets.en.oreilly.com/1/event/36/Answers%20to%20the%20Scaling%20Challenge_%20A%20Case%20Study%20With%20Answers_com%20on%20Scaling%20With%20Memcached%20and%20MySQL%20Presentation.pdf
MySQL Proxy Meets: Memcache
Jan Kneschke
Since MySQL 5.1 the row-based replication protocol contains all the properties to get scalability and consistency at the same time. Consistency we get by making sure the data reached a slave before we invalidate the data in memcache, scalability by keeping the query-execution free of syncronous, possibly blocking triggers.
All we need is a protocol translator which understands the MySQL replication protocol, can connect as slave to the replication tree, filter the changes of the right tables and invalidate the data in memcache ... and the MySQL Proxy is our foundation.
View the Presentation Slides:
http://assets.en.oreilly.com/1/event/36/MySQL%20Proxy%20Meets_%20Memcache%20Presentation.pdf
-------------------------------------------------------------------
Case Studies
Zappos.com Uses MySQL to Power its Growth and Exceptional Customer Service
In the earliest start-up days of Zappos.com, the company needed to properly balance their enterprise database requirements with the realities of a not-so-limitless IT budget. After evaluating several open source alternatives, they selected MySQL because it was the most robust, affordable database software available at the time.
Read this Case Study:
http://www.mysql.com/why-mysql/scaleout/zappos.html
Zimbra Deploys Millions of Email Accounts Using MySQL
Zimbra is the leader in open source, next-generation messaging and collaboration software, supporting over 8 million paid mailboxes across tens of thousands of organizations. To ensure high levels of scalability, reliability, security and high-performance, Zimbra chose to build their solution on top of proven, high-quality open source components including Linux, Apache, MySQL and Ajax. Furthermore, Zimbra employs a modular architecture that enables horizontal scale-out of the server and databases, which is crucial for high-growth enterprise-scale deployments.
Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_zimbra.php
Booking.com Serves One Million Visitors per Day with MySQL Enterprise Unlimited
As one of the Web's most successful online travel sites, Booking.com has experienced explosive growth. By dividing one main MySQL database into three separate master servers and then replicating their distinct data on multiple low-cost machines, Booking.com was able to significantly increase their site's speed, lower their infrastructure cost and improve their uptime through MySQL's high-availability solution, based on DRBD Linux technology.
Read this Case Study:
http://www.mysql.com/why-mysql/scaleout/booking.html
Wikipedia Enjoys Phenomenal Growth Thanks to MySQL
The growth at Wikipedia has put constant technical pressure on the performance and scalability of the system. Wikipedia is based on the LAMP stack (Linux, Apache, MySQL & PHP) and has grown from initially employing a single shared server to now being a Top Ten site, with more than 20 replicated database servers delivering up-to-date content to visitors.
Read this Case Study:
http://www.mysql.com/why-mysql/scaleout/wikipedia.html
MySQL Powers Cinnober's Financial Trading System
Cinnober, founded in 1998 in Sweden, offers a complete technology platform for financial trading, with customers including the Chicago Board Options Exchange, NYSE Liffe and London Metal Exchange. MySQL is a key element of the solution, deployed in the heart of the exchange systems.
Read this Executive Interview:
http://www.mysql.com/why-mysql/cio-corner/interviews/peter-kazinczy.html
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. With MySQL, ScienceLogic EM7 helps customers manage over 10,000 tables and perform over 200 million queries per day. MySQL delivers the speed, scale and flexibility that EM7 customers require of an enterprise-class solution.
Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_sciencelogic.php
MySQL Cluster Powers Rapidly Growing eCommerce Service
Since their founding in 2000, Shopatron has grown to provide the eCommerce and order management operations for 700+ global and local manufacturers, with over 10,000 retail partners, operating in eight currencies and three languages across North America and Europe.
In 2006, Shopatron began investigating clustered database solutions that would provide the performance, scale and availability demanded by their growing eCommerce business, and eventually selected MySQL Cluster to power their services.
Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_shopatron.php
Italtel enables Networking Convergence using MySQL Cluster Carrier Grade Edition
Italtel is an acknowledged leader in Next-Generation Network solutions. MySQL Cluster Carrier Grade Edition combined the flexibility of a general purpose database with unprecedented reliability and scalability for Italtel's next generation products to satisfy the requirements to scale from a few thousand to millions of subscribers.
Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_italtel.php
-------------------------------------------------------------------
MySQL Training
MySQL and PHP - Developing Dynamic Web Applications
In this training course you will learn how to develop applications in PHP and how to use MySQL efficiently for those applications! Through a hands-on approach, this instructor-led course will help you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.
Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D62048GC10
MySQL for Developers
The MySQL for Developers course is the foundation course for developers planning on designing and implementing applications that make use of MySQL 5.1. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare you for the MySQL Developer certification.
Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D61830GC10
MySQL for Database Administrators
The MySQL for Database Administrators course is the foundation course for database administrators and developers who want to use this powerful database. In this course you will learn how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new MySQL features such as creating and using Stored Procedures, Triggers and Views.
Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D61762GC10
-------------------------------------------------------------------
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://www.mysql.com/contact/
You can unsubscribe from this newsletter online:
http://www.mysql.com/unsub?email=johandontmessup@gmail.com
--
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.
