In my environment, I like to install the server software on the server and install a client version of the software in a common area. If you need to link to certain libraries or use programs to connect to the database, I'll put them in /usr/local for everybody to use. My authentication is in the database, so I don't care if you can run a program but not connect to the database.

It's no secret that I'm a MySQL newbie and I've had my share of issues installing the MySQL client. That was kind of a special case since I wasn't using a mainstream compiler, but even so, I was able to get the problem fixed in relatively short order.

One of my tasks lately has been to upgrade the Oracle client to version 10.2. I've installed the client software a couple dozen times and the server software maybe 100 times if I want to …

OK, I'm sufficiently recovered from a fabulous few days at EclipseCon 2006, where I got to meet a great bunch of enthusiastic, talented developers who, I am sure, will push the Eclipse project into new realms of productivity and platform stability. I got a chance to talk with Andi Gutmans from Zend shortly after his presentation on the PHP IDE project and I'm excited to see what MySQL can bring to the table with both the DTP project and the PHP IDE endeavour. The next few months will indeed be very interesting.

A Full Slate

But, no rest for the weary. I've got a full slate of conferences and meetings coming in the next three months, including next week at …

OS X Panther and Tiger come with built-in multicast dns host name resolving.

...In Panther client, I could just use ssh admin@xmysql and it worked, however in Panther server and Tiger client/server I have to correctly use ssh admin@xmysql.local to resolve the host name.

For WO https development, you can use your dev machine name as the host name for the ssl certificate.

...Bonjour is available as a download from Apple (just google "Bonjour for Windows" to find it) so that your Windows PC's can easily access your mac services and in particular your development WO app on your dev machine using mymac.local as the host.

OS X Panther and Tiger come with built-in multicast dns host name resolving.

...In Panther client, I could just use ssh admin@xmysql and it worked, however in Panther server and Tiger client/server I have to correctly use ssh admin@xmysql.local to resolve the host name.

For WO https development, you can use your dev machine name as the host name for the ssl certificate.

...Bonjour is available as a download from Apple (just google "Bonjour for Windows" to find it) so that your Windows PC's can easily access your mac services and in particular your development WO app on your dev machine using mymac.local as the host.

Recently I had occasion to delete a couple of rows from a MySQL table using the Access interface. This is not something I make a habit of doing. Normally with an Access database you highlight some rows, press Delete, the rows disappear, it asks you do you really want to do that, and if you say "No" the rows magically reappear again.

The first thing that happened was an error. I did not have Delete privilege granted to me on this database. I quickly corrected that, noting that the error messages appeared before it asked me for confirmation that I really meant to do this operation.

So, again selecting and electing to delete these rows, as it prompted me with it's readback of what I am about to do to my database that I cannot undo, and do I really want to do it? message, I elected to say "No" just for grins. My rows came back—  sort of. They had the #Deleted text in every column, and I had this feeling that they …

Given a new Linux Installation, the following is my recommendation for installation of MySQL for a experienced software developer giving flexibility in a development environment.

1. Under normal circumstances, most distros include MySQL either in a default server installation or on the distribution CD’s. You should first ensure MySQL is not installed.

2. All products can be downloaded from the MySQL Downloads page.

3. Download MySQL 5.1 Beta - Linux (non RPM, Intel C/C++ compiled, glibc-2.3), this product is close to production release and stable. This also includes both Server and Client as well as provides flexibility in installation location and …

I was asked a simple question today by a collegue who is an experiened Java Developer and Oracle user and had just installed SUSE on his personal laptop, to align closer with his work environment. What MySQL should I install, the MySQL web site has this and this and this?

Simple question, but the answer isn’t as simple, especially when MySQL now has a number of different products encompassing client functionality in addition to the MySQL server.

Oracle got it right with the latest edition Oracle 10g Express Edition (XE). A simple one rpm install that includes the Oracle Server, Oracle client, a Web Based Administrator, Query Tool and Application Development tool. I guess as we are all experienced, the simple question isn’t something we have a some notes on handy, hence the purpose of my entry …

I just ran into MySQL Bugs: #12027: , one of the fixes for this is to run ndbd --initial again, however as I had already done that on my other node just removing the offending file also worked.

I've been browsing around infrastructure tools, starting earlier with Postfix (SMTP server), and an POP/IMAP server.

There are a few reasons I'm doing this.
From the MySQL perspective, where tools are able to use MySQL, we would like to see it used optimally and provide some assistance where needed.
From my own perspective, infrastructure tools have always been favourite ever since my early coding days. I can tell when a GUI is good or not, but I know that building them is not my thing ;-)

Infrastructure is made up of many tools, but it all needs to work together. Different people make different choices (based on their needs and preferences) and so we can't actually expect any Linux distribution to contain precisely what we need, configured the way we need it. And sometimes tools can work together in theory since they provide some kind of external interface/API, but actually setting it up can be something …

MySQL today announced that tech industry leaders IBM and EMC have joined the MySQL Network Certified Partner Program. Among other co-marketing and promotion activities with MySQL, both companies will be sponsors of next month's MySQL Users Conference in Santa Clara, California (http://www.mysqluc.com).