MySQL Newsletter December 2007
Articles in this newsletter:
Highlights
- MySQL 6.0.4 - Falcon Feature Preview
- MySQL Conference 2008 - Registration is Open
- MySQL Proxy & Load Balancing Survey
- Case Study: Group Logic Manages Mission Critical Data
- MySQL is Hiring
New Product Releases
- New Release of MySQL Workbench 5.0.11 (Beta)
- New Release of MySQL Community Server 5.0.51
- New Release of MySQL Connector/ODBC 5.1.1 (Beta)
Hints & Tips
- Article: Understanding the Falcon Transaction Storage Engine
- Article: Using XML in MySQL 5.1 and 6.0
- Documentation: MySQL Server Version Reference
- PlanetMySQL Blog Posts
Events
- Live Webinar: Designing, Evaluating and Benchmarking MySQL Cluster
- Conference: Open Source meets Business 2008 (Germany)
- Seminar: MySQL Federal DBA Day
Training, Consulting & Certification
- Consulting: MySQL Scale-Out, High-Availability and Replication Jumpstart (4 Days)
- Training: MySQL Performance Tuning (4 Days)
Partner Corner
- Partner Solutions Using MySQL
- Are You Missing Out on Opportunities to Advertise Your Solutions to MySQL Users?
Highlights
Falcon Feature Preview
This Feature Preview is intended to allow the community to test some important performance improvements to the Falcon transactional storage engine. The performance changes are listed along with key bug fixes.
Read the MySQL 6.0.4 Feature Preview »
Download the latest release » (http://www.mysql.com/falcon)
MySQL Conference 2008 - Registration Open
Register now and save up to $300! Register early and reserve your spot in one of the following high-intensity, hands-on tutorials:
- Real World Web Scalability
- Getting started with MySQL Proxy
- MySQL Cluster Tutorial
- A Hands-on Introduction to High-Availability MySQL and DRBD
- Memcached and MySQL: From Soup to Nuts
- MySQL Workbench
MySQL Proxy & Load Balancing Survey
If you are interested in software-based Load Balancing, Read/Write Splitting, Connection Pooling, Sharding, Replication Fail-Over/Resynchronization and other techniques for managing MySQL Replication scale-out architectures, please take the survey to tell us what is important to you as it relates to MySQL Proxy and Load Balancing. This is your chance to influence the MySQL Proxy roadmap!
Case Study: Group Logic Manages Mission Critical Data
Group Logic built MassTransit, a high-performance digital file transfer and workflow solution using the MySQL Server. By managing low volume embedded client database requirements to high volume server to server requirements, MySQL enables Group Logic's customers to grow and scale their business using a single database solution.
Register for the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_grouplogic.php)
MySQL is Hiring
Apply today to join one of the largest and fastest growing open source companies! MySQL is a global organization with over 400 employees in 25 countries. We have openings for the following positions:
- Senior Consultant (US & EMEA)
- Support Engineers
- Senior Software Engineers
- Senior Sales Representatives
- Sales Engineers
- And More ...
Apply Now » (http://www.mysql.com/jobs/)
New Product Releases
New Release of MySQL Workbench 5.0.11 (Beta)
MySQL Workbench is the new tool for Visual Data Modeling (ER Diagrams), Forward/Reverse Engineering, and Schema Synchronization. You can also Document, Print and Report on your Data Models. And, for maximum flexibility, you can customize with plug-ins and Lua scripts. If you are a DBDesigner user, then you should definitely check out MySQL Workbench!
MySQL Community Server 5.0.51
This is a bugfix release for the current production release family. It replaces MySQL 5.0.45. Changes include:
- Using RENAME TABLE against a table with explicit DATA
- DIRECTORY and INDEX DIRECTORY options can be used to overwrite system table information by replacing the file to which the symlink points.
- Server parser performance was improved for expression
- parsing by lowering the number of state transitions and reductions needed.
- Bug Fix: Multiple-table DELETE statements could delete rows from the wrong table.
View the complete list of changes »
New Release of MySQL Connector/ODBC 5.1.1-beta
MySQL Connector/ODBC 5.1.1-beta, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the first beta (feature-complete) release of the new 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. Changes include:
- Added MSI installer for Windows 64-bit
- Implemented support for SQLCancel()
- Removed non-threadsafe configuration of the driver. The driver is now always built against the threadsafe version of libmysql
View the complete list of changes »
Hints & Tips
Article: Understanding the Falcon Transaction Storage Engine
Robin Schumacher
Falcon is a next-generation transactional management engine designed to run on all popular hardware/architecture platforms, but it is especially designed to take advantage of the large memory caches available in 64-bit environments.
Read Understanding Falcon - Part 1 »
Read Understanding Falcon - Part 2 »
Read Understanding Falcon - Part 3 »
Article: Using XML in MySQL 5.1 and 6.0
Jon Stephens
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.
Documentation: MySQL Server Version Reference
MySQL Server Version Reference provides a single resource for summary information about MySQL server, including specific information on changes between different versions and summary tables for reserved words, options/variables, operators and functions and build options.
View the MySQL Server Version Reference »
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.
Memcached MySQL Functions Released
Patrick Galbraith
A set of functions for MySQL have been released to allow integration between the MySQL database server and Memcached, a high performance object cache that is used throughout the web industry. The functions allows a user to push data directly from MySQL into Memcached, and will allow you to write triggers that can invalidate cache data. The functions make use of Brian Aker's high performance memcached connection library libmemcached. The functions are being released as open source and have been written for the website Grazr (a RSS reading list management site using MySQL).
Read the PlanetMySQL Blogpost »
PlanetMySQL Blog: Distributed Locking - Solving it with MySQL
Dathan Pattishall
At Flickr we use a Federated Architecture, where the WHOLE of the data is spread across many servers. This means that when you load a photo page the dynamic data generated is hitting a server that holds that data, while another photo page view may hit another server for content.
Read the PlanetMySQL Blogpost »
PlanetMySQL Blog: Excited about MySQL Workbench
Robin Schumacher
When I was a DBA, there were only a handful of must-have tools that I constantly used. One was a good performance monitor. Two was a cross-platform admin tool. And three was my data modeling/design tool.
Read the PlanetMySQL Blogpost »
MySQL Query Optimization
Peter Zaitsev
I have now posted slides for the talk I gave in Zurich last week in MySQL Performance Presentations section.
Read the PlanetMySQL Blogpost »
Events
Live Webinar: Designing, Evaluating and Benchmarking MySQL Cluster
Tuesday, January 08, 2008
Learn the fundamentals of how to design and select the proper components for a successful MySQL Cluster evaluation. We will explore hardware, networking and software requirements. Work through a basic installation, functional testing and ongoing best practices for maintaining the system. Finally, we will close with an examination of the recent benchmark results performed in conjunction with Intel and Dolphin Interconnect Solutions.
Conference: Open Source meets Business 2008 (Germany)
Nürnberg, January 22-24
Visit the MySQL booth and attend the "Carrier-Grade VoIP Solution based on Open Source Technology" customer presentation by Alexander Hoffmann, iptego GmbH.
Learn More about the conference »
Seminar: MySQL Federal DBA Day
MySQL and Carahsoft invite you to complimentary seminar providing you with sufficient training and knowledge transfer, to enable experienced Federal Oracle DBAs to deploy and manage MySQL in a production environment.
Training, Consulting, and Certification
Consulting: MySQL Scale-Out, High-Availability and Replication Jumpstart (4 Days)
In this engagement, a dedicated MySQL certified consultant will work closely with your team to:
- Analyze your Scale-out and High-Availability database requirements
- Identify potential issues and limitations
- Install, Configure and Fine-Tune MySQL
- Configure MySQL or MySQL Cluster to work with HA Technologies (e.g. DRBD, SAN, Shared SCSI, Heartbeat, etc), as required
- Secure your database environment against failures and downtime
- And more ...
Schedule your Schedule Your Engagement Now » (http://www.mysql.com/link/nl07-12e.{user_id}.712028/http%3a//www.mysql.com/consulting/packaged/scaleout.html)
Training: MySQL Performance Tuning (4 Days)
Ottawa, Houston, Paris, Chicago, Hamburg
- 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/link/nl07-12e.{user_id}.712029/http%3a//www.mysql.com/training/courses/performance_tuning.html)
Partners
Partner Solutions Using MySQL
Hundreds of Original Equipment Manufacturers (OEMs), Independent Software Vendors (ISVs) and Value Added Resellers (VARs) have chosen MySQL as their embedded or bundled database.
Read about who is using MySQL » (http://www.mysql.com/link/nl07-12e.{user_id}.712030/http%3a//solutions.mysql.com/news/release_1450.html)
Are You Missing Out on Opportunities to Advertise Your Solutions to MySQL Users?
With thousands of unique visitors hitting it each day, MySQL.com is the most targeted site on the web for exposing your products and services to MySQL enthusiasts. If you haven't already done so, get your company and products listed, today, in the MySQL Partner Directory.
MySQL Partner Directory » (http://www.mysql.com/link/nl07-12e.{user_id}.712031/http%3a//solutions.mysql.com/solutions/partners/)
The MySQL Team
© 2010, Oracle Corporation and/or its affiliates