MySQL Newsletter June 2007
Articles in this newsletter:
Highlights
- Customer Spotlight: 12 Days of Scale-Out
- Case Study: Quantel Reduces Time-to-Air for Broadcasters
- White Paper: MySQL, The Embedded Database for ISVs
New Product Releases
- MySQL Enterprise Server 5.0.42
- MySQL Community Server 5.1.19 (Beta)
- MySQL Connector/ODBC 3.51.16 (GA)
Hints & Tips
- Article: MySQL on Windows? Absolutely
- Article: Debunking GROUP BY Myths
- Interview: Jan Kneschke, Developer at MySQL AB
- PlanetMySQL Blog Posts
- MySQL Forge: Delayed Slave
- MySQL Forge: Backup MySQL Binary Logs
Events
- Live Web Seminar: MySQL Performance Tuning Best Practices (July 11)
- Live Web Seminar: Embedded MySQL Applications (July 31)
- Conference: Ubuntu Live (July 22-24)
- Conference: OSCON (July 23-27)
- MySQL Camp II (August 23-24)
Training, Consulting & Certification
- Training: MySQL 5.0 for Developers (5 Days): MySQL 5.0 for Developers (5 Days)
- Training: MySQL 5.0 for Database Administrators (5 days)
Partner Corner
- FileMaker: FileMaker + MySQL = Rapidly Build Database Solutions
- Rippletech: Achieving PCI Compliance by Securing Sensitive MySQL Enterprise Database Assets
- Talend: Integrating MySQL Enterprise in the Information System, an Open Source Approach
- Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today.
- On Demand Webinar: Becoming a MySQL Reseller Partner
Highlights
Customer Spotlight: 12 Days of Scale-Out
Each day from June 11-22, the MySQL Web site is highlighting how many of the world's fastest growing companies are using MySQL to cost-effectively Scale-Out their successful online businesses. Some of the companies that have been featured include Wikipedia, Booking.com, Zimbra and Alcatel-Lucent.
Learn More » (http://www.mysql.com/scaleout)
Case Study: Quantel Reduces Time-to-Air for Broadcasters
When a news and sports broadcaster like ESPN needs to get quality content to air as soon as possible, they use systems from Quantel. MySQL replication capabilities, low complexity, and high performance is helping journalists be more productive and improve the bottom line of broadcasters.
Download the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql-cs-quantel.php)
White Paper: MySQL, The Embedded Database for ISVs
The MySQL Server, the world's most popular open source database, has been named a leader in the overall and embedded database management market by Forrester and other analyst groups. This paper explores these benefits in detail and showcases why MySQL is the ideal choice for OEM's and ISV's when it comes to selecting an embedded database for their application.
Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_embedded.php)
New Product Releases
New Release of MySQL Enterprise Server 5.0.42
This is a Monthly Rapid Update release of the MySQL Enterprise Server 5.0. The following is a partial list of changes:
- Security fix: Use of a view could allow a user to gain update privileges for tables in other databases. (Bug#27878)
- Security fix: If a stored routine was declared using SQL SECURITY INVOKER, a user who invoked the routine could gain privileges. (Bug#27337)
- Security fix: The requirement of the DROP privilege for RENAME TABLE was not being enforced. (Bug#27515)
View the complete list of changes »
New Release of MySQL Community Server 5.1.19 (Beta)
This is a new Beta development release, fixing recently discovered bugs. The following is a partial list of changes:
- The data type used for the VARIABLE_VALUE column of the following INFORMATION_SCHEMA tables has been changed to VARCHAR:
- GLOBAL_STATUS
- SESSION_STATUS
- GLOBAL_VARIABLES
- SESSION_VARIABLES
- A new status variable, Com_call_procedure, indicates the number of calls to stored procedures.
View the complete list of changes »
MySQL Connector/ODBC 3.51.16 (GA)
MySQL Connector/ODBC 3.51.16, a new version of the ODBC driver for the MySQL database system, has been released. This release is the latest release of the 3.51 series and is suitable for use with any MySQL version including MySQL 4.1, 5.0, or 5.1.
- Added support for using SSL. This is not yet exposed in the setup GUI, but must be enabled through configuration files or the DSN.
- Bug Fix: Statements that return multiple result sets (such as calls to stored procedures) would not free all results when closed.
- SQL_C_TYPE_DATE, SQL_C_TYPE_TIME and SQL_C_TYPE_TIMESTAMP were formatted without seperators, which could cause them to get interpreted incorrectly in some cases due to server bugs.
View complete list of changes »
Hints & Tips
Article: MySQL on Windows? Absolutely
I honestly have to say that, now after years of using MySQL on Windows, I find it to be my favorite database/platform combination of choice. In my opinion, it's easier to use than Microsoft's own database on their platform, the performance and feature set will meet 90+% of the needs that Windows/Web applications have, it consumes less resources than SQL Server, and the reliability is stellar.
Article: Debunking GROUP BY Myths
There is a popular myth about the SQL GROUP BY clause. The myth holds that 'standard SQL' requires columns referenced in the SELECT list of a query to also appear in the GROUP BY clause, unless these columns appear exclusively in an aggregated expression. MySQL is often accused of violating this standard.
In this article I will attempt to debunk this myth, and to provide a more balanced view regarding MySQL's treatment of GROUP BY at the same time.
Interview: Jan Kneschke, Developer at MySQL AB
Jan Kneschke works for the MySQL Development Team and is the author of the very popular lighttpd web server. I recently had the opportunity to ask him a few questions about himself and his work.
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.
PlanetMySQL Blog: Good MySQL Cluster Configuration
Johan Andersson
I get the opportunity see a lot of different MySQL Cluster configurations and most of them do not configure the disk subsystem in a good way. E.g, the redo log is way to often not correctly dimensioned. Wrongly dimensioned buffers affects system stability!!
Read the PlanetMySQL Blogpost »
PlanetMySQL Blog: TO COUNT(*) or NOT TO COUNT (*)
Dathan Pattishall (Flickr)
Counts, we all love to show counts in our applications. Under a high traffic website, it's visually appealing to show a big number. But the cost of generating that big number real-time can be very expensive on our MySQL backend.
Read the PlanetMySQL Blogpost »
PlanetMySQL Blog: Automating maintenance tasks on MySQL
Paolo Magnoli
I'm trying to automate some trivial maintenance tasks for my own MySQL server, and trying also to minimize the effort, so ... Here is the recipe.
Read the PlanetMySQL Blog Post »
PlanetMySQL Blog: A tool for checking test coverage of a patch
Today I published the DGCov tool on the MySQL Forge. DGCov is a neat tool that I implemented last year for use internally at MySQL, an old idea of Monty's.
Read the PlanetMySQL Blog Post »
PlanetMySQL Blog: Interested in the XPath support in MySQL 5.1?
I have done a little with XPath over the years, but I've never spent that much time learning it in any detail. Since we have added XPath 1.0 support I'd thought I would site back and and learn a bit more about it.
Read the PlanetMySQL Blog Post »
MySQL Forge: Delayed Slave
Rodolphe Jouannet
dlslaved (Delayed Slave Daemon) allows delayed replication on MySQL databases. It works on Linux or Solaris, and can be used for any version of MySQL (MySQL 4.1.x and 5.0.x tested).
MySQL Forge: Backup MySQL Binary Logs
Partha Dutta
This script can be used to backup binary logs to a remote system. The script will also take into account all slave servers if you are backing up binary logs from the master, and will only backup completely processed binary logs. If a slave is behind on replication, or is stopped for some reason, then only the binary logs up to the lowest number processed by all slaves will be archived then purged.
Events
Live Web Seminar: MySQL Performance Tuning Best Practices
Wednesday, July 11, 2007
We will discuss guidelines and best practices covering the following areas:
- Benchmarking and Profiling Concepts and Guidelines
- Schema Optimization
- Index Selection and Tuning
- SQL Coding Techniques
- Server Parameter Tuning Guidelines
Live Web Seminar: Embedded MySQL Applications
Tuesday, July 31, 2007
The MySQL server is well known for its lightweight and high-performance features, but did you know it can also be used as an embedded database for your enterprise applications? This session explains the concepts of embedded applications and how to use the MySQL C API for creating your own embedded MySQL applications. It will introduce you to the techniques for compiling the embedded server and writing applications for both Linux and Windows.
Conference: Ubuntu Live
July 22-24 Portland, Oregon
Marten Mickos, MySQL CEO will be delivering a keynote presentation at Ubuntu Live. O'Reilly is offering a 35% discount to MySQL Newsletter subscribers. Use the following discount code: ubu07mys
Conference: OSCON
July 23-27, Portland, Oregon
Join Marten Mickos, Kaj Arno, and Jay Pipes who will be speaking at OSCON. O'Reilly is offering a 20% discount to MySQL Newsletter subscribers. Use the following discount code: os07mys
MySQL Camp II
August 23-24, Brooklyn, New York
Thanks to everyone for making the first MySQL Camp (http://mysqlcamp.org) a huge success. MySQL Camp II, the second community-driven MySQL user and hackfest will be August 23rd and 24th at the Polytechnic University in Brooklyn, New York.
For advanced information, please contact Jay Pipes: jay@mysql.com
Training, Consulting and Certification
Training: MySQL 5.0 for Developers (5 Days)
Calgary, Madrid, Boston, Tokyo, Chicago
- Do you want to learn how to develop database applications on MySQL?
- Do you need to use MySQL Stored Procedures, Triggers, Views, and Information Schema?
- Do you want to create complex reports, use complex queries to retrieve data and aggregate results?
Attend any MySQL for Developers class and get a free copy of O'Reilly's book, "MySQL Cookbook" by Paul DuBois.
Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dev.html)
Training: MySQL 5.0 for Database Administrators (5 Days)
Paris, Tokyo, Vancouver, Washington D.C. and more.
- Is your MySQL database secure?
- Do your users have the correct privileges and access rights?
- Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
- Do you want to save time using features like Stored Procedures, Triggers and Views?
- Do you want to utilize the new enterprise features of MySQL 5.0?
Attend any MySQL for Database Administrators class and get a free copy of Robert Schneider's book, "MySQL Database Design and Tuning".
Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dba.html)
Partners
FileMaker: FileMaker + MySQL = Rapidly Build Database Solutions
April, 23-26, 2007
FileMaker is more than database software, its is a rapid-application development environment anyone can use to quickly create data solutions. With future connections planned between FileMaker and MySQL, you will be able to combine the all-in-one ease of FileMaker database solutions with the open source strengths of MySQL.
Sign up for free trial code and technical info »
Rippletech: Achieving PCI Compliance by Securing Sensitive MySQL Enterprise Database Assets
Learn how to combine MySQL Enterprise, the world's most popular open source database, with Informant, RippleTech's world-class database auditing and monitoring solution, to provide real-time security for your eCommerce and retail data.
Talend: Integrating MySQL Enterprise in the Information System, an Open Source Approach
Any deployment of MySQL in an enterprise information system requires the newly-deployed system to interoperate, in one form or another, with a number of other applications or databases. This interoperability, based on data integration - the exchange of data between systems - guarantees the consistency of data in the overall information system. This white paper describes a number of real-life interoperability scenarios for MySQL Enterprise and explains how Talend Open Studio, an open source data integration solution helps solve the interoperability challenge.
Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today.
If you market a MySQL-based software application or hardware solution to end users, you can increase your business by advertising your product(s) in our Solutions Catalog. Join hundreds of existing partners and let millions of MySQL users find your solution by becoming a partner. All it takes is a few minutes to understand the program, and your company and product information.
Sign up and become MySQL's newest partner » (http://solutions.mysql.com/partners)
On Demand Webinar: Becoming a MySQL Reseller Partner
For System Integrators (SI) and Value-Added Resellers (VAR)
In this Webinar you will learn:
- Overview of the Partner Program
- The MySQL market opportunity
- Common industry and application type uses
- How MySQL sales reps are paired to your team for joint selling opportunities
- Simple sign-up details
The MySQL Team
© 2010, Oracle Corporation and/or its affiliates