Cluster One
Check out the new OpenSolaris page and download the new OpenSolaris binary distribution.
You can easily download the integrated MySQL packages by using the Package Manager GUI or simply
pkg install SUNWmysql5
As part of the MySQL packages the MySQL Cluster (NDB) storage engine and management binaries are included. You can use the general documentation available at MySQL.comfor setting up a Cluster . Then you should be ready for high availability MySQL.
Posted at 12:12PM mai 06, 2008 by Jan Berg in Databases | Comments[0]
Easy Living
New version (10.4.1) of JavaDB is out. Added features are asynchronous replication, table functions and JMX monitoring of the DB instance. Performance enhancements and some additional features, check it out here
Posted at 09:30AM apr 28, 2008 by Jan Berg in Databases | Comments[0]
When I'm Sixty Four
64 bit MySQL (5.0) is now integrated into OpenSolaris. It will be available in build 87. 64 bit should work with 32 bit generated data-files and vice versa, although MySQL recommends you to do a full dump and reload, at least in production. To enable the 64 bit server in SMF do:
% svcadm disable mysql:version_50 % svccfg svc:> select mysql:version_50 svc:/application/database/mysql:version_50> setprop mysql/enable_64bit=true svc:/application/database/mysql:version_50> quit % svcadm refresh mysql:version_50 % svcadm enable mysql:version_50Also check out the latest Netbeans 6.1 beta with integrated MySQL support.
Posted at 01:47PM mar 25, 2008 by Jan Berg in Databases | Comments[0]
Let's Get It Up
Some tips around MySQL and SMF on OpenSolaris. You can enable the MySQL server by starting it through svcadm
% svcadm enable mysqlAlthough for current builds since the integration on build 79, you need to do this manual stuff first:
% su - % cd /var % mkdir mysql % /usr/sbin/groupadd mysql % /usr/sbin/useradd -g mysql -d /var/mysql mysql % chown mysql:mysql mysqlSo if your MySQL service is going into maintenance:
% svcs | grep mysql maintenance 11:03:45 svc:/application/database/mysql:version_50You could find out more what happened by doing:
% svcs -x svc:/application/database/mysql:version_50 (MySQL RDBMS) State: maintenance since February 15, 2008 2:25:49 PM CET Reason: Restarting too quickly. See: http://sun.com/msg/SMF-8000-L5 See: MySQL 5.0.45(1) See: http://dev.mysql.com/docs See: /var/svc/log/application-database-mysql:version_50.log Impact: This service is not running.This will lead you to the above log-file, where you could get some useful information.
Another tip is that you can change where your datafiles should be, by doing:
% svcadm disable mysql:version_50 % svccfg svc:> select mysql:version_50 svc:/application/database/mysql:version_50> setprop mysql/data=/export/home/tmp/mysql/data svc:/application/database/mysql:version_50> quit % svcadm refresh mysql:version_50 % svcadm enable mysql:version_50Remember that the directory specified need to be owned by mysql user and group!
Also you can read more about the MySQL integration and SMF at Ritu's blog
Posted at 04:11PM feb 15, 2008 by Jan Berg in Databases | Comments[0]
Have A Drink On Me
Today I have been at a student day at the Trondheim university, NTNU called ITDagen. The Sun place draw a lot of attention, mostly because we were giving away coffee, but also we were lucky to demo the cool Sun SPOTs.
We also gave away the new Solaris Developer Express 01/08 DVD and a lot of them was really interested. This release also includes the Webstack, so hopefully we can get some users there :)
A lot of students had a lot of interest in Sun technologies, and specially we tried to convince them to use NetBeans instead of certain other products they were using..
Posted at 09:00PM feb 11, 2008 by Jan Berg in Sun | Comments[1]
Get It Hot
PostgreSQL version 8.3 has been released today. You can find the Solaris bits here. Among new features is the Heap Only Tuple (HOT), which should give substantial throughput improvements.
Posted at 02:19PM feb 04, 2008 by Jan Berg in Databases | Comments[0]
The Sign
Time to present more bands featuring friends. Watt is also a rock'n'roll band based in Trondheim. Their first album Those Days came last year, and we are hoping for new stuff this year.
Posted at 02:04PM feb 03, 2008 by Jan Berg in Music | Comments[0]
The Thing That Should Not Be
All things come to an end, and so do old software. By removing the older version of the EOL version 4.0 of MySQL from OpenSolaris, we encourage users to go on to 5.0. From build 79 MySQL 5.0 is now integrated into OpenSolaris. Btw, MySQL 4.0 will not go away unless the ARC case is accepted of course.
Posted at 11:31AM jan 30, 2008 by Jan Berg in Databases | Comments[0]
Dirty Looks
My friends at The Boogiemen Inc has released a CD single called Dirty Looks. The band is inspired by everything from old blues to the 70s hard rock scene. Go check out the Dirty Looks video at YouTube.
Posted at 11:56AM jan 27, 2008 by Jan Berg in Music | Comments[0]
Escape
Using SecurityManager with Java and Socket's is not always as easy as it first seems. You would think that when creating a DatagramChannel and operating on that (ie send and receive), you will get the SecurityException if you don't have the right permissions. But no, you have in fact to an explicit check for the permissions you need like this:
SecurityManager security = System.getSecurityManager();
if (security != null) {
security.checkXXX(argument, . . . );
}
And it is the calling Thread that should be checked before doing a DatagramChannel.receive call as this call will hang forever if it doesn't have the right permissions.
Posted at 05:50PM jan 25, 2008 by Jan Berg in Java | Comments[0]
Hit The Lights
Hi, I work in the Database Technology Group at Sun Microsystems, and I am located in Trondheim, Norway. I'm currently working with HADB. I'm also doing some work on the OpenSolaris Webstack project with integrating MySQL into OpenSolaris.
Posted at 01:30PM jan 24, 2008 by Jan Berg in Personal | Comments[0]