MySQL Newsletter
March 2011

Articles in this newsletter:

Highlights

- Live Webinar: MySQL on Windows Online Forum (March 16)
- Event: Collaborate 11 - Orlando, Florida (April 10-14)
- Event: MySQL Community Reception - Santa Clara, California (April 13)
- DevZone Interview: When the IOUG Meets the MySQL Community
- White Paper: MySQL Enterprise Backup - Fast, Consistent, Online Backups
- Live Webinar: MySQL Cluster 7.1, Latest Updates and Enhancements (March 24)
- Live Webinar: For MySQL ISVs/OEMs: Improve Product Performance, Lower Customer Support Costs (March 29)

New Product Releases

- New Release of MySQL Community Server 5.5.9 (GA)
- New Release of MySQL Community Server 5.1.56 (GA)
- New Release of MySQL Cluster 7.1.10 (GA)
- New Release of MySQL Workbench 5.2.32 (GA)
- New Release of MySQL Connector/J 5.1.15 (GA)
- New Release of MySQL Connector/ODBC 3.51.28 (GA)

Hints & Tips

- White Paper: MySQL Cluster for Presence & Location-Based Services
- White Paper: MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: Simple lessons in improving scalability
  - PlanetMySQL Blog: Upgrading passwords from old_passwords to "new passwords"
  - PlanetMySQL Blog: Web and Telco mode Cluster Configuration
  - PlanetMySQL Blog: Checkpoint handling enhancements in Cluster 7.1 -or- *Ding Dong* GCP Stop is dead!
  - PlanetMySQL Blog: OurSQL Episode 34: Collaborating
  - PlanetMySQL Blog: PHP: Application calling plugin - on communication
  - PlanetMySQL Blog: MySQL Semi-Synchronous Replication. See the Magic. Try the Magic.
  - PlanetMySQL Blog: PHP: want transparent master slave load balancing in mysqlnd?
  - PlanetMySQL Blog: Video: MySQL 5.5 Overview by Bill Papp
  - PlanetMySQL Blog: VIEWS on INFORMATION_SCHEMA tables - Useful stuff
  - PlanetMySQL Blog: How to detect if a MySQL server is an active replication slave
  - PlanetMySQL Blog: Using SQL to create SQL (and other usefulness)
  - PlanetMySQL Blog: MySQL Enterprise Backup 3.5, the crash course

Events

- Live Webinar: MySQL Reference Architectures for Scalable Web Infrastructure - EMEA (March 15 & 16)
- Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL - Portuguese (March 22)
- Live Webinar: MySQL 5.5 - What's New in Performance, Scalability and High Availability - Spanish (March 23)
- On-Demand Webinar: MySQL Reference Architectures for Highly Scalable Web Infrastructure

-------------------------------------------------------------------

Highlights

Live Webinar: MySQL on Windows Online Forum Wednesday, March 16, 2011 - 9:00AM PT

Would you like to reduce your database TCO on Microsoft Windows by up to 90% while increasing manageability and flexibility? Did you know that Windows is the #1 MySQL development platform? Join us for the "MySQL on Windows Online Forum" on March 16 and discover how you can win with MySQL on Windows!

Register Now:
  http://event.on24.com/r.htm?e=284490&s=1&k=583E2237A777967F8410211EC54EF3CB&partnerref=newsletter


Event: Collaborate 11 - Orlando, Florida April 10-14, 2011

Collaborate 11 is a user-driven technology and applications forum for the Oracle community, presented by three leading users groups - IOUG, OAUG, and Quest. This year, in response to the great interest in MySQL among its members, the IOUG creates a special "conference within a conference" on MySQL and features over 50 sessions with topics from technical tips to best practices. You can also meet with the MySQL experts from Oracle at the demo grounds and get all your questions answered!

Learn More about the MySQL sessions at Collaborate 11:
  http://collaborate11.ioug.org/tabid/133/Default.aspx

Register Now:
  http://collaborate11.ioug.org/Home/Registration/tabid/82/Default.aspx


Event: MySQL Community Reception - Santa Clara, California April 13, 2011 - 6:00PM PT

Join the MySQL Team on April 13, 2011, as we celebrate the health and growth of the MySQL community. Whether you are an attendee at O'Reilly MySQL Conference, a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in the MySQL technology, you're all invited to Oracle's MySQL Community Reception. If you're at the MySQL Conference, don't miss Tomas Ulin's "State of the Dolphin" keynote, as he summarizes MySQL's first year under Oracle's stewardship, discusses the current and ongoing engagement with the MySQL user community, and offers insights into future roadmaps of the MySQL products.

RSVP for the MySQL Community Reception:
  http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=131495&src=7011089&src=7011089&Act=10

Learn More about the "State of the Dolphin" Keynote:
  http://en.oreilly.com/mysql2011/public/schedule/detail/18530


DevZone Interview: When the IOUG Meets the MySQL Community

In light with the formation of the MySQL Council under the IOUG (Independent Oracle User Group) and two upcoming conferences with a lot of MySQL content - Collaborate 11 and O'Reilly MySQL Conference, we talked to Andy Flower, President of IOUG, Sarah Novotny, recognized MySQL community member and the Council Chair, as well as Lenz Grimmer and Dave Stokes, MySQL community managers at Oracle, on their thoughts and takes of the IOUG and the MySQL community.

Read the Interview:
  http://dev.mysql.com/tech-resources/interviews/flower-novotny-grimmer-stokes.html


White Paper: MySQL Enterprise Backup - Fast, Consistent, Online Backups

MySQL Enterprise Backup provides a high-performance, online "hot" backup solution with data compression technology to ensure your data is protected in case of downtime or an outage.

This white paper explores numerous backup methods to help you formulate your backup strategy. We also compare the advantages and disadvantages of these backup methods including mysqldump, LVM snapshots and MySQL Enterprise Backup. Backup and restore performance benchmarks, as well as illustrated examples of how MySQL Enterprise Backup works are provided.

Read the White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_backup.php


Live Webinar: MySQL Cluster 7.1, Latest Updates and Enhancements Thursday, March 24, 2011 - 9:00AM PT

MySQL Cluster is a leading real-time, write-scalable transactional database, combining high availability with the low TCO of open source. Join the live Webinar as we discuss the design concepts and most recent developments in MySQL Cluster.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-613.html?p=newsletter


Live Webinar: For MySQL ISVs/OEMs: Improve Product Performance, Lower Customer Support Costs Tuesday, March 29, 2011 - 9:00AM PT

MySQL Enterprise Monitor with best practice Advisors and the MySQL Query Analyzer are now available to OEMs in MySQL Enterprise Edition. MySQL OEMs can use MySQL Enterprise Monitor to provide higher levels of support to their customers, reduce support costs, and gain additional revenue.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-617.html

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.5.9 (GA)

MySQL 5.5.9 is a new release of the 5.5 production version of the world's most popular open source database. MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/news-5-5-9.html

Download Now:
  http://dev.mysql.com/downloads/mysql/


New Release of MySQL Community Server 5.1.56 (GA)

MySQL Server 5.1.56, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.56 is recommended for use on production systems.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-56.html

Download Now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Cluster 7.1.10 (GA)

The latest binary of MySQL Cluster 7.1.10 has been released.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-5-1-51-ndb-7-1-10.html

Download Now:
  http://dev.mysql.com/downloads/cluster/


New Release of MySQL Workbench 5.2.32 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.32. This is a maintenance release featuring a new and improved UI appearance and other enhancements.

View the Complete List of Changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-32.html

Download Now:
  http://dev.mysql.com/downloads/workbench/


New Release of MySQL Connector/J 5.1.15 (GA)

MySQL Connector/J 5.1.15, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL and version 5.1.15 is suitable for use with any MySQL version including MySQL 5.1 or MySQL 5.5.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-15.html

Download Now:
  http://dev.mysql.com/downloads/connector/j/5.1.html


New Release of MySQL Connector/ODBC 3.51.28 (GA)

MySQL Connector/ODBC 3.51.28, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the latest release of the 3.51 series and is suitable for use with any MySQL version since 4.1.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-news-3-51-28.html

Download Now:
  http://dev.mysql.com/downloads/connector/odbc/3.51.html#downloads

-------------------------------------------------------------------

Hints & Tips

White Paper: MySQL Cluster for Presence & Location-Based Services

This whitepaper explores the different types of services that can take advantage of location and presence awareness, and considers their unique requirements for data management. A solution is then presented, based on MySQL Cluster, that allows operators to fully leverage the market opportunity and differentiation presented by these new services.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_cluster_location_presence.php


White Paper: MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5

This white paper introduces the concepts behind replication and what can be achieved with MySQL Replication. It steps through setting up replication as well as handling failover. In addition, the changes introduced to replication in MySQL 5.5 are covered as well as the differences when replicating with MySQL Cluster.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-replication.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: Simple lessons in improving scalability Ronald Bradford

It can be very easy to improve scalability with a MySQL server by a few simple rules. Here is one of them -- "the most efficient way to improve an SQL statement is to eliminate it".

Read the PlanetMySQL BlogPost - Part 1:
  http://ronaldbradford.com/blog/simple-lessons-in-improving-scalability-2011-02-16/

Read the PlanetMySQL BlogPost - Part 2:
  http://ronaldbradford.com/blog/part-2-simple-lessons-in-improving-scalability-2011-02-24/


PlanetMySQL Blog: Upgrading passwords from old_passwords to "new passwords"
Shlomi Noach

You have old_passwords=1 in your my.cnf. I'm guessing this is because you used one of the my-small.cnf, my-large.cnf etc. templates provided with your MySQL distribution.

Read the PlanetMySQL BlogPost:
  http://code.openark.org/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords


PlanetMySQL Blog: Web and Telco mode Cluster Configuration Johan Andersson

The Core Scripts (aka Configurator) for MySQL Cluster has now been updated with a new feature that allows you to tune cluster for a particular workload. Currently there are two types of workloads supported: Web and Telco/Realtime.

Read the PlanetMySQL BlogPost:
  http://johanandersson.blogspot.com/2011/02/web-and-telcomode-cluster-configuration.html


PlanetMySQL Blog: Checkpoint handling enhancements in Cluster 7.1 -or- *Ding Dong* GCP Stop is dead!
Matthew Montgomery

One of the tasks that a data node must perform reliably is the Global Check Point. That is, to flush the transaction redo log to disk. The GCP completion must be synchronized on all data nodes in order to maintain a consistent end point for recovery.

Read the PlanetMySQL BlogPost:
  http://todointx.blogspot.com/2011/02/checkpoint-handling-enhancements-in.html


PlanetMySQL Blog: OurSQL Episode 34: Collaborating Sheeri Cabral and Sarah Novotny

In this episode, we talk about the Collaborate conference, including comparisons to the O'Reilly MySQL conference.

Read the PlanetMySQL BlogPost:
  http://technocation.org/content/oursql-episode-34:-collaborating


PlanetMySQL Blog: PHP: Application calling plugin - on communication Ulf Wendel

Imagine PECL/mysqlnd_ms could keep certain reads on certain slaves in a MySQL master-slave setup. You would have a good chance to profit from hot database caches. You would not only distribute read load, scale out horizontally by using MySQL replication, you would also optimize your reads for hot caches.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=301


PlanetMySQL Blog: MySQL Semi-Synchronous Replication. See the Magic. Try the Magic.
Ronen Baram

MySQL Replication is one of the most used and valued features of the MySQL Server. Unlike some other products on the market, it's out-of-the-box, easy to configure, non-paid and smart features. Most of our medium/large/super-large installation base are using replication to achieve "scale-out" scaling.

Read the PlanetMySQL BlogPost:
  http://blog.ronenb.com/2011/02/23/mysql-semisynchronous-replication/


PlanetMySQL Blog: PHP: want transparent master slave load balancing in mysqlnd?
Ulf Wendel

Are you interested in a master slave load balancing plugin for mysqlnd? It could have two operational modes. The automatic mode would operate transparent from an applications point of view. The manual mode would give you full control over all decisions. Automatic mode is for install and forget when you start with MySQL replication. Manual mode is for growing as your application evolves.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=299


PlanetMySQL Blog: Video: MySQL 5.5 Overview by Bill Papp Sheeri Cabral

At the February 2011 Boston MySQL User Group Meeting, Bill Papp of Oracle shared a presentation about what's new in MySQL 5.5. The video is already up on YouTube and is also embedded at the end of this post.

Read the PlanetMySQL BlogPost:
  http://palominodb.com/blog/2011/02/18/video-mysql-55-overview-bill-papp


PlanetMySQL Blog: VIEWS on INFORMATION_SCHEMA tables - Useful stuff Anders Karlsson

Views in MySQL really has quite a bad reputation, for bad performance mainly, but also there were some stability issues at some point. Now they are pretty stable, but I don't see them used that much. One place where I like to use them myself is in combination with INFORMATION_SCHEMA tables. The I_S tables are really useful and contain a lot of information, and by using VIEWs we can massage the data a bit.

Read the PlanetMySQL BlogPost:
  http://karlssonondatabases.blogspot.com/2011/02/views-on-informationschema-tables.html


PlanetMySQL Blog: How to detect if a MySQL server is an active replication slave Giuseppe Maxia

Sometimes you know for sure. And sometimes you wonder: is this server part of a replication system? And, most specifically, is it an active slave? The completeness of the answer depends on how much visibility you have on the server.

Read the PlanetMySQL BlogPost:
  http://datacharmer.blogspot.com/2011/02/how-to-detect-if-mysql-server-is-active.html


PlanetMySQL Blog: Using SQL to create SQL (and other usefulness) Sarah Novotny

Today, I had a task of modifying a slave to exclude (or if you want to say specifically include) tables. The situation is that this slave needs to only contain tables used for reporting. The added benefit is that with fewer tables to replicate, there will be less replication traffic, less disk I/O and less disk space used hence better performance for queries that digest statistical data.

Read the PlanetMySQL BlogPost:
  http://www.bluegecko.net/mysql/using-sql-to-create-sql-and-other-usefulness/


PlanetMySQL Blog: MySQL Enterprise Backup 3.5, the crash course Ronen Baram

Everyone loves hands-on tutorials with code snippets and stuff to establish the knowledge that something can be done. So here is my first one: MySQL Enterprise Backup 3.5, the new and shiny backup solution for MySQL.

Read the PlanetMySQL BlogPost:
  http://blog.ronenb.com/2011/02/21/mysql-enterprise-backup-3-5/

-------------------------------------------------------------------

Events

Live Webinar: MySQL Reference Architectures for Scalable Web Infrastructure - EMEA

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.

Register for the Germany Webinar on March 15 at 10:00 CET:
  http://dev.mysql.com/news-and-events/web-seminars/display-612.html

Register for the Italian Webinar on March 16 at 15:00 CET:
  http://dev.mysql.com/news-and-events/web-seminars/display-616.html


Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL - Portuguese Tuesday, March 22, 2011 - 16:00 Sao Paulo Time

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 the Portuguese Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-614.html


Live Webinar: MySQL 5.5 - What's New in Performance, Scalability and High Availability - Spanish Wednesday, March 23, 2011 - 17:00 Mexico City Time

MySQL, the world's most popular open source database, presents its latest release, MySQL 5.5. Join the Webinar and learn the details about improvements in performance, scalability and high availability, as a result of Oracle's investment in MySQL's community, developers and customers.

Register for the Spanish Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-615.html


On-Demand Webinar: MySQL Reference Architectures for Highly Scalable Web Infrastructure

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.

Register for this On-Demand Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-606.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

-------------------------------------------------------------------

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=sanjay.ujina@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-03.html

--
Copyright (c) 2011, Oracle Corporation and/or its affiliates.

Comment (0)

MySQL Newsletter
Special Edition: Developing and Managing MySQL Applications mysql-newsletter@sun.com

This is a special edition of the MySQL Newsletter. In addition to the regular MySQL Monthly Newsletter, a MySQL Newsletter Special Edition is issued each quarter that highlights technical information on topics most relevant to MySQL DBAs and developers. This edition is focused on Developing and Managing MySQL Applications with resources to help you get started and manage your MySQL environment more efficiently.

Highlights

- Oracle Magazine: Open for Business - MySQL community wins with better innovation, support, and integration
- Event: MySQL Developer Room at FOSDEM 2011 - Belgium (February 5)
- Event: MySQL at Mobile World Congress - Spain (February 14-17)
- Seminar: Get the Most Out of MySQL - Customer Stories - Italy (February 1)
- Seminar: Improve Performance and Scalability with the Latest from MySQL - EMEA (February 10 & 16)
- Live Webinar: NEW for ISVs and OEMs: MySQL Enterprise Edition - Adding Value to Your Products (February 10)
- Live Webinar: MySQL Essentials Part 7: MySQL Administration and Management Essentials (February 22)
- Live Webinar: MySQL Reference Architectures for Massively Scalable Web Infrastructure (February 24)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - EMEA

Developing PHP Applications with MySQL

- Blog: mysqlnd plugins for PHP in practice
- On Demand Webinar: How to Develop Simple PHP Applications for MySQL
- On Demand Webinar: Designing to Scale to 200K Transactions per Second with Open Source: MySQL, Java, curl, PHP

Developing Java Applications with MySQL

- Webcast: MySQL Tips for Java Developers - Expert Interview
- On Demand Webinar: How to Develop Simple Java Applications with MySQL
- On Demand Webinar: Blazing Java Application Performance: Connector/J Performance Gems
- On Demand Webinar: How to Develop MySQL-Backed Java Applications with Netbeans, JRuby-on-Rails & Glassfish
- On Demand Webinar: Automatic Java Application Multi-Platform Deployment Using MySQL Connector/MXJ
- Case Study: SonicWALL Achieves 100% ROI in Under Nine Months Using MySQL Embedded Database
- Case Study: Clickability Delivers Web Content Management SaaS Solution using MySQL

Developing MySQL Applications on Windows

- White Paper: A Visual Guide to Installing MySQL on Windows
- On Demand Webinar: How to Develop Simple .NET Applications for MySQL
- On Demand Webinar: Getting Started with MySQL on Windows
- On Demand Webinar: Building MySQL on Windows
- On Demand Webinar: Getting Started Using MySQL as an Embedded Database with Windows Applications
- On Demand Webinar: What's New in MySQL Connector/NET 6.2
- Presentation: MySQL and the ADO.NET Entity Framework
- Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
- Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance

Managing MySQL Applications

- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- White Paper: MySQL Enterprise Monitor 2.3: What's New
- White Paper: MySQL Enterprise Monitor: Business Overview
- White Paper: MySQL Cluster Manager
- On Demand Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL
- Demo: MySQL Workbench Demos
- Case Study: Big Fish Games Triples Database Performance with MySQL Query Analyzer

MySQL Training and Certification

- Training: Introduction to MySQL 5.5
- Training: MySQL and PHP - Developing Dynamic Web Applications
- Training: MySQL for Developers
- Certification: Save 20% and Get a Free Certification Retake with MySQL Certification Value Packages

-------------------------------------------------------------------

Highlights

Oracle Magazine: Open for Business - MySQL community wins with better innovation, support, and integration David A. Kelly

Sometimes, relatively small things can make a big impact. Take the case of the MySQL database. First released in 1995 and purchased by Sun in 2008, MySQL has quickly graduated from the realm of hobbyists to the world of business, becoming the leading open source database for many Web applications and an integral part of the LAMP Web application stack.

Read the Magazine Article:
  http://www.oracle.com/technetwork/issue-archive/2011/11-jan/o11mysql-194109.html


Event: MySQL Developer Room at FOSDEM 2011 Brussels, Belgium - February 5, 2011

FOSDEM is one of the largest gatherings of Open Source Developers and Projects in Europe. In 2011, the event will take place on February 5th and 6th in Brussels, Belgium. We will have a Developer Room titled "MySQL and Friends", which will provide a venue for talks about MySQL and related projects. The MySQL Developer Room will be open on Saturday, February 5th, from 13:00 to 19:00. If you're around, come join us and meet with MySQL experts!

Learn More:
  http://forge.mysql.com/wiki/FOSDEM_2011

View the Sessions and Speakers:
  http://forge.mysql.com/wiki/FOSDEM_2011_Developer_Room


Event: MySQL at Mobile World Congress
Barcelona, Spain - February 14-17, 2011

With more than 49,000 communications industry attendees, Mobile World Congress is where the industry comes together. Join us to learn how MySQL and other Oracle solutions enable innovative services while reducing the cost and complexity of infrastructure software and hardware.

Learn More:
  http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=109912&src=6973382&src=6973382&Act=4


Seminar: Get the Most Out of MySQL - Customer Stories Milan, Italy - February 1, 2011

MySQL is the world's most popular open-source database and many organizations in Italy selected MySQL to power their mission critical applications. In this event you will hear stories from MySQL customers and learn how ContactLab, Buongiorno and Cineca are benefitting from the use of MySQL.

Learn More and Register for this Italian Seminar:
  http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=129578&src=7011252&src=7011252&Act=99


Seminar: Improve Performance and Scalability with the Latest from MySQL Paris, France - February 10, 2011 London, UK - February 16, 2011

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.

Learn More and Register for the French Seminar:
  http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=129864&src=7011252&src=7011252&Act=118

Learn More and Register for the English Seminar:
  http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=129696&src=7011252&src=7011252&Act=100


Live Webinar: NEW for ISVs and OEMs: MySQL Enterprise Edition - Adding Value to Your Products Thursday, February 10, 2011 - 9:00AM PT

With the release of MySQL 5.5, all of the advanced capabilities of MySQL Enterprise Edition are now available to OEMs to be distributed with their commercial products. In this technical webinar, Sr. Product Managers and MySQL experts Mike Frank and Rob Young will review new options for OEMs, which are new or improved in the recently released MySQL version 5.5.

Register for this Webinar:
  http://www.mysql.com/news-and-events/web-seminars/display-605.html?p=newsletter


Live Webinar: MySQL Essentials Part 7: MySQL Administration and Management Essentials Tuesday, February 22, 2011 - 9:00AM PT

Join us to learn the essential key steps to administering and maintaining your MySQL database. From command-line utilities to MySQL Workbench to MySQL Enterprise Monitor, we'll show the fundamentals of administering MySQL. Plus, we'll share how to create and execute backup strategies, including tools like MySQL Enterprise Backup for on-line hot backups.

Register for this Webinar:
  http://www.mysql.com/news-and-events/web-seminars/display-608.html?p=newsletter


Live Webinar: MySQL Reference Architectures for Massively 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://www.mysql.com/news-and-events/web-seminars/display-606.html?p=newsletter


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://www.mysql.com/news-and-events/web-seminars/display-607.html

Register for the French Webinar on February 28 at 10:00 CET:
  http://www.mysql.com/news-and-events/web-seminars/display-609.html

-------------------------------------------------------------------

Developing PHP Applications with MySQL

Blog: mysqlnd plugins for PHP in practice Johannes Schlüter

If you follow my blog or twitter stream, you might know I've recently been at Barcelona to attend the PHP Barcelona conference. Conferences are great for exchanging ideas, and here is one of the ideas I discussed with Combell's Thijs Feryn. They are a hosting company providing managed MySQL instances to their customers, as such they run multiple MySQL servers and each server serves a few of their customers.

Read this Blog Post:
  http://schlueters.de/blog/archives/146-mysqlnd-plugins-for-PHP-in-practice.html


On Demand Webinar: How to Develop Simple PHP Applications for MySQL

In this technical webinar, MySQL developer Johannes Schlüter will show you the essentials for creating dynamic web content using MySQL and PHP. He will also discuss many of the fundamental elements used when developing PHP applications with MySQL, including the frameworks, APIs, security features, and asynchronous queries.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-575.html


On Demand Webinar: Designing to Scale 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, using fewer than 10 MySQL servers producing more then 200K Transactions per Second across a Multi-Terabyte store with all open source software. MySQL with InnoDB/myISAM, curl, PHP, and Java are the only components that are necessary for this linearly scaling engine without user-facing downtime.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-475.html

-------------------------------------------------------------------

Developing Java Applications with MySQL

Webcast: MySQL Tips for Java Developers - Expert Interview

MySQL is the world's most popular open-source database, and there are a lot of Java developers who use MySQL databases in their applications. In this Deep Dive, Mark Matthews, architect for Enterprise Tools Team at Oracle, demonstrated some of the techniques that can help Java developers get more out of their applications that use MySQL.

Watch the Webcast:
  http://java.sun.com/developer/media/deepdivemysqljava.jsp


On Demand Webinar: How to Develop Simple Java Applications with MySQL

Java is among the most popular development languages for MySQL applications. In this webinar, Java and MySQL expert Mark Matthews will present the basic knowledge for you to get started developing and deploying simple Java applications with MySQL, including installation pre-requisites and process, options in architecture and frameworks, as well as how to handle transactions.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-591.html


On Demand Webinar: Blazing Java Application Performance: Connector/J Performance Gems

In this session, the author of Connector/J, Mark Matthews, will show you how to wring that last little bit of performance out of your Java applications deployed on MySQL by not using the out-of-the-box configuration. Connector/J has nearly 200 configuration options, many of which affect performance. Mark will show you how to move from generic to customized, illustrating how to set Connector/J options that will deliver the best performance for your specific application.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-460.html


On Demand Webinar: How to Develop MySQL-Backed Java Applications with Netbeans, JRuby-on-Rails & Glassfish

Join us for this informative technical webinar presented by Arun Gupta, where he will demonstrate how to leverage the latest version of the Netbeans IDE to quickly and easily develop and deploy MySQL and Glassfish backed applications using the JRuby-on-Rails framework.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-305.html


On Demand Webinar: Automatic Java Application Multi-Platform Deployment Using MySQL Connector/MXJ

Connector/MXJ is a Java utility package that makes the MySQL database appear to be a Java-based component. With MySQL Connector/MXJ, you can reduce installation barriers for your end user customers by simply adding an additional parameter to the JDBC connection url which will cause the database to start when the first connection is made.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-423.html


Case Study: SonicWALL Achieves 100% ROI in Under Nine Months Using MySQL Embedded Database

SonicWALL started using MySQL 5.0 in July 2008, and within just six months of using MySQL, SonicWALL was able to: Lower their cost of goods sold (COGS); Shorten new product time-to-market through the efficiencies they gained in Development, Quality Assurance, Training, and Documentation; and, Reduce the number of trouble tickets they received by over 20%, in addition to other gains.

Read this Case Study:
  http://www.mysql.com/why-mysql/case-studies/mysql_cs_sonicwall.php


Case Study: Clickability Delivers Web Content Management SaaS Solution using MySQL

Clickability is the global leader in on demand Web Content Management, serving over 350 million page views per month for hundreds of customers, including Cisco, NetApp, Philly.com and CNN Interactive. MySQL stores the core application data which is used across multiple applications that include serving 500+ million advertisements and distributing 10+ million emails every month.

Read this Case Study:
  http://www.mysql.com/why-mysql/case-studies/mysql-cs-clickability.php

-------------------------------------------------------------------

Developing MySQL Applications on Windows

White Paper: A Visual Guide to Installing MySQL on Windows

This paper will guide you through the steps and tools needed to get up and running quickly with MySQL on Windows using familiar terms, comparisons, and language. Its goal is to put in place basic knowledge and building blocks you will need in conjunction with added references to resources as you continue to drill down further into the more advanced features of MySQL.

Read this White Paper:
  http://www.mysql.com/why-mysql/white-papers/visual_guide_to_installing_mysql_windows.php


On Demand Webinar: How to Develop Simple .NET Applications for MySQL

In this webinar we will explore the use of MySQL as the underlying database for .NET applications. Using several example programs, we will dive into how to develop a few starter applications for MySQL in C# and ASP.Net using Visual Studio. We will also guide you through the process from installing MySQL Connector/NET, setting up Visual Studio, starting a project, designing, coding and running these simple .NET apps.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-568.html


On Demand Webinar: Getting Started with MySQL on Windows

Join us for this informative technical webinar with Mike Frank, Sr Product Manager 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 will show you how to start using MySQL tools on Windows, such as MySQL Workbench and MySQL Enterprise Monitor with the Query Analyzer.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-416.html


On Demand Webinar: Building MySQL on Windows

In this presentation we'll demonstrate how to setup an environment for building MySQL on Windows from source. While not strictly necessary, installing and running the Windows build system in a virtual machine allows for a single source repository to be shared among multiple flavors of Windows and/or other operating systems.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-455.html


On Demand Webinar: Getting Started Using MySQL as an Embedded Database with Windows Applications

In this presentation we will cover the benefits of deploying MySQL Embedded Database with your Windows applications. You will learn the basic "How-Tos" of installation, security and configuration. You'll also learn how to use MySQL Connector/NET and Connector/ODBC, and how to ensure high availability and fault tolerance for MySQL on Windows.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-490.html


On Demand Webinar: What's New in MySQL Connector/NET 6.2

In this presentation we will explore the benefits of developing Windows applications with MySQL. We will also cover development best practices with Visual Studio and how to get the most from the latest version MySQL Connector/Net.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-446.html


Presentation: MySQL and the ADO.NET Entity Framework

In these presentation slides, Reggie Burnett, MySQL Software Engineer at Oracle explained how to leverage the Microsoft ADO.NET Entity Framework with MySQL. He presented a brief overview of the entity framework, a peek under the hood on how Connector/Net works with the entity framework and demonstrated using MySQL and the Entity Framework together.

View the Presentation:
  http://www.mysql.com/why-mysql/windows/mysql_ado.net_entity_framework.php


Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server

CONCEIVIUM Business Solutions ensures that BlackBerry Enterprise Servers are up and performing optimally 24X7 for three of the world's top five banks, The Coca Cola Company, IBM Global Services and many other primarily Fortune 500 organizations. With MySQL, CONCEIVIUM's Mobile Monitor/Analyzer Agents have achieved a 70% performance gain and are now able to analyze over two gigabytes of data per day and perform thousands of transactions per second.

Read this Case Study:
  http://www.mysql.com/why-mysql/case-studies/mysql_cs_conceivium.php


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

Read this Case Study:
  http://www.mysql.com/why-mysql/case-studies/mysql_cs_sciencelogic.php

-------------------------------------------------------------------

Managing MySQL Applications

White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper highlights how MySQL Workbench can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php


White Paper: MySQL Enterprise Monitor 2.3: What's New

MySQL is proud to announce the new release of MySQL Enterprise Monitor 2.3. This release can be used to monitor MySQL Servers that are part of a MySQL Cluster deployment. MySQL Enterprise Monitor 2.3 also improves general monitoring for MySQL and the Operating System by adding a set of new graphs for monitoring transactions and the new features available in InnoDB 1.1.

Read the English White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php

Read the German White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.de

Read the Italian White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.it

Read the French White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.fr

Try MySQL Enterprise Edition Now:
  http://www.mysql.com/trials/


White Paper: MySQL Enterprise Monitor: Business Overview

The MySQL Enterprise Monitor is designed to scale DBA resources by providing a unified, informed view into the health, security, performance and availability of an entire MySQL server environment. This paper explores the MySQL Enterprise Monitor in detail and explains how it can be leveraged as a "Virtual MySQL DBA" assistant to help over-extended DBAs proactively manage more MySQL servers with less time and effort.

Read the English White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php

Read the German White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.de

Read the Italian White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.it

Read the Japanese White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.ja


White Paper: MySQL Cluster Manager

MySQL Cluster Manager simplifies the creation and management of the MySQL Cluster database by automating common management tasks. As a result, Database Administrators (DBAs) and Systems Administrators are more productive, enabling them to focus on strategic IT initiatives and respond more quickly to changing user requirements.

Read this White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_manager.php


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 the 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 Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-592.html


Demo: MySQL Workbench Demos

Watch these self-running demos to learn how MySQL Workbench can help with Data Modeling, Reverse and Forward Engineering, Change Management and Documentation.

Watch the Demos:
  http://www.mysql.com/products/workbench/demo.html


Case Study: Big Fish Games Triples Database Performance with MySQL Query Analyzer

Big Fish Games is a global leader in the online games industry, with over 25 million unique customer accounts and over 2.5 million visitors per month. MySQL allowed Big Fish Games to quickly grow their business with lower cost and hardware requirements, and has scaled with the company as it has grown into an industry leader. With the MySQL Query Analyzer, Big Fish Games was able to identify and analyze problematic SQL code, and tripled its database performance within three days, rather than weeks.

Read this Case Study:
  http://www.mysql.com/why-mysql/case-studies/mysql_cs_bigfishgames.php

-------------------------------------------------------------------

MySQL Training and Certification

Training: Introduction to MySQL 5.5

This one-day seminar covers all the new features and key enhancements to MySQL 5.5 and the MySQL Enterprise Edition, including Performance, Scalability, Availability and Backups. Instructor lecture is supported by recorded product demonstrations. By attending this course, you learn how to plan your use of the MySQL 5.5 product release more effectively.

Learn More:
  http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D71615GC10


Training: MySQL and PHP - Developing Dynamic Web 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&p_org_id=1001&lang=US


Training: MySQL for Developers

This course is the foundation course for developers planning on designing and implementing applications that make use of MySQL. It covers essential SQL statements for data design, querying, and programming.

Learn More:
  http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D61830GC10&p_org_id=1001&lang=US

View the Complete List of MySQL Training Courses:
  http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getsearchpage?page_id=13&p_search_category_id=1488


Certification: Save 20% and Get a Free Certification Retake with MySQL Certification Value Packages

Choose one of the exclusive MySQL packages to get on the fast track to MySQL certifications while saving 20%. Get two Live Virtual Classes to jumpstart your training, and then demonstrate your proficiency using the certification exam vouchers in the package to obtain two certifications. In addition, you will get the exclusive bonus of a free retake with each exam voucher, so you can take the exam a second time if needed at no additional cost.

Learn More:
  http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=532&p_org_id=1001&lang=US

-------------------------------------------------------------------

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://www.mysql.com/contact/

You can unsubscribe from this newsletter online:
  http://www.mysql.com/unsub?email=sanjay.ujina@gmail.com

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

Comment (0)

Articles in this newsletter:

Highlights

- White Paper: MySQL Enterprise Monitor 2.3: What's New
- White Paper: MySQL Reference Architectures for Massively Scalable Web Infrastructure
- Case Study: Tralix Delivers High SLAs and Extreme Performance with MySQL
- Live Webinar: What's New in Managing MySQL Cluster (January 12)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition (January 18)
- Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL (January 20)

New Product Releases

- New Release of MySQL Community Server 5.1.54 (GA)

Hints & Tips

- White Paper: A Visual Guide to Installing MySQL on Windows
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: A step by step guide to upgrading to MySQL 5.5
  - PlanetMySQL Blog: Some hidden goods in MySQL 5.5
  - PlanetMySQL Blog: Video: MySQL Cluster Overview by Bill Papp
  - PlanetMySQL Blog: InnoDB locking
  - PlanetMySQL Blog: KSCOPE11 - ODTUG Conference June 2011
  - PlanetMySQL Blog: Tuning InnoDB Configuration
  - PlanetMySQL Blog: Looking for a hack - Passing comment-like info through the binary log
  - PlanetMySQL Blog: MySQL Server and NUMA architectures
  - PlanetMySQL Blog: Are you using the deadline scheduler?
  - PlanetMySQL Blog: MySQL v5.5 and Python

Events

- Live Webinar: MySQL 5.5 GA: Technology Update - APAC (January 13 & 20)
- Live Webinar: MySQL Enterprise Backup - Online Hot Backup for MySQL - Italian (January 20)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - German (January 21)
- On-Demand Webinar: Accelerating Telecoms Transformation with Web 2.0 Data Management
- On-Demand Webinar: MySQL Essentials Part 6 - How to Develop Simple Java Applications with MySQL

-------------------------------------------------------------------

Highlights

White Paper: MySQL Enterprise Monitor 2.3: What's New

MySQL is proud to announce the new release of MySQL Enterprise Monitor 2.3. This release can be used to monitor MySQL Servers that are part of a MySQL Cluster deployment. MySQL Enterprise Monitor 2.3 also improves general monitoring for MySQL and the Operating System by adding a set of new graphs for monitoring transactions and the new features available in InnoDB 1.1.

Read the English White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php

Read the German White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.de

Read the Italian White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.it

Read the French White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.fr


White Paper: MySQL Reference Architectures for Massively Scalable Web Infrastructure

This whitepaper presents 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. The paper also discusses the unique requirements for Large Social Networking applications.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_high-availability_webrefarchs.php


Case Study: Tralix Delivers High SLAs and Extreme Performance with MySQL

Tralix Corporation is the e-invoicing and e-marketing market-share leader in Mexico. In January 2011, a new Mexican law will come into effect mandating that invoices over MXN 2000 (~USD160) are electronic. With MySQL as its e-invoicing products' database, hosted and appliance-based, Tralix is prepared to meet this huge increase in demand.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql-cs-tralix.php


Live Webinar: What's New in Managing MySQL Cluster Wednesday, January 12, 2011 - 9:00am PT

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 Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-599.html?p=newsletter


Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition Tuesday, January 18, 2011 - 9:00am PT

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. 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 this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-597.html?p=newsletter


Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL Thursday, January 20, 2011 - 9:00am PT

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 Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-598.html?p=newsletter

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.1.54 (GA)

MySQL Community Server 5.1.54, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.54 is recommended for use on production systems.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-54.html

Download now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads

-------------------------------------------------------------------

Hints & Tips

White Paper: A Visual Guide to Installing MySQL on Windows

The following guide is meant to make getting started with MySQL easily for Windows developers, system administrators and Microsoft SQL Server DBAs that are new to MySQL. This paper will guide you through the steps and tools needed to get up and running quickly with MySQL on Windows using familiar terms, comparisons, and language.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/visual_guide_to_installing_mysql_windows.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: A step by step guide to upgrading to MySQL 5.5 Ovais Tariq

MySQL 5.5 has created a lot of hype and its not just hype. There are major performance enhancements not only in the MySQL server itself but in the newer InnoDB storage engine shipped with MySQL 5.5. That's exactly the reason why I have myself upgraded to MySQL 5.5. Now since I haven't come across a guide to help in upgrading to MySQL 5.5, I thought why not make one myself.

Read the PlanetMySQL BlogPost:
  http://www.ovaistariq.net/490/a-step-by-step-guide-to-upgrading-to-mysql-5-5/


PlanetMySQL Blog: Some hidden goods in MySQL 5.5 Giuseppe Maxia

The announcement of MySQL 5.5 released as GA has outlined the improvements in this version, which indeed has enough good new features to excite any user. There are two additions, though, that were lost in the noise of the bigger features, and I would like to spend a few words for each of them.

Read the PlanetMySQL BlogPost:
  http://datacharmer.blogspot.com/2010/12/some-hidden-goods-in-mysql-55.html


PlanetMySQL Blog: Video: MySQL Cluster Overview by Bill Papp Sheeri Cabral

At the December 2010 Boston MySQL User Group meeting a few days ago, Oracle/MySQL sales engineer Bill Papp gave a presentation on 'An Overview of MySQL Cluster'.

Read the PlanetMySQL BlogPost:
  http://palominodb.com/blog/2010/12/16/video-mysql-cluster-overview-bill-papp


PlanetMySQL Blog: InnoDB locking
Mark Callaghan

How well do you understand InnoDB locking? The documentation is good but would benefit from a few examples. If you want to debug contention for InnoDB then you need to understand record, gap and next-key locks, the reasons for using next-key locks and the locks used by different statements.

Read the PlanetMySQL BlogPost:
  http://www.facebook.com/note.php?note_id=479123255932


PlanetMySQL Blog: KSCOPE11 - ODTUG Conference June 2011 Chris Schneider

This year I found an interesting conference that brings both Oracle and MySQL users together, KSCOPE11. This will be the second year with a dedicated MySQL track at Kscope11. There will be a clear focus on providing both developers and DBAs the right information, tools and best practices within MySQL, emphasizing scalability and performance.

Read the PlanetMySQL BlogPost:
  http://everythingmysql.ning.com/profiles/blogs/kscope11-odtug-conference


PlanetMySQL Blog: Tuning InnoDB Configuration Ovais Tariq

I had earlier written a post on tuning the MySQL server configuration which was more geared towards the MyISAM storage engine. While that is not because I didn't intend on ignoring InnoDB, but because I had planned a whole post on tuning InnoDB related configuration. So this post is the post that I had planned, and I have discussed the major configuration parameters in here that should help you out most of the times.

Read the PlanetMySQL BlogPost:
  http://www.ovaistariq.net/496/tuning-innodb-configuration/


PlanetMySQL Blog: Looking for a hack - Passing comment-like info through the binary log Giuseppe Maxia

I am facing an interesting problem. I need to mark somehow a statement in such a way that the comment is preserved through the binary log.

Read the PlanetMySQL BlogPost:
  http://datacharmer.blogspot.com/2010/12/looking-for-hack-passing-comment-like.html


PlanetMySQL Blog: MySQL Server and NUMA architectures Mikael Ronstrom

When you run MySQL on a large NUMA box it is possible to control the memory placement and the use of CPUs through the use of numactl. Most modern servers are NUMA boxes nowadays.

Read the PlanetMySQL BlogPost:
  http://mikaelronstrom.blogspot.com/2010/12/mysql-server-and-numa-architectures.html


PlanetMySQL Blog: Are you using the deadline scheduler?
Partha Dutta

There have been many posts about performance, benchmarking and the results. Many DBAs have talked in the past about the deadline scheduler, available in all modern Linux distributions. The deadline scheduler is very effective for database systems, as it tries to prevent starvation of I/O requests.

Read the PlanetMySQL BlogPost:
  http://ralpartha.blogspot.com/2010/12/are-you-using-deadline-scheduler-part-1.html


PlanetMySQL Blog: MySQL v5.5 and Python
Geert JM Vanderkelen

MySQL v5.5 is GA, but is it working with Python? Yes, it does. Below you'll find some quick, small tests I did with MySQLdb, oursql and our own MySQL Connector/Python.

Read the PlanetMySQL BlogPost:
  http://geert.vanderkelen.org/post/464/

-------------------------------------------------------------------

Events

Live 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 Webinar on January 13 at 14:00 China Time:
  http://dev.mysql.com/news-and-events/web-seminars/display-601.html?p=newsletter

Register for the Japanese Webinar on January 13 at 18:00 JST:
  http://dev.mysql.com/news-and-events/web-seminars/display-602.html?p=newsletter

Register for the English Webinar on January 20 at 14:00 Singapore Time:
  http://dev.mysql.com/news-and-events/web-seminars/display-603.html?p=newsletter


Live Webinar: MySQL Enterprise Backup - Online Hot Backup for MySQL - Italian Thursday, January 20, 2011 - 10:00 CET

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 Italian Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-595.html


Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - German Friday, January 21, 2011 - 11:00 CET

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. 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 this German Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-600.html


On-Demand Webinar: Accelerating Telecoms Transformation with Web 2.0 Data Management

The convergence of communication networks onto one which is IP (Internet Protocol) based is revolutionizing today's telecommunications industry. Communications Service Providers (CSPs) are challenged to deliver compelling new personalized services with greater agility and lower costs than ever before.

Attend this webinar to learn how leading Communications Service Providers, Network Equipment Manufacturers and ISVs are transforming telecommunications services with MySQL.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-585.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, including installation pre-requisites and process, options in architecture and frameworks, as well as how to handle transactions.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-591.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/

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/2010/2010-12.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.

Comment (0)

Highlights

- Webcast: MySQL Technology Update - Announcing MySQL 5.5 GA
- Developer Zone Interview: MySQL 5.5 is GA - Interview with Tomas Ulin
- White Paper: What's New in MySQL 5.5
- White Paper: MySQL Enterprise Edition: Database. Management. Support.
- Oracle Magazine: Open for Business - MySQL Community Wins with Better Innovation, Support and Integration
- MySQL Selected as the Best Database by Linux Journal Reader's Choice Awards 2010
- Case Study: MySQL Powers the Market Leading Telecoms Network Management Framework
- Case Study: Central Banks Worldwide Rely on Bank of Finland's MySQL Based Simulator
- Live Webinar: What's New in Managing MySQL Cluster (January 12, 2011)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition (January 18, 2011)
- Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL (January 20, 2011)

New Product Releases

- New Release of MySQL Community Server 5.5.8 (GA)
- New Release of MySQL Cluster 7.1.9 Binary (GA)
- New Release of MySQL Workbench 5.2.31 (GA)
- New Release of MySQL Connector/J 5.1.14 (GA)
- New Release of MySQL Connector/ODBC 5.1.8 (GA)

Hints & Tips

- Blog Series: MySQL 5.5
- White Paper: MySQL Reference Architectures for Massively Scalable Web Infrastructure
- White Paper: MySQL on Windows - Why, Where and How
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL At Scale - Zynga Games
  - PlanetMySQL Blog: Testing MySQL 5.5 semi-synchronous replication
  - PlanetMySQL Blog: MySQL Performance: 5.5 and InnoDB thread concurrency
  - PlanetMySQL Blog: Working with MySQL on Windows
  - PlanetMySQL Blog: MySQL Cluster Manager 1.1 available!
  - PlanetMySQL Blog: Monitoring MySQL Cluster with MySQL Enterprise Monitor 2.3
  - PlanetMySQL Blog: How To Build MySQL Releases
  - PlanetMySQL Blog: How to setup MySQL on a DRBD volume
  - PlanetMySQL Blog: Excluding databases from mysqldump
  - PlanetMySQL Blog: A quick summary of patch contributions included in MySQL 5.5
  - PlanetMySQL Blog: Does the insert buffer work?
  - PlanetMySQL Blog: 8 substitution rules for running SQL in parallel
  - PlanetMySQL Blog: Submitting MySQL talks to upcoming Oracle User Group Events in Europe

Spotlight: MySQL Workbench

- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- Blog: MySQL Workbench Plugin: Auto-Create Foreign Keys
- Blog: MySQL Workbench: Introducing Utilities
- Blog: MySQL Workbench: Manage MySQL on Windows Servers the Windows Way

Events

- Live Webinar: MySQL Enterprise Backup - Italian (January 20, 2011)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - German (January 21, 2011)

-------------------------------------------------------------------

Highlights

Webcast: MySQL Technology Update - Announcing MySQL 5.5 GA

In this webcast, Tomas Ulin, Vice President of MySQL development, and Rob Young, Senior MySQL Product Manager, announced the availability of MySQL 5.5 GA release and provided updates on the latest developments with MySQL.

Watch the Webcast:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-596.html


Developer Zone Interview: MySQL 5.5 is GA - Interview with Tomas Ulin

Oracle Magazine features editor Rich Schwerin interviews Tomas Ulin, Vice President, MySQL Engineering, who answers questions about the GA release of MySQL 5.5.

Read the Interview:
  http://dev.mysql.com/tech-resources/interviews/thomas-ulin-mysql-55.html


White Paper: What's New in MySQL 5.5

This white paper provides a look at what's new in MySQL 5.5, including greatly improved performance, scalability, and usability specifically on today's modern, multi-processing hardware, software, and middleware architectures. Sysbench benchmarks demonstrate performance improvements of up to 370% and 540% faster performance on Linux and Windows respectively. Also, new Semi-synchronous Replications and MySQL Performance Schema provide developers and DBAs with improved tools for building high performance, scalable applications.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-whatsnew-mysql-55.php


White Paper: MySQL Enterprise Edition: Database. Management. Support.

MySQL Enterprise Edition combines the MySQL database, online backup, monitoring, management, visual database design and SQL developments tools. The MySQL Enterprise Edition is backed by Oracle Premier Support, 24x7 global enterprise-class support services, specifically designed to mitigate risk and ensure you meet customer and end-user Service Level Agreements (SLAs).

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_ready.php


Oracle Magazine: Open for Business - MySQL Community Wins with Better Innovation, Support and Integration David A. Kelly

Sometimes, relatively small things can make a big impact. Take the case of the MySQL database. First released in 1995 and purchased by Sun in 2008, MySQL has quickly graduated from the realm of hobbyists to the world of business, becoming the leading open source database for many Web applications and an integral part of the LAMP (Linux, Apache, MySQL, PHP) Web application stack. Almost a year after Oracle's acquisition of Sun, MySQL plays an even bigger role in enterprises of all sizes worldwide.

Read this Article:
  http://www.oracle.com/technetwork/issue-archive/2011/11-jan/o11mysql-194109.html


MySQL Selected as the Best Database by Linux Journal Reader's Choice Awards 2010

Voted by more than 12,000 readers, MySQL remains the "Best Database" selected by Linux Journal Reader's Choice Awards three years running.

Learn More:
  http://www.linuxjournal.com/content/readers-choice-awards-2010


Case Study: MySQL Powers the Market Leading Telecoms Network Management Framework

WebNMS, the leading network and element management solution, has been embedding MySQL as the default database for over ten years. To accommodate ever more stringent demands for availability and performance, WebNMS and MySQL can write up to 10 million rows daily and support 2,000 transactions per second across a replicated architecture and are positioned to address the explosive growth driven by Long Term Evolution (LTE) and mobile broadband in next generation telecom networks.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql-cs-webnms.php


Case Study: Central Banks Worldwide Rely on Bank of Finland's MySQL Based Simulator

The Bank of Finland acts as Finland's central bank, national monetary authority, and member of the European System of Central Banks and the Eurosystem.

The BoF developed a MySQL based versatile Payment and Settlement System Simulator for making payments and settlement system simulations. Running on Windows, the application has been widely adopted by Central Bank Economists Worldwide.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_bankoffinland.php


Live Webinar: What's New in Managing MySQL Cluster Wednesday, January 12, 2011 - 9:00am PT

By their very nature, clustered environments involve more effort and resource to administer than standalone systems, and the same is true of MySQL Cluster, the database designed for web-scale throughput with carrier-grade availability.

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 Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-599.html?p=newsletter


Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition Tuesday, January 18, 2011 - 9:00am PT

MySQL, the world's most popular open source database, powers today's most demanding web sites and applications. 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. 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 this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-597.html?p=newsletter


Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL Thursday, January 20, 2011 - 9:00am PT

Online backup has been one of the most requested features for MySQL. With MySQL Enterprise Backup, developers and DBAs have the 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 Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-598.html?p=newsletter

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.5.8 (GA)

We are proud to present the MySQL Server 5.5.8 GA release, the first 5.5 production version of the world's most popular open source database. MySQL 5.5.8 is recommended for use on production systems.

MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware. MySQL 5.5 also provides a number of other new enhancements, including InnoDB I/O subsystem changes, enhanced Solaris Support as well as diagnostic and monitoring capabilities.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/news-5-5-8.html

Download Now:
  http://dev.mysql.com/downloads/mysql/

Read the Documentation "What's New in MySQL 5.5":
  http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html


New Release of MySQL Cluster 7.1.9 Binary (GA)

The binary version for MySQL Cluster 7.1.9 has been released.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-5-1-51-ndb-7-1-9.html

Download Now:
  http://dev.mysql.com/downloads/cluster/


New Release of MySQL Workbench 5.2.31 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.31. This is a maintenance release focusing on general product improvement and usability.

View the Complete List of Changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-31.html

Download Now:
  http://dev.mysql.com/downloads/workbench/


New Release of MySQL Connector/J 5.1.14 (GA)

MySQL Connector/J 5.1.14, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.14 is suitable for use with any MySQL version including MySQL-5.0, MySQL-5.1 or MySQL-5.5.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/cj-news-5-1-14.html

Download Now:
  http://dev.mysql.com/downloads/connector/j/5.1.html


New Release of MySQL Connector/ODBC 5.1.8 (GA)

MySQL Connector/ODBC 5.1.8, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the latest release of the 5.1 series and is suitable for use with any MySQL version since 4.1.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-news-5-1-8.html

Download Now:
  http://dev.mysql.com/downloads/connector/odbc/5.1.html

-------------------------------------------------------------------

Hints & Tips

Blog Series: MySQL 5.5
Rob Young

MySQL 5.5 is GA now so I thought I would create a series of blogs that highlight the key new features. I will start with a rundown of where we have made improvements and then expand into details as things progress.

Read the Blog Post "MySQL 5.5 - Performance and Scalability Unleashed!":
  http://blogs.oracle.com/mysql/2010/11/mysql_55_performance_and_scalability_unleashed.html

Read the Blog Post "MySQL 5.5 - What's New in Replication":
  http://blogs.oracle.com/mysql/2010/11/mysql_55_whats_new_in_replication.html

Read the Blog Post "MySQL 5.5 - Improved manageability, efficiency for InnoDB":
  http://blogs.oracle.com/mysql/2010/11/mysql_55_improved_manageability_efficiency_for_innodb.html


White Paper: MySQL Reference Architectures for Massively Scalable Web Infrastructure

This whitepaper presents 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. The paper also discusses the unique requirements for Large Social Networking applications.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_high-availability_webrefarchs.php


White Paper: MySQL on Windows - Why, Where and How

Why is the world's most popular open source database so popular on Windows? What are the applications for which one should consider MySQL on Microsoft's platform? How should Windows shops relying on Microsoft databases get going with MySQL? Those are the questions we aim to answer in this guide.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_on_windows_wwh.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: MySQL At Scale - Zynga Games Venu Anuganti

Recently I am part of Zynga's database team as I was pretty much impressed with the company's database usage. Everyone knows how popular Zynga games like Farmville, Cafe World, Mafia Wars, Poker, FrontierVille, FishVille, PetVille and Treasure Island etc are.

As a matter of fact, Zynga may be the second largest MySQL user after Facebook. All games at Zynga are currently powered by MySQL as the backend storage along with memcache as the middle caching layer.

Read the PlanetMySQL BlogPost:
  http://venublog.com/2010/12/02/mysql-at-scale-zynga-games/


PlanetMySQL Blog: Testing MySQL 5.5 semi-synchronous replication Giuseppe Maxia

A few days ago I saw an article about Semi-Synchronous Replication in MySQL 5.5. It asks questions, and doesn't give answers beyond gut feeling. So I thought that I would do some practical testing of this new feature.

Read the PlanetMySQL BlogPost:
  http://datacharmer.blogspot.com/2010/11/testing-mysql-55-semi-synchronous.html


PlanetMySQL Blog: MySQL Performance: 5.5 and InnoDB thread concurrency Dimitri Kravtchuk

Until now, when you observed a performance degradation with a growing number of concurrent user sessions in InnoDB, the most simple way to avoid such a degradation was to set innodb_thread_concurrency to something different from zero - and since 5.5.4 the most optimal value was around of 32 ... But all the latest performance improvements in 5.5 are so good that it become less and less true now.

Read the PlanetMySQL BlogPost:
  http://dimitrik.free.fr/blog/archives/11-01-2010_11-30-2010.html#116


PlanetMySQL Blog: Working with MySQL on Windows Anders Karlsson

This is the first post in an attempt to write about how to get along with MySQL on Windows. Before I start, I want to stress that the focus here is seasoned Windows users getting started with MySQL.

Read the PlanetMySQL BlogPost:
  http://karlssonondatabases.blogspot.com/2010/12/working-with-mysql-on-windows-part-1.html


PlanetMySQL Blog: MySQL Cluster Manager 1.1 available!
Andrew Morgan

As the title of this post suggests, MySQL Cluster Manager 1.1 is now available - but this actually has a double meaning: 1. MySQL Cluster Manager 1.1 is GA, and 2. Everyone is now able to download and try it!

Read the PlanetMySQL BlogPost:
  http://www.clusterdb.com/mysql-cluster/mysql-cluster-manager-1-1-available/


PlanetMySQL Blog: Monitoring MySQL Cluster with MySQL Enterprise Monitor 2.3 Andrew Morgan

A few months ago, I posted a walkthrough of how to extend MySQL Enterprise Monitor in order to monitor MySQL Cluster. The great news is that as of MySQL Enterprise Monitor 2.3 this functionality is included in the core product and so there is no need to add the extra features in manually.

Read the PlanetMySQL BlogPost:
  http://www.clusterdb.com/mysql-cluster/monitoring-mysql-cluster-with-mysql-enterprise-monitor/


PlanetMySQL Blog: How To Build MySQL Releases Jonathan Perkin

One of the major benefits from the CMake work available in MySQL 5.5 is that in the MySQL Release Engineering team we have been able to make it easy for users and developers to build MySQL exactly as we do for the official releases.

Read the PlanetMySQL BlogPost:
  http://www.perkin.org.uk/blog/2010/11/how-to-build-mysql-releases/


PlanetMySQL Blog: How to setup MySQL on a DRBD volume Frederik Konietzny

This document describes how to setup a failover system with MySQL and DRBD (Distributed Replicated Block Device).

Read the PlanetMySQL BlogPost:
  http://frederikkonietzny.de/wp/2010/12/08/howto-setup-mysql-on-a-drbd-volume/


PlanetMySQL Blog: Excluding databases from mysqldump Giuseppe Maxia

A question that came up during the MySQL track at the UKOUG conference in Birmingham was "Can I exclude only a few databases from mysqldump? Let's say that I have 50 databases, and I want to dump all of them, except a few."

Read the PlanetMySQL BlogPost:
  http://datacharmer.blogspot.com/2010/12/excluding-databases-from-mysqldump.html


PlanetMySQL Blog: A quick summary of patch contributions included in MySQL 5.5 Lenz Grimmer

I've been going through our bugs database to compile a list of some noteworthy patch contributions that have been included in the MySQL 5.5 release. Of course any contribution is appreciated, no matter how small!

Read the PlanetMySQL BlogPost:
  http://www.lenzg.net/archives/325-A-quick-summary-of-patch-contributions-included-in-MySQL-5.5.html


PlanetMySQL Blog: Does the insert buffer work?
Mark Callaghan

The insert buffer in InnoDB buffers pending inserts for secondary index pages to avoid blocking on disk reads for those pages during secondary index maintenance. This feature has been renamed the change buffer for InnoDB in MySQL 5.5 as it has been enhanced to support more than inserts.

Read the PlanetMySQL BlogPost:
  http://www.facebook.com/note.php?note_id=460565850932


PlanetMySQL Blog: 8 substitution rules for running SQL in parallel Justin Swanhart

A lot of the work that I do on my personal projects such as Flexviews and Shard-Query involves taking a query and manipulating it in such a way as to obtain the same result, but in a different manner. Flexviews amortizes aggregation over time, making it possible to maintain summary tables incrementally. Shard-Query spreads queries over multiple Gearman workers, allowing it to run queries on one or more MySQL servers in parallel.

Read the PlanetMySQL BlogPost:
  http://swanhart.livejournal.com/134177.html


PlanetMySQL Blog: Submitting MySQL talks to upcoming Oracle User Group Events in Europe Lenz Grimmer

I've been informed about two upcoming events/conferences that are organized by the independent Oracle user groups of the respective countries. If you're nearby, how about submitting a talk about a MySQL-related topic?

Read the PlanetMySQL BlogPost:
  http://www.lenzg.net/archives/322-Submitting-MySQL-talks-to-upcoming-Oracle-User-Group-Events-in-Europe.html

-------------------------------------------------------------------

Spotlight: MySQL Workbench

White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how the MySQL Workbench product from MySQL can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php


Blog: MySQL Workbench Plugin: Auto-Create Foreign Keys Alfredo Kojima

To automatically create Foreign Key relationships is a typical use case for developers working with the MyISAM storage engine. This has been a popular topic on the Blog and forums so we're revisiting it here - with a new and improved plugin written in Python.

Read this BlogPost:
  http://wb.mysql.com/?p=777


Blog: MySQL Workbench: Introducing Utilities Mats Kindahl

To make it easier to work with the server, the latest release of the MySQL Workbench - version 5.2.31 - contains a set of Python scripts intended to make the life easier for DBAs by providing easy-to-use utilities for common tasks, which were introduced in the blog MySQL Workbench: Utilities.

Read this BlogPost:
  http://wb.mysql.com/?p=873


Blog: MySQL Workbench: Manage MySQL on Windows Servers the Windows Way Mike Lischke

The MySQL team has been continuously improving its products on the Windows platform. Along this line, we've responded to a request from our users of Workbench on Windows - to provide remote access to Windows Servers using Windows management methods - as an alternative to SSH.

Read this BlogPost:
  http://wb.mysql.com/?p=892

-------------------------------------------------------------------

Events

Live Webinar: MySQL Enterprise Backup - Italian Thursday, January 20, 2011 - 10:00 CET

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 Italian Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-595.html?p=newsletter


Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - German Friday, January 21, 2011 - 11:00 CET

MySQL, the world's most popular open source database, powers today's most demanding web sites and applications. 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. 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 this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-600.html?p=newsletter


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/

You can unsubscribe from this newsletter online:
  http://dev.mysql.com/unsub?email=sanjay.ujina@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/2010/2010-12.html

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

Comment (0)

Highlights

- Article: Introduction to MySQL 5.5
- Event: MySQL Sessions at UKOUG Conference Series Technology and E-Business Suite 2010
- Call for MySQL Participation at Collaborate 11 (April 10 - 14, 2011)
- Live Webinar: Delivering Scalability and High Availability with MySQL 5.5 Replication Enhancements (October 12)
- Live Webinar: MySQL Essentials Part 5: How to Develop Simple PHP Applications for MySQL (October 19)

New Product Releases

- New Release of MySQL Community Server 5.5.6 (RC)
- New Release of MySQL Community Server 5.1.51 (GA)
- New Release of MySQL Workbench 5.2.28 (GA)
- New Release of MySQL Connector/Net 6.3.4 (GA)
- New Release of MySQL Proxy 0.8.1 (Alpha)

Hints & Tips

- White Paper: Building Carrier-Grade Subscriber Databases Using MySQL Cluster
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL 5.5: InnoDB Performance Improvements on Windows
  - PlanetMySQL Blog: Online Schema Change for MySQL
  - PlanetMySQL Blog: MySQL 5.5: InnoDB as Default Storage Engine
  - PlanetMySQL Blog: Multiple Buffer Pools in MySQL 5.5
  - PlanetMySQL Blog: MySQL Performance: 5.5 Notes
  - PlanetMySQL Blog: MySQL 5.5: InnoDB adaptive_flushing - How it works?
  - PlanetMySQL Blog: MySQL 5.5: InnoDB Change Buffering
  - PlanetMySQL Blog: InnoDB Revision History
  - PlanetMySQL Blog: Resolving the "Can't create IP socket: No such file or directory" Error on Windows
  - PlanetMySQL Blog: MySQL Workbench Plugin: mforms example and slow query log statistics
  - PlanetMySQL Blog: Tracking mutex locks in a process list, MySQL 5.5's PERFORMANCE_SCHEMA
  - PlanetMySQL Blog: Testing Drupal 7 on a virtual appliance with MySQL 5.1 and the InnoDB plugin
  - PlanetMySQL Blog: Farewell CHM, hello EPUB!
  - PlanetMySQL Blog: How to speed up Sysbench on MySQL Cluster by 14x
  - PlanetMySQL Blog: Spins and Contentions in MySQL Cluster

Events

- Live Webinar: What's New with MySQL (October 14) - Italian
- Live Webinar: Designing MySQL Databases (October 14 & 15) - EMEA
- Live Webinar: Practical Partitioning With MySQL: When, Why and How (October 26)

-------------------------------------------------------------------

Highlights

Article: Introduction to MySQL 5.5

It's been a busy year for MySQL. Perhaps you've heard. Here are some recent improvements to the speed, scalability, and user-friendliness of the MySQL database and the InnoDB storage engine that we think deserve their own headlines. Now is a great time to test the 5.5 release and give feedback to the MySQL engineering team.

Read this Article:
  http://dev.mysql.com/tech-resources/articles/introduction-to-mysql-55.html


Event: MySQL Sessions at UKOUG Conference Series Technology and E-Business Suite 2010

UK Oracle User Group's annual Technology & E-Business Suite conference is taking place from November 29th to December 1st at the ICC in Birmingham. There will be numerous MySQL sessions aiming to help you further improve your MySQL deployment. Join the 1,500 attendees to learn and share the latest product information.

Learn More and Register:
  http://www.oug.org/techebs


Call for MySQL Participation at Collaborate 11 - Submit Your Proposal by October 11

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. 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/tabid/153/Default.aspx


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://dev.mysql.com/news-and-events/web-seminars/display-572.html?p=newsletter


Live Webinar: MySQL Essentials Part 5: How to Develop Simple PHP Applications for MySQL Tuesday, October 19, 2010 - 9:00am PT

In this technical webinar, MySQL developer Johannes Schlüter will show you the essentials for creating dynamic web content using MySQL and PHP. He will also discuss many of the fundamental elements used when developing PHP applications with MySQL, including the frameworks, APIs, security features, and asynchronous queries.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-575.html?p=newsletter

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.5.6-rc (RC)

MySQL Server 5.5.6-rc, a new version of the popular Open Source Database Management System, has been released. The "-rc" suffix indicates this is a "release candidate". MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/news-5-5-6.html

Read the Documentation:
  http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html

Download Now:
  http://dev.mysql.com/downloads/mysql/5.5.html#downloads


New Release of MySQL Community Server 5.1.51 (GA)

MySQL Community Server 5.1.51, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.51 is recommended for use on production systems.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-51.html

Download Now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Workbench 5.2.28 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.28. This maintenance release features improvements to the Workbench scripting Shell as well as various fixes. The enhancements to the Scripting Shell make it easier to develop and use Workbench Scripts and Plug-ins.

View the Complete List of Changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-28.html

Download Now:
  http://dev.mysql.com/downloads/workbench/

Learn More about Workbench Scripting and Plug-in:
  http://wb.mysql.com/?page_id=664


New Release of MySQL Connector/Net 6.3.4 (GA)

We're proud to announce the next release of MySQL Connector/Net version 6.3.4. This release is GA (Generally Available). We hope you will make MySQL Connector/Net your preferred set of .NET components including our ADO.Net library and other Microsoft .NET frameworks components such as our Visual Studio plug-in and Entity Framework for MySQL. New features include:

- The ability to dynamically enable/disable query analysis at runtime
- Visual Studio 2010 compatibility
- Improved compatibility with Visual Studio wizards using our new SQL Server mode
- Support for Model-First development using Entity Framework
- Nested transaction scopes

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-6-3-4.html

Download Now:
  http://dev.mysql.com/downloads/connector/net/6.3.html

Read the Tutorial:
  http://dev.mysql.com/doc/refman/5.1/en/connector-net-tutorials.html


New Release of MySQL Proxy 0.8.1 (Alpha)

We are pleased to announce MySQL Proxy 0.8.1, an alpha release. It makes the admin plug-in more useful by reporting better errors and explicitly enforces the options --admin-username, --admin-password and --admin-lua-script. We also bundle a simple admin script that you can use as a starting point for your own developments in lib/admin.lua.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-news-0-8-1.html

Download Now:
  http://dev.mysql.com/downloads/mysql-proxy/

-------------------------------------------------------------------

Hints & Tips

White Paper: Building Carrier-Grade Subscriber Databases Using MySQL Cluster

In this paper we describe how MySQL Cluster Carrier Grade Edition can be used to build a scalable, highly available, geographically replicated Subscriber Database. We show how user-defined partitioning and distribution keys help a subscriber database to scale its performance linearly with cluster size, while maintaining the benefits of a relational database, accessed via an SQL API.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_subscriber_db.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: MySQL 5.5: InnoDB Performance Improvements on Windows Calvin Sun

At MySQL, we know our users want Performance, Scalability, Reliability, and Availability, regardless of the platform they choose to deploy. We have always had excellent benchmarks on Linux, and with MySQL 5.5, we are also working hard on improving performance on Windows.

Read the PlanetMySQL BlogPost:
  http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-performance-improvements-on-windows/


PlanetMySQL Blog: Online Schema Change for MySQL Mark Callaghan

It is great to be able to build small utilities on top of an excellent RDBMS. Thank you MySQL. This is a small but complex utility to perform online schema change for MySQL.

Read the PlanetMySQL BlogPost - Part I:
  http://www.facebook.com/notes/mysql-at-facebook/online-schema-change-for-mysql/430801045932

Read the PlanetMySQL BlogPost - Part II:
  http://www.facebook.com/note.php?note_id=431123910932


PlanetMySQL Blog: MySQL 5.5: InnoDB as Default Storage Engine John Russell

MySQL has a well-earned reputation for being easy-to-use and delivering performance and scalability. In previous versions, MyISAM was the default storage engine. In our experience, most users never changed the default settings. With MySQL 5.5, InnoDB becomes the default storage engine. Again, we expect most users will not change the default settings. But, because of InnoDB, the default settings deliver the benefits users expect from their RDBMS - ACID Transactions, Referential Integrity, and Crash Recovery.

Read the PlanetMySQL BlogPost:
  http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-as-default-storage-engine/


PlanetMySQL Blog: Multiple Buffer Pools in MySQL 5.5 Mikael Ronstrom

In our work to improve MySQL scalability we tested many opportunities to scale the MySQL Server and the InnoDB storage engine. The InnoDB buffer pool was often one of the hottest contention points in the server. This is very natural since every access to a data page, UNDO page, index page uses the buffer pool and even more so when those pages are read from disk and written to disk.

Read the PlanetMySQL BlogPost:
  http://mikaelronstrom.blogspot.com/2010/09/multiple-buffer-pools-in-mysql-55.html


PlanetMySQL Blog: MySQL Performance: 5.5 Notes Dimitri Kravtchuk

Since 5.5 is announced as Release Candidate now, I'll not compare it with 5.1 anymore - I think there was written enough about the performance gain even since introduction of 5.4. From the other side, we want to be sure that the final 5.5 will be at least as good as 5.5.4 release, and here the feedback from real users with real workloads will be very precious! So, please, don't keep quiet!

Read the PlanetMySQL BlogPost:
  http://dimitrik.free.fr/blog/archives/2010/09/mysql-performance-55-notes.html


PlanetMySQL Blog: MySQL 5.5: InnoDB adaptive_flushing - How it works?
Inaam Rana

Write-heavy workloads can reach a situation where InnoDB runs out of usable space in its redo log files. When that happens, InnoDB does a lot of disk writes to create space and you can see a drop in server throughput for a few seconds. From InnoDB plugin 1.0.4 we have introduced the 'innodb_adaptive_flushing' method that uses a heuristic to try to flush enough pages in the background so that it is rare for the very active writing to happen.

Read the PlanetMySQL BlogPost:
  http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-adaptive_flushing-how-it-works/


PlanetMySQL Blog: MySQL 5.5: InnoDB Change Buffering Marko Mäkelä

To speed up bulk loading of data, InnoDB implements an insert buffer, a special index in the InnoDB system tablespace that buffers modifications to secondary indexes when the leaf pages are not in the buffer pool. Batched merges from the insert buffer to the index pages result in less random access patterns than when updating the pages directly. This speeds up the operation on hard disks.

Read the PlanetMySQL BlogPost:
  http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-change-buffering/


PlanetMySQL Blog: InnoDB Revision History Vasil Dimov

This is a brief overview of the history of InnoDB with respect to the Version Control Systems (VCS) that were used for developing. It could be useful to people who want to trace back in time to find the origins of bugs or features.

Read the PlanetMySQL BlogPost:
  http://blogs.innodb.com/2010/09/innodb-revision-history/


PlanetMySQL Blog: Resolving the "Can't create IP socket: No such file or directory" Error on Windows Chris Calender

Every now and again, when installing or upgrading MySQL on Windows, mysqld will not start, and it's not due to any changes in the config file, using some old config option, permissions, something changed/removed, or anything else. It just simply fails, when you know it should work.

Read the PlanetMySQL BlogPost:
  http://www.chriscalender.com/?p=140


PlanetMySQL Blog: MySQL Workbench Plugin: mforms example and slow query log statistics Lee Stigile

As an update to my prior post, I've added a form to the workbench plugin. Now, the user can select a slow query log file and generate statistics from it. The plugin scans the slow query log, aggregates similar queries, and provides summary statistics for each group. It's very similar to the mysqldumpslow perl utility, which is included in the mysql bin folder. However, as a plugin, it's easier to use on a Windows server as it doesn't require you to install perl.

Read the PlanetMySQL BlogPost:
  http://lstigile.wordpress.com/2010/09/29/mysql-workbench-plugin-mforms-example-and-slow-query-log-statistics/


PlanetMySQL Blog: Tracking mutex locks in a process list, MySQL 5.5's PERFORMANCE_SCHEMA Mark Leith

Internally MySQL uses various methods to manage (or, block) concurrent access to shared structures within the server - the most common being mutexes (or Mutual Exclusion locks), RW Locks, or Semaphores. Each have slightly different properties on how different threads are allowed to interact when trying to access these synchronization points.

Read the PlanetMySQL BlogPost:
  http://www.markleith.co.uk/?p=377


PlanetMySQL Blog: Testing Drupal 7 on a virtual appliance with MySQL 5.1 and the InnoDB plugin Lenz Grimmer

The Drupal community just recently released another alpha test release of their upcoming Drupal 7 version, to shake out the remaining bugs and to encourage more users to test it.

If you would like to give it a try, but you don't have a free server handy, how about using a virtual machine instead? Using the fabulous SuSE Studio, I've created an appliance based on openSUSE 11.3, Drupal 7.0-alpha7 and MySQL 5.1 with the InnoDB plugin and strict mode enabled (both for the SQL mode and InnoDB mode).

Read the PlanetMySQL BlogPost:
  http://www.lenzg.net/archives/314-Testing-Drupal-7-on-a-virtual-appliance-with-MySQL-5.1-and-the-InnoDB-plugin.html


PlanetMySQL Blog: Farewell CHM, hello EPUB!
Stefan Hinz

For a long time, the MySQL Documentation Team has been providing CHM files for most MySQL documentation we publish.

With the increasing complexity and size of our documentation (the MySQL 5.1 Manual contains more than 1.6 million words now!), providing CHM has become more and more of a pain, because builds tend to break more often.

Read the PlanetMySQL BlogPost:
  http://blogs.sun.com/mysqlf/entry/farewell_chm_hello_epub


PlanetMySQL Blog: How to speed up Sysbench on MySQL Cluster by 14x Mikael Ronstrom

During the summer I had the opportunity to get some work done on scalability of the MySQL Cluster product. Given that I once was the founder of this product it was nice to return again and check where it stands in scalability terms. The objective was to compare MySQL Cluster to the Memory engine.

Read the PlanetMySQL BlogPost:
  http://mikaelronstrom.blogspot.com/2010/09/how-to-speed-up-sysbench-on-mysql.html


PlanetMySQL Blog: Spins and Contentions in MySQL Cluster Johan Andersson

I get a number of question about contentions/stuck in. So here comes some explanation to contention, thread stuck in, and what you can do about it.

Read the PlanetMySQL BlogPost:
  http://johanandersson.blogspot.com/2010/09/cluster-spinscontentions-and-thread.html

-------------------------------------------------------------------

Events

Live Webinar: What's New with MySQL - Italian Thursday, October 14, 2010 - 10:00 CET

Join us for this webinar 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 and community, aiming to make MySQL even a better MySQL.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-574.html?p=newsletter


Live Webinar: Designing MySQL Databases - EMEA Thursday, October 14, 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.

Register for the French Webinar on October 14 at 10 CET:
  http://dev.mysql.com/news-and-events/web-seminars/display-576.html?p=newsletter

Register for the German Webinar on October 15 at 11 CET:
  http://dev.mysql.com/news-and-events/web-seminars/display-573.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://dev.mysql.com/news-and-events/web-seminars/display-571.html?p=newsletter

Read the White Paper: Guide to MySQL 5.1 Partitioning:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_partitioning.php


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?

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/

You can unsubscribe from this newsletter online:
  http://dev.mysql.com/unsub?email=sanjay.ujina@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/2010/2010-08.html

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

Comment (0)

MySQL Newsletter
September 2010
mysql-newsletter@sun.com

Articles in this newsletter:

Highlights

- Event: MySQL Sunday at Oracle OpenWorld - Last Chance to Register! (September 19)
- Event: MySQL Sessions at DOAG Conference 2010 - Nuremberg, Germany (November 16-18)
- Announcing the MySQL Japanese Newsletter
- Quickpoll: What concerns you most about your current MySQL backup solution?
- The MySQL Community Team is Hiring
- White Paper: Session Management with MySQL
- White Paper: Guide to Optimizing Performance of the MySQL Cluster Database
- Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the Query Analyzer
- Case Study: MySQL Cluster Powers Leading Document Management Web Service
- Live Webinar: Getting the Best MySQL Performance in Your Products: Part 2, Beyond the Basics (Wednesday, September 15)
- Live Webinar: MySQL Essentials Part 4: How to Develop Simple .NET Applications for MySQL (Thursday, September 30)

New Product Releases

- New Release of MySQL Community Server 5.1.50 (GA)
- New Release of MySQL Connector/ODBC 5.1.7 (GA)
- New Release of MySQL Workbench 5.2.27 (GA)

Hints & Tips

- CEO Interview: AlSego develops financial applications with MySQL
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL Cluster on Windows
  - PlanetMySQL Blog: MySQL Master High Availability at Yahoo
  - PlanetMySQL Blog: Binary Log Group Commit - Recovery
  - PlanetMySQL Blog: PHP @ FrOSCon: the power of mysqlnd plugins
  - PlanetMySQL Blog: Improving InnoDB Transaction Reporting
  - PlanetMySQL Blog: No, DRBD doesn't magically make your application crash safe
  - PlanetMySQL Blog: Easy MySQL: how to backup databases to a remote machine
  - PlanetMySQL Blog: MySQL Workbench Plugin: Execute Query to Text Output
  - PlanetMySQL Blog: Upcoming MySQL Conferences
  - PlanetMySQL Blog: Managing load-balanced Connector/J deployments with MySQL Cluster
  - PlanetMySQL Blog: Why GRANT ALL is bad
  - PlanetMySQL Blog: Tips for taking MySQL backups using LVM

Events

- Live Webinar: MySQL Cluster: 5 Steps to Getting Started, then 5 More to Scale for the Web (Wednesday, September 8)
- Live Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached - German (Wednesday, September 8)
- Live Webinar: Scaling Web Services with MySQL Cluster - Italian (Thursday, September 9)
- Live Webinar: Oracle Outlines Strategy for MySQL - Portuguese (Tuesday, September 14)
- Live Webinar: Getting Started with MySQL on Windows - Japanese (Thursday, September 30)

-------------------------------------------------------------------

Highlights

Event: MySQL Sunday at Oracle OpenWorld - Last Chance to Register! (September 19)

MySQL Sunday is a half-day conference with 4 highly technical tracks, covering the latest on MySQL High Availability, Scalability, MySQL Performance Tuning, and more. Don't miss this great opportunity to learn from the MySQL experts and hear the keynotes from Edward Screven, Oracle's Chief Corporate Architect, and Marten Mickos, CEO of Eucalyptus. MySQL Sunday is happening as part of Oracle OpenWorld in San Francisco, one of the largest IT events worldwide.

Learn More:
  http://blogs.sun.com/datacharmer/entry/marten_mickos_strikes_back

View the Sessions and Speakers:
  http://blogs.sun.com/MySQL/entry/mysql_sunday_tracks_at_oracle


Event: MySQL Sessions at DOAG Conference 2010 - Nuremberg, Germany (November 16-18)

The DOAG is the German association of users for Oracle products. In November 16-18, they will hold their annual Oracle Users Conference 2010, which will take place in Nuremberg, Germany. For the first time, this year's conference will also have a dedicated stream of sessions about MySQL.

View the full list of MySQL sessions:
  http://www.lenzg.net/archives/306-Speaking-at-the-DOAG-Conference-in-Nuremberg.html


Announcing the MySQL Japanese Newsletter

MySQL Newsletter is now available in Japanese, in addition to the English and German versions. You can subscribe to the Japanese Newsletter by editing newsletter subscriptions in your MySQL account profile.

Edit your MySQL Account (Log-in Required):
  http://dev.mysql.com/profile/


Quickpoll: What concerns you most about your current MySQL backup solution?

A new quickpoll is posted on the MySQL Developer Zone about your MySQL backup solution.

Take the Quickpoll:
  http://dev.mysql.com/tech-resources/quickpolls/


The MySQL Community Team is Hiring!

Our team at Oracle needs to grow in order to better serve the growing MySQL Community, and we are starting by filling the position for MySQL Community Manager in a place with a significantly large MySQL user base: North America.

Learn More:
  http://blogs.sun.com/MySQL/entry/the_mysql_community_team_is


White Paper: Session Management with MySQL

An inherent characteristic about the web and one of the most common technical issues when designing and maintaining the web infrastructure, is addressing the stateless interaction between the user's browser and the web server from which the pages are requested. In this paper we explore how MySQL and MySQL Cluster can be used as part of a cost-effective, high-performance, open-source solution for database-centric session management.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_session_mngmnt.php


White Paper: Guide to Optimizing Performance of the MySQL Cluster Database

This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. It discusses data access patterns and how to build distribution awareness into applications, exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.

Read the English White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php

Read the French White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php.fr


Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the Query Analyzer

Launched in 1998, Promovacances is a brand of the Karavel group, the leading provider of vacation packages online in France. Promovacances.com gets about 40 million individual visitors per year and 250,000 per day during the high season.

The MySQL Enterprise Platinum subscription gives Karavel access to 24/7 technical support as well as to the MySQL Enterprise Monitor including the MySQL Query Analyzer.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_karavel_travelling.php


Case Study: MySQL Cluster Powers Leading Document Management Web Service

The DocQ web service eliminates the limitations of sharing physical documents by offering a complete paperless business solution; providing a single place where customers can manage, archive, and send their important documents.

MySQL Cluster was selected as it met all of the requirements of the service with one, integrated solution out of the box. MySQL Cluster is handling 1 million queries on average per day across both in-memory and disk-based tables, with the database growing at up to 2% daily.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs-cluster_docudesk_WebServices.php


Live Webinar: Getting the Best MySQL Performance in Your Products: Part 2, Beyond the Basics Wednesday, September 15, 2010 - 9:00am PT

In Part 2 of a three-part performance series, MySQL performance expert Brian Miezejewski 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.

In this session, Brian will build on the steps he covered in Part 1, the Fundamentals and will review more advanced topics, including monitoring, data and key caches, sessions, tuning, sorting and other server tuning tips.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-567.html?p=newsletter


Live Webinar: MySQL Essentials Part 4: How to Develop Simple .NET Applications for MySQL Thursday, September 30, 2010 - 9:00am PT

In this webinar we will explore the use of MySQL as the underlying database for .NET applications. Using several example programs, we will dive into how to develop a few starter applications for MySQL in C# and ASP.Net using Visual Studio. We will also guide you through the process from installing MySQL Connector/NET, setting up Visual Studio, starting a project, designing, coding and running these simple .NET applications.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-568.html?p=newsletter

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.1.50 (GA)

MySQL Community Server 5.1.50, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.50 is recommended for use on production systems.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-50.html

Download now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Connector/ODBC 5.1.7 (GA)

MySQL Connector/ODBC 5.1.7, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the latest release of the 5.1 series and is suitable for use with any MySQL version since 4.1.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-news-5-1-7.html

Download now:
  http://dev.mysql.com/downloads/connector/odbc/5.1.html


New Release of MySQL Workbench 5.2.27 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.27. This is the second maintenance release for 5.2 GA (Generally Available) and focuses on general product improvement and usability. We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications.

View the complete list of changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-27.html

Download now:
  http://dev.mysql.com/downloads/workbench/

-------------------------------------------------------------------

Hints & Tips

CEO Interview: AlSego develops financial applications with MySQL Enterprise

AlSego, based in Luxembourg, builds business intelligence reporting and integration solutions with MySQL Enterprise. Marc Van Oost, the CEO of AlSego, shares how MySQL addresses the flexibility, security and performance challenges of AlSego's financial applications.

Read the Interview:
  http://dev.mysql.com/tech-resources/interviews/marc-van-oost-alsego.html


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: MySQL Cluster on Windows Anders Karlsson

So you thought that just because MySQL Cluster 7.1 is GA on Windows that NDB API was available and you could just download the MySQL Cluster 7.1 binary for Windows and start hacking the NDB API. Nope. But fear not, there is help!

Read the PlanetMySQL BlogPost - Part 1: NDB API:
  http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-ndb-api-part-1.html

Read the PlanetMySQL BlogPost - Part 2: Set up a dev environment:
  http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-not-so-ndb.html

Read the PlanetMySQL BlogPost - Part 3: The Code:
  http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-ndb-api-part-3.html

Read the PlanetMySQL BlogPost - Part 4: Finishing it up:
  http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-ndb-api-part-4.html


PlanetMySQL Blog: MySQL Master High Availability at Yahoo Jay Janssen

I was asked to write a blog post about MySQL High Availability at Yahoo, particularly for writes. Our standard practice is not particularly high-tech, but we've been using it for over 4 years now and it has become a company-wide standard with a few exceptions.

Read the PlanetMySQL BlogPost:
  http://mysqlguy.net/blog/2010/08/03/mysql-master-ha-yahoo


PlanetMySQL Blog: Binary Log Group Commit - Recovery Mats Kindahl

In the previous article, an approach was outlined to handle the binary log group commit. The basic idea is to use the binary log as a ticketing system by reserving space in it for the transactions that are going to be written. This will provide an order on the transactions as well as allowing writing the transactions in parallel to the binary log, thereby boosting performance.

Read the PlanetMySQL BlogPost:
  http://mysqlmusings.blogspot.com/2010/08/binary-log-group-commit-recovery.html


PlanetMySQL Blog: PHP @ FrOSCon: the power of mysqlnd plugins Ulf Wendel

Slowly the power of mysqlnd plugins becomes visible. Mysqlnd plugins challenge MySQL Proxy and are often a noteworthy, if not superior, alternative to MySQL Proxy for PHP users.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=293


PlanetMySQL Blog: Improving InnoDB Transaction Reporting Mark Leith

Everybody knows that parsing the output of SHOW ENGINE INNODB STATUS is hard, especially when you want to track the information historically, or want to aggregate any of the more dynamic sections such as the TRANSACTIONS one.

Read the PlanetMySQL BlogPost:
  http://www.markleith.co.uk/?p=367


PlanetMySQL Blog: No, DRBD doesn't magically make your application crash safe Florian Haas

It is a common misconception that DRBD (or any block-level data replication) solution can magically make an application crash-safe that intrinsically isn't.

Read the PlanetMySQL BlogPost:
  http://fghaas.wordpress.com/2010/08/17/no-drbd-doesnt-magically-make-your-application-crash-safe/


PlanetMySQL Blog: Easy MySQL: how to backup databases to a remote machine Matt Reid

Here's a simple answer to a simple question. "How do I run a backup of MySQL to another machine without writing to the local server's filesystem?" - this is especially useful if you are running out of space on the local server and cannot write a temporary file to the filesystem during backups.

Read the PlanetMySQL BlogPost:
  http://themattreid.com/wordpress/2010/08/13/easy-mysql-how-to-backup-databases-to-a-remote-machine/


PlanetMySQL Blog: MySQL Workbench Plugin: Execute Query to Text Output Alfredo Kojima

In MySQL Workbench 5.2.26 a new query execution command is available, where query output is sent as text to the text Output tab of the SQL Editor. Some MySQL Workbench users liked the "Results to Text" option available in Microsoft SQL Server Management Studio. Cool thing is with a few lines of Python we implemented this command using the SQL Editor scripting API.

Read the PlanetMySQL BlogPost:
  http://wb.mysql.com/?p=677


PlanetMySQL Blog: Upcoming MySQL Conferences Ronald Bradford

Unlike previous years when the number of conferences with MySQL content diminishes after the O'Reilly MySQL and OSCON conferences (Open SQL Camp excluded), this year has a lot to offer.

Read the PlanetMySQL BlogPost:
  http://ronaldbradford.com/blog/upcoming-mysql-conferences-2010-08-09/


PlanetMySQL Blog: Managing load-balanced Connector/J deployments with MySQL Cluster Todd Farmer

Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or master-master replication deployments, but until version 5.1.13, managing such deployments frequently required a service outage to redeploy a new configuration.

Read the PlanetMySQL BlogPost:
  http://mysqlblog.fivefarmers.com/2010/08/03/managing-load-balanced-connectorj-deployments-2/


PlanetMySQL Blog: Why GRANT ALL is bad
Ronald Bradford

A common observation for many LAMP stack products is the use of poor MySQL security practices. Even for more established products such as Wordpress don't always assume that the provided documentation does what is best for you.

Read the PlanetMySQL BlogPost:
  http://ronaldbradford.com/blog/why-grant-all-is-bad-2010-08-06/


PlanetMySQL Blog: Tips for taking MySQL backups using LVM Shlomi Noach

LVM uses copy-on-write to implement snapshots. Whenever you're writing data to some page, LVM copies the original page to the snapshot volume. The snapshot volume must be large enough to accommodate all pages written to for the duration of the snapshot's lifetime. In other words, you must be able to copy the data somewhere outside in less time than it would take for the snapshot to fill up.

Read the PlanetMySQL BlogPost:
  http://code.openark.org/blog/mysql/tips-for-taking-mysql-backups-using-lvm

-------------------------------------------------------------------

Events

Live Webinar: MySQL Cluster: 5 Steps to Getting Started, then 5 More to Scale for the Web Wednesday, September 8, 2010 - 9:00am PT

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://dev.mysql.com/news-and-events/web-seminars/display-566.html?p=newsletter


Live Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached - German Wednesday, September 8, 2010 - 15:00 CET

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 German Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-563.html?p=newsletter


Live Webinar: Scaling Web Services with MySQL Cluster - Italian Thursday, September 9, 2010 - 10:00 CET

There are two common choices to power web applications. 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. The MEMORY storage engine has also been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management.

The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address increased web service demands. This webinar will discuss the use-cases for all three approaches, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.

Register for this Italian Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-564.html?p=newsletter


Live Webinar: Oracle Outlines Strategy for MySQL - Portuguese Tuesday, September 14, 2010 - 9:30am Brazil Time

MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout its history. Many of the world's largest and fastest-growing organizations use MySQL to save time and money powering their high-volume websites, critical business systems, and packaged software - including industry leaders such as Yahoo, Globo, TRF4, Google, Facebook, Paggo and Banco de Republica.

In this webinar 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 and community, directed toward making MySQL an even better MySQL.

Register for this Portuguese Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-569.html?p=newsletter


Live Webinar: Getting Started with MySQL on Windows - Japanese Thursday, September 30, 2010 - 14:00 JST

MySQL has been widely adopted and popular on Windows, with 45,000 downloads per day for Windows packages. Its ease of use allows you to download, configure and start using MySQL very quickly.

In this webinar, you will learn the basic "How-To's" for MySQL installation, security and configuration. We will also show you how to get started using MySQL tools on Windows.

Register for this Japanese Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-562.html?p=newsletter


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?

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/

You can unsubscribe from this newsletter online:
  http://dev.mysql.com/unsub?email=sanjay.ujina@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/2010/2010-08.html

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

Comment (0)

After four months of beta availability and testing, SugarCRM today officially announced the general availability of its Sugar 6 CRM customer relationship management platform. Sugar 6 includes an open source community edition as well as commercially licensed professional and enterprise editions.

With Sugar 6, SugarCRM is expanding its partnership base with enhanced extensibility that enables partner solutions. There is a new user interface that aims to make CRM users more productive with fewer keystrokes. While the Sugar 6 solution has open source technology at its core, users that download the open source community edition will get a different interface than users of the commercial professional and enterprise editions. For SugarCRM, the issue of being an open source company is all about being open to users.

"As an open source project, we've given people a lot, and Community edition has helped us to get where we are today," Martin Schneider, senior director of communications at SugarCRM, told InternetNews.com.

Schneider added that in his experience, he would go to conferences and users of SugarCRM's professional solution were not aware of the community edition and vice versa. As such, the new version takes pains to show the Sugar user base that there is a difference between the freely available community edition and the paid versions of Sugar.

With Sugar 6, professional and enterprise customers get a new global search option for CRM records as well as the ability to more rapidly create contact records. When Sugar 6 was first announced as a beta in April, SugarCRM co-founder Clint Oram told InternetNews.com that the goal was to reduce the number of click users needed to accomplish tasks.

Schneider explained that with Sugar 6, the company is delivering a 'Go Pro' message to community users. The new user interface for the professional and enterprise versions is the front-end for other commercial enhancements, including better security, mobile and reporting features in the paid versions. He emphasized that overall, Sugar 6 is an open source product from an open source company.

Open source doesn't mean free

"Open source doesn't mean free and was never really meant to mean free," Schneider said. "Open source runs through everything we do, it enables us to be transparent and gives customers more power. We are an open source company and it's why we're better than proprietary companies."

Though the community edition is not getting the same new user interface as the commercial versions, all three versions of Sugar 6 will benefit from an improved Sugar module builder. The module builder has been improved for all users of Sugar 6 to provide users with more integrated data views into the system. For example, a user can choose to integrate a contact's Twitter feed into a CRM record or an adjacent record tab. Schneider explained that any website can be exposed inside of a contact record to provide additional visibility.

From an extensibility perspective, Sugar 6 supports both SOAP and REST Web services, providing data integration points for partners. Sugar 6 is also being enabled to run on Microsoft's Azure cloud operating system.

Schneider said that to date, 70 percent of SugarCRM's customers run Sugar in either a cloud or hosted environment, while only 30 percent run Sugar onsite. SugarCRM offers its own on-demand hosted offering, though Schneider stressed that hosting isn't SugarCRM's core business.

"We want to empower other people to have cloud deployments and help customers get up and running," Schneider said. "We don't want to be in the hosting business, we want to be everywhere and run everywhere.

Comment (0)

SugarCRM, the open source CRM company founded in 2004, has announced the release of their latest version, Sugar 6. With this release, SugarCRM is trying to focus on making it easier and flexible for users to use CRM systems. In fact, many users are completely lost when it comes to using CRM. The complexity and lack of good user experience are considered to be the main reasons for this. This release focusses on substantially improving the user experience by offering a clean, bold look with new buttons and icons that allow users to perform tasks more easily while increasing the information density of each screen. In short, the idea is to make the CRM be flexible and convenient to users needs than users spending time to understand the UI and the complexities associated with it. They have achieved this by focusing on the user friendliness of their menu bars.

This new release also brings more social aspects to SugarCRM. Now Sugar users can leverage information from social networks like Twitter, LinkedIn and other data sources from inside the CRM. This makes SugarCRM more social than before, positioning themselves to compete with other sCRM offerings. This release also has support for more cloud providers making it easy to deploy SugarCRM on the cloud.

 SugarCRM also announced partnerships with two cloud service providers, a topic that may be of some interest to Cloud Ave audience. At the Microsoft Worldwide Partners Conference at Washington DC, SugarCRM announced that Sugar 6 is now certified for deployment on Microsoft’s Windows Azure platform. What it essentially means is that one can install SugarCRM on Windows Azure and it will work as promised without any issues. This increases the number of cloud partners for SugarCRM. Interestingly, SugarCRM has embraced the cloud era with a different approach from companies like Salesforce.com, Zoho CRM (disclaimer: Zoho is the exclusive sponsor of this blog but it is my independent opinion), etc.. While the latter companies take a multi-tenant SaaS approach, SugarCRM is trying to push for cloud apps instead. They certify SugarCRM with different cloud vendors and when it is installed on these clouds, it will work flawlessly. I asked Martin Schneider, Senior Director, Communications at SugarCRM, if SugarCRM will scale out in the Azure environment like the underlying cloud platform, he said it will scale seamlessly without any efforts on the user's side. He also pointed out that the users of SugarCRM on Azure can use either MySQL or SQL Azure.

Comment (0)

Highlights

- Tutorial: Getting Started with MySQL Workbench
- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- White Paper: Guide to MySQL for Microsoft Windows
- Case Study: MySQL Cluster Scores at the 2010 FIFA World Cup
- Live Webinar: MySQL Essentials Series - Part 2: SQL Scripting Essentials (Thursday, July 22)

New Product Releases

- New Release of MySQL Workbench 5.2.25 (GA)
- New Release of MySQL Community Server 5.1.48 (GA)
- New Release of MySQL Connector/J 5.1.13 (GA)

Hints & Tips

- Documentation: InnoDB INFORMATION_SCHEMA Tables
- Case Study: MySQL Enterprise Powers 2 Million Referrals in Central Hospital Registry
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL Sunday tracks at Oracle OpenWorld 2010
  - PlanetMySQL Blog: MySQL Workbench 5.2 goes GA - partial support for MySQL Cluster
  - PlanetMySQL Blog: 5 Steps to Get Started with MySQL Cluster in less than 15 minutes
  - PlanetMySQL Blog: mysqlnd plugins: alternative to MySQL Proxy?!
  - PlanetMySQL Blog: PHP: Client side caching for all MySQL extensions
  - PlanetMySQL Blog: Running MySQL Cluster as a service on Windows
  - PlanetMySQL Blog: Ease of Switching to the InnoDB Plugin and the Numerous Benefits
  - PlanetMySQL Blog: Oracle MySQL Storage Engine Advisory Board - It's Happening
  - PlanetMySQL Blog: How read_buffer_size Impacts Write Buffering and Write Performance
  - PlanetMySQL Blog: How many IOPs can InnoDB do?
  - PlanetMySQL Blog: Lock wait timeout on slaves

Spotlight: MySQL Embedded Server in Network Management

- On Demand Webinar: Inserts at Drive Speed: Designing a Custom Storage Engine
- Case Study: NetQoS Delivers Distributed Network Management Solution with Embedded MySQL
- Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
- Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance

Events

- Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine (Wednesday, July 14)
- Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals (Thursday, July 15)
- Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA - EMEA
- Live Webinar: What's New in MySQL - Japanese (Thursday, July 22)
- On Demand Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL
- On Demand Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached

-------------------------------------------------------------------

Highlights

Tutorial: Getting Started with MySQL Workbench

This tutorial provides a quick hands-on introduction to using MySQL Workbench for beginners. In order to complete this tutorial you will need to have a locally installed MySQL Server. This tutorial requires MySQL Workbench version 5.2.16 or above.

View the Tutorial:
  http://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial.html


White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper looks at various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how MySQL Workbench can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php


White Paper: Guide to MySQL for Microsoft Windows

As we will discover over the course of this paper, MySQL on Windows continues to be a popular choice for independent software vendors, original equipment manufacturers, hosting providers and organizations developing custom web, departmental and enterprise applications.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_onwindows.php


Case Study: MySQL Cluster Scores at the 2010 FIFA World Cup

The Pyro Group has selected the MySQL Cluster database to power their InRoam SDP (Service Delivery Platform). InRoam enables Cell C and their network partners to provide low cost, border-less mobile communications services to hundreds of thousands of football fans from around the world as they descend on South Africa for the 2010 FIFA World Cup tournament.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs-pyro_telecoms.php


Live Webinar: MySQL Essentials Series - Part 2: SQL Scripting Essentials Thursday, July 22, 2010 - 9am PT

Join us for Part 2 of the "MySQL Essentials" webinar series with Mike Frank from the MySQL Product Management group at Oracle. In this presentation, we'll demonstrate the fundamentals of SQL scripting with MySQL. We will cover SELECTs, JOINs, CREATE, DELETE, INSERTs and a host of other DML and DDL operations. Also covered will be essential management commands for administering and monitoring MySQL. We will be demonstrating how to accomplish these tasks both at the command line and in an automated fashion using MySQL's built-in scheduler, MySQL Workbench and MySQL Enterprise Monitor.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-553.html?p=newsletter

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Workbench 5.2.25 (GA)

We're pleased to announce the release of MySQL Workbench 5.2.25. This release is GA (Generally Available). We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications. MySQL Workbench 5.2 GA provides:

- Database Design & Modeling
- SQL Development (replacing MySQL Query Browser)
- Database Administration (replacing MySQL Administrator)

View the complete list of changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-25.html

Download now:
  http://dev.mysql.com/downloads/workbench/

Read the Documentation:
  http://dev.mysql.com/doc/workbench/en/index.html


New Release of MySQL Community Server 5.1.48 (GA)

MySQL Community Server 5.1.48, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.48 is recommended for use on production systems.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-48.html

Download now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Connector/J 5.1.13 (GA)

MySQL Connector/J 5.1.13, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.13 is suitable for use with any MySQL version including MySQL-5.0, MySQL-5.1 or MySQL-5.5.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-13.html

Download Now:
  http://dev.mysql.com/downloads/connector/j/5.1.html

-------------------------------------------------------------------

Hints & Tips

Documentation: InnoDB INFORMATION_SCHEMA Tables

There are seven INFORMATION_SCHEMA tables that contain live information about compressed InnoDB tables, the compressed InnoDB buffer pool, all transactions currently executing inside InnoDB, the locks that transactions hold and those that are blocking transactions waiting for access to a resource.

Read the Documentation:
  http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-information-schema-overview.html


Case Study: MySQL Enterprise Powers 2 Million Referrals in Central Hospital Registry

Sahlgrenska University Hospital (SU) is one of the major hospitals in Europe and was founded in 1997 when three hospitals in Sweden merged. Every year, Sahlgrenska University Hospital records two million referrals and comments through the Central Registry system which is powered by MySQL.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs-enterprise-sahlgrenska_hospital.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: MySQL Sunday tracks at Oracle OpenWorld 2010 Giuseppe Maxia

Oracle OpenWorld is the conference of everything related to Oracle. This year's edition, running from September 19th to 23rd, is expected to have more than 45,000 attendees, making it one of the biggest IT events worldwide.

Now that MySQL is part of the Oracle portfolio, it is going to be part of the Oracle OpenWorld show. In the spirit of the user groups events, there will be a MySQL Sunday event on Sunday afternoon, with four highly technical tracks, with well known speakers.

Read the PlanetMySQL BlogPost:
  http://blogs.sun.com/MySQL/entry/mysql_sunday_tracks_at_oracle


PlanetMySQL Blog: MySQL Workbench 5.2 goes GA - partial support for MySQL Cluster Andrew Morgan

The new version of MySQL Workbench (5.2.25) has just gone GA - see the Workbench Blog for details. So what's the relevance to MySQL Cluster? If you have a Cluster that uses MySQL Servers to provide SQL access then you can now use MySQL Workbench to manage those nodes.

Read the PlanetMySQL BlogPost:
  http://www.clusterdb.com/mysql/mysql-workbench-5-2-goes-ga-partial-support-for-mysql-cluster/


PlanetMySQL Blog: 5 Steps to Get Started with MySQL Cluster in less than 15 minutes Andrew Morgan

A series of quick-start guides are now available to get you up and running with MySQL Cluster in as little time as possible; they are available for LINUX/Mac OS X, Windows and Solaris. The configuration is intentionally a simple 1 - 2 data nodes, 1 management node and 1 MySQL Server. Once you have this up and running, your next experiment may be to extend this over multiple hosts.

Read the PlanetMySQL BlogPost:
  http://www.clusterdb.com/mysql/download-install-configure-run-and-test-mysql-cluster-in-under-15-minutes/


PlanetMySQL Blog: mysqlnd plugins: alternative to MySQL Proxy?!
Ulf Wendel

The mysqlnd plugin API is a well hidden gem of mysqlnd. Mysqlnd plugins operate on a layer between PHP applications and the MySQL server. This is comparable to MySQL Proxy. MySQL Proxy operates on a layer between any MySQL client application, for example, a PHP application, and the MySQL server.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=284


PlanetMySQL Blog: PHP: Client side caching for all MySQL extensions Ulf Wendel

The first public mysqlnd plugin adds client side query result caching to all MySQL extensions of PHP. The cache is written in C. It does not change any of the PHP MySQL APIs and works with any PHP application using MySQL. Query results are stored on the client.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=286


PlanetMySQL Blog: Running MySQL Cluster as a service on Windows Anders Karlsson

The MySQL Cluster daemon for MySQL Cluster (ndbd and ndb_mgmd) doesn't by themselves yet let them run as a service. But there are ways to fix this, using some simple Windows tools and some registry hacking.

Read the PlanetMySQL BlogPost:
  http://karlssonondatabases.blogspot.com/2010/06/running-mysql-cluster-as-service-on.html


PlanetMySQL Blog: Ease of Switching to the InnoDB Plugin and the Numerous Benefits Chris Calender

There are many advantages to using the plugin as opposed to the built-in version (aside from just the new I_S tables, and more importantly, numerous performance enhancements), and it's breeze to set up, so I wanted to provide a quick start guide to using the new InnoDB plugin.

Read the PlanetMySQL BlogPost:
  http://www.chriscalender.com/?p=99


PlanetMySQL Blog: Oracle MySQL Storage Engine Advisory Board - It's Happening Bob Zurek

Over a month ago, Infobright was invited to join the Oracle MySQL Storage Engine Advisory Board and last week was the first in a series of meetings that Oracle will be hosting for the Advisor Board members. Oracle did a terrific job stepping up to the task of assembling a well known group of companies as part of the board. The meeting last week was clearly a sign of commitment by Oracle to work closely with the storage engine vendors in the market. This resonated very well with the advisory board members.

Read the PlanetMySQL BlogPost:
  http://www.infobright.org/Blog/Entry/oracle_mysql_storage_engine_advisory_board_-_its_happening/


PlanetMySQL Blog: How read_buffer_size Impacts Write Buffering and Write Performance Venu Anuganti

Even though the name read_buffer_size implies that the variable controls only read buffering, but it actually does dual purpose by providing sequential IO buffering for both reads and writes.

Read the PlanetMySQL BlogPost:
  http://venublog.com/2010/06/23/how-read_buffer_size-impacts-write-buffering-and-write-performance/


PlanetMySQL Blog: How many IOPs can InnoDB do?
Mark Callaghan

I previously tested InnoDB on an 8-core server to determine how many IOPs it can do for a simple IO-bound workload. The limits were ~12k disk reads/second for MySQL 5.0 and ~18k reads/second for MySQL 5.1. I just repeated the tests using a 16-core server and the results are much better. I can get 20,000 to 30,000 disk reads/second using InnoDB 5.1.

Read the PlanetMySQL BlogPost:
  http://www.facebook.com/note.php?note_id=403975340932


PlanetMySQL Blog: Lock wait timeout on slaves Alex Lurthu

We had one of our slave servers frequently stops replicating with the "Innodb Lock Wait Timeout" error. The slave IO thread would continue to fetch the binlogs while the slave SQL thread kept stopping with the above mentioned error.

Read the PlanetMySQL BlogPost:
  http://alexlurthu.wordpress.com/2010/06/07/lock-wait-timeout-on-slaves/

-------------------------------------------------------------------

Spotlight: MySQL Embedded Server in Network Management

Many new technologies and applications are creating a significant increase in network traffic volume and complexity, making it more difficult to maintain a high performance network that doesn't disrupt application availability. MySQL enables ISVs and OEMs to overcome these limitations and build modern network management products by providing high performance, cost-effectiveness, ease of installation, zero administration, and much more.


On Demand Webinar: Inserts at Drive Speed: Designing a Custom Storage Engine

MySQL offers a variety of storage engines that can be matched to application requirements. Data can be integrated seamlessly between storage engines. When none of the existing engines look like a perfect match to your requirements, you can add your own. MySQL provides a SQL stack for your data. By leveraging the integration between storage engines, you are free to concentrate on just the design of key tables.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-424.html


Case Study: NetQoS Delivers Distributed Network Management Solution with Embedded MySQL

NetQoS delivers products and services that enable some of the world's most demanding enterprises, including American Express, Boeing, and Chevron, to improve network performance. NetQoS ReporterAnalyzer relies on MySQL and tells IT organizations which applications and users are consuming bandwidth, and when, so they can optimize the wide area network and improve IT service delivery.

NetQoS found that MySQL provided the ideal combination of performance, reliability, and ease of administration for ReporterAnalyzer. In addition, MySQL's affordable licensing model enabled NetQoS to reduce its database costs by several thousand dollars per network appliance.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_netqos.php


Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server

CONCEIVIUM Business Solutions ensures that BlackBerry Enterprise Servers are up and performing optimally 24X7 for three of the world's top five banks, The Coca Cola Company, IBM Global Services and many other primarily Fortune 500 organizations. With MySQL Embedded Server, CONCEIVIUM's Mobile Monitor/Analyzer Agents have achieved a 70% performance gain and are now able to analyze over two gigabytes of data per day and perform thousands of transactions per second.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_conceivium.php


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

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_sciencelogic.php

-------------------------------------------------------------------

Events

Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine Wednesday, July 14, 2010 - 9am PT

The MEMORY storage engine has been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management. The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address these evolving web service demands.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-551.html?p=newsletter


Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals Thursday, July 15, 2010 - 9am PT

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.

In this session, 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.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-552.html?p=newsletter


Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA - EMEA

Join this technical webinar for an overview of MySQL's internal architecture including storage engines, security and datatypes. Also covered will be replication, migration strategies, tools and product comparisons to SQL Server, SQL Server Express and Access.

Register for the German Webinar on July 16:
  http://dev.mysql.com/news-and-events/web-seminars/display-554.html

Register for the Italian Webinar on July 22:
  http://dev.mysql.com/news-and-events/web-seminars/display-555.html


Live Webinar: What's New in MySQL - Japanese Thursday, July 22, 2010 - 2pm JST

As a result of the acquisition of Sun Microsystems and Oracle, MySQL is now part of Oracle's product portfolio. Oracle invests in MySQL, the world's most popular open source database, and further drives its innovation.

The latest release of MySQL Enterprise includes many new features and improvements, which are designed to save DBAs and Developers time and effort in keeping MySQL systems running at the highest levels of security, performance and availability. In this webinar, we will share the latest updates from MySQL, including exciting new product development.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-556.html


On Demand Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL

In this presentation we'll demonstrate how to setup an environment for building MySQL from source on Windows and Linux, leveraging free or open source tools in the build environment. We'll also examine the various MySQL downloads, packages, distributions and installers available to get up and running in 15 minutes or less. Finally, we'll cover the initial configuration of MySQL including memory allocation, connection limits, security and other options.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-538.html?p=newsletter


On Demand Webinar: 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.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-545.html?p=newsletter

Read the White Paper "Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached":
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_ScalingWebServices.php


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?

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/

You can unsubscribe from this newsletter online:
  http://dev.mysql.com/unsub?email=sanjay.ujina@gmail.com

Read more about the newsletter and view previous issues.
  http://dev.mysql.com/news-and-events/newsletter/

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

Comment (0)

Cost savings are still the primary driver for organizations choosing open-source software, according to Jay Lyman, an analyst at The 451 Group. However, that impression seems to change after adoption, when more users report that flexibility is the primary benefit they enjoy rather than cost savings, he says.

"With the downspin of the economy, how you spend your money is critically important," says Bassim Hamadeh, founder of University Readers, which uses SugarCRM software. "But beyond saving money, what we look for is better software." SugarCRM offers enough flexibility that when the IT team wants to add a feature to the Web site, it first considers creating it in SugarCRM.

Comment (0)