Databases

Migrating an MyISAM schema to use Referential Integrity

Here are some steps involved. Using the current MySQL defacto engine InnoDB. Of course, Falcon, PBXT and others will enable alternative engines to be used. Convert Table Storage Engine Types

Read more

Restyling a Mediwiki Installation – Lesson 1

Following my implementation of UltimateLAMP , read heaps more at this thread , I undertook to provide customizations of a MediaWiki Installation. Here is the first lesson that you can undertake if you wish to beautify the default MediaWiki Installation.

Read more

UltimateLAMP

This product is no longer available. This was created over 6 years ago and software is too out of date. As I discussed earlier in [A picture can tell a thousand words][1], I outlined briefly what the intention of **UltimateLAMP** was for.

Read more

A picture can tell a thousand words

I’m a keen advocate of MySQL. However, while I use it and promote it within my limited IT circles, I often wonder how MySQL can get better traction and exposure, especially within both the industry sectors and physical locations where I am presently.

Read more

MySQL GUI Products

I’ve started now to actively use more of the MySQL Workbench, MySQL Administrator and MySQL Query Browser and MySQL Migration Toolkit. I am traditionally a very command line person, and it’s important that these skills are never put on the back burner.

Read more

MySQL :: Developer Zone Quick Polls

I don’t get to the MySQL Developer Zone main page often enough. In thinking about what pages I view everyday or regularly, it doesn’t rate as high as Planet MySQL , MySQL Forums or even the MySQL Forge.

Read more

A Post MySQL Conference review. The 4 F’s

Finally back home after some R&R at Yosemite before leaving the US. In conclusion, to sum up my experience of the 4th Annual MySQL Users Conference “Excellent”. Here’s my take. Friends, Functionality & New Features, the Future.

Read more

The Answer is: PBXT

Round 2. Question 2? From the MySQL Quiz Show. (you had to be there)

Read more

MySQL Stored Procedures Performance

Another one of the sessions at the MySQL Users Conference I attended was Tuning MySQL5 SQL and Stored Procedures by Guy Harrison from Quest Software. A global company with 6000+ customers.

Read more

Some photos from the MySQL Users Conference

I didn’t take any photos myself at the MySQL User’s Conference. In reflection, perhaps I should. I did make it into some photos however. A few of them here. <td> <a href="http://jcole.

Read more

Mark Shuttleworth

Thursday’s Keynote speaker at the MySQL Conference was Mark Shuttleworth talking on The Ubuntu Project: Improving Collaboration in the Free Software World. Ubuntu from Canonical Ltd is fastly becoming one of the most popular Linux Distributions, based on Debian.

Read more

My MySQL Conference Presentation

My talk at the MySQL Users Conference went well. MySQL For Oracle Developers was part of two talks, the second was by Mark Leith on <a href"http://www.mysqluc.com/cs/mysqluc2006/view/e_sess/8465" target="_blank">MySQL For Oracle DBA’s.

Read more

Hacking MySQL Source improvements

Further to my earlier post Hacking MySQL Source (in a good way) in which I was having a compilation problem when re-compiling MySQL source (i.e. tt worked the first build, but failed on subsequent re-compiles, even with no changes).

Read more

Contributing to the MySQL Community

Everybody can contribute to the MySQL Open Source Community. Here are some ideas: You can start with completely a MySQL Conference Survey form (those forms that we are all avoiding). You can download, evaluate and test newer versions of MySQL Products.

Read more