opensubscriber
   Find in this group all groups
 
Unknown more information…

n : newsletter@mysql.com 16 November 2007 • 4:32AM -0500

MySQL Newsletter: November 2007
by MySQL AB

REPLY TO AUTHOR
 
REPLY TO GROUP



MySQL Newsletter
November 2007
newsletter@mysq...

Articles in this newsletter:

Highlights
- 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

New Forums
- memcached and MySQL

Events
- 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)

Partner Corner
- XAware 5 Open Source Data Integration Project for MySQL

-------------------------------------------------------------------

Highlights

MySQL Lunch & Learn Program

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

Register to Qualify:
  http://www.mysql.com/news-and-events/lunch-n-learn/


Win a MySQL Conference Pass - Take the MySQL User Survey

Please take a few moments to complete our annual user survey, and you could win a pass to join over 1600 MySQL enthusiasts at the MySQL Conference, April 14-17, 2007 in Santa Clara, California.

Take the Survey (On Zoomerang):
  http://www.zoomerang.com/survey.zgi?p=WEB227556NBGTJ


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.

Read the Case Study:
  http://www.mysql.com/why-mysql/scaleout/istockphoto.html


30 Day Trials for MySQL Enterprise Monitor

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.

Register for the Trial:
  http://www.mysql.com/ent-trial-reg-2007/


MySQL is Hiring

Apply today to join one of the largest and fastest growing open source companies! MySQL is a global organization with over 300 employees in 25 countries. We have openings for the following positions:

- Support Engineers
- Senior Software Developers
- QA Engineers
- Senior Sales Representatives
- Sales Engineers
- And More ...

Apply Now:
  http://www.mysql.com/jobs/

-------------------------------------------------------------------

New Product Releases

Fall 2007 Release of MySQL Enterprise Monitor

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

Download the White Paper, What's New: MySQL Enterprise Monitor:
  http://www.mysql.com/products/enterprise/whitepapers/mysql-wp-enterprise-fall-whatsnew.php
Download the MySQL Enterprise Monitor: (Login Required)
  http://enterprise.mysql.com


New Release of MySQL Enterprise Server 5.0.50

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)

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0-50.html
Download Now: (Login Required)
  http://enterprise.mysql.com
  
  
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.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-22.html
Download Now:
  http://dev.mysql.com/downloads/mysql/5.1.html

-------------------------------------------------------------------

Hints & Tips

Article: A look at MySQL on ZFS
John David Duncan

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.

Read the Article:
  http://dev.mysql.com/tech-resources/articles/mysql-zfs.html


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.

Read the Article:
  http://dev.mysql.com/tech-resources/articles/failover-strategy-part1.html


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.

Visit PlanetMySQL:
  http://www.planetmysql.org
Submit Your Blog Feed:
  http://www.planetmysql.org/newfeed.php


PlanetMySQL Blog: Using MySQL Table Checksum
Ronald Bradford

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.

Read the PlanetMySQL Blogpost:
  http://blog.arabx.com.au/?p=883


PlanetMySQL Blog: How to Keep MySQL Replication in Sync
Mark Callaghan

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.

Read the PlanetMySQL Blogpost:
  http://mysqlha.blogspot.com/2007/11/how-to-keep-mysql-replication-in-sync.html


BLOB Streaming presentation at the Hamburg MySQL User Group
Paul McCullagh

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.

Read the PlanetMySQL Blogpost:
  http://pbxt.blogspot.com/2007/11/blob-streaming-presentation-at-hamburg.html

-------------------------------------------------------------------
  
New Forums

memcached and MySQL

Since many leading web sites use memcached with MySQL, we have now created a dedicated discussion forum. MySQL Engineers will be participating in the discussions.

Visit the Forum:
  http://forums.mysql.com/list.php?150

-------------------------------------------------------------------

Events

Live Web Seminar: Backup and Recovery of MySQL Servers
Thursday November 15, 2007 (German)
Tuesday November 20, 2007 (French)

Join us for a webinar covering best practices for doing full and incremental backups of your MySQL servers. In this webinar we will cover:

- MySQL Backup Principals
- Physical and Logical Security
- Backups using multiple storage engines
- mysqldump
- Replication
- Recovering secure data

Register for the Webinar (German)
  http://www.mysql.com/news-and-events/web-seminars/display-71.html
Register for the Webinar (French)
  http://www.mysql.com/news-and-events/web-seminars/display-80.html


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.

Register for the Webinar:
  http://www.mysql.com/news-and-events/web-seminars/display-77.html


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.

Register for this Webinar:
  http://www.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

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 Engagement Now:
  http://www.mysql.com/consulting/packaged/scaleout.html


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.

Register Now for an Upcoming Date:
  http://www.mysql.com/training/courses/mysql_partitioning.html

-------------------------------------------------------------------

Partners

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.

Learn More:
  http://www.xaware.com/MySQL/

The MySQL Team


About the Newsletter

You can send us queries and give us feedback online.
  http://www.mysql.com/company/contact/

You can unsubscribe from this newsletter online:
  http://www.mysql.com/unsub?email=subscriber@open...

Read more about the newsletter and view previous issues.
  http://www.mysql.com/news-and-events/newsletter/

--
Copyright (c) 2007 MySQL AB. All rights reserved.
You are free to distribute this newsletter, as long as you don't make any changes.

Bookmark with:

Delicious   Digg   reddit   Facebook   StumbleUpon

opensubscriber is not affiliated with the authors of this message nor responsible for its content.