As part of my A call to arms! post about a month ago, I’ve had a number of unofficial comments of support. In addition, I’ve also been approached to assist in the completion of a MySQL Transactional support engine. More information on the PBXT engine will be forthcoming soon by it’s creator.

Anyway, I’ve taken on the responsiblity of assisting in testing this new storage engine. This will also give me the excuse of being able to pursue some other ideas about the performance of differing storage engines for differing tables in business circumstances, such as MyIsam verses InnoDB in a highly OLTP environment. Part of testing will be ensure ACID conformance in varying situations and multi-concurrency use. Of course the ability to also do performance and load testing would be a obvious extension.

Considering how I’m going to benchmark is an interesting …

Apache JMeter is a 100% pure Java desktop application designed to load test functional behavior and measure performance. It was originally designed for testing Web Applications but has since expanded to other test functions. Specifically it provides complete support for database testing via JDBC.

Some References: Homepage http://jakarta.apache.org/jmeter/  ·  Wiki Page  ·  User Manual

Initial Installation Steps

$ su -
$ cd /opt
$ wget http://apache.planetmirror.com.au/dist/jakarta/jmeter/binaries/jakarta-jmeter-2.1.1.tgz
$ wget …

I made reference previously to Testing/Trialing new MySQL Releases using VMWare.

Well, I’ve just about completed my own Image for the lastest MySQL 5.0 (given I’m now running MySQL 5.1). I’m interested in sharing my experiences, and even providing some images for users if there is any demand out there.

What I’ve decided on is to use the VMWare supplied Browser Appliance which is Ubuntu 5.10. The great thing is the image autoboots into graphical mode, auto logins and loads a browser. My goal now is to get a suitable startup page describing the MySQL environment, links, manual etc.

The only requirements to run would be the …

Have a look at InnoDB. Well, ok your lazy, so here’s a screen print below.
Plastered thoughout the top section is the word MySQL. It’s in the core banner blurb, there’s a logo, and even links to the MySQL Documentation. And right in the middle of all this is “Innobase OY is an Oracle Company”, with the standard Oracle Logo.

So my question would be, is this a good thing or a bad thing from a MySQL advertising perspective?
Does it help or hinder MySQL?
Does it show Oracle as being in partnership with MySQL? Is this good for MySQL to increase it’s exposure into the Oracle world?
Does inclusion of InnoDB now within Oracle traffic and links improve exposure to MySQL within search engines?

Frankly, I’m a little surprised that Oracle Legal hasn’t got onto this, I’m sure somewhere there would …

Some recent posts regarding Oracle (See Smart moves by MySQL AB and Larry Ellison still doesn’t understand open source) leads me to put in my 2 cents worth.

My background I’m sure like a lot of experienced MySQL people is in Oracle, and indeed in Ingres before that (starting in 1988). I have also worked for a number of years at Oracle Corporation. Ironically I started as their resident Ingres Specialist, in an international research project of DMS (Design & Migration Services) of re-engineering Ingres applications into an Oracle Designer Repository some 10 years ago in 1996. I of course moved into a number of other Oracle roles for clients following that. I still retain some …

AUSTRALIA PRESS: Telstra To Charge More For Fixed Lines

great - I get to pay more for a service I DON’T WANT! I just want internet, not a phone line (which I aparrently have to have to get ADSL).

Oracle bought 2 companies which develop 2 open source storage engines that MySQL uses. Those storage engines are both transactional.

There’s the possibility Oracle does the stupid (from a PR perspective) move of making those databases proprietary. But it’s OPEN SOURCE right now. Which means that it’ll branch.

Worst case scenario? The developing stops here, and InnoDB and BDB never get any more functional than they currently are.

The “bad” scenario? MySQL is a company. With hired staff. They pay the hired staff to get familiar with the source code for those engines and continue to develop them. Hence the branch.

The likely scenario? 1) Oracle tries to have a pluggable storage engine architecture like MySQL. Oracle Express or Lite or whatever would be free with those engines, pay with the original. 2) Oracle tries to go on the good partnership of “we support MySQL by developing their architecture, we’re …

Folks, I‘m going to be involved in (giving the first, available for questions on the second) webcasts on Java and MySQL related topics, so if you read this blog because you‘re interested in those topics, you should check them out (they‘re free).

The first, For Java Developers Only: Developing and Deploying JDBC-based Applications with MySQL is on March 2nd. I‘ll be covering some common pitfalls, new features available with MySQL-5.0 (including XA and stored procedures), and a look at what‘s coming in JDBC-4.0.

The second on March 9th, Cost-Effective Enterprise Content Management Using Alfresco and MySQL is a webcast from Alfresco‘s founder and CTO, John Newton. Alfreso is an open source, enterprise content management system that …

Folks, I'm going to be involved in (giving the first, available for questions on the second) webcasts on Java and MySQL related topics, so if you read this blog because you're interested in those topics, you should check them out (they're free).

The first, For Java Developers Only: Developing and Deploying JDBC-based Applications with MySQL is on March 2nd. I'll be covering some common pitfalls, new features available with MySQL-5.0 (including XA and stored procedures), and a look at what's coming in JDBC-4.0.

The second on March 9th, Cost-Effective Enterprise Content Management Using Alfresco and MySQL is a webcast from Alfresco's founder and CTO, John Newton. Alfreso is an open source, enterprise content management system that happens to …

Folks, I‘m going to be involved in (giving the first, available for questions on the second) webcasts on Java and MySQL related topics, so if you read this blog because you‘re interested in those topics, you should check them out (they‘re free).

The first, For Java Developers Only: Developing and Deploying JDBC-based Applications with MySQL is on March 2nd. I‘ll be covering some common pitfalls, new features available with MySQL-5.0 (including XA and stored procedures), and a look at what‘s coming in JDBC-4.0.

The second on March 9th, Cost-Effective Enterprise Content Management Using Alfresco and MySQL is a webcast from Alfresco‘s founder and CTO, John Newton. Alfreso is an open source, enterprise content management system that …