Out of Sync: Maddy's Blog

I am facing a strange behaviour when trying to setup a node which has 2 different versions of mysql running.  The second instance tends to ignore the "socket" directive and uses /tmp/mysql.sock instead of the defined /tmp/<hostname>.sock.  The system has multiple virtual interfaces and conflict is not the issue.

bash-3.00# /global/db/bin//mysqld --defaults-file=/global/db/my.cnf --user=root --pid-file=/global/db/logs/my.pid --basedir=/global/db/ --datadir=/global/db/ &
[1] 13773
bash-3.00# 090427 12:09:40  InnoDB: Started; log sequence number 0 46409
090427 12:09:40 [Note] Event Scheduler: Loaded 0 events
090427 12:09:40 [Note] /global/db/bin//mysqld: ready for connections.
Version: '5.1.24-rc'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)

The datadir is owned by the mysql user and problem occurs even if the datadir and the basedir are different.

If you have an idea on what the problem might be, please drop me a note.

A new blue print on why you should deploy MySQL on Solaris Cluster is available :

Deploying MySQL Database in Solaris Cluster Environments for Increased High Availability

If you are the kind of datacenter customer whose database and application server deployments are limited by the license fees based on core count, then you have the perfect solution from Sun that frees your data centre from core count and your mind from license worries by going for the unlimited Glassfish + MySQL deployment for a flat fee based on the number of employees.

For a comparison of the TCO, check the details here.

Of course for additional HA capabilities including DR, you can use Solaris Cluster with its robust monitoring, low costs and excellent stability.

Solaris Cluster Express 6/08 is now available for download!  You can
download the DVD image here.


What is new in this release?

*  This release runs on OpenSolaris Nevada build 86. The version of the
Sun Management Centre is now 3.1.

*  The HA agent for Solaris Containers is now enhanced to include
support for the Solaris 9 Branded Zones on SPARC platform. This
is very useful for those customers who still need to run some
applications on Solaris 9 while taking advantage of the new features of
Solaris 10 and above.


* The HA agent for PostgreSQL Database is now ehanced to support WAL
shipping.  This feature greatly enhances the deployment of PostgreSQL
database in Enterprise deployments.

* Support for Solaris Containers configured with exclusive IP is
included in this release.


* The SCX Geographic Edition is enhanced to support Oracle Data Guard
based replication.


* This release also contains the mandatory bug fixes and other minor
enhancements not mentioned above.

Stay tuned for more milestones along the open source journey!

With 5.1.24c, if the MySQL is not installed in the default path /usr/local, then  there is this simple error that prevents the startup:

080507  7:20:36 [ERROR] Can't find messagefile '/global/mysql/share/mysql/english/errmsg.sys'
 

The are many workarounds for the problem and one of them is to just create the soft link!

# mkdir -p /usr/local/mysql/share/

#ln -s /global/mysql/share/english/   /usr/local/mysql/share/english