It’s only been a few weeks since Sun announced the close of the MySQL AB acquisition (which really didn’t take long) and we now have a bundle of Sun Application Server 9.1 (GlassFish v2) together with MySQL.
The full distro is less than 150 MB (double that once installed on disk). It includes the open source GlassFish v2ur1 app server (Sun App Server 9.1ur1), MySQL Community Server 5.0 and of course the MySQL JDBC driver (version 5.1.16). You can get the bits off of HERE. They are available for Solaris, Linux, Windows, and Mac. Check out the “Installing Application Server 9.1 Update 1 with MySQL Community Server” documentation, the Release Notes, and Sathyan’s entry and sample application.
The database default “SMALL” install option corresponds to a system using 64 MB memory or less (typically a developer platform).
Once installed (interactive and silent installs available), the application server can be started using this simple command (or simply during the install process) :
% INSTALL_HOME/bin/asadmin start-domain
The application server documentation is here.
… it takes the following few set of commands (documented here) to get MySQL going :
% sh INSTALL_HOME/mysql/scripts/mysql_install_db (to initialize the grant tables)
% INSTALL_HOME/mysql/bin/mysqladmin -u root password 'new-password'
% INSTALL_HOME/mysql/bin/safe_mysqld [--defaults-file=install-dir/mysql/mysql.ini --user=root] &
mysql.ini config. file is located in
To find more information on working with MySQL: Getting Started, Full Documentation.
Creating a connection pool to the MySQL DB using the web console is pretty simple (command-line equivalent is
% asadmin create-jdbc-connection-pool ...):
No separate JDBC driver to install :
Testing the connection is always worthwhile (command-line equivalent is
% asadmin ping-connection-pool ...) :
Support for Sun Application Server/GlassFish starts at $4500 for 4 sockets while unlimited supports calls for MySQL Enterprise starts at $1999 per server. Access to patches (sustaining branch) is included in both support plans.
I have very regular discussions with GlassFish clients, system integrators, ISVs, and OEMs and the most common question (a fairly valid one too) I’ve been getting is this – “Great product experience and great roadmap, but how serious are you about this Open Source model?”. Needless to say that I haven’t heard the question since the MySQL acquisition.