Below is the text of the page https://mysql.dp.ua/ stored 2006-12-04 by archive.org.ua. The original page over time could change. View as original html

MySQL AB :: Developer Zone

[http://www.mysql.com/] DEVELOPER ZONE :: Login / Register Home Products Services Partners Community Customers News & Events About Why MySQL? How to Buy Downloads Documentation Articles Forums Lists Blogs Newsletter Forge Bugs What's New MySQL Enterprise -- Double your DBA Staff without Adding Headcount Proposals for the 2007 MySQL Conference & Expo Now Being Accepted Find a GUI Bug, Win an iPod! White Papers » Web Seminars » Jobs at MySQL » Learn about new MySQL releases, technical articles, events and more. Subscribe Now » Try the MySQL 5.1 Beta! Row-based Replication Table and Index Partitioning MySQL Cluster Disk-Based Tables Dynamic Pluggable Storage Engine API MySQL Cluster Replication Learn About More Cool Features (pdf) » Download 5.1 » Development with MySQL PHP Perl Python Ruby Java / JDBC Developer Articles MySQL Scale-Out With Application Partitioning Introduction: Eventually every database system hit its limits. Especially on the Internet, where you have millions of users which theoretically access your database simultaneously, eventually your IO system will be a bottleneck. Conventional solutions: In general, as a first step, MySQL Replication is used to scale-out in such a situation. MySQL Replication scales very well when you have a high read/write (r/w) ratio. The higher the better. But also such a MySQL Replication system hits its limits when you have a huge amount of (write) access. Because database systems have random disk access, it's not the throughput of your IO system that's relevant but the IO per second (random seek). You can scale this in a very limited way by adding more disks to your IO system, but here too you eventually hit a limit (price). Read More » Interview with Brian Moon, from the Phorum project If you've spent any amount of time on the forums, you probably will have recognized Brian among the forum users who most frequently answer posts -- particularly SQL and performance-related questions. Some time ago, I had a chance to ask Brian a little bit about his experience writing Phorum, about his thoughts on open source and MySQL in particular, and on his vision for Phorum in the future... Read More » Interview with Rohit Nadhani, Co-founder of Webyog Webyog is the company behind the popular SQLyog GUI tool for managing and developing MySQL databases. They have a great history of partnership with MySQL and, recently, decided to open source part of their product line. I had a chance to interview Rohit Nadhani, co-founder of Webyog, about their decision to move to open source, the changes they've made to the code as a result of that move, and various other things. Read More » Tuning MySQL for eZ publish This article explains how to tune a MySQL database for use with eZ publish. MySQL is a database engine used by eZ publish to store content. While other databases are supported by eZ publish (such as PostgreSQL and Oracle), for performance reasons we recommend MySQL. This article has suggestions for optimizing for either read or write operations, and also discusses some other optimization techniques such as DNS and filesystem configuration. Read More » MySQL 5.1 New Features: MySQL Partitions Partitioning is a way of pre-organizing table storage. You can say "some of the table's rows will go here, some will go there, still others will go to to still other places". Often, depending on the storage engine, the effect is to spread the table's rows over different files or even different disks. Read More » Getting Started with MySQL 5.0 Download MySQL 5.0 Server What's New in MySQL 5.0 MySQL 5.0 Documentation MySQL 5.0 In-Depth Web Seminar MySQL 5.0 Key Features Stored Procedures ( docs , article , forum ) Triggers ( docs , article , forum ) Views ( docs , article , forum ) Information Schema ( docs , article , forum ) Archive Storage Engine ( docs , article , forum ) PlanetMySQL Blogs 451 CAOS Links - 2006.11.14 (The 451 Group) What is the next step in Internet search technology? (Konstantin Osipov) Day 3 - Memorable Quotes (Ronald Bradford) MySQL Camp Lost and Found (Sheeri Kritzer) Zimbra Front Page News in WSJ (Zack Urlocker) Bug fix of InnoDB scalability problem (Peter Zaitsev) MySQL AB & NitroSecurity to Jointly Develop Database Storage Engine (MySQL AB Corporate News) ZRM for MySQL and MySQL Online Backup (Zmanda Team Blog) MuleSource Chooses Hyperic to Add Management Capability to ESB Platform (John Mark Walker) Sun to GPL Java (Zack Urlocker) More posts » MySQL Quickpoll MySQL will be conducting a trial of database-related advertising on our web site. What is your initial reaction to this? I think it sounds like a good way to help fund MySQL community activities. As long as the ads don't get in my way, it's OK with me. I don't know -- I'd have to wait & see. It would be a nuisance, but I could live with it. Advertising would be a major Turn-Off. Don't do it! View results MySQL 5.0 Workshops and Training MySQL 5.0 Upgrading and New Features Jan 03: Ottawa Dec 20: San Francisco Jan 03: London MySQL 5.0 for Database Administrators Feb 19: Rome Dec 18: New Delhi Jan 29: Winnipeg MySQL High Availability Jan 16: Dallas Jan 15: Milan Jan 30: München New Discussion Forums Stored Procedures Triggers Views Information Schema Archive Storage Engine Partitioning Jobs Downloads and Documentation MySQL 5.0 Database Server - Community Edition Generally Available 5.0.27 New! Documentation MySQL 5.1 Database Server - Community Edition Beta 5.1.12 New! Documentation MySQL GUI Tools 5.0-r5 Documentation MySQL Connector/ODBC Beta 5.00.07 Generally Available (GA) 3.51.12 Documentation MySQL Connector/J Generally Available (GA) 5.0.4 Generally Available (GA) 3.1.14 Documentation MySQL Connector/Net Beta 5.0.2 Release Candidate (RC) 1.0.8 New! Generally Available (GA) 1.0.7 Documentation MySQL Connector/MXJ Beta 5.0.3 Generally Available (GA) 1.1.6 Documentation MySQL Visual Studio Plugin Beta 1.0.1 New! MaxDB™ by MySQL Generally Available (GA) 7.5.00 Generally Available (GA) 7.6.00 Documentation Other software  © 1995-2006 MySQL AB. All rights reserved. Online Shop Site Map Legal Contact Us