Databases
Data Modelling
I’m a data modeller. I specialise in this, and for a number of years on large projects I’ve been able to focus on this single task within the System Development Life Cycle of software development for several months at a time.
Read moreContributing to JMeter
As part of my using JMeter for the purpose of testing a new Transactional storage engine PBXT for MySQL, I’ve been investigating the best approach for handling transactions. Read more about earlier decisions at my earlier post Testing a new MySQL Transactional Storage Engine .
Read moreEmulating Oracle Output Functionality
Updated 28-mar-2006 There really is no way to do a comparision by numbers in features and functionality when it comes to Oracle and MySQL in the area of Stored Procedures and Triggers.
Read moreJust how many articles are at Planet MySQL?
I was trying to find an old article at Planet MySQL . One about a MySQL UDF to write to /var/log/messages. No luck. Anyway, there is no search option on the site, and the latest addition of 10 entries per page makes it difficult to review pages.
Read moreMySQL Forge
I was reading Zack Urlocker’s MySQL Workbench Beta article and was keen to look at the Extensible architecture. Not much detail yet in the Figure Stylesheets, Scripts and Plugins, which will be good when it’s there, however it lead me to another secret.
Read moreAnother dissappointing MySQL article
Another slightly disappointing article regarding MySQL, this one from a printed magazine. Below are my comments to the editor of Linux Format. The Dear Editor is an email link should others wish to make any comments.
Read moreAtomicity, Consistency, Isolation, and Durability = ACID
ACID is the key transaction processing feature for a RDBMS. Without this, the integrity of the database cannot be guaranteed. In Summary. Atomicity is an all-or-none proposition. Consistency guarantees that a transaction never leaves your database in a half-finished state.
Read moreTesting a new MySQL Transactional Storage Engine
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.
Read moreLatest MySQL Versions under VMWare
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.
Read moreOracle Comments
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).
Read moreA call to arms!
With Oracle Corporation purchasing InnoBase, the company providing the InnoDB Storage Engine, and now reliable rumors of the acquisition of SleepyCat, the BDB Storage Engine, both key transactional storage engines for MySQL are effectively owned by a competitor.
Read moreInnoDB, BDB. What is Big Red Doing!
Last year saw a record number of acquisitions by Oracle Corporation. Of note was in October 2005 InnoBase (Read Press Release) which had a direct relationship with MySQL providing the InnoDB Storage Engine.
Read moreAuditing an existing MySQL Installation
Yesterday I ran into an old collegue that now runs quite a successful computer store chain and highly successful web store here in Australia. Long story short he was having some MySQL problems, so I offered to pass my eye over it.
Read more