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).

Have you ever tried to take a snapshot from a mysql server only to find an hour later that the box ran out of disk space when trying to create the tar ball? An easy solution is to use ssh to pipe the tar data directly to another server without it even touching the disk. For those unfamiliar with unix shells or pipes a pipe allows you to tie the output of one program to the input of another. This is most commonly used to manipulate that stream of data. For example if you want to find a specific file in a directory. In these examples cartman is server A (where the commands are ran from). Stan is server B.

cartman> ls | grep mysql-5
mysql-5.0

The | (pipe) tells the shell to direct the output of ls to the input of grep which looks for the pattern ‘mysql-5′. This same functionality can be used with the tar command. This next command would compress a file and uncompress it on itself. Of course this is pointless. Until we …

I've been using del.icio.us since 2004, and it has served me well. For those who still haven't tried it, it's basically a bookmark manager with a social twist. You can get a (nearly) real-time list of everyone's PHP bookmarks, everyone's MySQL bookmarks, my bookmarks, or the blogs I read.

At the bottom of each page, there is a convenient link to an RSS feed for that page. For example, you can get a feed of the blogs I read. There's only one problem - the feeds are limited to 30 items. That's why the list of blogs on …

I’m a data modeller. I specialise in this, and for a number of years on large projects I’ve been able to focus on this single task within the System Development Life Cycle of software development for several months at a time. Unfortunately what depresses me the most, is I can’t get a full time position in what I’m an expert in. It’s not a specialised skill that an organisation can use on a full-time basis, unless it’s a large organisation, and quite frankly, Brisbane isn’t a market that can support the diversity of large organisations. (caveat, large organisations that are proactive in software development, not just large organisations that have significant IT requirements, but do not work proactively). This is why I can also do Software Development, Database Administration, and even System Administration. Again, I’m not good enough to fill one of these positions in a larger organisation as an expert, but I can generally hold …