| MySQL Bulletin for UK and Ireland - Dec 2008
MySQL News
Sun Releases MySQL 5.1 -- Boosts Performance & Simplifies Management of Large-Scale Database Applications.........
.......and it gets downloaded more than 250,000 times in First Ten Days of General Availability
On December 8, 2008 -- Sun Microsystems, Inc and The MySQL team announced the general availability of MySQL™ 5.1, a major new release of the world's most popular open source database. Designed to improve performance and simplify management of large-scale database applications, the production-ready MySQL 5.1 software is available for download now at dev.mysql.com/downloads.
MySQL 5.1 has been downloaded more than 250,000 times in the ten days it has been generally available. This show of community interest and adoption follows a number of well-received database announcements that Sun has made this quarter -- including Sun Systems for MySQL as well as the new MySQL Query Analyzer tool that is now part of its MySQL Enterprise™ subscription offering.
MySQL 5.1 features a number of new enterprise-class enhancements, including: - Table and Index Partitioning – MySQL 5.1 supports five forms of horizontal data partitioning: range, hash, key, list, and composite (sub-partitioning). By partitioning table and index data, faster query response times can be achieved as only the relevant partitions of data need to be scanned, instead of the entire table or index. Further, various storage and other maintenance operations are made much easier and accomplished more quickly via partitioning.
- Row-Based and Hybrid Replication – Two new replication options are now available in MySQL 5.1. Row-based replication replicates the data changes (rather than the actual SQL statements) between a master server and its slave servers, and hybrid replication uses either statement-based or row-based replication depending on the individual SQL operations – these achieve and maintain the most efficient and safest replication scheme for the application.
- Event Scheduler – This new tool allows developers and DBAs to automatically schedule common recurring SQL-based tasks to execute on the database server. It provides greater support for database-specific tasks than is available through CRON in Linux or Unix� or the Microsoft Windows task scheduler.
- New MySQL Query Analyser – Available to premium MySQL Enterprise subscribers, Sun's new MySQL Query Analyzer tool can dramatically improve the speed and uptime of MySQL database applications by monitoring query performance to accurately pinpoint and correct problem SQL code. Thirty-day trial subscriptions for the MySQL Enterprise service, including the new MySQL Query Analyzer, are now available free-of-charge from http://www.mysql.com/trials.
MySQL 5.1 is available now for a wide variety of hardware and software platforms, including Red Hat Enterprise Linux, SuSE Enterprise Linux Server, Microsoft Windows, Solaris™ 10 Operating System (OS), Macintosh OS X, Free BSD, HP-UX, IBM AIX, IBM i5/OS and other popular Linux distributions.
Sun Systems Optimised for MySQL.
Sun Microsystems, Inc. announced on November 5th the availability of Sun Systems for MySQL™. The new solutions integrate MySQL with other innovations from Sun, enabling customers to get to market faster by using Sun's open software, extensive code samples with MySQL, and documented best practices. Using Sun's Try and Buy program, users can evaluate the new Sun Systems for MySQL in their own environment for 60 days at no cost and no risk with full technical support, and then buy the systems for up to 40 percent off list price. In addition, Sun Systems for MySQL is available via the Sun Startup Essentials™ program with substantial discounts for qualifying customers
Solutions announced include Sun Systems for MySQL in the following environments: - x86 Performance: Changing the economics of Web services delivery.Sun Systems for MySQL x86 Performance includes a MySQL Enterprise™ Gold subscription with Sun Fire™ x64 servers, Open Storage, comprehensive services, and a no-risk, free-trial program -- allowing users to build a complete solution based on Open Source software from Sun. This Open Source software, combined with Sun Fire™ X4150 servers, produced the best published price/performance score on the industry-standard SPECjAppServer2004 benchmark. See: http://www.sun.com/servers/x64/x4150/benchmarks.jsp.
- Virtualization: Scaling while overcoming power, cooling and space constraints. Sun Systems for MySQL Virtualization includes Sun's CoolThreads™ systems and Open Storage technologies running the Solaris OS and enables users to consolidate and scale their MySQL-based web services for breakthrough eco-efficiency and cost-effectiveness at the highest volumes. Using CoolThreads servers, companies have seen close to five times higher MySQL throughput with four times less power and space and 10 times improvements in price/performance. As an example of near-linear vertical scalability, the SugarCRM application runs very well under the Solaris OS with the MySQL database. Using the standard benchmarking kit available from Sugar, CoolThreads-based Sun SPARC Enterprise servers configured with Logical Domains (LDOMs) were able to support 3,200 SugarCRM users with four CPUs, 1,600 users with two CPUs and 900 users with one CPU, allowing customers to select a complete Open Source solution that best fits their needs.
- Multi-tier Deployment: Simple and predictable scaling supports massive increases in user and data volumes. Sun Systems for MySQL Multi-tier Deployment is a collection of code samples and published best practices – including pre-optimized, pre-integrated AMP-stack software components and sample Web 2.0 implementations.
- Rich Media Storage: Handling explosion in data volume and unstructured data to deliver value-added services to users. Sun Systems for MySQL Rich Media Storage combines MySQL with the Sun Fire X4540 storage server, JBODs, OpenSolaris and Solaris ZFS™, which allows customers to host their media-rich data on a single integrated platform that offers up to three times denser storage than competitors, at half the cost.
- Back-up: Managing growth in data volumes and ever shrinking back-up windows. Sun Systems for MySQL Back-up provides the Sun Fire X4540 server and Zmanda Recovery Manager for back-up and recovery of MySQL applications. Customers deploying this solution can save 15 percent in costs and have twice the density compared to HP, and save 10 percent in costs and have almost three times the density compared to Dell. Customers can also save 40-70 percent on power and cooling consumption compared to competitive offerings.
Sun customers deploying these Sun Systems for MySQL solutions have seen significant advantages and power/cost savings. For example, DigiTar reduced power consumption by 83 percent and improved price/performance by a factor of 10 using the Sun Systems for MySQL Virtualization solution. Other Sun customers deploying Sun systems to run MySQL include 6.cn, Fotolog, Last.fm and LinkedIn.
To view a video of John Fowler, executive vice president of Sun's Systems Group, and Marten Mickos, senior vice president of Sun's Database Group, discussing the new solutions, please visit: www.sun.com/mysqlsystems.
Upcoming MySQL Training Courses
As and end of year special, Book on any of the MySQL training courses listed below before December 23rd and get a 10% discount against the standard price. Book 2 or more attendees from the same organisation on a single course and get 15% discount against the standard price. Offer is limited so if you are interested, please do not hang about but contact us asap!
0845 399 1124 or email uk-sales@mysql.com
MySQL Performance Tuning
- Do you need to manage an increasing amount of data in your MySQL applications?
- Do you want to monitor, diagnose problem areas and tune MySQL for optimal performance?
- Do you want to write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing?
- Do you want to Evaluates the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance
Then MySQL 5.0 Performance Tuning is the class for you! The MySQL 5.0 Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare each student with the skills needed to utilize tools for monitoring, evaluating and tuning. Students will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts. Availability:
MySQL for Database Administrators - Is your MySQL database secure? Do your users have the correct privileges and access rights?
- Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
- Do you want to save time using features like Stored Procedures, Triggers and Views?
- Do you want to utilize the new enterprise features of MySQL 5.0?
Then MySQL for DBAs is the class for you! An Authorised MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, create secure Stored Procedures to update and access data and more!
This instructor led, hands-on class will teach you how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new 5.0 features such as creating and using Stored Procedures, Triggers and Views.
Availability:
MySQL For Developers
- Do you want to learn how to develop database applications on MySQL?
- Do you need to use MySQL Stored Procedures, Triggers, Views, and Information Schema?
- Do you want to create complex reports, use complex queries to retrieve data and aggregate results?
- Do you want to transfer your data from one server to another?
Then MySQL for Developers is for you! With an Authorized MySQL instructor and hands-on exercises you will learn how to develop applications with all the new features of MySQL 5.1.
Availability:
Upcoming MySQL Webinars
We are still putting the schedule for 2009 together so please check the website regularly but highlights for January include:
High Availability with DRDB for MySQL - Thursday January 9th 2009
Presented by Florian Haas, Senior Consultant at Linbit, the company behind the high availability solution DRBD. In this webinar, Florian will discuss the new features in DRBD 8.3, including support for multi-Terabyte devices, device stacking, efficient resynchronization, plus the recently added Dolphin Express low-latency interconnect support. DRBD for MySQL is a high availability solution that combines MySQL, Linux Heartbeat, and DRBD so organizations can cost-effectively deliver high availability open source database solutions. If you are interested in learning what's new in DRBD 8.3 and how to architect an open source high availability solution for MySQL, this webinar is for you.
Boost Performance with 5.1 and Query Analyser - Wednesday, January 07, 2009
Join this webinar to learn how MySQL Enterprise now delivers higher performance for large-scale enterprise applications through Partitioning and Row-Based Replication - as well as the ability to further optimize database performance and manage scale by with Query Analyzer, a must-have tool for DBAs and developers to identify and analyze problem SQL code causing performance issues and slow downs.
Web 2.0 Lessons for Communications Services Providers - Wednesday, January 14, 2009
The convergence of communication & entertainment services is creating multiple challenges for Communications Services Providers (CSPs) as well as Network Equipment Providers (NEPs). Some of these challenges are technical in nature, but others may be more cultural, requiring new organizational behaviors in order to remain relevant and competitive in the new online world. In this webinar we compare the approaches and attitudes of the Web 2.0 industry and the Communications industry, as well as outlining the changes that CSPs and NEPs should embrace if they want to win in the new converged marketplace.
Scaling MySQL Leveraging Sun Systems - Tuesday, January 20, 2009
Scalability is a top priority for MySQL DBAs and developers. However, there are different scalability options to choose from, with different benefits.
Join us for this web seminar in which we will cover the following topics: - When should you rather scale out or scale up?
- When and why does MySQL virtualization make sense?
- How can you leverage Sun systems to increase performance and save money, space and energy?
- Detailed benchmark results in terms of performance, costs reduction and eco-efficiency
- Customer case studies
Sun Systems for MySQL are enterprise-ready solutions combining servers, storage and software that can give you up to three times greater performance and help you cut costs by 50%. Join this webinar to discover how!
Sun Startup Essentials
If you are a company under 6 years old and with fewer than 150 employees then you can join other startup companies such as Last.fm and Fav.or.it, in the Startup Essentials Programm to take advantage of a special 15% off our entire x86 server range, and leave the worry of scaling your company behind. Take advantage of this cutting edge innovation from Sun Microsystems at prices that won't leave your business gasping for air.
Take Advantage Today
MySQL UK on Twitter
In response to feedback from the UK MySQL Community, we have created a MySQL UK Twitter channel. We'll use this channel to help keep you up to date on all MySQL related news such as product releases or updates, meetups, special offers, tips and tricks and anything else worthy of mention. If you are a both a Twitter and MySQL User then start following mysqluk today. http://twitter.com/mysqluk If you have no idea what Twitter is then do check it out, we love it and not just because it runs on MySQL.
Finally, on behalf of all members of the Sun Database Technology Group let us wish you a very Merry Christmas and a Happy New Year. Note that MySQL AB also provides a global newsletter with more extensive articles and information. To sign up for that newsletter please go to:
http://www.mysql.com/register.php Best regards,
MySQL AB
Copyright � 2008 MySQL AB| www.mysql.com |
