MySQL Newsletter
February 2011
Articles in this newsletter:
Highlights
- OurSQL: The MySQL Database Community Podcast
- PlanetMySQL Blog: Something awesome in InnoDB -- the insert buffer
- MySQL 5.5 Now Builds with CMake
- White Paper: MySQL 5.5: Storage Engine Performance Benchmark for MyISAM and InnoDB
- Case Study: F5 Relies on MySQL to Improve Performance 1000%
- Live Webinar: MySQL Essentials Part 7: MySQL Administration and Management Essentials (February 22)
- Live Webinar: MySQL Reference Architectures for Scalable Web Infrastructure (February 24)
New Product Releases
- New Release of MySQL Connector/NET 6.3.6 (GA)
Hints & Tips
- White Paper: MySQL - Powering The Online Media & Entertainment Industry
- Case Study: IMS Adoption Fueled by the Open IMS Core Project and MySQL
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: How to select random rows in MySQL
- PlanetMySQL Blog: Multi condition UPDATE query
- PlanetMySQL Blog: It's about Time.
- PlanetMySQL Blog: Statement-based vs Row-based Replication
- PlanetMySQL Blog: The MySQL Council is up and running. We want to hear from you!
- PlanetMySQL Blog: A case for FORCE INDEX
- PlanetMySQL Blog: Low latency distributed parallel joins
- PlanetMySQL Blog: Welcome New Oracle ACE's
- PlanetMySQL Blog: PHP: Transparent load balancing and sharding with mysqlnd
- PlanetMySQL Blog: MySQL Makes The Cover of Oracle Magazine!
Events
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - EMEA
- On-Demand Webinar: MySQL Essentials Part 6 - How to Develop Simple Java Applications with MySQL
- On-Demand Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL
- On-Demand Webinar: What's New in Managing MySQL Cluster
- On-Demand Webinar: MySQL 5.5 GA: Technology Update - APAC
-------------------------------------------------------------------
Highlights
OurSQL: The MySQL Database Community Podcast
OurSQL, the MySQL database community podcast is back! These podcasts are brought to you by two well-known MySQL community members, Sheeri K. Cabral and Sarah Novotny, who provide you with regular updates on what's happening in the MySQL community.
Learn More:
http://blogs.oracle.com/mysql/2011/01/oursql_podcasts_now_available_from_the_mysql_developer_zone.html
Listen to the Podcasts:
http://dev.mysql.com/podcasts/
PlanetMySQL Blog: Something awesome in InnoDB -- the insert buffer
Mark Callaghan
The InnoDB insert buffer significantly reduces the disk IO required to support a change intensive workload when the database does not fit in the buffer pool. Eventually I must begin calling it the change buffer as it does more in MySQL 5.5.
Read the PlanetMySQL BlogPost:
http://www.facebook.com/note.php?note_id=492969385932
MySQL 5.5 Now Builds with CMake
Starting with MySQL 5.5, CMake has replaced the legacy autoconf/automake framework for building MySQL on all platforms. If you want to develop on MySQL or want to compile the server from source, make sure to take a look at the resources below.
Read the BlogPost "MySQL 5.5: CMake replaces autoconf/automake on all platforms":
http://www.lenzg.net/archives/329-MySQL-5.5-CMake-replaces-autoconfautomake-on-all-platforms,-support-for-autotools-has-now-been-removed.html
Read the Tutorial "How to Build MySQL Server with CMake":
http://forge.mysql.com/wiki/CMake
Read the Documentation "Installing MySQL from Source":
http://dev.mysql.com/doc/refman/5.5/en/source-installation.html
White Paper: MySQL 5.5: Storage Engine Performance Benchmark for MyISAM and InnoDB
With the release of MySQL 5.5, InnoDB has become the default storage engine. InnoDB is designed to handle transactional applications that require crash recovery, referential integrity, high levels of user concurrency and fast response times. The purpose of this whitepaper is to directly compare performance of the latest InnoDB 1.1 release included with MySQL 5.5 and MyISAM, using a benchmark that is commonly run to measure MySQL throughput.
Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_5.5_perf_myisam_innodb.php
Case Study: F5 Relies on MySQL to Improve Performance 1000%
F5 is the market share leader in Application Delivery Controllers, with revenues of over $882 million in 2010. F5 used MySQL with partitioning to increase performance over 1000%, which made a new real-time performance graphing product module possible. This new module became the F5 Enterprise Manager product's most compelling differentiator.
Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql-cs-f5.php
Live Webinar: MySQL Essentials Part 7: MySQL Administration and Management Essentials
Tuesday, February 22, 2011 - 9:00am PT
MySQL is well known for being "easy to use" and "easy to manage". In Part 7 of the MySQL Essentials webinar series, we'll discuss various MySQL tools essential for a busy DBA. These tools help simplify the job and improve the effectiveness of any DBA administering and managing MySQL environments - from beginner to pro. Our discussion will span from command-line tools and scripts to graphical user interfaces. We'll share the techniques that can help you avoid costly outages, secure MySQL and assure your MySQL databases are running at the highest level of availability.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-608.html?p=newsletter
Live Webinar: MySQL Reference Architectures for Scalable Web Infrastructure
Thursday, February 24, 2011 - 9:00am PT
In this webinar, we present a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management. Optimum deployment architectures and topologies are defined based on sizing and availability requirements for each environment. We will also discuss the unique requirements for Large Social Networking applications.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-606.html?p=newsletter
Download the White Paper "MySQL Reference Architectures for Scalable Web Infrastructure":
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_high-availability_webrefarchs.php
-------------------------------------------------------------------
New Product Releases
New Release of MySQL Connector/NET 6.3.6 (GA)
We're happy to announce the latest maintenance release of MySQL Connector/Net 6.3.6.
View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.5/en/connector-net-news-6-3-6.html
Download Now:
http://dev.mysql.com/downloads/connector/net/6.3.html#downloads
-------------------------------------------------------------------
Hints & Tips
White Paper: MySQL - Powering The Online Media & Entertainment Industry
As the term "Online Media" seems to become a pleonasm, we examine the following topics in this whitepaper, including the key trends shaping the evolution of the media & entertainment industry, the implications and requirements these trends placing on the infrastructure of entertainment services providers, as well as how to leverage Oracle's MySQL technologies in order to win in the new world of media and entertainment.
Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_powering_online_media.php
Case Study: IMS Adoption Fueled by the Open IMS Core Project and MySQL
IMS is the foundation of Next Generation Networks (NGNs), a key architectural transformation in telecommunications networks designed to deliver communications services, such as voice, data and multi-media, over converged, all-IP (Internet Protocol) networks. It is expected that IMS will become the prominent technology enabler for converging fixed, mobile and cable networks, providing seamless triple and quadruple play services.
Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_IMS_Core.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: How to select random rows in MySQL
Ilan Hazan
The easiest way to generate random rows in MySQL is to use the ORDER BY RAND() clause. This can work fine for small tables. However, for big tables, it will have a serious performance problem, as in order to generate the list of random rows, MySQL needs to assign random number to each row and then sort them.
Read the PlanetMySQL BlogPost:
http://www.rndblog.com/how-to-select-random-rows-in-mysql/
PlanetMySQL Blog: Multi condition UPDATE query
Shlomi Noach
A simple question I've been asked: is it possible to merge two UPDATE queries, each on different WHERE conditions, into a single query?
Read the PlanetMySQL BlogPost:
http://code.openark.org/blog/mysql/multi-condition-update-query
PlanetMySQL Blog: It's about Time.
Mark Grennan
This post started with a simple question: "Does the function NOW() get executed every time a row is examined?"
Read the PlanetMySQL BlogPost:
http://www.mysqlfanboy.com/2011/01/its_about_time/
PlanetMySQL Blog: Statement-based vs Row-based Replication
Ovais Tariq
Replication as most people know it, has mostly been SQL statement propagation from master to slave. This is known as "statement-based" replication. But there is also another kind of replication that is available, the "row-based replication", and that has quite a lot of benefits. In this post I intend on highlighting the advantages and disadvantages of both types of replication to help you choose the best one. I also follow up with my own recommendation.
Read the PlanetMySQL BlogPost:
http://www.ovaistariq.net/528/statement-based-vs-row-based-replication/
PlanetMySQL Blog: The MySQL Council is up and running. We want to hear from you!
Giuseppe Maxia
The Independent Oracle User Group (IOUG) has formed the MySQL Council, with the purpose of addressing the interests and needs of MySQL users.
Read the PlanetMySQL BlogPost:
http://datacharmer.blogspot.com/2011/01/mysql-council-is-up-and-running-we-want.html
PlanetMySQL Blog: A case for FORCE INDEX
Domas Mituzas
I remember various discussions in different mediums where people were building cases against the use of FORCE INDEX in SQL queries. I'll hereby suggest using it way more often, but at first I'll start with a small explanation.
Read the PlanetMySQL BlogPost:
http://dom.as/2011/01/27/a-case-for-force-index/
PlanetMySQL Blog: Low latency distributed parallel joins
Frazer Clement
The SPJ project started around the time of the last MySQL Developers conference in Riga in September 2008. The intention at the time was to look at ways of efficiently supporting more complex queries, specifically involving table joins, reducing unnecessary data transfer, communication latencies and context switches and increasing parallelism.
Read the PlanetMySQL BlogPost:
http://messagepassing.blogspot.com/2011/01/low-latency-distributed-parallel-joins.html
PlanetMySQL Blog: Welcome New Oracle ACE's
Ronald Bradford
I am pleased to announce that the Oracle ACE program has two new MySQL inductees, Giuseppe Maxia and Patrick Galbraith. These people actively contribute to the MySQL community via a varied means in an unbiased and non commercial way.
Read the PlanetMySQL BlogPost:
http://ronaldbradford.com/blog/welcome-new-oracle-aces-2011-01-25/
PlanetMySQL Blog: PHP: Transparent load balancing and sharding with mysqlnd
Ulf Wendel
Psst, you want some client-side MySQL load balancing with and without sharding for your PHP application? PHP 5.3 has something to offer for you. It is free. It requires no to very little changes to your applications.
Read the PlanetMySQL BlogPost:
http://blog.ulf-wendel.de/?p=298
PlanetMySQL Blog: MySQL Makes The Cover of Oracle Magazine!
Bertrand Matthelie
In case you haven't seen it yet, MySQL made the cover of the January/February Edition of Oracle Magazine! Published 6 times per year and distributed to over half a million of IT managers, DBAs and developers, Oracle Magazine contains technology-strategy articles, sample code, tips, Oracle & partner news, and more.
Read the PlanetMySQL BlogPost:
http://blogs.oracle.com/mysql/2011/01/mysql_makes_the_cover_of_oracle_magazine.html
-------------------------------------------------------------------
Events
Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - EMEA
Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools. You'll also hear about new innovative professional support services offerings aimed at quickly improving the performance of your business-critical MySQL databases and applications.
Register for the Italian Webinar on February 17 at 10:00 CET:
http://dev.mysql.com/news-and-events/web-seminars/display-607.html
Register for the French Webinar on February 28 at 10:00 CET:
http://dev.mysql.com/news-and-events/web-seminars/display-609.html
On-Demand Webinar: MySQL Essentials Part 6 - How to Develop Simple Java Applications 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.
Register for this On-Demand Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-591.html
On-Demand Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL
Online backup has been one of the most requested features for MySQL. With MySQL Enterprise Backup, developers and DBAs have tools they need to safely and rapidly backup and restore their databases. In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.
Register for this On-Demand Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-592.html
On-Demand Webinar: What's New in Managing MySQL Cluster
In this webinar, we will present an overview of the three latest enhancements to provisioning, monitoring and managing MySQL Cluster - collectively serving to lower costs, enhance agility and reduce the risk of downtime caused by manual configuration errors.
Register for this On-Demand Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-599.html
On-Demand Webinar: MySQL 5.5 GA: Technology Update - APAC
This online webinar will explain enhanced features introduced in MySQL 5.5 with benchmark data that proves MySQL 5.5 performance improvements. With the acquisition of Sun, Oracle continued to invest and improve MySQL - to make MySQL a better MySQL. Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools.
Register for the Chinese On-Demand Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-601.html
Register for the Japanese On-Demand Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-602.html
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?
Read Oracle's MySQL Blog:
http://blogs.oracle.com/mysql/
Join MySQL on Facebook:
http://www.facebook.com/mysql
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/?topic=newsletter
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/2011/2011-02.html
--
Copyright (c) 2011, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.
Attend a free live event
