MySQL Newsletter February 2011
Articles in this newsletter:
- 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)
- 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!
- 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
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.
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.
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.
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.
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.
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.
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.
We're happy to announce the latest maintenance release of MySQL Connector/Net 6.3.6.
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.
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.
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.
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.
A simple question I've been asked: is it possible to merge two UPDATE queries, each on different WHERE conditions, into a single query?
This post started with a simple question: "Does the function NOW() get executed every time a row is examined?"
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.
The Independent Oracle User Group (IOUG) has formed the MySQL Council, with the purpose of addressing the interests and needs of MySQL users.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.