In what I think must be MySQL’s first time in the Philippines, there will be a presence there next week. Well, its not the first time, but in terms of a community/developer event, I think it might be. The Sun Tech Days is happening from 17-19 June 2008, in the Shangri-La Makati.

Besides MySQL, expect great talks on NetBeans, GlassFish, OpenSolaris, and so much more. I’ll be the guy walking around in the MySQL shirt, so feel free to stop me and ask questions. Its exciting for me, as we’ve not really paid much attention to the Philippines, in terms of community growth (and the Philippines is in the APAC region!).

This isn’t a free event (its 1,000 PHP = ~USD23), and registration should still be available. If you’d like to meet up, and talk MySQL, shoot me an email at colinATmysqlDOTcom or …

Well I don't quite know either (yet ;-) but I spotted a hint: his LinkedIn profile now says "President at NimbusDB", with stated goal "To build a database in the clouds that scales to 1000X disk-based database systems." Sounds good.

Which Jim? Jim Starkey, most recently known from MySQL's Falcon storage engine.

I’m going to OSCON in July, and I know that just about everyone I know who is a participant in this crazy life we call IT (or web 2.0, or whatever it’s called now), is flying to a conference or something in 2008. I’m starting to notice more and more posts like this one, so if you can avoid it, don’t put anything in a checked bag that you can’t afford to lose, and avoid US Airways, and pass it on, because when you see the list of things they don’t cover in their lost baggage policy, you’ll suddenly feel like you’re lucky to still have anything you ever checked with your bags.

Welcome the the 101st edition of Log Buffer, the weekly review of database blogs.

This edition was originally claimed by Ward Pond for his SQL Server Blog. Unfortunately, Ward is, in his own words, “dealing with the aftermath of a burst appendix,” which is a very good reason not to spend your time at the computer. Ward, heal up soon! We’ll see you on LB before too long.

In lieu of the normal Log Buffer, I throw it open to our readers. Please leave a comment mentioning your favourite database blog items from the week that was, and anything else you care to say about them.

LB will be back to normal next Friday. See you then!

After a period of inactivity I was hacking back on a Drupal project, I had taken a mysql dump from a production platform and imported into my local dev setup, just to have some realistic data.

All of a sudden some forms started failing with the following error:


user warning: There is no 'user'@'nonlocalhost registered query: insert into blah (stuff,morestuff) values (x,y) in /var/vhost/drupal-tree/includes/database.mysql.inc on line 172.


My Drupal data connection was correct and working for selects etc.. only a limited set of inserts failed.

After some debugging I realised that the error was not Drupal related, running the same query on my MySQL console gave the same error.


ERROR 1449 (HY000): There is no 'user'@'nonlocalhost' registered


The error came from a trigger on the table I was inserting data into that had been created on the …

A common misunderstanding seems to be that the only way to increase the available “paper space” for a diagram is by increasing the size of the paper. But there is another way to do that, which is in the Model -> Diagram Size dialog, where you can set the number of pages your diagram has, vertically and horizontally (perhaps it’s not very obvious to first time users, so we’ll be working on making it more easily accessible).

Another recurring issue is that of printing in the community version. Direct printing is …

La registrazione del webinar e le slide sono presenti qui.
Di seguito riporto la sezione di domande e risposte:
Q from Ivo: Tutte le considerazioni sulla scalabilita' fin qui individuate sono valide anche per la versione community di MySQL?
A: si

Q from Alex: Mysql Proxy per la suddivisione delle richieste lettura scittura è ad oggi stabile ?
A: MySQL Proxy e' ancora in fase alfa e non e' consigliato l'utilizzo in produzione.

Q from Massimo: Qual'e' il metodo migliore per il backup incrementale di un db?
A: E' necessario attivara il binary log ed effettuare le operazioni di FLUSH LOG al momento del backup.

Q from Mauro: Ci possono essere applicativi web che inseriscono dei dati nel DB, e che subito rileggono i dati inseriti. Dato  che la replicazione è …

To coincide with EURO 2008, I’m embarking on a virtual European tour, taking a quick look at open source policies and deployment projects in the 16 nations that are competing in the tournament.

According to statistics presented by Roberto Galoppini, 2.4% of visitors to SourceForge are from Poland, a statistic which serves its purpose of being both interesting and pointless at the same time.

Also statistically meaningless in terms of open source adoption, but nonetheless interesting is the …

There's an interesting post from a few weeks back by Guy Kawasaki in an article entitled "How to pickup a VC." While it's a short piece illustrating how boneheaded "attention grabbers" will work against you with VCs, I think it's actually quite a good reminder about effective communications for any IT vendor. I can't count how many times I've sat through a vendor pitch or product presentation and after 20 minutes I'm wondering "Why don't they just tell me what it is that they do?" Instead, I get a lot of discussion about open source freedom, community, business models, licensing... READ MORE

OK, now I know that the GA version of 5.1 is rapidly approaching. PBXT compiles with the latest release of MySQL without any changes!

This has never been the case before. Just search the PBXT code for MYSQL_VERSION_ID, and you will find things like:

#if MYSQL_VERSION_ID < 50114
    XT_RETURN_VOID;
#else
    XT_RETURN(0);
#endif

and, even worse:

#if MYSQL_VERSION_ID < 60000
#if MYSQL_VERSION_ID >= 50124
#define USE_CONST_SAVE
#endif
#else
#if MYSQL_VERSION_ID >= 60005
#define USE_CONST_SAVE
#endif
#endif

The lack of changes that affect pluggable storage engines can only mean that the bug fixes required are diminishing in scope.

And I believe this is a far better gauge of whether GA is close than any other …