Our newest documentation team member, Martin "MC" Brown has finished the often thankless task of refreshing and expanding our API documentation, which includes Connector/J. I suggest you take a look, as you can now find nice "nuggets" like how to use com.mysql.jdbc.ReplicationDriver to do load-balanced reads across a farm of slave replicas.

Also of note is a plugin for Eclipse that allows you to access the entire MySQL Reference Manual from inside your IDE (which happens to be the IDE that a majority of the Java developers inside MySQL use too!)

Our newest documentation team member, Martin "MC" Brown has finished the often thankless task of refreshing and expanding our API documentation, which includes Connector/J. I suggest you take a look, as you can now find nice "nuggets" like how to use com.mysql.jdbc.ReplicationDriver to do load-balanced reads across a farm of slave replicas.

Also of note is a plugin for Eclipse that allows you to access the entire MySQL Reference Manual from inside your IDE (which happens to be the IDE that a majority of the Java developers inside MySQL use too!)

Our newest documentation team member, Martin "MC" Brown has finished the often thankless task of refreshing and expanding our API documentation, which includes Connector/J. I suggest you take a look, as you can now find nice "nuggets" like how to use com.mysql.jdbc.ReplicationDriver to do load-balanced reads across a farm of slave replicas.

Also of note is a plugin for Eclipse that allows you to access the entire MySQL Reference Manual from inside your IDE (which happens to be the IDE that a majority of the Java developers inside MySQL use too!)

consistency, j2ee, java jboss

(also entitled, “Who Put the J in lam-a-lam-a-LAMJ?”)

So, I have started to read Mysql Stored Procedures by Guy Harrison with Steven Feuerstein — a fabulous book already! One thing that caught my attention was this (which you can see in the Preface, available through Safari):

MySQL is the dominant open source database management system: it is being used increasingly to build very significant applications based on the LAMP …

On September 18th-21st, the second EuroOSCON will take place in Brussels, Belgium. I probably won't make it to this year's conference, but I really enjoyed the event in Amsterdam last year.

The session grid contains a number of talks related to MySQL:

• John Paul Ashenfelter: Data Warehousing with MySQL
• Peter Zaitsev: High Performance Full Text search for Database …

We interrupt this scheduled viewing, for our faithful Windows users…

We have a new release of the MySQL Connector/PHP. MySQL has released 5.0.24 for a bit, and PHP themselves have released 5.1.5. The PHP release actually fixes some security related issues. Be sure to check the forums out if you encounter issues and if you fancy, the usual announce message.

Now back to your regular scheduled programming…

Technorati Tags: connector, …

Friendster got some new VC capital, after putting itself up for sale and nearly running out of money. They filed for some patents a long time ago, and at least one of those came through. That appears to be what the VCs are interested in, one had specifically pushed for patent applications earlier.

See GigaOM and Red Herring: Friendster Wins Patent (don't click on the actual patent link!)

But what is Friendster's business model? Some advertising, and subscriptions to phone alerts... I suppose it's going somewhere, but is it enough? For a small company without VC, this could be a good road for profitability. But with the VCs wanting to see a return on …

So, FireFox have come up with a novel idea to promote it’s product. Check out Firefox Day.

The official blurb: Share Firefox with a friend. If your friend downloads Firefox before September 15, you?ll both be immortalized in Firefox 2.

You can even choose how to link your names together on the “Firefox Friends Wall”. Examples like ‘my name’ Informed ‘your name’, or ‘my name’ Empowered ‘your name’, or ‘my name’ Liberated ‘your name’.

Perhaps MySQL can leverage this idea for some what to promote future download!

MySQL issues a cryptic error message, “Error on rename,” when you try to alter a table in such a way that it would break a foreign key constraint: create table test1(a int not null primary key)engine=innodb; create table test2(a int not null, foreign key(a) references test1 (a)) engine=innodb; alter table test2 modify a smallint not null; ERROR 1025 (HY000): Error on rename of './test/#sql-2fa8_1' to './test/test2' (errno: 150) This happens because ALTER TABLE really works by making a copy of the table, then renaming to move the old table out of the way and move the new table into its place.

If someone asks me about MySQL Backup advice my first question would be if they have LVM installed or have some systems with similar features set for other operation systems. Veritas File System can do it for Solaris. Most SAN systems would work as well.

What is really needed is ability to create atomic snapshot of the volume, which can be later mounted same as original file system

Why snapshot based MySQL backups are great ?

There are number of reasons:

Almost Hot backup In most cases you can perform this type of backup while your application is running. No need to shut down server, make it read only or anything like it.

Support for all local disk based storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines.

Fast Backup You simply do file copy in the binary …