MySQL Newsletter September 2008
Articles in this newsletter:
- MySQL European Customer Conferences 2008 - London, Munich, Paris
- 2009 MySQL Conference & Expo: Submit a Proposal
- Infobright Data Warehouse for MySQL
- Case Study: Italtel Enables Networking Convergence
- MySQL Jobs
- New Release of MySQL Community Server 5.1.28 (Release Candidate)
- New Release of MySQL Workbench OSS 5.1 for Linux / SE 5.0.25 (Alpha)
- Article: Advanced Bazaar for MySQL Developers
- Article: Using Partitioning and Event Scheduler to Prune Archive Tables
- Article: Data Warehousing with MySQL and Infobright
- White Paper: Enterprise Data Warehousing with MySQL
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: How do you know when you need more memcache servers?
- PlanetMySQL Blog: MySQL Query Analyzer: A Peek Under the Hood
- PlanetMySQL Blog: A common problem when optimizing COUNT()
- PlanetMySQL Blog: Show Query Plans
- PlanetMySQL Blog: Sun CMT and MySQL Cluster
- PlanetMySQL Blog: Enable Dtrace support for MySQL 5.1 on Solaris
- Live Webinar: Managing MySQL in the Amazon EC2 Cloud
- Live Webinar: MySQL Performance Tuning Best Practices (EMEA)
- Live Webinar: Using Microsoft ADO.NET Entity Framework with MySQL
- Live Webinar: Join-fu - The Art of MySQL Tuning
- Live Webinar: Managing MySQL and Memcached on Amazon EC2
- Live Webinar: Enterprise-Ready Database, Monitoring and Support with MySQL Enterprise
- MySQL Meetup Groups
- SAVVIS Joins the MySQL Authorized Hosting Partner Program
- Packet General and Sun to Co-Market PCI Solutions for MySQL
- HP: MySQL Available on HP-UX 11i v3
- IBM: MySQL Available on IBM i5/OS V6R1
A day packed with technical sessions, customer experiences and all round MySQL goodness! You will be able to learn, improve your skills and network with other MySQL users.
Whatever your experience with MySQL, the MySQL European Conferences help you can get the most out of MySQL technology, and from the company now behind it, Sun Microsystems.
Don't miss this once a year opportunity! Register Now:
Munich, October 21 » (http://www.mysql.de/news-and-events/european-conferences/2008/)
London, October 23 » (http://www.mysql.com/news-and-events/european-conferences/2008/)
Paris, November 19 (Early Registration Discount Still Available) » (http://www.mysql.fr/news-and-events/european-conferences/2008/)
The 2009 MySQL Conference & Expo, April 20-23, 2009 in Santa Clara, CA, brings over 2,000 open source and database enthusiasts together to harness the power of MySQL and celebrate the huge MySQL ecosystem. Take an active role in shaping the future of MySQL and related open source technologies by leading sessions and tutorials at the next MySQL Conference & Expo.
Infobright provides a modern data warehousing solution for MySQL users that combines MySQL's hallmark ease-of-use with support for terabyte-sized data volumes on a single server. With Infobright, no data warehousing expertise is required to build and manage databases that deliver rapid response times for analytic and business intelligence applications.
Italtel is an acknowledged leader in Next-Generation Network solutions. MySQL Cluster Carrier Grade Edition combined the flexibility of a general purpose database with unprecedented reliability and scalability for Italtel's next generation products to satisfy the requirements to scale from a few thousand to millions of subscribers.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/italtel-enables-networking-convergence-using-mysql-cluster/)
MySQL is the world's most popular open source database software. As part of Sun Microsystems' software group, MySQL is a global organization with over 400 workers in 25 countries. We are looking for talented professionals in engineering, sales, marketing, professional services, and support that will contribute to our products' strong momentum and share in our success! We have openings for the following positions:
- MySQL Tools Web Application Developer
- Software Systems Engineers
- MySQL Cluster Support Engineer
- Support Engineers
- QA Engineers
- MySQL Business Development Manager, Telecom
- MySQL Senior Consultant
- MySQL Sales Engineer
- And Many More ...
Apply Now » (http://www.mysql.com/jobs/)
We are proud to present to you the MySQL Server 5.1.28-rc release, a new "release candidate" version of the popular open source database. Changes include:
- Security Fix: It was possible to circumvent privileges through the creation of MyISAM tables employing the DATA DIRECTORY and INDEX DIRECTORY options to overwrite existing table files in the MySQL data directory (Bug#32167).
- Security Enhancement: The server consumed excess memory while parsing statements with hundreds or thousands of nested boolean conditions (such as OR (OR ... (OR ... ))) (Bug#38296).
- Incompatible Change: An additional correction to the original MySQL 5.1.23 fix was made to normalize directory names before adding them to the list of directories (Bug#20748).
We're proud to announce that we've just uploaded the first Linux-Alpha build for upcoming MySQL Workbench 5.1 for everyone to try. But beware, it's an early Alpha release! It includes basic functionality like loading/saving Models, import/export SQL files and a set of basic editors to model your data-structures. A couple of features are still missing and the UI from a lot of things is not done yet but its purpose is to give you a chance to experience how WB will look and feel on your Linux Desktop.
The MySQL project switched from Bitkeeper to another revision control system, Bazaar, in June 2008. My colleague Daniel Fischer wrote an excellent article describing how to get MySQL's code by using Bazaar, and how to compile a MySQL server binary from this. Here I am going to build on this knowledge and take it further, to show you how to modify MySQL's code for your needs, and share your modifications.
Gregory J. Haase
First in our series of Use Case reports on new MySQL 5.1 features, we have Greg Haase of Lotame describing his innovative use of partitioning. At Lotame, we're using the MySQL 5.1 event scheduler and partitioning to regularly prune data stored in the archive engine since June 25, 2008. We're now on MySQL 5.1.24 and we started development using partitioning and events with MySQL 5.1.23.
Unless you've been on a desert island lately, you probably know that the area of data warehousing/analytics/business intelligence (BI) is going gangbusters these days. Not many years ago, when industry analyst groups polled CIOs on their top priorities, BI was #10. Then it jumped to #2 in 2006, and today it's #1 according to Gartner group. It's no mystery as to why this is: it's a cut-throat economy out there in all industries and smart businesses need to tap their internal data to make critical business decisions, both tactically and strategically, to stay ahead of the pack.
Although the MySQL database server has been the proven leader in database management for online businesses, many have wondered if it has the capabilities to also lead in the area of data warehousing and business intelligence. This paper examines the MySQL strategy for data warehousing and showcases the unique abilities and advantages that come with choosing MySQL as a provider for data warehousing and business intelligence needs.
Read the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_data_warehousing.php)
The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things MySQL, including technical tips and best practices.
Let me first start of with the disclaimer, that I do not use memcache to scale, I use it to reduce latency. I'm of firm belief that the database layer should be able to handle the requests, while memcache is used to keep frequent requests returning in a consistent time frame i.e. reduce I/O spikes.
What I want to achieve with this article is to give definitions, data, flow, etc., that describe how we look at things internally in the architecture of the application. This is intended to give the hapless reader an idea of what Query Analysis can do, and consequently what it can not.
When optimizing queries for customers, the first thing I do with a slow query is figure out what it's trying to do. You can't fully optimize a query unless you know how to consider alternative ways to write it, and you can't do that unless you know what the query "means." I frequently run into a situation where I'm forced to stop and ask the developers what they were trying to do with COUNT().
There are some cases when I want to know the plan for a running query. These include:
- MySQL doesn't explain INSERT, UPDATE and DELETE statements. As the optimizer for SELECT statements is different than that for the other statements, the query plan may be very different than expected.
After joining SUN I have seen and heard more and more people/customers that are wanting or planning to deploy MySQL Cluster on SUN's CMT technology.
DTrace is a comprehensive dynamic tracing framework for the Solaris Operating System. DTrace provides a powerful infrastructure that permits administrators, developers,and service personnel to concisely answer arbitrary questions about the behavior of the operating system and user programs.
Recently we enabled dtrace support for MySQL 5.1 for OpenSolaris. Here I list the way dtrace support needs to be enabled and the testing that needs to follow to check the dtrace functionality.
Thursday, October 02, 2008 - 8:00am PST
Join us for this informative technical webinar with Michael Crandell, CEO of RightScale, the most popular management system for MySQL Enterprise on Amazon's Elastic Compute Cloud (EC2). You'll learn the fundamentals of deploying, optimizing and scaling MySQL in the cloud. We will also discuss the impact of Amazon's new persistent storage feature, Elastic Block Storage, in deploying durable and portable MySQL-backed applications.
Friday, October 10, 2008 - 15:00 CET
Are you experiencing current performance bottlenecks? Designing a new application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries?
Then this web presentation is for you! 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.
Tuesday, September 30, 2008 - 10:00am PST
The Entity Framework is a new technology that was developed by Microsoft and delivered as part of .NET 3.5 SP1. This framework abstracts the relational schema of the database and presents it as a conceptual schema. By working with a conceptual schema, the application developer avoids having to write complicated joins to connect all the related items of data. Application developers can access their data using ORM-like classes, LinQ syntax, or with a new SQL syntax named EntitySQL.
Wednesday, October 1, 2008 - 10:00am PST
Join-fu is the art of performance-tuning your application's SQL. Join Jay Pipes and Rob Young in a fun, irreverent look at the common ways application developers misuse and abuse their database.
Tuesday, October 14, 2008 - 10:00am PST
Join us for this technical webinar with Carl Mercier, founder of Defensio.com, an on-demand spam filtering web service that protects blogs and web applications from comment spam. In this webinar we will explore how on-demand SaaS applications like Defensio, are leveraging MySQL and memcached in Amazon's Elastic Compute Cloud (EC2).
Wednesday, October 15, 2008 - 10:00am PST
Join us for this discussion where you will how you can confidently deploy MySQL, aka the "M" in LAMP, as part of an overall move to today's web-enabling technologies. This includes a detailed overview of the MySQL Enterprise subscription, and the database software, monitoring and advisor services and support solutions that are designed to alleviate common pain points associated with building and supporting scalable, data-driven online applications.
Meet nearby MySQL Users for conversation and fun! Come to a local MySQL Meetup to talk about the world's most popular open source database, get great tips and share new ideas. All levels of experience welcome!
The San Francisco MySQL Meetup Group gets together on the first Monday of the month at CNET's Headquarters in San Francisco. Join us for our informative get-togethers, and really get the most out of your MySQL experience.
- Is your DBA team overworked?
- Could you benefit from a "Remote DBA" to augment your DBA team?
- Do you need a dedicated DBA who works with your DBA team on a weekly schedule?
The MySQL Remote DBA services are provided either 2 days/week or 4 days/week for a period of 3/6/12 months. Sun's MySQL consultants use proven methodologies and expertise in database administration, security, performance tuning, replication, backup, and fault-tolerance in providing this service.
Learn More » (http://www.mysql.com/consulting/packaged/remote-dba.html)
Oslo, Raleigh, Paris, London, Dallas
- 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?
Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dev.html)
SAVVIS is a recognized industry leader in the IT Infrastructure-as-Service space and was recently positioned in the Leaders Quadrant of the Gartner North American Web Hosting, 2008 report. SAVVIS is the newest addition to the MySQL Authorized Hosting Partner Program. SAVVIS offers a Managed MySQL Database Service built on the MySQL Enterprise offering. SAVVIS' solutions are ideal for those firms needing a Service Level Agreement (SLA) that is ultimately backed by MySQL.
Packet General Networks, provider of the industry's first secure server appliance, and Sun will jointly co-market Packet General's regulatory compliance solutions for MySQL. Packet General's MySQL soft appliances ease the pain of enterprises that store regulated information in MySQL databases. Transparent data encryption, extended access control and protection against privileged user are some of the hallmarks of Packet General's solutions.
MySQL is now available on HP-UX 11i v3! HP's latest HP-UX 11i release delivers complete integrated security plus significant advantages over prior releases in the areas of performance, simplified more powerful system management, and reduced downtime, for benefits to our mutual customers including faster time-to-solution, increased productivity, and risk avoidance. The range of Integrity servers running HP-UX 11i v3 - from entry-class to Superdomes to blade servers - gives our customers flexibility to configure to budget, business and technical requirements. Support for MySQL on HP-UX 11i is available from both HP and MySQL.
IBM i 6.1 (i5/OS V6R1) takes a great step forward to set new standards for efficiency and resiliency in business processing. To help businesses thrive in competitive marketplaces, this release includes expanded options for virtualization, upgraded storage and availability management, breakthrough Java performance, new support for POWER6 processors and BladeCenter and a broad range of middleware and tools to help drive business transformation. i 6.1 also continues to support Apache, MySQL, and PHP for AMP application development and deployment.