- MySQL Lunch & Learn Program
- Win a MySQL Conference Pass - Take the MySQL User Survey
- Case Study: iStockphoto Grows to a Top-100 U.S. Website
- 30 Day Trials for MySQL Enterprise Monitor
- MySQL is Hiring
New Product Releases
- Fall 2007 Release of MySQL Enterprise Monitor
- New Release of MySQL Enterprise Server 5.0.50
- New Release of MySQL Community Server 5.1.22 (Release Candidate)
Hints & Tips
- Article: A look at MySQL on ZFS
- Article: MySQL Failover Strategy Using State Management, introducing MPP - Part 1
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Using MySQL Table Checksum
- PlanetMySQL Blog: How to Keep MySQL Replication in Sync
- PlanetMySQL Blog: BLOB Streaming presentation at the Hamburg MySQL User Group
- memcached and MySQL
- Live Webinar: Backup and Recovery of MySQL Servers
- Live Webinar: Advanced Techniques: MySQL Circular Replication
- Live Webinar: MySQL vs. Oracle Express, An ISV Perspective
Training, Consulting & Certification
- Consulting: MySQL Scale-Out, High-Availability and Replication Jumpstart (4 Days)
- Training: MySQL Partitioning MySQL (Virtual Course, 1 Day)
- XAware 5 Open Source Data Integration Project for MySQL
The "MySQL Lunch-n-Learn Program" is designed to be a fun and informal educational event for your team. MySQL provides the technical experts, and brings lunch! Select a topic of your choice:
- MySQL Enterprise Monitor, Replication Monitor, and Scale-Out
- MySQL High Availability and Scalability Architectures
- MySQL Performance Tuning - Advanced Tips & Tricks
- MySQL Partitioning
- MySQL for Data Warehousing
- MySQL for the Oracle DBA
- MySQL Cluster - Carrier Grade Edition (for Telecoms only)
- Embedded Databases: Why MySQL is a perfect fit for ISV applications
Case Study: iStockphoto Grows to a Top-100 U.S. Website using MySQL
iStockphoto is the world's busiest image market, with an image downloaded every 2.5 seconds. For their Web site, scalability has become mission-critical. Being able to manage increasing volumes of data and transactions has to be carefully balanced with IT budgets and resource expenditures.
You can experience the power of the MySQL Enterprise Monitor at no charge for 30 days. This Service continuously monitors your MySQL servers and alerts you to potential problems before they impact your system. It is like having a "Virtual DBA Assistant" at your side to recommend best practices to eliminate security vulnerabilities, improve replication, optimize performance and more.
This latest release adds new advanced replication monitoring, graphs and best practice advisor rules. The new feature set includes:
- New Replication Monitor provides real time visibility into Replication health and status, master/slave performance, and latency issues. (Gold and Platinum)
- Master/slave relationships are now auto detected and grouped giving DBAs immediate visibility into their Replication topologies
- New rules for monitoring master and slave configuration, status, performance and latency
This is a Monthly Rapid Update release of the MySQL Enterprise Server 5.0. Following is a partial list of changes and bug fixes:
- Bug Fix: Server parser performance was improved for expression parsing by lowering the number of state state transitions and reductions needed. (Bug#30625)
- Incompatible Change: The parser accepted statements that contained /* ... */ that were not properly closed with */, such as SELECT 1 /* + 2. Statements that contain unclosed /*-comments now are rejected with a syntax error. (Bug#28779)
- Bug Fix: A server crash could occur when a non-DETERMINISTIC stored function was used in a GROUP BY clause. (Bug#31035)
New Release of MySQL Community Server 5.1.22 (Release Candidate)
MySQL Server 5.1.22-rc release is the first 5.1 "Release Candidate" version of MySQL. Following is a partial list of changes and bug fixes:
- There is a new innodb_autoinc_lock_mode system variable to configure the locking behavior that InnoDB uses for generating auto-increment values.
- Bug fix: MySQL Cluster: (Replication): Multi-master replication setups did not handle --log-slave-updates correctly.
- Bug fix: Row-based replication from a pre-5.1.22 MySQL Server to a MySQL 5.1.22 was unstable due to an uninitialized variable.
When Sun Microsystems released the ZFS filesystem in 2004, they set out to remove all of the practical limits on filesystem storage, and to make the arcane details of storage management a thing of the past. ZFS is a 128-bit filesystem with - to name just a few features - copy-on-write transactional semantics, fast snapshots, and optional compression.
Article: MySQL Failover Strategy using State Management, introducing MPP - Part 1
Russell E Glaue
Having a strategy for failover has become almost standard in the business world. Whether it is a total site failover from a NOC in one city to another, or just a simple redundant server. Over the years many technology solutions have been created for or adapted to MySQL to provide this type of strategy.
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: Using MySQL Table Checksum
The MySQL Table Checksum, part of the MySQL Toolkit is an invaluable community tool for use with MySQL. Most sites or installations of any volume will use MySQL Replication for one purpose or another, be it for read scalability, backups, testing, upgrading etc.
PlanetMySQL Blog: How to Keep MySQL Replication in Sync
There is a great article on how using LIMIT clauses in update and delete statements can produce different results on a slave than it did on the master. If you really want to keep a master and slave in sync, I have a larger list of rules to follow for SQL that is run on a master.
BLOB Streaming presentation at the Hamburg MySQL User Group
I have just posted the presentation that I gave at the Hamburg MySQL User Group last Tuesday. You can download the presentation here. I have added a few slides on advanced topics: backup, replication and the distributed repository, which did not actually make it into my talk. However, these topics came up in the discussion over a few drinks afterwards.
Live Web Seminar: Advanced Techniques: MySQL Circular Replication
Wednesday, December 05, 2007
Mike Gaydos, System Architect, EDS
Join us for this webinar where you can learn about a practical implementation of MySQL multi-master circular replication.
In this webinar learn about a use case along with operational process sequences that can be used to effectively manage the environment. We will explore what multi-master replication is, considerations for setting it up and then how it can be used to provide value to your applications.
Live Webinar: MySQL vs. Oracle Express: an ISV Perspective
Tuesday, December 11, 2007
When bringing a new product to market, an ISV faces a collection of key business and technology decisions. One of the most important determinations revolves around selecting an embedded database to include with their new product. Hundreds of successful ISVs have already done their homework and chosen MySQL as their data storage architecture. This has radically changed the game in the relational database market, especially with regard to embedded solutions.
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 ...
Training: MySQL Partitioning (Virtual Course, 1 Day)
November, 20 2007
This instructor-led course is designed for MySQL users who would like to use the new partitioning features available in the MySQL 5.1. This course provides in-depth information in an E-Learning classroom format that is easily accessible and affordable.
XAware 5 Open Source Data Integration Project for MySQL
The XAware 5 Open Source Data Integration Project adds comprehensive XML capabilities to MySQL. Easily create, update, join, federate, construct, and expose MySQL data as services. XML provides the most effective way of representing and manipulating business data. It has become the de-facto method for transforming data to and from web-based applications and between business partners in B2B exchanges.