MySQL Newsletter December 2009
Articles in this newsletter:
- Case Study: Symantec Benefits from MySQL Embedded Server's Rock-Solid Quality and Low Administrative Costs
- Case Study: Telenor Powers its Next Generation Mobile Broadband Services with MySQL Cluster
- Press Release: MySQL Saves Cashpoint an Estimated Half-Million Euros per Year
- White Paper: Guide to Optimizing Performance of the MySQL Cluster Database
- Live Webinar: Windows Server Failover Clustering with MySQL
- Java & MySQL Webinar Series
- Upcoming MySQL University Sessions
- Take the MySQL Cluster Community Survey
- New Release of MySQL Cluster 7.0.9 (GA)
- New Release of MySQL Community Server 5.0.88 (GA)
- New Release of MySQL Connector/NET 6.1.3 (GA)
- New Release of MySQL Connector/MXJ 5.0.11 (GA)
- Article: Using MySQL Cluster in Sun's Virtual Desktop Infrastructure
- White Paper: MySQL Cluster for Presence & Location-Based Services
- White Paper: Virtualization for MySQL on the VMware® Platform: Using VMotion, DRS, HA, and FT
- Case Study: MySQL Enterprise Powers Educational Software in 70% of Belgium's Dutch-Speaking Schools
- Case Study: MySQL Cluster Powers Leading Mobile Media Publishing Platform go2 Media
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Fixing Poor MySQL Default Configuration Values
- PlanetMySQL Blog: MySQL Schema Maintenance
- PlanetMySQL Blog: Poor man's Schema Comparison
- PlanetMySQL Blog: Things you manage to miss - ALTER TABLE .. ORDER BY
- PlanetMySQL Blog: About CSV Tables
- PlanetMySQL Blog: Launch MySQL from the Command Line
- PlanetMySQL Blog: Software preview MySQL Scriptable Replication
- PlanetMySQL Blog: MySQL University: Speakers for 2010 wanted!
- PlanetMySQL Blog: Ext4 with MySQL binary logs oddity
- PlanetMySQL Blog: On restoring a single table from mysqldump
- PlanetMySQL Blog: MySQL Cluster Restarts Get Faster
- PlanetMySQL Blog: Node Failure Handling - Take 2
- PlanetMySQL Blog: Scaling - going from 2 to X data nodes
- PlanetMySQL Blog: MySQL Cluster fault tolerance - impact of deployment decisions
- Live Webinar: Why LiveTime Software Provides SQL Server to MySQL Migration for its Customers (December 15)
- Live Webinar: MySQL Cluster on Windows (January 7)
- Live Webinar: How to grow your user base 275% with High Availability (EMEA January 13)
- Live Webinar: Scaling to 20k Transactions per Second with Open Source - MySQL, Java, curl, PHP (January 15)
- Live Webinar: Developing Windows Applications with MySQL (January 21)
- Consulting: MySQL Time Hire
- Training: MySQL High Availability (5 Days)
- Java and Solaris Training for Startups
Case Study: Symantec Benefits from MySQL Embedded Server's Rock-Solid Quality and Low Administrative Costs For Over Six Years
Symantec is one of the largest software companies in the world and a global leader in providing security, storage, and systems management solutions. Symantec chose to use MySQL Embedded Server in its Brightmail product-line because, after looking at the leading commercial and open source databases, they found that MySQL Embedded Server provided both the best functionality and price point.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/symantec-benefits-from-mysql/)
Telenor is an international provider of high quality mobile communications services to customers in twelve markets across Asia and Europe. Telenor is also a leading provider of fixed-line and media services to the Scandinavian countries. Telenor's Nexus platform provides IP management and authentication for user access and MySQL Cluster is used to store all IP leases, subscriber service configurations, entitlements and provisioning.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/telenor-powers-mobile-broadband-services-mysql-cluster/)
Sun Microsystems today announced Cashpoint, the Austrian betting and gaming company, has selected Sun's MySQL™ database to manage its customer, Web, and results data. In order to protect its systems' high-availability, Cashpoint uses both a MySQL Enterprise™ Unlimited subscription and the MySQL Cluster database product. Employing an enterprise-wide MySQL Enterprise subscription along with MySQL Cluster contributes to considerable cost savings for the company.
Read the Press Release » (http://www.mysql.com/news-and-events/generate-article.php?id=1643)
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, before exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.
Read the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php)
Thursday, December 17, 2009 10:00 PST
In this presentation we will explore the benefits of leveraging Microsoft Windows 2008 Server Failover Clustering with MySQL. We will also cover step by step, how to get started installing and configuring Failover Clustering. Finally, we will look at best practices concerning MySQL storage engine selection and behaviors with Failover Clustering.
Java is the number one most popular language for developing MySQL applications according to our most recent Annual MySQL Survey. The Java & MySQL Webinar Series features Java and MySQL sharing their best practices around developing, scaling and tuning MySQL applications.
MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Sun employees. Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.
If you use MySQL Cluster then now's your chance to influence the product roadmap. All information you provide will be kept confidential and will only be reported on in aggregate form.
MySQL Cluster 7.0.9 GA binaries have been released. MySQL Cluster is a real-time open source transactional database designed for fast, always-on access to data under high throughput conditions.
MySQL Cluster 7.0 Evaluation Guide » (http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/)
MySQL Community Server 5.0.88, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts.
MySQL Connector/Net 6.1.3, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against servers ranging from version 4.1 to 5.4!
MySQL Connector/MXJ 5.0.11 is a Java utility package for deploying and managing a MySQL RDBMS. The 5.0.11 version includes MySQL 5.1.40 server community binaries and related resources for the following platforms:
- Linux x86, x86_64
- Mac OS X ppc, x86, x86_64
- Windows XP/2K/NT/Vista/2008/7 x86, x86_64
- SunOS sparc, x86, x86_64
Platforms can easily be added or removed from: mysql-connector-mxj-gpl-5-0-11-db-files.jar
Sun Virtual Desktop Infrastructure (VDI3) is a desktop virtualization technology that provides virtual desktop access, brokering, and hosting, enabling Windows, OpenSolaris, or Linux virtual desktops. These desktops can be accessed by using existing PCs, Macs or thin clients such as Sun Ray.
Read the Article »
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 the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-cluster-for-presence-location-based-services/)
In this paper, we explore using MySQL with advanced VMware features that support live migration, high availability, recovery, and load balancing. Specifically, we discuss how we set up and performed a live migration of a MySQL 5.1 Enterprise Server environment under sustained Sysbench load using VMware VMotionTM. Also included is an example that demonstrates dynamic load balancing for a MySQL server using VMware DRS, again while under sustained Sysbench load.
Read this white paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_virtualization_vmware.php)
Smartschool is an on-line educational platform used by school administrators, teachers and students in 750 schools in Belgium - more than 70% of all Dutch- speaking secondary schools. In order to support and monitor the system, Smartbit purchased a MySQL Enterprise Unlimited subscription from Sun Microsystems to help ensure the Smartschool platform would scale to handle the growing number of users from all over Belgium.
Read this Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_smartschool.php)
go2 Media (www.go2.com) publishes the largest entertainment guide on the mobile web, growing at 300% every 6 months. Updated daily, the guide covers everything from movies, concerts, sports events, and a restaurant guide combined with tools like directions, weather and contact details. Social networking features are also included, enabling users to share their plans with friends and colleagues via their preferred platform, i.e. Twitter, Facebook, SMS or Send to Friend.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_Go2Media.php)
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 MySQL, including technical tips and best practices.
I've recently been accumulating some MySQL configuration variables that have defaults which have proven to be problematic in a high-volume production environment. The thing they all have in common is a network blip or two can trigger some very undesirable behavior.
At CodeBits I had my first session about MySQL schema maintenance. I covered the basic command line possibilities before coming to the recommended tool, MySQL Workbench.
Comparing database schemas is one of those DBA tasks that occur all the time. If you can afford the luxury of having a GUI, then MySQL Workbench is the tool for you. It will help you compare structures and eventually synchronizing the differences.
If the only thing at your disposal is a command line interface, without the possibility of installing anything (a common occurrence when you are consulting), then this Poor man's schema comparison tool may come handy.
It's funny how you can use a product heavily for so many years and still be completely unaware of some features.
As most of MySQL users, I have often ignored what I'd like to call the minor storage engines. MYISAM, InnoDB and NDB (aka MySQL Cluster) are well covered in several articles; but what about engines like CSV or ARCHIVE? As part of some internal projects, we have been playing around with these 2 with some interesting results. On this article I'll concentrate on CSV.
In my last blog entry, I discussed a "silent" install method for deploying MySQL on Windows. However, the best way to distribute MySQL may be to not install it. Instead, design the application to launch mysql from the command line. With this method, you can deploy with two files, avoid registry entries, and hide database files from end-users and their IT staff.
A MySQL Software preview is available which allows you to write Lua scripts to control replication on a statement-by-statement basis. Note that this is prototype functionality and is not supported but feedback on its usefulness would be gratefully received. The final version would allow much greater functionality but this preview allows you to implement filters on either the master or slave to examine the statements being replicated and decide whether to continue processing each one or not.
We'll soon have our last MySQL University session for this year, followed by a winter break until the end of January 2010. So far there's only one session scheduled next year, but we'd like to have one session per week, so we need lots more speakers!
I was working with a customer recently that kept seeing 10-12 second hangs in MySQL. Everything would be working well and suddenly all data changing statements would stop working.
Once the 10-12 seconds passed, the system would recover and everything would be fine for a while. This would repeat every 30-45 minutes normally, and would occur more frequently when the system was doing some heavy ETL type activity (data loads, big updates, etc...), with the ETL ones being longer and worse generally.
Following Restore one table from an ALL database dump and Restore a Single Table From mysqldump, I would like to add my own thoughts and comments on the subject. I also wish to note performance issues with the two suggested solutions, and offer improvements.
MySQL Cluster 6.3.28b and 7.0.9b contain optmizations which can greatly reduce the time taken for data nodes to restart - this includes restarting a single node, performing a rolling restart or a full system restart.
Jonas improved the node failure handling in MySQL Cluster 7.0.9 (and 6.3.29) so here comes a re-run of the a previous blog post. And the node failure handling time has improved a lot - see below.
When moving from two data nodes to a bigger Cluster it is not necessarily true that you will have better performance. In fact you can get worse. Here are some things to think about.
MySQL Cluster is designed to be a High Availability, Fault Tolerant database where no single failure results in any loss of service.
This is however dependent on how the user chooses to architect the configuration - in terms of which nodes are placed on which physical hosts, and which physical resources each physical host is dependent on.
Tuesday, December 15, 2009 - 10:00 am PST
LiveTime has been providing ITIL Service Management and Help Desk products to global 2000 companies for more than 8 years and has recently witnessed significant interest from customers in migrating from SQL Server to MySQL. In this webinar you will learn why LiveTime decided to offer a free migration service for its customers as well as optimizations and performance characteristics. You will also learn specifically about:
- Toolsets used to perform migration
- Tuning parameters
- Compiling on Solaris
- Cost of ownership
- Database connections
- Character sets
Thursday, January 7, 2010 - 10:00am PST
In this presentation we will explore the benefits of leveraging MySQL Cluster on Windows. We will also cover step by step, how to get started with installing, configuring, and running MySQL Cluster on Windows. Finally, a review of MySQL Cluster's architecture and future roadmap for Windows support will be covered. If you are interested in learning how to leverage MySQL Cluster on Windows, this webinar is for you.
Wednesday, January 13, 2010 - 10:00am CET (EMEA)
University of Turku in Finland is at the forefront of research in areas such as bioscience, interaction of culture and society, mathematical research, research of learning and education, astronomy and space research. Their organization is expanding from 22,000 users to 60,000 users with the combination of Turku School of Economics and University of Turku as one unified organization as of January 1st 2010. With MySQL Enterprise the universities have created a solution that enables them to expand and scale. "With our double set of databases, we can ensure high availability of the identity and access management of all students". Listen to Miika Kauppi, Project Manager at University of Turku, present how he designed the solution, purchased it and now is taking it into production.
Thursday, January 19, 2010 - 10:00am PST
It IS possible to build an ad-engine that can serve up more ads than Twitter to an audience larger than Twitter's (19.2m unique US visitors in Oct 2009), using fewer than 10 MySQL servers producing more then 20K Transactions per Second across a Multi-Terabyte store with all open source software. Dathan Pattishall, Chief DataLayer architect at RockYou and former database architect at Friendster and Flickr, will tell you how to do this giving real-world examples.
Thursday, January 21, 2010 - 10:00am PST
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. Finally, we will offer a review of the future roadmap of the MySQL Connectors applicable for Windows environments. If you are interested in learning how to leverage MySQL Cluster on Windows, this webinar is for you.
- Would you like the flexibility of adding one or more of Sun's MySQL consultants to your team, on an as needed basis?
- Do you need Sun's MySQL consultants on a project basis?
- Do you need DBA experts to cover for staff absences or increased work load?
Sun's MySQL consultants have proven expertise in designing, developing, deploying, upgrading and managing database applications. By using Sun's MySQL consultants to supplement their teams, customers can reduce the time, effort and costs associated with building and running MySQL-based applications. Sun's MySQL consultants will work closely with customers who purchase this service to:
- Act as a temporary member of the customer's MySQL database team working on those areas that they prioritize
- Provide advice on architecture and design
- Implement the database schema
- Assist with loading or migrating data from existing system
- Make recommendations on best practice for development, deployment and operations
- Assist in performance measurement, tuning and optimization
- Achieve improved scalability, availability and reliability
Learn More » (http://www.mysql.com/consulting/packaged/timehire.html)
MySQL Consulting Testimonials » (http://www.mysql.com/consulting/testimonials/)
Phoenix, Dublin, Montreal, London, Paris, Boston
An Authorized 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 features such as creating and using Stored Procedures, Triggers and Views.
Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dba.html)
Need to boost your knowledge of Java and Solaris? The Sun Startup Essentials program offers over 120 web-based Java Technology and Solaris training programs covering Web development with Servlet and JSP Technologies, Java Application Security, Solaris System Administration, Virtualization Management and much more. Check if you qualify for the program and learn how you can save 90% off list price for a typical 10-person startup!
If you're struggling to develop cost effective data warehouses, data marts, reporting databases, or BI/analytic applications, but aren't getting the performance you want, maybe you need a new approach. Learn how Calpont's InfiniDB handles all query and read-intensive application needs by supplying an architecture that both scales up and out using massive parallel processing, but with the ease-of-use of MySQL.
Read the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_infinidb.php)