Feeds : MySQL Development Site


      view feed content Using Partitioning and Event Scheduler to Prune Archive Tables (MySQL Development Site)   2 d, 12 h, 0 min and 41 secs ago
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. Usually, the creators of new applications are unaware of the various tweaking that users may submit their features to, in order to achieve surprising results. We in the community team are usually on the tweaking side, and we like to surprise developers with (positive) side effects of the existing features. This time, we were caught by surprise. Greg's usage of partitioning and events is really cool!

View original post|Add to del.icio.us | Share

      view feed content MySQL Conference & Expo Opens Call for Participation (MySQL Development Site)   3 d, 12 h and 0 min ago
O'Reilly Media has opened the Call for Participation for the 2009 MySQL Conference & Expo, scheduled for April 20-23, in Santa Clara, California.

Conference program chair Colin Charles and the program committee invite proposals for conference sessions, panel discussions, and tutorials. More than 2,000 attendees are expected to participate in over 120 sessions at next year's event.

Proposals can be submitted here. The deadline runs through October 22, 2008.

Co-presented by O'Reilly Media and Sun Microsystems, the MySQL Conference & Expo is the largest gathering of MySQL developers, users, and DBAs worldwide. The event reflects MySQL's wide-ranging appeal and capabilities. The open atmosphere of the MySQL Conference & Expo helps IT professionals and community members create the best database applications, tools, and software through expert instruction, hands-on tutorials, and interaction with readily available MySQL developers. Users gain the knowledge they need to rapidly build solid applications with MySQL that scale with the enterprise. New to the 2009 program will be MySQLCamp, a place where any and all participants can create an "unconference" within the larger event.



View original post|Add to del.icio.us | Share

      view feed content Happy Birthday to GNU (MySQL Development Site)   5 d and 12 h ago
MySQL celebrates the 25th Anniversary of the GNU project this September.

Also, a community reminder that September 20 is "Software Freedom Day" around the World.



View original post|Add to del.icio.us | Share

      view feed content A Quick Look at MySQL 6.0’s New Backup (MySQL Development Site)   16 d and 12 h ago
I still remember the day. I was working for a large systems integrator on a very major account, and had responsibility for some DB2 databases, but also had the unfortunate duty of also taking care of some legacy IMS databases (hierarchical IBM databases used quite a lot ‘back in the day’), which I knew next to nothing about. One morning I was asked to make a small change to a very large and prominent IMS database – just remove one record – what could go wrong? The guy who knew IMS real well was gone so I put together a program to do the job (yes, you actually had to write a program to do it), and ran it after hours. I came in the next day and tried to access some records in the database. Nothing. All gone, except for – ta-da – the one record I wanted to remove! At the instant I realized my mistake, I was acutely aware of two things: (1) I was in serious trouble if I didn’t have a backup, and (2) I was in desperate need of a complete change in underwear.

View original post|Add to del.icio.us | Share

      view feed content MySQL 5.1 Use Case Competition (MySQL Development Site)   [1 views] 51 d ago
MySQL Community Team launches a competition for the users of new features of MySQL 5.1. Submit your MySQL 5.1 Use Case Report to community(at)mysql.com by 31 August 2008 and win!

View original post|Add to del.icio.us | Share

      view feed content Donate to help Andrii Nikitin's son Ivan (MySQL Development Site)   [2 views] 55 d ago
Donations are requested to help Andrii Nikitin, a MySQL support engineer in Ukraine, provide for his son Ivan who requires a bone marrow transplant operation. The cost of this operation is expected to be between $150,000 - $250,000. Please help us provide Ivan a chance to live.

View original post|Add to del.icio.us | Share

      view feed content Getting started with Bazaar for MySQL code (MySQL Development Site)   75 d ago
Since you're reading this, you probably know that Sun is switching to the Bazaar version control system for all development work on the MySQL server. Unlike the version control system that we've been using previously, Bazaar is an open source project and freely available to anyone. This means that it is now much easier to follow ongoing development, or even to participate in it! On the downside, just like our previous tool, Bazaar is not quite as straight-forward as traditional version control systems such as CVS or subversion. The aim of this article is to give an overview and a general idea of how to set up Bazaar, how to access the MySQL server source code repositories, and the basic commands for working with the source code.

View original post|Add to del.icio.us | Share

      view feed content Falcon storage engine in depth (MySQL Development Site)   81 d ago
MySQL/Sun released a new storage engine "Falcon" in January, 2007. Falcon is a high performance transactional (fully compliant with ACID) storage engine, which is beta at this time (June 2008). In this article, I describe Falcon's features and its architecture in detail.

View original post|Add to del.icio.us | Share

      view feed content MySQL Workbench for Database Change Management (MySQL Development Site)   [3 views] 4 months ago
Managing database change is an incredibly important discipline that very few database professionals overtly talk or worry about until they're in the thick of things with a particular database - moving it from development to production, making changes to a newly installed production database, or implementing an updated version of the database (new tables, modifications to existing objects, etc.) in a SaaS application. It's at that point where change management becomes very important because if you don't do things right the first time, you can make a royal mess of things and even (in a small number of cases) reach the point of no return where you've completely torched your database.

View original post|Add to del.icio.us | Share

      view feed content Sun Introduces MySQL Tech Support for Amazon EC2 (MySQL Development Site)   [1 views] 4 months ago
Sun Microsystems, Inc. today announced two new offerings that will significantly expand customer choice by providing users with access to Sun's innovative open source software running on the Amazon Web Services platform. Sun has added premium technical support for its MySQL™ database running on Linux and on the Amazon Elastic Compute Cloud (Amazon EC2) to its global support and services offerings.



View original post|Add to del.icio.us | Share

      view feed content Sun Introduces MySQL Workbench (MySQL Development Site)   4 months ago
Sun Microsystems, Inc. today announced the availability of MySQL™ Workbench, a new visual database design tool that integrates data modeling, physical database design, database creation, change management and documentation capabilities into a single, seamless environment for MySQL developers and DBAs.

MySQL Workbench is available for download in two versions: an open source Community Edition and a (US) $99 commercial Standard Edition. Both are available now for Microsoft Windows, with future cross-platform support for Linux and Macintosh OS X under development.



View original post|Add to del.icio.us | Share

      view feed content Sun Microsystems Announces MySQL 5.1 (MySQL Development Site)   4 months ago
Sun Microsystems, Inc. today announced the pending general availability of MySQL(TM) 5.1, a new version of the world's most popular open source database, designed to improve performance and simplify management of large database applications. A near-final release candidate of the GPL software is available for download now at dev.mysql.com/downloads/.



View original post|Add to del.icio.us | Share


      view feed content A look at Falcon Diagnostic Tables (MySQL Development Site)   5 months ago
Performance tuning is one of the top disciplines (if not THE top discipline) that database professionals want to excel at. Being able to take a system that's running sluggish and turn it into one that's running as fast as a scalded dog is a talent that's part art and part science, but whatever the combination necessary to make it happen, there will always be strong demand for folks who are good at it.

View original post|Add to del.icio.us | Share

      view feed content How the MySQL Enterprise Upgrade Advisor Helps DBAs Avoid Being Bitten by Known Bugs (MySQL Development Site)   5 months ago
In an earlier article I described how MySQL Enterprise takes the guesswork out of deciding which version of the MySQL server customers should be running by providing alerts around regularly scheduled Monthly Rapid Update and Quarterly Service Pack releases of the Enterprise Server. Being of an old school "if it ain't broke don't fix it" mindset, I understand the conservative approach most DBAs take when deciding if a new release of any software is relevant to their environment. In fact, given the monthly frequency of Enterprise maintenance releases and the work involved with upgrading, I completely understand how recipients can begin to ignore Update Alerts (unless of course a known fix is on the way). Based on feedback from customers, MySQL colleagues, and my own field experience, I recognize that while notifications around the regular Enterprise Server drops is a good thing, upgrading an existing MySQL implementation is no small task and that a major part of removing guesswork around new releases involves helping those receiving notifications better understand how they are affected.

View original post|Add to del.icio.us | Share

      view feed content Why you want to be good at data modeling (MySQL Development Site)   5 months ago
To be really successful at working with databases, there are many different disciplines to become proficient in - things like disaster recovery, security management, data integration, and more. But there are less than a handful of things you want to be really good at; becoming super-skilled in them will help you enormously in your database career. And believe it or not, one of these key areas is data modeling and its kissing cousin, physical database design.

View original post|Add to del.icio.us | Share

      view feed content Sun-MySQL Community Town Hall on March 4 (MySQL Development Site)   6 months ago
Please join executives Jonathan Schwartz, Rich Green and Zack Urlocker for the first public event on the Sun-MySQL World Tour:

Sun and MySQL's Community Townhall

MySQL and Sun community members, employees, partners and customers are all invited to attend this casual virtual event -- and participate by asking their questions.



View original post|Add to del.icio.us | Share

      view feed content Sun Microsystems Announces Completion of MySQL Acquisition (MySQL Development Site)   6 months ago
SANTA CLARA, CALIF. — Sun Microsystems, Inc. (NASDAQ: JAVA) today announced it has completed the acquisition of MySQL AB, developer of the world's most popular open source database, for approximately $1 billion in total consideration. Sun also unveiled the immediate availability of MySQL's complete portfolio of products and enterprise services backed by its 17,000-strong global sales and services organization and its extensive international network of authorized distribution channels. Sun now provides a single, secure choice for customers and developers seeking to put MySQL into deployment on a global basis. Users can get started today with free downloads at dev.mysql.com/downloads.

View original post|Add to del.icio.us | Share

      view feed content Visionary Keynote Speakers Announced for MySQL Conference & Expo 2008 (MySQL Development Site)   6 months ago
The sixth annual MySQL Conference & Expo, co-presented by MySQL AB and O'Reilly Media, is expected to bring together 2,000 open source and database users from some of the most exciting and fastest-growing companies in the world, as well as from the large and active MySQL community. The conference will take place April 14-17, 2008, in Santa Clara, California.

MySQL AB CEO Marten Mickos and Jonathan Schwartz, president and CEO of Sun Microsystems, will kick off the conference with keynotes highlighting the strategic, technical and community synergies between the two companies and their pending merger. Mickos’ annual "State of the Dolphin" address is always thought-provoking for corporate customers, open source developers and MySQL ecosystem partners alike. Schwartz will be speaking on "Open Source: The Heart of the Network Economy” -- how free software and open communities like MySQL are the lifeblood of network innovation. Tuesday’s other keynote will be Werner Vogels, CTO of Amazon.com, who will speak about distributed computing in the modern Internet era.

To register and learn about early registration discounts, please visit http://mysqlconf.com.



View original post|Add to del.icio.us | Share

      view feed content Reporting MySQL Internals with Information Schema plug-ins (MySQL Development Site)   [1 views] 6 months ago
Last week, I described how to use the MySQL plug-in API to write a minimal 'Hello world!' information schema plug-in. The main purpose of that plug-in is to illustrate the bare essentials of the MySQL information schema plug-in interface.

View original post|Add to del.icio.us | Share

      view feed content MySQL Information Schema Plugins: the best kept secret of MySQL 5.1 (MySQL Development Site)   6 months ago
MySQL 5.1 offers an extremely useful feature called information_schema plugins. This feature allows dynamic runtime loading of a shared library into the MySQL server to implement a table in the information_schema database. The SQL standard (ISO/IEC 9075-11:2003) allows database implementations to extend the information_schema. MySQL 5.1 transfers the possibility to do this directly to privileged database users so they can extend the information_schema themselves, in any way they see fit.

View original post|Add to del.icio.us | Share

      view feed content A Q&A Session with Mårten Mickos, CEO of MySQL AB, about the Sun Acquisition (MySQL Development Site)   7 months ago
We got a chance to speak with Mårten Mickos, CEO of MySQL AB, about Sun's planned acquisition of MySQL, and we asked him some questions, that the community at large, might have.

View original post|Add to del.icio.us | Share

      view feed content Sun Microsystems Announces Agreement to Acquire MySQL (MySQL Development Site)   7 months ago
Sun Microsystems, Inc. (NASDAQ: JAVA) today announced it has entered into a definitive agreement to acquire MySQL AB, an open source icon and developer of one of the world’s fastest growing open source databases for approximately $1 billion in total consideration. The acquisition accelerates Sun's position in enterprise IT to now include the $15 billion database market. Today's announcement reaffirms Sun's position as the leading provider of platforms for the Web economy and its role as the largest commercial open source contributor.

View original post|Add to del.icio.us | Share

      view feed content MySQL 5.1 partitions in practice (MySQL Development Site)   8 months ago
This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions. The test database uses data published by the US Bureau of Transportation Statistics. Currently, the data consists of ~ 113 million records (7.5 GB data + 5.2 GB index).

View original post|Add to del.icio.us | Share

      view feed content Program Unveiled for 2008 MySQL Conference & Expo -- Registration is Now Open! (MySQL Development Site)   8 months ago
Registration is now open for the sixth annual MySQL Conference & Expo. Co-presented by MySQL AB and O'Reilly Media, the conference will take place April 14-17, 2008, in Santa Clara, California. The event is expected to bring together over 1,600 open source and database users from some of the most exciting and fastest-growing companies in the world, as well as from the large and active MySQL Community. The program for 2008 will include keynote presentations by Jacek Becla of Stanford Linear Accelerator and MySQL CEO Marten Mickos.

More information is available at www.mysqlconf.com.



View original post|Add to del.icio.us | Share

      view feed content Using XML in MySQL 5.1 and 6.0 (MySQL Development Site)   8 months ago
In this article, we discuss the XML functionality available in MySQL, with an emphasis on new features coming online in MySQL 5.1 and MySQL 6.0. We assume that you already have a working knowledge of XML, and that you know what the terms “valid” and “well-formed” mean. We also assume that you have some knowledge of XPath.

View original post|Add to del.icio.us | Share

      view feed content MySQL Failover Strategy using State Management, introducing MPP - Part 3 (MySQL Development Site)   9 months ago
In part 2 we discussed the internals of MPP and how MPP can be used with LVS to create a failover strategy. In this part 3 we will discuss how to configure and operate MPP, and additionally use MPP with MySQL Proxy to create a failover strategy.

View original post|Add to del.icio.us | Share