MySQL Newsletter March 2008
Articles in this newsletter:
- MySQL Conference and Expo 2008, April 14-17 Register Now, Tutorials are Selling Out
- MySQL Conference and Expo 2008 - 100+ Tutorials & Sessions
- Press Release: Sun & Zmanda to Deliver Backup & Recovery Solutions for MySQL Enterprise
- White Paper: MySQL Guide to Enterprise 2.0
- Case Study: Supply Dynamics Delivers SaaS Solution on MySQL
- MySQL Jobs
- New Release of MySQL Enterprise Monitor (Spring 2008)
- New Release of MySQL Community Server 6.0 (Alpha)
- New Release of MySQL Workbench 5.0.16 (Release Candidate)
- New Release of MySQL Connector/J 5.1.6 (GA)
- New Release of MySQL Connnector/ODBC 5.1.3 (Release Candidate)
- Article: Reporting MySQL Internals with Information Schema plug-ins
- White Paper: ZRM - Guide to MySQL Backup & Recovery
- PlanetMySQL Blog Posts
- Live Webinar: Retrieving, aggregating and transforming your MySQL data using XQuery and XML
- Catch the Sun-MySQL World Tour
- Consulting: MySQL Architecture & Design (2+ Days)
- Training: MySQL Performance Tuning (4 Days)
- Certification: Get Certified at the MySQL Conference (Only $25)
MySQL Conference & Expo draws more than 1,600 participants with sessions and tutorials led by some of the leading database and open source experts in the world. The MySQL Conference will help attendees:
- Optimize the performance of MySQL
- Get detailed insight into new MySQL features
- Learn replication, security and performance best practices
- Learn how the MySQL Enterprise Monitor improves productivity
- And more ...
The 2008 MySQL Conference & Expo will include 100+ in-depth technical tutorials and sessions including:
- MySQL Workbench
- MySQL Cluster
- MySQL Proxy
- High Availability with MySQL
- MySQL Replication
Sun Microsystems and Zmanda, the open source leader in backup and recovery software, today announced they are partnering to deliver a comprehensive, global data backup and recovery solution for MySQL Enterprise subscribers.
Read the Press Release » (http://www.mysql.com/news-and-events/press-release/release_2008_12.html)
Enterprise 2.0 is a term which has come into recent usage to describe organizations leveraging Web 2.0 technologies, applications, architectures, and business models, to deliver online, data-driven applications to their end-users. In this paper we explore the technical and business components that make up Web 2.0 and its effect on the modern enterprise.
Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-2.0.php )
Supply Dynamics is a leading supply chain solution provider that is focused on material consolidation solutions known as "Material Demand Aggregation." Their hosted multi-enterprise platform is helping Fortune 100 companies like General Electric, Honeywell and others to reduce raw material costs by as much as 15% and deliver products faster and at lower risk by linking their entire supply chain.
Download the Case Study » (http://www.mysql.com/why-mysql/case-studies/supply-dynamics-delivers-saas-solution-using-mysql/)
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:
- Database Systems Engineer (Australia)
- Senior Software Engineer, Online Backup (Worldwide)
- QA Engineers (Worldwide)
- Senior Sales Representatives, Telecom (USA, East Coast)
- Senior Instructors (Ireland)
- Senior Consultants (USA, EMEA)
- And Many More ...
Apply Now » (http://www.mysql.com/jobs/)
The Spring 2008 Release of the Enterprise Monitor is now Generally Available. This update includes new features designed to help subscribers standardize on the most secure, up to date version of the MySQL Enterprise Server. Updates include:
- New Upgrade Advisor - The Upgrade Advisor provides automated rules that monitor and advise users on specific bugs that can potentially impact versions of the MySQL Enterprise Server deployed within an environment.
- Enterprise Monitor Localized on Japanese - Users can now switch the context of the Enterprise Monitor user interface to Japanese using a simple configuration setting.
Learn More » (http://www.mysql.com/products/enterprise/whats_new.html)
MySQL 6.0.4-alpha, a new version of the MySQL database system including the Falcon transactional storage engine has been released.
Learn more about MySQL 6.0 » (http://www.mysql.com/mysql60/)
MySQL Workbench is a next-generation visual database design application that can be used to efficiently design, manage and document database schemata. Further improvements have been made, including improved loading times for Models with large diagrams, colors of figures used on different diagrams can be synced now, the "pick columns" option of Relationship-tools is a separate tool now (used to create connections using already existing columns), we added a all new GRT Scripting IDE to create/modify/manage plugin scripts.
MySQL Connector/J 5.1.6, 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.6 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 RC or the MySQL-6.0 development release. Changes include:
- JDBC-4.0-ized XAConnections and datasources.
- Fixed BUG#31790 - MysqlValidConnectionChecker doesn't properly handle ReplicationConnection
- Fixed Bug#20491 - DatabaseMetadata.getColumns() doesn't return correct column names if connection character set isn't UTF-8. (There was a server-side component of this that was fixed late in the 5.0 development cycle, it seems, this is the last piece that fixes some loose ends in the JDBC driver). This fix touches *all* metadata information coming from the MySQL server itself.
MySQL Connector/ODBC 5.1.3-rc, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the first release candidate of the 5.1 series and is suitable for use with any MySQL server version since MySQL 4.1, including MySQL 5.0, 5.1, and 6.0. (It will not work with 4.0 or earlier releases.) Changes include:
- Added SSLVERIFY connection option to verify server certificate. By default certificate is not verified now. (Bug #34648)
- Database list height is autoadjusted in Windows GUI. (Bug #33918)
- Recordset-based update fails if blob field is queried. (Bug #19065)
- Descriptor records were not cleared correctly when calling SQLFreeStmt(SQL_UNBIND). (Bug #34271)
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.
Database backup and recovery are a primary responsibility of every enterprise DBA. This white paper is a guide to the requirements, challenges, and solutions available to the MySQL DBA. You will learn about Logical/Raw backups, Hot/Warm backups, Full/Incremental backups, Snapshots, Point-in-Time Recovery, Retention Policies, Compliance, Access Control, Scheduling, Monitoring and Administration.
Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_zrm_backup_recovery.php )
Download a 30 Day Trial Version » (http://www.mysql.com/trials/zrm)
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.
This article contains my notes and detailed instructions on setting up a MySQL cluster. After reading it, you should have a good understanding of what a MySQL cluster is capable of, how and why it works, and how to set one of these bad boys up. Note that I'm primarily a developer, with an interest in systems administration but I think that every developer should be able to understand and set up a MySQL cluster, at least to make the dev environment more robust.
After following the scale up path (i.e. buy bigger boxes) for a while now, we definitely need to scale out as things start to become "unhandy" and simply HUGE. We are running an OLTP application with about 200 million transaction per month. Currently we have some very large tables with more than 1,5 billion rows and the total database size is about 600 GB - all InnoDB.
Last week I blogged about the upcoming MySQL Users conference, in particular about the Writing MySQL UDFs tutorial that I will be delivering. I will also be doing the Grand Tour of the Information Schema and its Applications.
- Point your browsers to forge.mysql.com.
- MySQL Forge is the directory for projects related to MySQL.
- New MySQL functionality under work is described on the Forge Worklog.
- New Forge 2.0 features includes site-wide search, commenting and voting.
- Forge 2.0 hence sports ranking of projects.
- Forge 2.0 has a new people section with profiles and listings of contributed tools.
- The tools section is a code and tool repository for smallish code snippets.
How do you return a dataset using MySQL Proxy? This being a common task, as many that we will see in these pages, it is worth implementing with a function. When you return a dataset, there are two main cases:
Tuesday, April 08, 2008
In this Webinar you will learn how you can use DataDirect XQuery to query and retrieve data as XML from your MySQL database in a highly scalable and performant way; how you can aggregate MySQL data with XML documents, Web service results or even with EDI or other non-XML formats. Finally you will see how you can use DataDirect XQuery to perform update operations on your MySQL database, like executing bulk load operations that shred XML documents into one or more MySQL tables.
Sun and MySQL meetups are coming near you, bringing together the expertise and technology know-how directly to you. Be sure to keep checking back to find out when the meetups are going to be in your city.
In this engagement, a dedicated MySQL certified consultant will work closely with your team to deliver the following benefits:
- Accelerate the development process by ensuring the application is architected correctly
- Help ensure application meets current and future business requirements
- Minimize re-architecting efforts when business conditions change
- Learn and use best practices techniques to ensure success
Learn More » (http://www.mysql.com/consulting/packaged/architecture.html)
Sacramento, Dallas, Berlin, Paris, Lyon, Toronto
- Do you want to monitor, diagnose problem areas and tune MySQL for optimal performance?
- Do you want to write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing?
- Do you want to Evaluates the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance
Register Now for an Upcoming Date » (http://www.mysql.com/training/courses/performance_tuning.html)
Sign up to get MySQL Certified at the 2008 MySQL Conference & Expo. Certification Exams are being offered only at the Conference for this discounted price of $25 ($175 value). Space is limited, only pre-registered exams are guaranteed a seat at the conference, so sign up now.