OSScamp returns to Chandigarh within 6 months for a splendid show on April 10th, 2010, at Chitkara Educational Trust, Chandigarh. Organized by the will and initiative of two 14 year old school kids, OSScamp Chandigarh has also received a good response from the tech community in Chandigarh and promises to be a grand FOSS event in the city. OSScamps are India's premier FOSS Unconference - an informal/casual event where the emphasis is put on participative and collaborative knowledge sharing over the traditional one-way sharing model. Tweetups are meetups of local twitter users, who come together to network with each other and discuss the world around them. The event schedule is as follows: …

Unnoticed by many, DRBD ports have been spreading for some time on non-Linux platforms. AVS for (Open-)Solaris has been around for a while, and HAST for FreeBSD joined the club last autumn.

And now, Windows. We have received a generous grant (from a source not wishing to have their identity disclosed in public) to fund a port to the Windows Server platform. Development work on this port has commenced back in mid-January.

It’s pretty exciting technology. Rather than tying in with the standard Windows block layer infrastructure, DRBD-W (that’s just a working title, we’ll eventually come up with a spiffier marketing name) is at the core of a brand new storage architecture. Termed Hyper-S, said architecture is actually a highly scalable, extremely light weight, distributed storage …

Here are the minutes of the meeting. They can also be found online
with the irc logs here.

Beta2 status

ttx reminded everyone that Beta2 Freeze was around the corner.

There are a few beta2-targeted bugs:

• Bug 292971 (mathiaz). It will probably require a BetaFreezeException.

• Bug 493593 (zul)

• Bug 408402 (zul)

• Bug 532733 (kirkland)

Most of the Work Items targeted for beta2 are not …

Well, now I have to wade into the NoSQL discussions that have been going on recently, because we’ve been getting some questions on the differences between InfiniDB and the various NoSQL offerings. I’ve posted a FAQ addition to our site that you can read to get a handle on the distinctions between InfiniDB and NoSQL products. It’s a quick read, I promise.

One thing to keep in mind is that InfiniDB is architected in a very modular fashion, and we are basically a MapReduRead More...

Wow. Now’s not a good day to announce anything true on your blog. I see a bunch of stuff that probably is true – but who’s banking on that? Is there really a new version of HeidiSQL? Is Arjen really moving to California to do MySQL work? Is Tokutek really purchasing Oracle? Gee, I’m not sure. If I had any thoughts left in my head, I’d make a funny myself, but my head’s pretty empty.

Using ROLLBACK with MyISAM is useless. A ROLLBACK command is used to undo any DML that occurs during a transaction (i.e. START TRANSACTION and COMMIT). The MySQL default storage engine MyISAM does not support transactions.

It is easy with the SHOW GLOBAL STATUS command to see if your application code uses ROLLBACK. By performing two samples you can look at the delta over time. The statpack utility is one product that provides a human friendly display of this delta. As seen below, the use of ROLLBACK in combination with the read/write ratio and the my.cnf –skip-innodb indicate unnecessary database work.

====================================================================================================
                    Variable    Delta/Percentage         Per Second              Total …

For situations where you need an overview on a larger set of databases, now you have a detailed view in the new "Databases" tab, left besides the "Variables", "Status" etc. The new tab displays database names, number of items in them, their collation, and the summed size of all items in them. Together with a colored bar and sorting options this should somehow be helpful in HeidiSQL's mission to make a developer's life easier:

Fig. 1 Java access to MySQL Cluster

This is a follow up to the earlier post Using ClusterJ (part of MySQL Cluster Connector for Java) – a tutorial but covers the ClusterJPA interface rather than ClusterJ.

JPA is the Java standard for persistence and different vendors can implement their own implementation of this API and they can (and do) add proprietary extensions. Three of the most common implementations are OpenJPA, Hibernate and Toplink. JPA can be used within server containers or outside of them (i.e. with either J2EE or J2SE).

Typically a JPA implementation would access the database (for example, MySQL Cluster) using JDBC. JDBC gives a great deal of flexibility to the …

In vBulletin Board System there is session table contains online user information and tracking, in which forum now, what the current URL now, So it is have huge concurrent update statement, By default this table is MEMORY engine because its data not important in case MySQL restart.

I notice early loaded in MySQL and server, So I do full tuning for the server then analyze slow query using

1. ZeroMQ -- bold claim of "Fastest. Messaging. Ever." LGPL, C++ with bindings for many languages, past version 2 already. (via edd on Twitter)
2. Prediction Market News (David Pennock) -- HSX is going to be a real marketplace with real $. The real HSX will of course say goodbye to the virtual specialist and the opening weekend adjust, two facets of the game that make it fun to play, but that create significant amounts of (virtual) wealth out of thin air. The Cantor Gaming group is engaged in other interesting initiatives. They are taking over a sportsbook in Las Vegas and turning it into more of a derivatives exchange with live in-game betting, a step toward my dream of a geek-friendly casino. …