Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter February 2005

Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links.

Articles in this newsletter:

Highlights

Products

Tips & Hints

Events

Consulting, Training & Certification

Partner Corner

Highlights

MySQL Network - Certified Software, Advisors, and Support

MySQL Network is a comprehensive set of proactive service that saves enterprise developers and DBAs time and effort. It includes everything an enterprise needs to be successful using MySQL including:

Special Offer

MySQL Network Basic

$295
Regularly $595
Save 50%
until March 31, 2005

Get it now »
  • Certified Software to improve application reliability
  • Service Advisors to proactively receive alerts and updates
  • Knowledge Base with hundreds of technical articles
  • MySQL Production Support to resolve issues quickly
  • More...

For More Information on MySQL Network, visit: http://www.mysql.com/network/ (http://www.mysql.com/network/)

Enterprise Software & Hardware Vendors Rally around MySQL Network

HP, Intel, Novell, Red Hat & leading ISVs join the new MySQL Partner Program to make it easier for IT organizations to integrate popular open source database. The multi-tiered MySQL Network Certified Partner Program enables ISV partners to certify that their software has been tested and is compatible with the MySQL Pro Certified Server and related MySQL tools.

Ensure Your Tools and Technologies are Certified » (http://solutions.mysql.com/program/)

MySQL Users Conference 2005 - Early Registration Ends Feb 28th
Silicon Valley, California
April 18-21, 2005

This is your last chance to save up to $300 - early registration ends February 28th. The 2005 Conference will host leading industry keynote speakers, the latest MySQL technologies, in-depth sessions and tutorials, and an exhibit hall showcasing the latest open source technologies. Highlights include:

  • Learn how to optimize and fine-tune the performance of MySQL
  • Get in-depth information on MySQL 5.0, MySQL Cluster, and more
  • Learn how to migrate from proprietary databases to MySQL
  • Learn MySQL Best Practices from Sabre, Suzuki, eBay, and more
Early Registration Ends February 28th - Last Chance to Save $300

Google, HP, Novell, and RedHat Keynote MySQL Users Conference

The program for the third annual MySQL Users Conference continues to expand. At the conference you will get a unique inside look into the open source industry with visionary keynotes from:

  • Google's Adam Bosworth
  • HP's Martin Fink
  • Novell's Miguel de Icaza
  • Red Hat's Michael Tiemann
  • O'Reilly Media founder and CEO, Tim O'Reilly
View the Complete Program Schedule »
Early Registration Ends February 28th - Last Chance to Save $300

Case Study: Ongame Powers High Transaction Online Poker System MySQL

Ongame's PokerRoom.com is one of the largest poker sites online. During peak hours, 12,000 players occupy the poker tables. Since each bet, each played hand and other data are recorded, the database often handles 2,000 transactions per second. They chose a classical open source solution with Linux, Apache, MySQL and PHP, known as the LAMP stack.

Download the Case Study » (http://www.mysql.com/it-resources/case-studies/mysql-ongame-casestudy.pdf)

MySQL is Hiring!

MySQL has job openings for qualified individuals in software engineering, quality assurance and consulting.

For more information, visit the jobs page » (http://www.mysql.com/jobs/)

Products

New Release of MySQL Community Edition (4.1.10) is Now Available

This is a maintenance release of the 4.1 version, mainly fixing recently discovered bugs. This release includes:

  • The server now issues a warning when 'lower_case_table_names=2' and the data dictionary is on a case-sensitive filesystem
  • The server now issues a warning to the error log when it encounters older tables that contain character columns that might be interrupted by newer servers to have a different column length.
  • InnoDB: A shared record lock ('LOCK_REC_NOT_GAP') is now taken for a matching record in the foreign key check because inserts can be allowed into gaps.

For detailed information on what is new visit »
Source and binaries are available to download »

New Release of MaxDB Beta (7.6) is Now Available

This release includes:

  • The released version of the Installation Manager (GUI).
  • Schemas replace the user/user-group feature.
  • The database size can be reduced now.
  • Parameters can be changed in the ONLINE operational mode
  • Log backup checks can be performed
For a complete overview see »
For the complete list of changes visit »
Download now »

Tips & Hints

MySQL Network and You

Community Relations Manager, Arjen Lentz, explains what MySQL Network means for you, the MySQL Community.

Read the complete article »

Securing a MySQL Server on Windows

At the end of January 2005 a new worm-like malware named Forbot spread across the Internet, targeting poorly configured MySQL installations and exploiting them to gain access to the Windows host machines. With a few simple steps MySQL on Windows can be secured to prevent malicious users from accessing MySQL and the data it contains. The key steps are to secure the default user accounts, limit external access, and use strong passwords.

Read the article which includes screenshots and sample code »

MySQL Cluster: Two Web Server Setup

This HOW TO is designed for a classic setup of two servers behind a loadbalancer. Learn how to achieve true redundancy - either server can be unplugged and yet the site will remain up.

Read the complete article »

MySQL Cluster: Updated Documentation

The MySQL Cluster documentation has been updated to make it easier to get started. It now includes:

  • Glossary of Terms
  • Basic MySQL Cluster Concepts
  • Simple Multi-Computer How To
  • MySQL Cluster Configuration
  • Management of MySQL Cluster
Read the updated and improved documentation »
MySQL Cluster is included in MySQL 4.1 as part of the Max packages »

Events

MySQL Users Conference and Expo: 70+ Technical Sessions
April 18-21, 2005, Santa Clara, California

Choose from over 70+ technical sessions presented by MySQL Experts including:

  • MySQL Performance Optimization, Peter Zaitsev, MySQL
  • A Guide to the MySQL GUI Tools, Michael Zinner, MySQL
  • Multi-Terabyte Data Warehouse, Michael Benzinger, Sabre
  • MySQL Scalabilty, Dathan Pattishall, Friendster
  • Managing LAMP Stacks with Open Source Tools, Yazz Atlas, Open Source Technology Group
  • PHP 5 + MySQL 5 = A Perfect 10, Adam Trachtenberg, eBay
  • MySQL Replication and Clustering, Brian Aker, MySQL

View the all the Sessions »
Early Registration Ends February 28th - Save $300! »

Web Seminar: Rackspace Ensures "Uptime Guarantee" with MySQL and Dell
February 23, 2005

The Rackspace Data Center powers thousands of business critical applications and high traffic websites, using a proven formula for success: their expertise, Dell systems, and the MySQL database.

Join us in this web presentation to learn Rackspace's best practices to deliver high-performance and zero-downtime applications at affordable prices.

Register for the Web Seminar »
February 23; 10:00 am PST; 1:00 pm EST; 19:00 CET

Conference: JBoss World 2005
March 1-2, 2005

Join MySQL at the first annual JBoss users conference and exhibition, JBoss World 2005, being held at the Omni/CNN Center in downtown Atlanta, Georgia.

For more information and registration visit »

Conference: Open Source Business Conference
April 5-6, 2005

Join Marten Mickos in his keynote presentation as he discusses how well today's open source solutions stack up to the requirements of conservative corporate buyers.

For more information and registration visit»

Community Event: MySQL Meetups
Monday, March 7th, 2005

Meet other MySQL users in your local community. MySQL Meetups are free and informal, face-to-face meetings that happen in hundreds of cities around the world. These meetings are a great opportunity to share your interest over a coffee or a beer.

Find a MySQL Meetup day near you »

Training & Certification

MySQL Data Warehouse Workshop (2 days)
March 10-11, 2005 - San Francisco Bay Area

This workshop will provide you with expert insight, best practices, and techniques that will cover the entire life-cycle of your Data Warehouse or Data Mart project. You will learn about requirements definition, modeling, architecture, deployment, and ongoing management. You will also learn to overcome the pitfalls and risks associated with Data Warehouse and Data Mart projects. Learn more about this course and see upcoming dates.

Learn more about this course and see upcoming dates » (http://www.mysql.com/training/workshops/datawarehouse.html)

Get Certified at the MySQL Users Conference

MySQL and Zend will be offering discounted certification exams to registered conference attendees for MySQL Core, MySQL Professional, and Zend PHP exams.

For more information contact certification-uc2005@mysql.com

Partner Corner

MySQL Tests Code with Coverity Prevent™

An analysis of the source code for the MySQL database has revealed that the code is very high quality - at least four times better than is typical with commercial software. The MySQL 4.1.10 version includes the fixes to the defects found in the analysis.

View the Coverity report »