MySQL Newsletter February 2010 mysql-newsletter@sun.com
Articles in this newsletter:
Highlights
- MySQL Conference and Expo: Register Now - Save $250 - MySQL Conference and Expo: 15 Half-Day Tutorials - MySQL Download and Documentation Links - PlanetMySQL Blog: Reorganizing the documentation - Upcoming MySQL University Sessions - MySQL Community Survey
New Product Releases
- New Release of MySQL Community Server 5.1.44 (GA) - New Release of MySQL Cluster 7.1.1 (Beta) - New Release of MySQL Workbench 5.2.16 (Beta) - New Release of MySQL Connector/J 5.1.11 (GA)
Hints & Tips
- PlanetMySQL Blog: Performance schema overview - PlanetMySQL Blog: Index search time depends on the value being searched - PlanetMySQL Blog: Aggregates: subqueries vs. GROUP BY - PlanetMySQL Blog: innodb_file_per_table, shrinking table spaces and the data dictionary - PlanetMySQL Blog: MySQL Replicant: Architecture - PlanetMySQL Blog: Configuring the InnoDB Plugin (1.0.6) in MySQL 5.1.43 - PlanetMySQL Blog: Further Thoughts on MySQL Upgrades - PlanetMySQL Blog: What is CHECK TABLE doing with InnoDB tables? - PlanetMySQL Blog: mysql's --xml and some XSLT - PlanetMySQL Blog: MySQL Cluster Uses - PlanetMySQL Blog: MySQL Cluster Start Phases - PlanetMySQL Blog: MySQL Cluster Start Phases - PlanetMySQL Blog: How MySQL Cluster BLOBs work: - PlanerMySQL Blog: How to Prevent Global Check Point Stops in MySQL Cluster - PlanetMySQL Blog: Gearman meets MySQL Cluster (NDBAPI) - PlanetMySQL Blog: MySQL Cluster Disk Data Tables
Events
- Live Webinar: MySQL Cluster Connector/Java: Technology Introduction & Getting Started, Part 2 (March 3) - Live Webinar: MySQL Cluster on Windows - EMEA (March 5) - Live Webinar: Performance Part 2: How to Boost Performance with MySQL 5.1 and the new InnoDB Plugin (March 9) - Live Webinar: Migrating from SQL Server to MySQL EMEA (March 11) - Windows and MySQL - Part 12: Advanced MySQL Replication on Windows (March 16) - Achieving Peak Application Performance with MySQL Embedded Server (March 17) - Running MySQL Securely on Windows - EMEA (March 18)
MySQL Conference and Expo: Register Now - Save $250
The MySQL Conference and Expo is a deep technical conference designed to take your skills and know-how to the next level through expert-led sessions, in-depth tutorials, and face-to-face conversations with open source gurus and developers.
Take advantage of this rare opportunity to get hands-on knowledge from MySQL experts on numerous topics. Tutorials are half day presentations that give you the opportunity to learn a topic in-depth, in a collaborative environment. Tutorials include:
- The Replication Tutorial - Diagnosing and Fixing MySQL Performance Problems - Using Partitioning in MySQL 5.1 and 5.5 - MySQL Cluster Tutorial - Scaling Applications with Caching, Sharding and Replication
View all Tutorials: http://en.oreilly.com/mysql2010/public/schedule/stype/Tutorial
MySQL Download and Documentation Links
The most recent MySQL downloads and documentation can be found at the following URLs:
Downloads: http://dev.mysql.com/downloads/
Documentation: http://dev.mysql.com/doc/
PlanetMySQL Blog: Reorganizing the documentation Martin 'MC' Brown
Those of you that know the documentation well will be aware of the old page we used to have for the MySQL documentation. It was huge, and over the years we'd done a number of things to try and improve the layout and make it easier to find what you wanted.
Read the PlanetMySQL Blog: http://coalface.mcslp.com/2010/02/02/reorganizing-the-documentation/
Upcoming MySQL University Sessions
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.
Learn More and View Upcoming Sessions: http://forge.mysql.com/wiki/MySQL_University
Please take a few moments to complete our annual user survey. This is an opportunity to tell us how you are using MySQL and to influence the MySQL roadmap.
Take the Survey (On Zoomerang): http://www.zoomerang.com/Survey/?p=WEB22A4GYWJTJW
MySQL Community Server 5.1.44, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.44 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-44.html
MySQL Connector/J 5.1.11, 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.11 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-11.html
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.
Visit PlanetMySQL: http://www.planetmysql.org
Submit Your Blog Feed: http://www.planetmysql.org/newfeed.php
PlanetMySQL Blog: Performance schema overview Marc Alff
This paper is an introduction to the new 'performance schema' feature, which will be part of the upcoming MySQL 5.5 release. Covering in details every part of the performance schema would require much, much more than a simple article. The pace of this teaser is voluntarily fast, to have a quick overview of the new landscape, and help users already familiar with MySQL to understand by examples what the performance schema provides.
Read the PlanetMySQL Blogpost: http://marcalff.blogspot.com/2010/01/performance-schema-overview.html
PlanetMySQL Blog: Index search time depends on the value being searched Alex Bolenok
Answering questions asked on the site. I have a table which stores track titles in a VARCHAR(200) field. The field is indexed, but searching for titles beginning with a letter Z is noticeably slower than for those beginning with A, and the closer the initial letter is to Z, the slower is the query.
PlanetMySQL Blog: Aggregates: subqueries vs. GROUP BY Alex Bolenok
I have a table users and there is a field invited_by_id showing user id of the person who invited this user. I need to make a MySQL query returning rows with all the fields from users plus a invites_count field showing how many people were invited by each user.
Read the PlanetMySQL Blog: http://explainextended.com/2010/01/30/aggregates-subqueries-vs-group-by/
PlanetMySQL Blog: innodb_file_per_table, shrinking table spaces and the data dictionary Dathan Pattishall
INNODB has some irritating gotchas that makes disk space management hard. In 2002ish INNODB, added innodb_file_per_table to get around allot of these issues, but it does not fix everything.
PlanetMySQL Blog: MySQL Replicant: Architecture Mats Kindahl
In the previous post I described the first steps of a Python library for controlling the replication of large installations. The intention of the library is to provide a uniform interface to such installations and that will allow procedures for handling various situations to be written in a uniform language.
PlanetMySQL Blog: Further Thoughts on MySQL Upgrades Simon Mudd
I have been upgrading more MySQL database instances recently and have found a few more potential gotchas, which if you are not careful, can potentially be rather nasty. These are not documented explicitly by MySQL, so it may be handy for you to know if you have not come across this type of thing before.
Read the PlanetMySQL Blogpost: http://blog.wl0.org/2010/01/further-thoughts-on-mysql-upgrades/
PlanetMySQL Blog: What is CHECK TABLE doing with InnoDB tables? Oli Sennhauser
Recently we had a case where a customer got some corrupted blocks in his InnoDB tables. His largest tables where quite big, about 30 to 100 Gbyte. Why he got this corrupted blocks we did not find out yet (disk broken?).
Read the PlanetMySQL Blogpost:
http://shinguz.blogspot.com/2010/01/what-is-check-table-doing-with-innodb.ht ml
PlanetMySQL Blog: mysql's --xml and some XSLT Scott Noyes
Somebody asked in Freenode the other day how to get their data out of MySQL into a specific XML format.
Read the PlanetMySQL Blogpost: http://thenoyes.com/littlenoise/?p=99
PlanetMySQL Blog: MySQL Cluster Uses
MySQL Cluster can be used as a general purpose transactional storage engine, but if you convert all your InnoDB tables to it and connect your application straight to it you may not see the performance you were hoping for.
Read the PlanetMySQL Blog: http://blogs.sun.com/LinuxJedi/entry/mysql_cluster_uses
PlanetMySQL Blog: MySQL Cluster Start Phases
When MySQL Cluster data nodes start they need to go through a process of determining roles in the cluster, copying the data back into RAM and synchronising everything up. This can take longer than expected and the process is not always very verbose. So in this post I will outline a simplified version of what MySQL Cluster is doing in each start phase so that you can see why it can take time.
Read the PlanetMySQL Blog: http://blogs.sun.com/LinuxJedi/entry/mysql_cluster_start_phases
PlanetMySQL Blog: How MySQL Cluster BLOBs work
If there is one thing that confuses people about tables in MySQL Cluster (including me at times) it is BLOB/TEXT columns. When NDB was originally created it was not designed to handle BLOB data, so the handling of BLOB data was difficult to implement and is sometimes not exactly what users expect.
Read the PlanetMySQL Blog: http://blogs.sun.com/LinuxJedi/entry/blobs_in_mysql_cluster
PlanetMySQL Blog: How to Prevent Global Check Point Stops in MySQL Cluster
One of the most common errors we come across whilst supporting MySQL Cluster is an error commonly referred to as 'GCP stop'. These errors will occur most frequently in cluster setups which have high activity and more often than not use disk data. So lets look into what these are, why they happen and how to prevent them.
Read the PlanetMySQL Blog: http://blogs.sun.com/LinuxJedi/entry/mysql_cluster_gcp_stop
PlanetMySQL Blog: Gearman meets MySQL Cluster (NDBAPI) Johan Andersson
After a discussion with my colleague Stephane Varoqui we decided to see how Gearman and the NDBAPI could be used together.
PlanetMySQL Blog: MySQL Cluster Disk Data Tables Andrew Hutchings
MySQL Cluster is well known as an in-memory database which can be restrictive (a server typically has a RAM limit) so it may surprise some to learn that you can also store MySQL Cluster data on disk. Disk Data Tables have been in MySQL Cluster for quite a while, the first GA release with them included was 6.2. They do have caveats which I will describe here, many of which already have plans to be improved in future versions.
Read the PlanetMySQL Blog: http://blogs.sun.com/LinuxJedi/entry/mysql_cluster_disk_data_tables
Live Webinar: MySQL Cluster Connector/Java: Technology Introduction & Getting Started, Part 2 Wednesday, March 03, 2010
Designed for Java developers, the MySQL Cluster Connector for Java implements an easy-to-use and high performance native Java interface and OpenJPA plug-in that maps Java classes to tables stored in the high availability, real-time MySQL Cluster database. Tune into Part 2 of this 2-part webinar series where Sun's senior engineering staff will discuss how to integrate the MySQL Cluster Connector for Java into existing applications.
Register for the Webinar: http://dev.mysql.com/news-and-events/web-seminars/display-488.html
Live Webinar: MySQL Cluster on Windows - EMEA Friday March 5, 10:00am CET
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 will be covered. If you are interested in learning how to leverage MySQL Cluster on Windows, this webinar is for you.
Register for the Webinar: http://dev.mysql.com/news-and-events/web-seminars/display-517.html
Live Webinar: Performance Part 2: How to Boost Performance with MySQL 5.1 and the new InnoDB Plugin Tuesday March 9, 10:00am PST
Looking for immediate performance and scalability gains for your MySQL application? Then join us for Part 2 of our "Boosting Performance" webinar series where MySQL Professional Services experts will walk you through best practices for achieving performance and scalability improvements using MySQL 5.1 and the new InnoDB Plugin. We will cover which plugin features to enable, and review specific use cases, tuning, and benchmarking best practices to help you maximize results.
Register for the Webinar: http://dev.mysql.com/news-and-events/web-seminars/display-498.html
Live Webinar: Migrating from SQL Server to MySQL - EMEA Thursday, March 11, 15:00 CET
In this presentation we will explore the benefits of migrating from Microsoft SQL Server to MySQL. We will also cover migration best practices, as well as, an overview of migration tools, scripts, datatype mapping and functional equivalents. If you are interested in learning how to migrate from SQL Server to MySQL, this webinar is for you.
Register for the Webinar: http://dev.mysql.com/news-and-events/web-seminars/display-516.html
Windows and MySQL - Part 12: Advanced MySQL Replication on Windows Tuesday, March 16, 10:00am PST
In this presentation we will build of the previous presentation and look at more advanced MySQL Replication techniques. We will cover master-master configurations, semi-synchronous replication, fail-over and resynchronization. If you are interested in learning about advanced MySQL Replication on Windows, this webinar is for you.
Register for the Webinar: http://dev.mysql.com/news-and-events/web-seminars/display-506.html
Achieving Peak Application Performance with MySQL Embedded Server Wednesday, March 17, 10:00am PST
MySQL expert and trainer, Sarah Sproehnle, will discuss the major MySQL design decisions that can affect the performance of your application and with it, your customers' experience and satisfaction. Sarah will show you how to achieve top performance with MySQL Embedded Server, covering the following topics:
- Choose the right storage engine(s) - Identify critical performance-related server settings - Understand and properly use indexes - Using EXPLAIN to verify query execution plans - How to identify performance problems
Register for the Webinar: http://dev.mysql.com/news-and-events/web-seminars/display-510.html
Running MySQL Securely on Windows - EMEA Thursday, March 18, 2010, 15:00 CET
In this presentation we will demonstrate how to install and configure MySQL to run securely on Windows. We will explain how MySQL's internal security model, authentication and privileges model works. We will also look at how to secure network access to MySQL and look how to thwart common attacks on MySQL. If you are interested in learning how to run MySQL securely on Windows, this webinar is for you.
Register for the Webinar: http://dev.mysql.com/news-and-events/web-seminars/display-518.html
- Live Webinar: Migrating from Access to MySQL - White Paper: A Guide for Migrating From Microsoft Access to MySQL - Case Study: MySQL Cluster Helps Mapion to Improve its User Experience - Quick Poll: What information do you find most useful in the MySQL Newsletter? - New Java and MySQL Resources Page - Upcoming MySQL University Sessions - Test Drive MySQL Enterprise Monitor for 48 Hours
New Product Releases
- New Release of MySQL Community Server 5.1.40 (GA) - New Release of MySQL Community Server 5.0.87 (GA) - New Release of MySQL Cluster 7.0.8a (GA)
Hints & Tips
- White Paper: A Visual Guide to Installing MySQL Embedded Server on Windows - White Paper: Best Practice Guide: Developing Subscriber Databases with MySQL Cluster - Case Study: be2 Scales Fast Growing Matchmaking Web Site with MySQL Enterprise - PlanetMySQL Blog Posts - PlanetMySQL Blog: Silent Install Instructions - PlanetMySQL Blog: Long running transactions - PlanetMySQL Blog: PHP/C: Does MYSQL[I]_OPT_CONNECT_TIMEOUT work? - PlanetMySQL Blog: Agents, Hosts and Instances, Oh My!
- PlanetMySQL Blog: Data type confusion: what is an int(11)? - PlanetMySQL Blog: InnoDB Plugin (With some Windows focus) - Part 1 - PlanetMySQL Blog: Some friendly advice for bootstrapping your OSS - PlanetMySQL Blog: MySQL and hardware information - PlanetMySQL Blog: PHP: 150 performance tuning screws for mysqlnd - PlanetMySQL Blog: Secure Your Server - Tips for DBAs - PlanetMySQL Blog: MySQL Cluster 7.0.9a source release now available - replaces 7.0.9 - PlanetMySQL Blog: MySQL Cluster: Errors faced while importing data - PlanetMySQL Blog: Configuring MySQL Cluster for Large Databases - PlanetMySQL Blog: Make MySQL refuse connections until data nodes are started - PlanetMySQL Blog: How MySQL Cluster Executes Queries
Events
- Live Webinar: Memcached and MySQL for Rapidly Scaling High Traffic Websites (November 12) - Live Webinar: MySQL Cluster: Geographic Replication Deep-Dive (November 24) - Live Webinar: Migrating from SQL Server to MySQL (December 3) - Live Webinar: For ISVs and OEMs: Getting Maximum Scalability and Availability with Java and MySQL (December 8) - Live Webinar: Optimizing Queries for Performance (December 9) - Live Webinar: Why LiveTime Software Provides SQL Server to MySQL Migration for its Customers (December 15) - Live Webinar: Windows Server Failover Clustering with MySQL (December 3, 17) - On Demand Webinars: Java, Windows & More - MySQL Seminar: The Revolution of the Open Source Data Warehouse (November 18, Milan)
Training, Consulting, & Certification
- Consulting: MySQL Developer (4+ Days) - Training: MySQL High Availability (3 Days)
Partners
- Calpont: MySQL Database Analytics with InfiniDB from Calpont - Joyent: Read/Write Load Balancing for MySQL with ZXTM in the Joyent Public Cloud (Webinar, November 17)
Live Webinar: Migrating from Access to MySQL Thursday, November 19, 2009 10:00 PST (Americas) Thursday, November 19, 2009 15:00 CET (EMEA)
In this webinar we will explore the benefits of migrating Microsoft Access data to MySQL including migration best practices, migration tools, scripts and datatype mapping. Finally, we will demonstrate how to leverage Access front-ends with a MySQL-backend.
Register Now (Americas): http://www.mysql.com/news-and-events/web-seminars/display-442.html
Register Now (EMEA): http://www.mysql.com/news-and-events/web-seminars/display-451.html
White Paper: A Guide for Migrating From Microsoft Access to MySQL
Many MySQL customers are migrating from Microsoft Access because they have reached the conclusion that the combination of enhanced scalability (both in terms of concurrent userload and overall data volume), cost-savings, platform freedom, and feature set of MySQL make for a compelling business case to offload some or all their Access applications to the MySQL database server.
Case Study: MySQL Cluster Helps Mapion to Improve its User Experience
Headquartered in Tokyo, Japan, Mapion Co. Ltd delivers Japan's leading online map search service, with over 700,000 page views per day, and over 200 enterprise customers. Mapion's shareholders include Toppan, NTT East, Dentsu, Yahoo Japan, and Sharp.
Read this Case Study: http://www.mysql.com/why-mysql/case-studies/mysql_cs_mapion.php
Newsletter Quickpoll: What information do you find most useful in the MySQL Newsletter?
Take the Quickpoll: http://dev.mysql.com/tech-resources/quickpolls/newsletter-interests.html
New Java and MySQL Resources Page
Java is the number one most popular language for developing MySQL applications according to our most recent Annual MySQL Survey. The mysql.com/java page is a compilation of the variety of resources - from formal tutorials to discussion forums - that can help you develop and optimize your Java and MySQL applications.
Visit the Java Resources Page: http://www.mysql.com/why-mysql/java/
Upcoming MySQL University Sessions
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.
Upcoming sessions include:
- November 12: Gearman for MySQL (Giuseppe Maxia) - November 19: memcached Functions for MySQL (UDFs) (Patrick Galbraith) - November 26: The Spider Storage Engine (Giuseppe Maxia) - December 3: Practical Full-Text Search in MySQL (Bill Karwin)
You can now Test Drive the MySQL Enterprise Monitor with no download or installation required. MySQL will provide you access to demo servers to test MySQL Enterprise Monitor for 48hrs.
New Product Releases
New Release of MySQL Community Server 5.1.40 (GA)
MySQL Community Server 5.1.40, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.40 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-40.html
Download Now: http://dev.mysql.com/downloads/mysql/5.1.html
New Release of MySQL Community Server 5.0.87 (GA)
MySQL Community Server 5.0.87, a new version of the popular Open Source Database Management System, has been released. This and future releasesin the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.0/en/news-5-0-87.html
This release includes a fix for Bug#47844, which was discovered in MySQL Cluster NDB 7.0.8 shortly after release. The MySQL Cluster NDB 7.0.8a release is identical in all other respects to MySQL Cluster NDB 7.0.8.
White Paper: A Visual Guide to Installing MySQL Embedded Server on Windows
The goal of this guide is to make getting started with MySQL Embedded Server on the Windows platform easy for commercial application developers (ISVs/OEMs) who are new to MySQL and/or are used to using SQL Server. This paper will guide you through the steps and tools needed to get up and running quickly with MySQL Embedded Server on Windows using familiar terms, comparisons, and language.
Read the White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_embedded_visual_guide.p hp
White Paper: Best Practice Guide: Developing Subscriber Databases with MySQL Cluster
In this new 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://www.mysql.com/why-mysql/white-papers/mysql_wp_subscriber_db.php
Case Study: be2 Scales Fast Growing Matchmaking Web Site with MySQL Enterprise
be2 started in 2004 with its German web site be2.de and is now one of the world's leading matchmaking services with more than 17 million members in 36 countries and 20,000 new members joining be2 every day.
Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_be2.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 MySQL, including technical tips and best practices.
Visit PlanetMySQL: http://www.planetmysql.org
Submit Your Blog Feed: http://www.planetmysql.org/newfeed.php
PlanetMySQL Blog: Silent Install Instructions Lee Stigle
This entry provides instructions for "silently" installing MySQL on a Microsoft Windows server. I use the term "silent install" to describe the method of passing parameters to the Microsoft Installation Package (MSI) to bypass installation screens. This allows you to deploy MySQL with your application and to install MySQL without end-user intervention. The developer can define the install location, the appropriate storage engines, the root password and the server configuration.
Read the PlanetMySQL Blogpost: http://lstigile.wordpress.com/2009/11/02/silent-install-instructions/
PlanetMySQL Blog: Long running transactions Mark Callaghan
I was debugging a server that had too many concurrent queries. From SHOW INNODB STATUS output, there were many long running transactions with uncommitted work and there were many more transactions blocked on InnoDB locks. This is not a good state for a busy OLTP server and I am trying to figure out if the problem is the application or InnoDB.
Read the PlanetMySQL Blogpost: http://www.facebook.com/note.php?note_id=172915805932
PlanetMySQL Blog: PHP/C: Does MYSQL[I]_OPT_CONNECT_TIMEOUT work? Ulf Wendel
C and PHP MySQL clients can set a connection timeout before a connection is established to MySQL. The MySQL C API manual states about MYSQL_OPT_CONNECT_TIMEOUT, which is equal to PHPs MYSQLI_OPT_CONNECT_TIMEOUT:
That is half of the story. The actual behaviour depends on the library you use, the operating system and the transport protocol (TCP/IP, Unix domain sockets, Windows named pipes, Shared Memory).
Read the PlanetMySQL Blogpost: http://blog.ulf-wendel.de/?p=273
PlanetMySQL Blog: Agents, Hosts and Instances, Oh My!
Jonathon Coombes
The MySQL Enterprise Monitor (MEM) is designed to collect data from installations of MySQL and report back to the service manager so that information can be correlated and displayed in an easy to read form on the dashboard. What does become confusing sometimes for people is that the item displayed on the dashboard gives a hostname, but you have multiple databases running on that host?! How does MEM distinguish between all these installs of MySQL versus the hosts they are running on and how the data is collected for each one?
Read the PlanetMySQL Blogpost: http://blogs.sun.com/DatabaseEmporium/entry/agents_hosts_and_instances_oh
PlanetMySQL Blog: Data type confusion: what is an int(11)? Sarah Sproehnle
Over and over I see customers that don't understand what int(11) really means. Their confusion is understandable. Many know what defining a char(10) means (a fixed-sized character string that allows up to 10 characters). However, ints are different.
Read the PlanetMySQL Blogpost:
http://everythingmysql.ning.com/profiles/blogs/data-type-confusion-what-is-a n
PlanetMySQL Blog InnoDB Plugin (With some Windows focus) - Part 1 Anders Karlsson
So InnoDB is now, from 5.1.38, distributed with MySQL. It is still not enabled by default though. What this means is that there are 2 InnoDB implementations that comes with your MySQL installation. The old-school standard one, which is compiled in with the MySQL binary and is enabled by default, and one plugin.
PlanetMySQL Blog: Some friendly advice for bootstrapping your OSS project Lenz Grimmer
So you're a small startup company, ready to go live with your product, which you intend to distribute under an Open Source License. Congratulations, you made a wise decision! Your developers have been hacking away frantically, getting the code in good shape for the initial launch. Now it's time to look into what else needs to be built and setup, so you're ready to welcome the first members of your new community and to ensure they are coming back!
PlanetMySQL Blog: MySQL and hardware information Sheeri Cabral
People often ask "what's the best hardware to run a database on?" And the answer, of course, is "it depends". With MySQL, though, you can get good performance out of almost any hardware.
If you need *great* performance, and you have active databases with a large data set, here are some statistics on real life databases - feel free to add your own.
Read the PlanetMySQL Blogpost: http://www.pythian.com/news/3893/mysql-and-hardware-information
Yes, 150 means we added some 30 performance statistics to the MySQL native driver for PHP (mysqlnd) since monday. The new statistics are explained in three words: counting COM_* commands. COM_* commands refers to the command packets of the MySQL client server protocol. For example, COM_QUERY is used to execute nonprepared SQL statements.
Read the PlanetMySQL Blogpost: http://blog.ulf-wendel.de/?p=271
PlanetMySQL Blog: Secure Your Server - Tips for DBAs Everything MySQL
It has been the responsibility of the DBA to implement a security strategy, at least on the database level. All DBAs should take action, if not already, by taking a proactive approach to this crucial part of database administration. For this post I have compiled a list of general best practices below.
Read the PlanetMySQL Blogpost: http://everythingmysql.ning.com/profiles/blogs/secure-your-server-tips-for
PlanetMySQL Blog: MySQL Cluster 7.0.9a source release now available - replaces 7.0.9 Andrew Morgan
The source version for MySQL Cluster 7.0.9a has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.39-ndb-7.0.9a /
PlanetMySQL Blog: MySQL Cluster: Errors faced while importing data Umang Gopani
Here is the list of errors I have faced while importing a 25G .sql file into my cluster setup.
This is a test setup and to get maximum RAM availability, I have 3 data nodes and 1 Management node with replication factor of 1. The solutions provided are the ones which helped me.
Read the PlanetMySQL Blogpost: http://umangg.blogspot.com/2009/10/mysql-cluster-errors-faced-while.html
PlanetMySQL Blog: Configuring MySQL Cluster for Large Databases Johann Andersson
If you need to create a big database into MySQL Cluster with:
- A lot of tables indexes, columns, and tables - A lot of records
PlanetMySQL Blog: Make MySQL refuse connections until data nodes are started Geert JM Vanderkelen
MySQL Cluster 6.3.28 and 7.0.9 introduce the MySQL server option --ndb-wait-setup. This makes sure that clients can not connect the SQL Node when no Data Nodes are available within, by default, 15 seconds. When the timeout is reached, and no Data Nodes are available, the NDB storage engine will be marked as unavailable.
PlanetMySQL Blog: How MySQL Cluster Executes Queries Sarah Sproehnle
This post describes how MySQL Cluster executes queries. First of all, Cluster is a storage engine. It doesn't actually execute queries because it doesn't speak SQL. That is why you use a MySQL server, which parses your queries and sends low-level storage engine API calls to the Cluster data nodes. The data nodes know how to retrieve or store data. Or you can talk to the data nodes directly using the NDB API(s).
Read the PlanetMySQL Blogpost: http://everythingmysql.ning.com/profiles/blogs/how-mysql-cluster-executes
Events
Live Webinar: Memcached and MySQL for Rapidly Scaling High Traffic Websites Thursday, November 12, 2009 - 10:00 am PST
Please join us for this informative technical webinar with MySQL, Glam Media and Gear6. Glam Media was the 2nd fastest growing US-based web property in 2008 and continues to increase its unique visitor count by over 100% annually.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-458.html
Live Webinar: MySQL Cluster: Geographic Replication Deep-Dive - EMEA Tuesday, November 24, 2009 - 10:00am CET (EMEA)
MySQL Cluster has been deployed into some of the most demanding web, telecoms and enterprise/government workloads, supporting 99.999% availability with real time performance and linear write scalability.
Tune into this webinar where you can hear from the MySQL Cluster product management team provide a detailed "deep dive" into one of MySQL Cluster's key capabilities - Geographic Replication.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-463.html
Live Webinar: Migrating from SQL Server to MySQL Thursday, December 03, 2009 - 10:00am PST
Join us for Part 5 of the Windows and MySQL webinar series with Jimmy Guerrero and Mike Frank of the MySQL group at Sun Microsystems. In this presentation we will explore the benefits of migrating from Microsoft SQL Server to MySQL. We will also cover migration best practices, as well as, an overview of migration tools, scripts, datatype mapping and functional equivalents. If you are interested in learning how to migrate from SQL Server to MySQL, this webinar is for you.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-443.html
Live Webinar: For ISVs and OEMs: Getting Maximum Scalability and Availability with Java and MySQL Tuesday, December 08, 2009 - 10:00am PST
In this technical webinar, Mark Matthews will review the various MySQL-provided and third-party options for horizontally scaling J2EE applications that use MySQL on commodity hardware and making those applications highly available. He will provide the information you need to determine which option is best for your particular application.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-462.html
Live Webinar: Optimizing Queries for Performance Wednesday, December 09, 2009 - 10:00am CET (EMEA)
In this webinar we will show different methods to analyze and optimize queries to increase the performance of your MySQL database. We will focus on identifying problematic queries, analyzing their impact and possible optimizations. Examples will be shown during a live demo.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-465.html
Live Webinar: Why LiveTime Software Provides SQL Server to MySQL Migration for its Customers Tuesday, December 15, 2009 - 10:00am 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.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-466.html
Live Webinar: Windows Server Failover Clustering with MySQL Thursday, December 03, 2009 - 15:00 CET (EMEA) Thursday, December 17, 2009 - 10:00am PST (Americas)
Join us for Part 6 of the Windows and MySQL webinar series with Jimmy Guerrero and Mike Frank of the MySQL group at Sun Microsystems. 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. If you are interested in learning how to leverage Windows 2008 Server Failover Clustering with MySQL, this webinar is for you.
Register for this Webinar (EMEA): http://www.mysql.com/news-and-events/web-seminars/display-452.html
Register for this Webinar (Americas): http://www.mysql.com/news-and-events/web-seminars/display-444.html
On Demand Webinars
MySQL is pleased to make the following On-Demand Web Seminars available. They are recorded replays of our most popular live Web Seminars:
Introduction to MySQL on Windows (German): http://www.mysql.de/news-and-events/on-demand-webinars/display-od-454.html
Introduction to MySQL on Windows (Italian): http://www.mysql.it/news-and-events/on-demand-webinars/display-od-421.html
All On Demand MySQL Web Seminars: http://www.mysql.com/news-and-events/on-demand-webinars/
MySQL Seminar (Italian): The Revolution of the Open Source Data Warehouse November 18, 2009 - Milan
This event is designed *for decision makers* to learn more about how to use MySQL and complementary partner products from Talend and Infobright in order to lower the Data Warehouse TCO by up to 90%. During this event you will have plenty of opportunities to discuss the topic with our presenters and network with your peers.
A dedicated MySQL certified consultant will work closely with your team to:
- Analyze your current database application - Analyze your database requirements - Identify potential issues and limitations - Benchmark, load test, and optimize critical SQL queries - Help them implement best practices and recommend tools for developing your database infrastructure
Training: MySQL High Availability (3 Days) London, Paris, Milan, Chicago, Hamburg
This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.
Register Now for an Upcoming Date: http://www.mysql.com/training/courses/mysql_5_ha.html
-------------------------------------------------------------------
Partners
Article: MySQL Database Analytics with InfiniDB from Calpont
Let's be honest: working with big databases is a lot of fun. There's something cool about dealing with tables that have hundreds of millions or billions of rows in them, loading huge amounts of data, building star and snowflake schemas for data warehouses/marts, optimizing query performance, and all that jazz.
Read the Article - Part 1:
http://dev.mysql.com/tech-resources/articles/mysql_datawarehouse_calpont1.ht ml
Read the Article - Part 2:
http://dev.mysql.com/tech-resources/articles/mysql_datawarehouse_calpont2.ht ml
Live Webinar: Read/Write Load Balancing for MySQL with ZXTM in the Joyent Public Cloud Tuesday, November 17, 2009 - 10:00am PST
Join us for this informative technical webinar with Raja Srinivasan - Zeus Technology, Rod Boothby - Joyent, and Jimmy Guerrero - Sun Microsystems, where we will explore how to load balance MySQL in the Joyent Public Cloud with ZXTM.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-441.html
- The MySQL Librarian is Here - Find and Add MySQL Content! - Twitter: Follow the MySQL Community on Twitter! - Meet MySQL Experts at OpenSQL Camp Europe (August 22-23, Germany) - Case Study: MySQL Helps Simply Accounting by Sage Increase Revenue, Market Share, and Customer Satisfaction - Case Study: TweetMeme Manages Explosive Growth with MySQL Enterprise - Live Webinar: Introduction to MySQL Scale Out and Replication Services (Tuesday, August 18, 2009) - Live Webinar: MySQL at Clickability - Growing Small and Mid-Sized Businesses Fast on MySQL (Thursday, August 27, 2009)
New Product Releases
- New Release of MySQL Server 5.0.84 (GA) - New Release of MySQL Server 5.1.37 (GA) - New Release of MySQL Workbench 5.2.2 (Alpha) - New Release of MySQL Connector/Net 5.2.7 (GA) - New Release of MySQL Connector/Net 6.1.0 (Alpha) - New Release of MySQL Connector/J 5.1.8 (GA)
Hints & Tips
- White Paper: Open Databases White Paper - MySQL Provides Scalability, Reliability & Enterprise Support at a Lower Cost - White Paper: Guide to Using Open-source Software to Develop Web Applications - White Paper: MySQL Enterprise for Small and Mid-sized Businesses - Article: MySQL - Five More Dials To Turn - PlanetMySQL Blog Posts - PlanetMySQL Blog: OPTIMIZE TABLE on MySQL Cluster (revisited) - PlanetMySQL Blog: Understanding Different MySQL Index Implementations - PlanetMySQL Blog: Setting up MySQL Asynchronous Replication for High Availability - PlanetMySQL Blog: Possible Improvements to MySQL Administration - PlanetMySQL Blog: Disabling binary logging when restoring a MySQL dump - PlanetMySQL Blog: Auto-create relationships for MyISAM tables in MySQL Workbench
Spotlight: MySQL on Microsoft Windows
- White Paper: A Visual Guide to Installing MySQL on Windows - White Paper: A Visual Guide to Microsoft SQL Server 2008 Reporting Services and MySQL - White Paper: Guide to MySQL Embedded Server for Microsoft Windows - PlanetMySQL Blog: MySQL Windows Install Troubleshooting - Live Webinar: For ISVs - What's New in MySQL Connector/NET 6.1? (Tuesday, September 15, 2009)
Events
- Live Webinar: Tuning and Optimizing MySQL for Maximum Performance (Thursday, September 03, 2009) - Live Webinar: Advanced Techniques for High Traffic Sites (Thursday, September 17, 2009) - Live Webinar: For ISVs - Architecting Embedded Databases for High Performance Applications (Wednesday, September 23, 2009) - Live Webinar: High Availability Architectures for Online Applications (Tuesday, September 29, 2009)
Training, Consulting, & Certification
- Training: MySQL Performance Tuning (4 Days) - Consulting: MySQL Architecture and Design (2+ Days)
Partners
- Press Release: MySQL on the optimized Joyent Cloud is 3x faster than Amazon EC2! - Live Webinar: Kimball Group Data Warehousing Educational Webinar Series - Part II: Dimensional Modeling 101 (Wednesday, September 9, 2009)
The MySQL Librarian is Here - Find and Add MySQL Content!
We're pleased to announce the MySQL Librarian, a collection of community-generated and cross referenced content related to MySQL. It's a place where the community collaboratively builds and maintains MySQL content. Everyone is encouraged to add articles, presentations, videos, and pictures to the librarian.
Visit the MySQL Librarian: http://dev.mysql.com/librarian/
Read the Article "Introducing the MySQL Librarian": http://dev.mysql.com/tech-resources/articles/introducing-librarian.html
Read the Tutorial:
http://datacharmer.blogspot.com/2009/07/automating-mysql-librarian-tasks.htm l
Twitter: Follow the MySQL Community on Twitter!
In addition to MySQL, the MySQL Community has a separate Twitter account, with more than 1,000 followers. This account listens to and interacts with the MySQL community, by answering requests, announcing community related information, and giving advice. Join this big family by following the MySQL Community Twitter account.
Follow MySQL Community on Twitter: http://twitter.com/mysql_community
Meet MySQL Experts at OpenSQL Camp Europe (August 22-23, Germany)
The OpenSQL Camp Europe is being held in Sankt Augustin, Germany, in conjunction with FrOSCon on August 22 and 23. Many MySQL and open-source database talks will be presented, so if you are in Europe, it's definitely worth a visit. FrOSCon is one of the most charming and well organized open source events in Europe.
Learn More about OpenSQL Camp: http://opensqlcamp.org
Learn More about FrOSCon: http://froscon.org
Case Study: MySQL Helps Simply Accounting by Sage Increase Revenue, Market Share, and Customer Satisfaction
The Sage Group plc, is one of the world-wide market leaders in accounting and business management software and services for small and medium-sized businesses (SMBs), with over 5.8 million customers. In the Canadian market, Simply Accounting by Sage is the established market share leader in the small to mid-size business accounting software market with 54% of the Canadian retail market.
MySQL is now the new Sage database standard for Sage's small-to-medium targeted products. At present this includes Simply Accounting by Sage in Canada, Sage 50 HR in the UK and Sage's GS product line in Germany.
Read this Case Study: http://www.mysql.com/why-mysql/case-studies/mysql_cs_sage.php
Case Study: TweetMeme Manages Explosive Growth with MySQL Enterprise
Like many social network products, TweetMeme was initially developed in PHP using the MySQL open source database. With Twitter users growing at a month-over-month rate of approximately 82% for the first half of 2009, TweetMeme needed to manage incredible scalability demands being placed upon its database infrastructure. The nature of real-time search also meant that to stay competitive, TweetMeme needed to be highly available, offer lightning fast service delivery capability, while ensuring that management and administration costs didn't grow out of control.
Read this Case Study: http://www.mysql.com/why-mysql/case-studies/mysql_cs_Tweetmeme.php
Live Webinar: Introduction to MySQL Scale Out and Replication Services Tuesday, August 18, 2009 - 10:00am PDT
Join us for the first in a series of 4 webinars that will explore the different aspects of using MySQL as the database for online applications. With real life experience gained working with MySQL Customers such as Facebook, Alcatel-Lucent, and Google, this webinar series will give you the information you need to run scalable, highly available online applications.
In this first installment we look at the basics for deploying MySQL for a scalable online application. Whether you are already using MySQL for your online application or considering it for a new project, register today to learn how you can make best use of the world's most popular database for online applications.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-400.html
Live Webinar: MySQL at Clickability - Growing Small and Mid-Sized Businesses Fast on MySQL Thursday, August 27, 2009 - 10:00am PDT
MySQL is a proven business-critical database that provides incredible scale and performance at a significantly lower total cost of ownership. At the same time, MySQL is also easy to deploy, easy to use, and requires low administration which makes it ideal for small and mid-sized businesses.
In this informative webinar, Jeff Freund, CTO and Co-Founder at Clickability, will discuss how the company builds its core application on MySQL and grows from a small start-up to a global leader in on demand Web Content Management. You'll also learn from Alex Roedling, Sr. MySQL Product Marketing Manager at Sun Microsystems, regarding MySQL's benefits and how it can be leveraged to build a scalable, reliable and high performance platform in your fast-growing business.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-395.html
MySQL Community Server 5.0.84, 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.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.0/en/news-5-0-84.html
MySQL Community Server 5.1.37, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.37 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-37.html
Read the Documentation: http://dev.mysql.com/doc/refman/5.1/en/index.html
New Release of MySQL Workbench 5.2.2 (Alpha)
The MySQL Workbench team announces the availability of version 5.2.2 - the 3rd alpha release - of our database development tool. Since the last alpha release, several bugs have been fixed and fixes from the 5.1 branch were also included.
View the complete list of changes: http://dev.mysql.com/workbench/?page_id=49
MySQL Connector/Net 5.2.7, a new version of the all-managed .NET driver for MySQL has been released. This release is of GA quality and is suitable for use in production environments. We have many fixes in this release so please review the changelog and see if your favorite bug has been fixed. This version officially supports all versions of MySQL from 4.1 and later.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-5-2-7.html
MySQL Connector/Net 6.1.0, a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release and is intended to introduce you to the new features and enhancements we are planning. This release should not be used in a production environment. Additional functions include:
- Support for native output parameters - Session State Provider - Website Configuration Dialog
View the complete list of changes: http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-6-1-0.html
MySQL Connector/J 5.1.8, 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.8 is suitable for use with any MySQL version, including version 4.1, 5.0, 5.1 and the 5.4 performance release.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-8.html
White Paper: Open Databases White Paper - MySQL Provides Scalability, Reliability & Enterprise Support at a Lower Cost
Enterprises are looking for the best, most cost-effective way to manage the ever-increasing amount of data, an ever-growing pool of users, and unrelenting demands for high availability. As proprietary database systems have grown increasingly complex with features that many companies don't need, they have also become harder to manage and more expensive in terms of upgrades and staffing, training, and support. The Sun MySQL database delivers the scalability and features that companies need but with less complexity and lower costs than proprietary systems.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_open_online_database.ph p
White Paper: Guide to Using Open-source Software to Develop Web Applications
As enterprises struggle to develop and deliver new and more dynamic services to more people, they must do so with severe budget constraints. They need a Web infrastructure that can enable higher developer productivity at a lower cost. While many enterprises are looking to open-source software to meet these complex requirements, managing and supporting a range of disparate software solutions is a huge challenge for the IT staff.
Read this White Paper: http://www.mysql.com/why-mysql/white-papers/mysql_wp_open_web_platform.php
White Paper: MySQL Enterprise for Small and Mid-sized Businesses
This paper explores the database, monitoring and support components of MySQL Enterprise and how Small and Mid-Sized businesses under pressure to "do more with less" can confidently deploy it as part of a cost-effective and low-maintenance platform, ideal for delivering Internet-based applications for fast-growing businesses.
Read this White Paper: http://www.mysql.com/why-mysql/white-papers/mysql_wp_Enterprise_SMB.php
Article: MySQL - Five More Dials To Turn Sean Hull
Last month we talked about some things to set and tune in a new MySQL database installation. We touched on connections, query cache, temp tables, session memory, and the slow query log. This second part in the series hits on some other very important things to tune in a new MySQL database.
Read this Article:
http://www.databasejournal.com/features/mysql/article.php/3828566/article.ht m
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: OPTIMIZE TABLE on MySQL Cluster (revisited) Johan Andersson
Before, OPTIMIZE TABLE hardly freed up any pages and to defragment you had to do a rolling restart of the data nodes. Now, there is only a 2% discrepancy between OPTIMIZE TABLE and doing a rolling restart. This is great stuff. This fix will make into MySQL Cluster 6.3.26 and 7.0.7.
PlanetMySQL Blog: Understanding Different MySQL Index Implementations Ronald Bradford
It is important to know and understand that while indexing columns in MySQL will generally improve performance, using the appropriate type of index can make a greater impact on performance.
PlanetMySQL Blog: Setting up MySQL Asynchronous Replication for High Availability Andrew Morgan
MySQL replication is often positioned as a solution to provide extra throughput for your database. What tends to be overlooked is how it can be used to provide high availability (HA) - no matter how much redundancy you have at a local level, your system remains at risk from a single catastrophic failure - loss of power, earthquake, terrorist attack etc.
PlanetMySQL Blog: Possible Improvements to MySQL Administration Simon Mudd
One thing you learn when you start to manage several servers is that life is easier if things are done the same way. I manage a few MySQL database instances on a few different hosts and here are a list of some things which I think could do with improvement.
Read the PlanetMySQL BlogPost: http://blog.wl0.org/2009/07/possible-improvements-to-mysql-administration/
PlanetMySQL Blog: Disabling binary logging when restoring a MySQL dump Geert JM Vanderkelen
There is a cool option for mysqlbinlog for disabling the binary log when doing recovery using binary logs, namely --disable-log-bin. How, one would think it is also available for something like mysqldump or even the mysql CLI?
PlanetMySQL Blog: Auto-create relationships for MyISAM tables in MySQL Workbench Alfredo Kojima
Over a chat on the #workbench IRC channel, Collin Cusce has written a handy little Lua script to automatically create relationships (through foreign keys) for his reverse engineered database.
Read the PlanetMySQL BlogPost: http://dev.mysql.com/workbench/?p=271
White Paper: A Visual Guide to Installing MySQL on Windows
This 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.
White Paper: A Visual Guide to Microsoft SQL Server 2008 Reporting Services and MySQL
For many years, Microsoft Windows has been the most popular development platform and second most popular production platform for organizations developing MySQL applications. We also found that roughly one in three MySQL Enterprise shops also made use of Microsoft SQL Server. In this paper we will visually show you how to connect MySQL into some of the existing tools that the SQL Server DBA will already be familiar with.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_MSReporting_Services.ph p
White Paper: Guide to MySQL Embedded Server for Microsoft Windows
This Guide outlines the reasons why MySQL on Windows continues to be a popular choice for independent software vendors, original equipment manufacturers, and hosting providers. In addition, it provides tips and links to various resources on how to develop and optimize MySQL applications on Windows.
PlanetMySQL Blog: MySQL Windows Install Troubleshooting Lee Stigile
If you're having trouble installing MySQL 5.1 on a Windows server, I'd recommend the following process. Don't skip the first steps that describe the uninstall and removal of the previous install as this seems to clear up most issues.
Live Webinar: For ISVs - What's New in MySQL Connector/NET 6.1? Tuesday, September 15, 2009 - 10:00am PDT
MySQL Connector/Net 6.1.0 is the latest version of the all-managed .NET driver for MySQL. In this Web seminar, Reggie Burnett, the creator of MySQL Connector/NET 6.1, will introduce you to its new features and enhancements and explain how and when to use them for optimal results with your Windows applications.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-407.html
Live Webinar: Tuning and Optimizing MySQL for Maximum Performance Thursday, September 03, 2009 - 10:00am PDT
Join us for the second of our 4 part webinar series exploring the different aspects of using MySQL as the backend database for online applications.
For our second installment we will look at performance tuning. You will get expert insight and learn best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-401.html
Live Webinar: Advanced Techniques for High Traffic Sites Thursday, September 17, 2009 - 10:00am PDT
Join us for the 3rd of our 4 part webinar series exploring the different aspects of using MySQL as the database for online applications. In the 3rd part of this webinar series we examine some of the advanced techniques available to service complex, high traffic, online applications.
We will discuss guidelines, best practices and customer examples in the following areas: caching services such as memcache, session management, intelligent load balancing via MySQL Proxy, use of Cloud services for on demand scalability, and using MySQL Enterprise and the new MySQL Query Analyzer.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-402.html
Live Webinar: For ISVs - Architecting Embedded Databases for High Performance Applications Wednesday, September 23, 2009 - 10:00am PDT
In this Web seminar you'll learn the tips and tricks for architecting your application's embedded or bundled database for higher performance and customer satisfaction.
Using MySQL Embedded Server as our example, the MySQL Consulting pros will take you through the steps they use to optimize MySQL Embedded Server to achieve highest database and application performance. They will also help you find the right answers to important architecture choices that can impact your application's performance.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-405.html
Live Webinar: High Availability Architectures for Online Applications Tuesday, September 29, 2009 - 10:00am PDT
Join us for the last of our 4 part webinar series exploring the different aspects of using MySQL as the backend database for online applications. In this last installment we look at MySQL high availability technologies and architectures. We will explore the use cases for implementing MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD), and other high-availability technologies
Also covered will be the fundamentals of how these technologies work and how they can be combined to create a more scalable and highly available database infrastructure. Several case studies will be presented to show how these technologies have been implemented in the real world.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-403.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 MySQL Webinars: http://www.mysql.com/news-and-events/web-seminars/index.html
Training: MySQL Performance Tuning (4 Days) Paris, Nashville, Sao Paulo, Portland
The MySQL Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare you with the skills needed to utilize tools for monitoring, evaluating and tuning. You 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.
Register Now for an Upcoming Date: http://www.mysql.com/training/courses/performance_tuning.html
Consulting: MySQL Architecture and Design (2+ Days)
A dedicated MySQL certified consultant will work closely with you to review your database application plans and provide an analysis of how to architect them for current and future requirements. Sun's MySQL consultants can provide expertise in the following areas:
- Web Applications - Online Transaction Processing (OLTP) - Data Warehousing - Online Analytical Processing (OLAP) - High Availability - Load Balancing - Embedded Systems - Search Applications
Press Release: MySQL on the optimized Joyent Cloud is 3x faster than Amazon EC2!
Joyent, the industry leading Enterprise-Class Cloud Computing provider is excited to announce the launch of the Joyent Virtual Appliance for MySQL! The Joyent Virtual Appliance for MySQL is pre-configured to maximize the database's performance on Joyent's powerful, secure and stable virtualization technology. The most recent performance benchmarks have demonstrated that the Joyent Virtual Appliance for MySQL can deliver 3 times the number of Transactions per Second or more than comparable deployments of XEN based clouds, such as Amazon's EC2.
Read the Full Press Release: http://www.mysql.com/news-and-events/generate-article.php?id=1625
Learn More about MySQL Enterprise on the Joyent Cloud: http://www.mysql.com/products/enterprise/joyent.html
Register for the Webinar to Learn More: http://www.mysql.com/news-and-events/web-seminars/display-414.html
Live Webinar: Kimball Group Data Warehousing Educational Webinar Series - Part II: Dimensional Modeling 101 Wednesday, September 9, 2009 - 10:00am PDT
According to a recent Aberdeen Group report, top-performing companies deploy business intelligence (BI) at a rate of 2.5x more than their peers. The foundation for any successful BI deployment is the data warehouse (DW). Understanding how to properly design and deploy a DW is therefore key.
In this second webinar presented by Kickfire and Sun, Joy Mundy of The Kimball Group explains the fundamentals of dimensional modeling - the logical design technique for building data warehouses.
Copyright (c) 2009 Sun Microsystems. All rights reserved.
- MySQL Enterprise Monitor with Enhanced Query Analyzer (Beta) is Available Now! - Small to Mid-Size Business Solutions from MySQL - For ISVs: Take the MySQL OEM Life Cycle Survey and Win a $150 Amazon.com Gift Certificate - Case Study: thePlatform Migrates Media Publishing System to MySQL and Achieves 23x Performance Gain with the MySQL Query Analyzer - Case Study: Datagest selects MySQL for tour operator management application - Live Webinar: Scalable MySQL High Availability Architectures (June 23, 2009) - Live Webinar: Kimball Group Data Warehousing Educational Webinar Series - Part I: Data Warehousing Fundamentals (June 25, 2009) - Upcoming MySQL University Sessions - Last Two Sessions before the Summer Break
New Product Releases
- New Release of MySQL Community Server 5.0.83 (GA) - New Release of MySQL Community Server 5.1.35 (GA) - New Release of MySQL Community Server 6.0.11 (Alpha) - New Release of MySQL Cluster 7.0.6 (GA) - New Release of MySQL Workbench 5.2.1 (Alpha)
Hints & Tips
- Article: MySQL Developer, Meet the MySQL Query Analyzer - White Paper: Server Virtualization and MySQL - Your Options - White Paper: Best Practices for MySQL on Amazon EC2 - White Paper: A Guide to Open Source Data Warehousing for Communications Service Providers - PlanetMySQL Blog Posts - PlanetMySQL Blog: MySQL Clustering in a Sandbox - PlanetMySQL Blog: From Russia with Blogs - PlanetMySQL in Russian - PlanetMySQL Blog: Basic MySQL Security - Providing passwords on the command line - PlanetMySQL Blog: Replicating from MySQL to * - PlanetMySQL Blog: MySQL Cluster - flexibility of replication - PlanetMySQL Blog: Scaling Writes, Using MySQL Cluster to non-Cluster Replication
Spotlight: MySQL Performance Tips
- Article: Improving Database Performance with Partitioning - Video: MySQL Query Analyzer In Action - PlanetMySQL Blog: A 10x Performance Increase for Batch INSERTs With MySQL Connector/J Is On The Way - PlanetMySQL Blog: MySQL Performance - InnoDB Dirty Pages & Log Size Impact - Live Webinar: Architecting Databases for High Performance (June 23, 2009) - Live Webinar: Architecting Databases for High Performance - for Commercial Application Developers / ISVs (June 25, 2009) - Live Webinar: Improve Application Performance with the MySQL Enterprise Monitor and the MySQL Query Analyzer (June 30, 2009)
Events
- Live Webinar: Guide to Scaling OpenLDAP - MySQL Cluster as Data Store for OpenLDAP Directories (June 24, 2009) - On-Demand Webinar: MySQL Performance Tuning Step-by-step - On-Demand Webinar: Data Warehousing for Communications Service Providers
Training, Consulting, & Certification
- Training: MySQL High Availability (3 Days) - Consulting: MySQL Cluster Jumpstart (4+ Days)
Partners
- GA Release of IBM DB2 for i (IBMDB2I) Storage Engine for MySQL
MySQL Enterprise Monitor with Enhanced Query Analyzer (Beta) is Available Now!
The MySQL Enterprise Monitor now correlates MySQL and OS graph activities with your queries, allowing you to view query history graphs in the query pop-ups and to track query errors and warnings. Be the first to evaluate and provide feedback on this new beta release and start finding your most expensive queries now!
Not yet a MySQL Enterprise customer? You can still get a test drive on this beta release of MySQL Enterprise Monitor by signing-up the MySQL Enterprise 30-day Trial.
Download Now (Login Required): https://enterprise.mysql.com/monitoring/prerelease.php
Sign-up for the MySQL Enterprise Trial: http://www.mysql.com/trials/
Small to Mid-Size Business Solutions from MySQL
Your business may be small or mid-sized but your business pressures are just as big as any global enterprise. For businesses like yours, open source applications offer a scalable, reliable and high performance platform that allows you to keep total cost of ownership extremely low. Learn how MySQL and open source applications can add value to your business with white papers, webinars, case studies and solutions on the MySQL Small and Medium Business Resource Center.
Read the MySQL SMB Resource Center: http://mysql.com/industry/smb/
For ISVs: Take the MySQL OEM Life Cycle Survey and Win a $150 Amazon.com Gift Certificate
Are you a Commercial Software Developer or Product Manager but missed the survey last month? Here is your opportunity again! Please help us understand how the MySQL team can provide best value to you by taking a 3 minute survey on your product's development cycle. And, you'll be entered to win a $150 Amazon.com gift certificate.
Take the Survey Now: http://www.zoomerang.com/Survey/survey.zgi?p=WEB22957RJFHET
Case Study: thePlatform Migrates Media Publishing System to MySQL and Achieves 23x Performance Gain with the MySQL Query Analyzer
thePlatform is a leading, fast-growing video management and publishing company for broadband, mobile and TV. Comcast Interactive Media acquired thePlatform in 2006, which now operates as a stand-alone subsidiary.
thePlatform had been using proprietary databases to store meta data for media files. To further scale the system and reduce costs, thePlatform decided to migrate the application to MySQL. thePlatform also used the MySQL Query Analyzer to quickly identify critical performance issues before going into production and reduced the query time by 95% from 70 seconds to 3 seconds. They achieved the 23x performance gain in just a few minutes, rather than days.
Read the Case Study: http://www.mysql.com/why-mysql/case-studies/mysql_cs_theplatform.php
Case Study: Datagest selects MySQL for tour operator management application
Datagest is an IT company serving the Italian tourism industry using both specialized solutions - its own products customized for customers' requirements - and strategic consultancy. Datagest has helped TUI Italia, Meridiana, Gruppo Grimaldi, and Gardaland to create quotes and sales documents in seconds and without any mistakes.
Flexibility, stability, platform portability, documentation, low cost, support, training, global presence, throughput, scalability, security etc. are the reasons why Datagest relies on MySQL Embedded Server for its solutions. For Datagest MySQL has proven to be the best solution for operating in dot.net environments.
Read the Case Study: http://www.mysql.com/why-mysql/case-studies/mysql_cs_datagest.php
Live Webinar: Scalable MySQL High Availability Architectures Tuesday, June 23, 2009 - 13:00 UTC
Join us for this informative technical webinar where we will explore various MySQL high availability technologies and architectures. We will explore the use cases for when to implement MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD) and other high-availability technologies. Also, covered will be the fundamentals of how these technologies work and how they can be combined to create a more scalable and highly available database infrastructure.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-371.html
Live Webinar: Kimball Group Data Warehousing Educational Webinar Series - Part I: Data Warehousing Fundamentals Thursday, June 25, 2009 - 1:00pm PDT / 4:00pm EDT
Business Intelligence/analytics continues to grow in importance. According to Gartner's survey of 1500 CIO's, it is the #1 priority for a fourth year in a row. The foundation for any successful deployment of analytics is the data warehouse (DW). Understanding how to properly design and deploy a DW is therefore key. In the first part of a three-part series, Joy Mundy, of the world-renowned Kimball Group, explains the fundamentals of data warehousing.
Register for this Webinar: http://info.kickfire.com/Kimball_Group_Webinar_Series_Part1_6_25_09.html
Upcoming MySQL University Sessions - Last Two Sessions before the Summer Break
MySQL University is a no cost online training program for Sun Engineers, MySQL Community Contributors and anyone who's interested in MySQL development and internals. Take your opportunity to join these two upcoming sessions before the annual summer break:
- June 25: MySQL Code Contributions (Lenz Grimmer, MySQL Community Team) - July 2: Starring Sakila - a Data Warehouse Mini-Tutorial (Roland Bouman, Abvakabo NV)
MySQL Community Server 5.0.83, 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.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.0/en/news-5-0-83.html
MySQL Community Server 5.1.35, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.35 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-35.html
New Release of MySQL Community Server 6.0.11 (Alpha)
MySQL 6.0.11-alpha, a new version of the MySQL database system has been released. MySQL 6.0.11 will be the last release of 6.0. After this we will be transitioning into a new release model for the MySQL Server. The goal of this transition is to enable more frequent and timely releases of the MySQL Server.
View the complete list of changes: http://dev.mysql.com/doc/refman/6.0/en/news-6-0-11.html
MySQL Cluster 7.0.6, a new version of the leading open source, high availability database for real-time, mission critical telecommunications services, has been released in source and binary forms. MySQL Cluster version 7.0.6 uses MySQL Server version 5.1.34 and contains all bug fixes and updates to both MySQL Server 5.1.33 and 5.1.34.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-5-1-34-ndb-7-0-6.html
Read the White Paper: MySQL Cluster 7.0 - Architecture & New Features: http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster7_architecture.php
Read the White Paper: MySQL Cluster 7.0 - Evaluation Guide: http://www.mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php
New Release of MySQL Workbench 5.2.1 (Alpha)
We're proud to announce the availability of the second Alpha release of MySQL Workbench 5.2. This is the youngest member of the workbench family and this version also adds the database querying tool to the application. There have been major enhancements - not only to the querying part - since we released the first alpha version.
Article: MySQL Developer, Meet the MySQL Query Analyzer
As Product Managers with MySQL, Robin Schumacher and I have heard loud and clear from customers and users that they love MySQL's ease of use and reliability, but see it as a "black box", specifically when it comes to identifying problematic SQL code. Polling of our Community and Enterprise users also reveals that finding problem SQL is commonly the #1 challenge they say that comes with deploying and scaling applications on MySQL.
Read this Article: http://dev.mysql.com/tech-resources/articles/quan_for_developers.html
White Paper: Server Virtualization and MySQL - Your Options
Virtualization technology has now gone main stream, and its footprint within IT infrastructures continues to accelerate. This paper will explain virtualization technologies and how they work with MySQL to help optimize your infrastructure investment while at the same time increasing the performance and availability of your business-critical applications.
Read this White Paper: http://www.mysql.com/why-mysql/white-papers/mysql_wp_virtualization_options.php
White Paper: Best Practices for MySQL on Amazon EC2
Currently, the most popular cloud computing platform is Amazon Web Services (AWS) and the most popular database in the cloud is MySQL. Although Amazon originally launched AWS in 2002 and since has made available many new computing services, for the purposes of this paper we will focus on those most relevant to deploying MySQL - specifically Elastic Computing Cloud (EC2), Simple Storage Service (S3) and Elastic Block Store (EBS). These are services which developers can access using web services, specifically REST and SOAP protocols.
Read this White Paper: http://www.mysql.com/why-mysql/white-papers/mysql_wp_best_practices_mysql_ec2.php
White Paper: A Guide to Open Source Data Warehousing for Communications Service Providers
Download this joint whitepaper from Infobright and MySQL to learn how open source data warehousing enables Communications Service Providers to gain greater subscriber insight, with lower cost and risk than ever before.
Read this White Paper: http://www.mysql.com/why-mysql/white-papers/mysql_wp_infobright_telecon.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://www.planetmysql.org
Submit Your Blog Feed: http://www.planetmysql.org/newfeed.php
PlanetMySQL Blog: MySQL Clustering in a Sandbox Sean Hull
MySQL's unique architecture allows for plugin storage engines. So for example, there is the MyISAM storage engine, the original one, and there is the ARCHIVE storage engine, which has characteristics that make it suitable for storing archived data. And of course we know the InnoDB storage engine, with its transactional capabilities. So it makes sense then that MySQL's clustering solution involves a storage engine as well, namely the NDB (Network DataBase) storage engine.
Read the PlanetMySQL BlogPost: http://www.databasejournal.com/features/mysql/article.phpr/3819061/article.htm
PlanetMySQL Blog: From Russia with Blogs - PlanetMySQL in Russian Duleepa 'Dups' Wijayawardhana
We've enabled Russian as a choice in PlanetMySQL and feel free to start submitting your Russian language blogs.
- Russian Language PlanetMySQL: http://ru.planet.mysql.com - New feed submissions: http://ru.planet.mysql.com/new
Read the PlanetMySQL BlogPost: http://blogs.sun.com/dups/entry/from_russia_with_blogs_planetmysql
PlanetMySQL Blog: Basic MySQL Security - Providing passwords on the command line Lenz Grimmer
Reading through the comments in Ronald's second post about More Basic MySQL Security, I noticed that there seems to be a misunderstanding about the implications of providing passwords to the mysql command line client via the "-p" option.
Read the PlanetMySQL BlogPost: http://www.lenzg.net/archives/256-Basic-MySQL-Security-Providing-passwords-on-the-command-line.html
PlanetMySQL Blog: Replicating from MySQL to * Darren Cassar
Recently I needed to replicate between MySQL and another database technology. You might say, why on earth would you want to do something like that, but believe me there are reasons and definitely not to go away from MySQL to some other DB technology like Oracle or SQL server. Unsurprisingly there are quite a few different tools to do it from any platform towards MySQL but very few which do it the other way round, just to name a couple: Golden Gate and DSCallards.
Read the PlanetMySQL BlogPost: http://mysqlpreacher.com/wordpress/2009/05/replicating-from-mysql-to/
PlanetMySQL Blog: MySQL Cluster - flexibility of replication Andrew Morgan
One of the better kept secrets about MySQL Cluster appears to be the flexibility available when setting up replication. Rather than being constrained to implementing a single replication scheme, you can mix and match approaches.
Read the PlanetMySQL BlogPost: http://www.clusterdb.com/mysql-cluster/mysql-cluster-flexibility-of-replication/
PlanetMySQL Blog: Scaling Writes, Using MySQL Cluster to non-Cluster Replication Johan Andersson
There are various setups and solutions to solve the problem of having redundant MySQL masters and scaling writes on them. MySQL Cluster can be an alternative. Here is why and how...
Read the PlanetMySQL BlogPost: http://johanandersson.blogspot.com/2009/05/ha-mysql-write-scaling-using-cluster-to.html
Article: Improving Database Performance with Partitioning Robin Schumacher
One of the reasons I'm very excited about the release of MySQL 5.1 is that it contains a potent new weapon for designing supercharged databases that any MySQL DBA should quickly learn how to use and exploit. By smartly using the new 5.1 partitioning feature, a DBA can oftentimes dramatically improve the performance of almost any VLDB or data warehouse they happen to be in charge of.
Read the Article: http://dev.mysql.com/tech-resources/articles/performance-partitioning.html
Read More Performance Tuning and Optimization Tips in the MySQL Performance Resource Center: http://www.mysql.com/performance
Video: MySQL Query Analyzer In Action
Don't miss any performance tuning opportunity! Learn how the MySQL Query Analyzer can help you find and fix your most expensive queries in minutes vs hours, all with no dependence on the MySQL Slow Query Log.
Watch the Video: http://webcast-west.sun.com/interactive/09D12514/index.html
PlanetMySQL Blog: A 10x Performance Increase for Batch INSERTs With MySQL Connector/J Is On The Way Mark Matthews
Connector/J has a feature where the driver can take prepared statements of the form "INSERT INTO foo VALUES (...)", and if configured with "rewriteBatchedStatements=true", can re-write batches of them to the form "INSERT INTO foo VALUES (...), (...), (...)". This is a performance win on a few fronts, because of reduction in latency and because of optimizations of handling "multivalue" INSERT in the server itself.
Read the PlanetMySQL BlogPost: http://www.jroller.com/mmatthews/entry/speeding_up_batch_inserts_for
The beginning of this story is coming from the first weeks of the last year - when seeking for the most optimal MySQL config parameters I've discovered a strange thing ... I've told a lot of people, but everybody was just surprised and did not really believe such case is possible.
Read the PlanetMySQL BlogPost: http://dimitrik.free.fr/blog/archives/05-01-2009_05-31-2009.html#52
Live Webinar: Architecting Databases for High Performance Tuesday, June 23, 2009 - 10:00am PDT
This complimentary web seminar will show the tips and tricks for architecting your database for high performance. Using MySQL as our example, you'll learn the steps the pros use for architecting and optimizing databases for performance and scalability. Get the keys to designing a MySQL database for performance and scalability to meet both current and future user demands! In this webinar, the MySQL Consulting pros will introduce you to the steps they use to design a high performance MySQL database server.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-372.html
Live Webinar: Architecting Databases for High Performance - for Commercial Application Developers / ISVs Thursday, June 25, 2009 - 10:00am PDT
This complimentary web seminar will give you the tips and tricks for architecting your database for highest performance. Using MySQL as our example, you'll learn the steps a foremost database performance expert uses to architect and optimize databases for performance and scalability.
MySQL Performance Guru, Jay Pipes will share his expert insight and best practices to help you identify those areas of database architecture and application design that will give you the greatest performance benefits.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-373.html
Live Webinar: Improve Application Performance with the MySQL Enterprise Monitor and the MySQL Query Analyzer Tuesday, June 30, 2009 - 10:00am PDT
Are you looking for performance tuning opportunities in MySQL?
In this technical webinar, Phil Hildebrand, Database Manager at thePlatform, will talk about how they used the MySQL Enterprise Monitor, the MySQL Enterprise Advisors and the MySQL Query Analyzer to deploy new applications and implement changes to production systems more efficiently. Phil will present these tools from a practical, user-oriented perspective, and also showcase how to achieve significant performance enhancements while reducing troubleshooting time of difficult SQL code issues.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-359.html
Live Webinar: Guide to Scaling OpenLDAP - MySQL Cluster as Data Store for OpenLDAP Directories Wednesday, June 24, 2009 - 10:00am PDT
Discover how to fully exploit distributed subscriber and network data, and how to enhance your investments in OpenLDAP technology by tuning into this webinar, jointly run by OpenLDAP and MySQL.
In this webinar, the Chief Architect of OpenLDAP will demonstrate where this solution can be used, and how to get started with MySQL Cluster as the directory data store.
Register for the Webinar: http://www.mysql.com/news-and-events/web-seminars/display-366.html
On-Demand Webinar: MySQL Performance Tuning Step-by-step
Learn the basic steps the MySQL Consulting pros follow to tune a MySQL database server. Each step will be covered at a high level with one or two of the most critical parameters covered in detail for each step.
Learn not only what to tune, but also how to determine what you NEED to tune. Do you want to know what to watch and how to tune for connections? What caches/buffers are allocated per session, when are they allocated and how to monitor them? What can you do in 10 minutes to speed up your MyISAM or InnoDB performance? Get the answers to these and other tuning questions in this online talk.
Register for this Webinar: http://www.mysql.com/news-and-events/on-demand-webinars/display-od-356.html
On-Demand Webinar: Data Warehousing for Communications Service Providers
Tune into this on-demand webinar from Infobright and MySQL to learn how open source data warehousing enables Communications Service Providers to gain greater subscriber insight, with lower cost and risk than ever before.
Register for this Webinar: http://www.mysql.com/news-and-events/on-demand-webinars/display-od-326.html
More MySQL webinars are scheduled and added between each Newsletter edition, so visit our website for the most updated information.
View the full list of webinars: http://www.mysql.com/news-and-events/web-seminars/index.html
Training: MySQL High Availability (3 Days) Seattle, Singapore, Paris, Lyon
This course is designed for experienced database administrators and system architects who want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate for you and how to implement a system with the correct design.
Register Now for an Upcoming Date: http://www.mysql.com/training/courses/mysql_5_ha.html
Consulting: MySQL Cluster Jumpstart (4+ Days)
Sun's MySQL consultants will use proven methodologies and expertise in database clustering, replication, fail-over, fault-tolerance and other HA techniques to help jump start your high-availability database projects and recommend project roadmaps to help you successfully implement MySQL Cluster.
GA Release of IBM DB2 for i (IBMDB2I) Storage Engine for MySQL
A new pluggable storage engine has been developed specific to MySQL running in IBM i, V5R4 and V6R1, and is now available as GA starting from version 5.1.35. This storage engine is the DB2 for i (IBMDB2I) Storage Engine for MySQL on IBM i.
