This Sunday I’ll be flying down to the bay area for my final week of work at Concentric. The following week I’ll be starting as a full-time Drizzle/Gearman developer with Sun Microsystems. This was the position Brian Aker mentioned back in January.

Over nine years ago I was flying to the bay area for my job interview at Concentric. It’s been a great run and I’ve learned a tremendous amount there, writing everything from customized, multi-threaded HTTP and DNS servers to a clustered, hierarchical object database with a full query language. The environment at Concentric feels like a family, probably because a number of co-workers have been there even longer than me. It was a tough decision to make, and I …

Rogers is one of Canada's biggest ISP's. I've pretty much been subscribed to them ever since I moved here. The last few months I've been seeing some shady behaviour, which lead to find out:

• They have some sort of transparent proxy in place, not only intercepting tcp packages; but sometimes even change them.
• Every DNS lookup to an unknown host will be responded to with a rogers ip.

Both of these are a little scary. The first time I noticed they were rewriting packages, was when I was just browsing around. All of a sudden rogers injected some html telling me my bills were due. This one is the most scary, who knows what else they log or modify. Wouldn't this cause some privacy concerns in most western countries?

I didn't make a screenshot at the time, but I'm …

Economic downturn? Perhaps, our service offering and pricing is such that we've actually only seen an increase in demand, which is of course great! So, we're looking for additional skilled and enthusiastic co-workers.

Open Query is not structured like your typical company, and this is quite on purpose. Our funding, business structure and approach, human resources, decisions on offering and pricing, are all "a bit different" to jive with our thoughts on building a company that provides a range of excellent services, while also really looking at what customers actually need, and providing a healthy (literally) working environment for our people.

One of our key aims is towards no-stress, both for ourselves as well as for our clients. You may figure stress and emergencies are an inevitable "fact of life", but we feel that that would be a wrong starting point. When instead we …

A new technical article entitled "Using the MySQL Connector/J JDBC Driver With the Java SE Platform", has been posted on java.sun.com at:

        http://java.sun.com/developer/technicalArticles/mysql_java/index.html

This article explains the essential steps involved in accessing/manipulating the data in a MySQL database from a Java application. MySQL Connector/J JDBC driver was used in the example code to show the database connectivity, data manipulation steps. Application developers who are new to Java programming language [but not to MySQL database] are the target audience of this article.

Stay tuned for the next article in this series "Using MySQL with PHP" ..

A new technical article entitled "Using the MySQL Connector/J JDBC Driver With the Java SE Platform", has been posted on java.sun.com at:

        http://java.sun.com/developer/technicalArticles/mysql_java/index.html

This article explains the essential steps involved in accessing/manipulating the data in a MySQL database from a Java application. MySQL Connector/J JDBC driver was used in the example code to show the database connectivity, data manipulation steps. Application developers who are new to Java programming language [but not to MySQL database] are the target audience of this article.

Stay tuned for the next article in this series "Using MySQL with PHP" ..

I'm consolidating my various blogs to a common blog, the Database Geek. I'm still tweaking the site and I plan to add links to categories (i.e. Oracle, Postgres, MySQL, etc) so that it is easily searchable. I also plan to add an RSS feed for each category so you only read the topics that interest you. Stop by and check it out.

Any comments or feedback is appreciated.

LewisC

Technorati : blogging, database-geek.com

The PrimeBase PBMS storage engine is now running on Drizzle.

It uses blobcontainer plugin hooks that I was asked to add to Drizzle at the OpenSQL camp in Virginia a few months ago.

It's always very rewarding to see something I built enable someone else to do something cool

As Ronald Bradford noticed there have been some changes at planetmysql.org today. For one thing, planetmysql.org is now part of the mysql.com family of websites, sure you will still be able to use planetmysql.org, but all now redirect to planet.mysql.com.

PlanetMySQL now takes its place next to the Forge, Forums, Developer Zone and the main MySQL.com web site. You may now move your user account between Forums, DevZone, www.mysql.com  and PlanetMySQL seamlessly. The same login credentials can be used on the Forge.

This may not seem like a …

Did anybody notice that http://planetmysql.org now redirects to http://planet.mysql.com?

Curious to know the reason why, perhaps an official MySQL person can give us some details.
Also it’s a 302 redirect, not a 301 redirect, interesting?

 wget http://planetmysql.org
--2009-02-26 14:40:09--  http://planetmysql.org/
Resolving planetmysql.org... 213.136.52.29
Connecting to planetmysql.org|213.136.52.29|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: http://www.planetmysql.org/ [following]
--2009-02-26 14:40:10--  http://www.planetmysql.org/
Resolving www.planetmysql.org... 213.136.52.29
Connecting to www.planetmysql.org|213.136.52.29|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://planet.mysql.com/ [following]
--2009-02-26 14:40:10-- …

MySQL has system variables auto_increment_increment and auto_increment_offset for managing auto increment 'sequences' in multi master environment. Using these variables, it is possible to set up a multi master replication, where auto increment sequences in each master node interleave, and no conflicts should happen in the cluster. No matter which master(s) get the INSERTs.

Logically auto increment sequence is a shared resource, which would require distributed locking to deal with. However, auto increment sequence interleaving circumvents the need to lock, it sort of splits the auto increment sequence to several node specific sequences, making it "not a shared resource" anymore.

auto_increment_increment and auto_increment_offset have been implemented as session variables, as opposed to being global. We felt at first a bit uncomfortable with this, as there is obvious risk of misconfiguration resulting in …