Enterprise Platform Vendors Express Enthusiastic Support for World's Most Popular Open Source Database Major New Version Delivers Advanced SQL Standard-Compliant Features Such as Stored Procedures, Triggers, Views & New Pluggable Storage Engines

UPPSALA, Sweden & CUPERTINO, Calif. -- October 24, 2005 -- MySQL AB, developer of the world's most popular open source database, today announced the general availability of MySQL 5.0, the most significant product upgrade in the company's ten-year history. Starting today, MySQL 5.0 can be downloaded under the open source GPL license at http:/dev.mysql.com.

"We are quite proud to deliver this new version of MySQL -- as it includes the most-requested features from our users, customers and partners," said Marten Mickos, CEO of MySQL AB. "With their feedback, we have been ableto provide important enterprise-class features while staying true to MySQL's renowned heritage of high-performance, reliability and ease-of-use."

MySQL 5.0's Enterprise Database Features
The new MySQL 5.0 combines enterprise-grade reliability and performance with advanced SQL 2003 standard-compliant features, making it the most cost-effective database solution for business-critical applications. The product's new functionality will be especially familiar to database developers and DBAs of proprietary relational database systems -- allowing IT departments to ease the integration and transition of their data, applications and skill-sets.

MySQL 5.0 delivers dozens of new enterprise features, including:

Stored Procedures and SQL Functions -- to embed business logic in the database and improve performance;
Triggers -- to enforce complex business rules at the database level;
Views -- to ensure protection of sensitive information;
Cursors -- to allow easier database development and reference of large datasets;
Information Schema -- to provide easy access to metadata;
XA Distributed Transactions -- supports complex transactions across multiple databases in heterogeneous environments;
SQL Mode -- provides server-enforced data integrity for new and existing data;
New Federated and Archive Storage Engines -- MySQL's unique pluggable storage engine architecture allows greater flexibility, functionality and performance by making it easy to swap database engines in and out, based on users' application requirements;
New Migration Toolkit -- A new graphical toolkit that completely migrates all data and objects from Oracle, Microsoft SQL Server, Microsoft Access and other database platforms to MySQL;
Instance Manager -- new management assistant that allows remote starting/stopping of any MySQL Server, as well as remote editing of configuration files, reading of error and query logs, and more;
Updated Connectors and Visual Tools -- new high-performance versions of MySQL's ODBC, Java and .NET database drivers are now available, along with updated versions of the MySQL Query Browser and MySQL Administrator.

"MySQL 5.0 represents a huge leap in features and functionality for the MySQL database," said Gunter Rombauts, European IT manager for Chicago Metallic. "As a worldwide leader in metal ceiling systems, it's critical that our database supports heavy-duty enterprise applications with speed and reliability. We are looking forward to using MySQL 5.0 as a key component of Chicago Metallic's global IT infrastructure."

Industry Support for MySQL 5.0
Over 30 enterprise software and database tool vendors have expressed support for MySQL 5.0. These third-party partners' products and platforms will be certified for MySQL Network, the company's commercial database subscription service. They include Acronis, ActiveGrid, Actuate BIRT, Agresso, Alphasoftware, Arkeia, Business Objects, Embarcadero Technologies, Emic Networks, Four J's, GoldenGate Software, HP, IBM, Informatica, Jaspersoft, NEC System Technolo
gies, Novell, Pentaho, Quest Software, Samsung SDS, SAP, SourceLabs, SpikeSource, SSA Global, Steeleye, Sumisho, Sun Microsystems, SugarCRM, Zend, and Zimbra.

SSA Global, a leading global provider of extended enterprise solutions and services, will certify SSA ERP LN 6.1 with MySQL Network 5.0 before the end of this year. "MySQL 5.0, with its enterprise-class features, represents a very cost-effective and proven database alternative capable of meeting our customers' toughest requirements," said Rick Bernard, vice president Solutions Management, SSA Global. "SSA Global is committed to Open Source solutions, and support for MySQL is the next significant step in delivering value to our customers."

Ton Dobbe, product marketing manager for Agresso, states, "Apart from being the most popular open source database with over 6 million active installations worldwide, MySQL 5.0 also provides our clients with a robust, viable alternative to traditional offerings in the market at total cost of ownership savings of up to 90 percent."

Platforms and Availability
The production version of MySQL 5.0 is available now for Linux, Windows, Solaris, Mac OS X, FreeBSD, HP-UX, IBM AIX 5L and a range of other operating systems.All MySQL database software is available under a dual licensing model. Developers and organizations can choose between an open source (GPL) or a commercial MySQL license, depending on their deployment requirements. End-user enterprises can also subscribe to MySQL Network, a comprehensive set of certified software and premium support services.For software downloads and additional information, visit http://www.mysql.com/products/.

About MySQL
MySQL AB develops and supports a family of high performance, affordable database products. The company's flagship product is MySQL, the world's most popular open source database, with more than 6 million active installations. Many of the world's largest organizations, including Yahoo!, Sabre Holdings, The Associated Press, Suzuki and NASA are realizing significant cost savings by using MySQL to power high-volume Web sites, business-critical enterprise applications and packaged software.

With headquarters in Sweden and the United States -- and operations around the world -- MySQL AB supports both open source values and corporate customers' needs in a profitable, ustainable business. For more information about MySQL, please visit www.mysql.com.

# # #

MySQL is a registered trademark of MySQL AB in the USA and other countries. Other products mentioned may be trademarks of their respective companies.

差异大到什么程度呢? MySQL 的管理工具 MySQL Administrator, 有一个功能是备份数据库和将备份的数据库文件恢复的功能, 昨天的问题就在如此, 无论怎么折腾, 导入数据的时候在导入到 2.7M 左右 (备份文件大小是 60 多 M) 之后就再也不动了, 硬盘也不再有读写, CPU 占用率达到 100%. 昨天下班后开着这个程序开了一个晚上, 早上来一看还是一动不动.. 跟熟悉 MySQL 的同事讨论了半天, 不知所以然, 他们建议我把数据库换成 MySQL 的 4.1 版本 (我们现在用的是 4.0.11 版), 我考虑了半天, 觉得这个风险还是太大, 想到 Administrator 的版本有更新的了 (最新的 Windows 版本是 1.0.21 版, 我用的是 1.0.16 版), 换成 1.0.21 版后, 居然就顺利的成功了. 虽然以前碰到过的 bug 还在 (就是导入一部分就告诉你已经导入成功了, 不过只要多重复导入几次就会真正的全部导入), 但是至少那个问题解决了, 可以重新工作了.  

倒也不是真的没事, 下午刚上班的时候, 准备做一次数据格式的变化. 以前存储在数据库中的一些数据是经过处理后的, 准备还原成原始的内容, 本以为是个狠简单的事情, 也就没多想, 写了一个 jsp 就开始转, 结果.. 转了大概 1/3 之后, 蹦出来一个错误: OutOfMemory. 当时就 ft 了, 到数据库里一看, 一部分转了一部分还是原来模样, 完蛋, 还好折腾的是自己机器上的数据库, 要是弄的项目服务器上的那个, 同事非吃了我不可. 只好再吭哧吭哧恢复数据, 从项目服务器上的数据库中导出数据再导入我的数据库, 该死的是新加了不少数据在服务器上, 结果导致数据量比以前大了很多.. 现在还没导完, 只好坐在这里无聊.

下班回来边看电视边吃晚饭, 吃了一半想起来程序里可能的一个问题, 当时就忍不住了, 直接打开试了试, 果然是个 bug, 随手改了, 然后转头在 test 版鄙视了一下自己, 然后招来一捆人鄙视, 呵呵, 可见我本质上还是一个工作狂. 唉.

本来这个破事情不是自己的事情, 上周他们从青岛打回电话说客户需要一个聊天室, 于是就找到我头上了, 让我从网上找个开源的东西. 说实话太简单了的东西反而不好找, 找到的几个所谓中文版的都莫名其妙的不好用, 无可奈何之下找了个美国鬼子写的回来, 把界面改成中文, 以及输入的地方做了一下转码就给他们发过去了, 以为就没事了. 没想到今天又找上头来说客户又具体提了一堆需求让我给改改, 我分特的不行, 很不想接下这个破工作, 倒不是有多困难, 实话说那个米国人写的程序还是很清晰的, 而且, 一个聊天室而已, 统共就那么几个页面几个类, 根本没什么难改的, 给的需求也不是很诡异. 不过我就是不想干, 估计想法主要还是这个事情太没有技术含量了, 真是比较无聊. 推了推结果推不掉, 只好接下, 谁想自己真上手干了就没有一点不喜欢的样子, 改的上瘾居然下班时间过了二十分钟才发现, 分特死了. 种种表现真的证明自己很变态的有工作狂倾向..

btw: 早上起床第一件事情是开电脑, 心满意足的看到了客场 2:0 的比分, happy 极了, 可惜第二回合一捆人要去参加那个该死的联合会杯, 打倒该死的赛程和白痴意大利足协一万次.. 希望曼乔发挥意大利杯夺冠的惯性.. 呵呵.

一个多月以来的传闻成为了现实, 苹果公司终于无法忍受 IBM 和 Moto 的 PowerPC 缓慢的更新速度和高发热, 正式转向了 Intel 体系. 2005 年 6 月 6 日, 在旧金山举行的开发者大会上, Apple 公司的 CEO 乔布斯 Jobs 宣布了这个决定. 不知道啥时候能看到 x86 版的 MacOS X 呢.. 呵呵

这条新闻同时出现在两家公司的网站上.
http://www.apple.com/pr/library/2005/jun/06intel.html
http://www.intel.com/pressroom/archive/releases/20050606corp.htm

因为项目的需要, 我们使用了一个用 java 写的 ftp server 作为接收发布内容的服务器端, 发布端使用的也是用 java 写的 ftp 客户端程序, 以前使用的一直一切正常, 然而在重新搭建了一个服务器端 (windows 2000 server) 后发现, 发布始终失败, debug 了一下客户端, 发现是 ftp 操作在上载第一个文件之后 (首先是使用 stor 命令打开一个 datasocket, 然后上载文件), 执行任何一个 ftp 命令都会报错, 而错误信息是 stor 的命令语法错误. 感觉像是服务器端的问题, 然而同样的服务器软件放在另外一个机器 (linux) 上工作时则一切正常, 我是百思不得其解. 因为正在使用的那台 win2000 的服务器上没有可用的调试工具, 于是我在自己的工作机上用 eclipse 作为 ide 调试这个 ftp server, 然后更神奇的是, 这下就一切正常了, 不用 ide, 直接从控制台启动 ftp server, 一样一切正常. 难道这个还挑机器? 我郁闷了半天, 然后在那个 win2000 服务器上装了一个 jbuilder 来调试, 更加神奇的事情发生了, 在调试状态下居然也一切正常, 关掉调试, 还是正常. 关掉 ide, 从控制台启动, 同样的错误再次出现. 再打开 ide 运行, 又是一切正常..

大家都傻了, 之后又发现在另外一台 win2000 server 上工作的这个 ftp server 也是一切正常没有这个问题, 众人都佩服的五体投地, 这个传说中一次编译到处运行的 java, 居然会挑机器, 而且不但挑机器, 还挑运行环境.. 最后只得自己安慰自己说, 反正以后给人部署的时候用的都是 linux 做服务器操作系统.. 至于那台该死的 win2000 server, 暂时就开着 jbuilder 让这个 ftp server 在 jbuilder 里跑着好了, 反正只要先让它发布正常就好..

ANT 是 apache 提供的一个强大的工具. 由于项目需要, 研究了一下如何在程序中启动一个 ant 任务. 周五折腾一个下午, 试图直接调用我们需要的一些功能 (主要是 javac 和其他几个相关的), 始终不得其门而入. 今天晚上突然想到为什么不直接调用 ant 任务? 随手试了一下, 不到 20 分钟就搞清楚了应该怎么弄, 嘿嘿.

我们所用的 IDE 是 Eclipse. 首先在项目中建立 ant 所需的 build.xml 文件, 我写了一个非常简单的任务:

<?xml version="1.0"?>
<project name="testant" default="init" basedir=".">
  <!-- Init -->
  <target name="init">
    <property file="./build.properties"/>
    <mkdir dir="./classes"/>
    <javac srcdir="./src"
     destdir="./classes"
     classpath="${project.path}">
    </javac>
  </target>
</project>

这是一个很简单的任务, 在项目中建立一个 ./classes 文件夹作为编译的目的路径, 编译 ./src 目录下的全部源文件. 所引用的环境变量在 ./build.properties 文件里描述清楚.

然后写两个简单的类, 代码如下:

import org.apache.tools.ant.Project;
import org.apache.tools.ant.taskdefs.Ant;
public class TestAnt {
public static void main(String[] args) {
MyAnt com = new MyAnt();
com.execute();
}
}
class MyAnt extends Ant {
public MyAnt() {
setProject(new Project());
getProject().init();
setTaskType("ant");
setTaskName("compile");
setTarget("init");
}
}

代码很简单, MyAnt 类继承了 org.apache.tools.ant.taskdefs.Ant 类, 这是 ant 的主任务类, 并设定了相关信息, setTarget() 所用的参数就是要启动的任务名称.

然后直接运行 TestAnt 类的 main 方法, 发现系统报错, org.apache.tools.ant.launch.Locator 类找不到, 这个类在 ant-launcher.jar 中, 在 ant 的发行包中可以找到, 将这个类添加到运行环境中, 再次运行, 发现系统再次报错, 这次的错误是无法找到 javac, 这是因为 eclipse 的项目的默认运行环境中只包括 jre 的位置, 而 jre 不包含编译功能, 解决办法也很简单, 将 $jdk_home$/lib/tools.jar 包加入运行环境即可. 再次运行, 这次一切正常, 搞定!

现在已经能够满足我们的需求了, 不过我计划明天再研究研究, 因为现在这么运行还没有信息输出, 看看是哪个选项没有设置的问题:)