This morning I held a short presentation to share my vision on
the project. The handouts for this presentation with the title
"SQLbusRT: A first glance" are available at our SourceForge
project website.
You can download these handouts directly by clicking this link:
SQLbusRT: A first glance
Blog: http://sqlbusrt.blogspot.com/
Project website: http://sqlbusrt.sourceforge.net/
The Apache Friends team is proud to announce XAMPP 1.5.3 for
Linux and Windows. The new version of XAMPP includes fresh, green
and up-to-date versions of: PHP 5.1.4, MySQL 5.0.21, Apache
2.2.2, phpMyAdmin 2.8.1 and OpenSSL 0.9.8b.
In case of Linux we also upgraded ProFTPD to the recent 1.3.0 and
in case of Windows we included the new version of FileZilla FTP
Server 0.9.16c.
Download XAMPP 1.5.3 here
Couple of weeks ago when testing the Disk based storage in MySQL cluster 5.1.6 I ran into some annoying unstabilities
I've updated to 5.1.9 in the meanwhile.. my cluster has been up for 5 days now it seems like the problem has been fixed in the more recent versions.
I`ll continue runnnig tests to see if it stays stable :)
"Ovid":http://users.easystreet.com/ovid/ wrote a short article "giving a glimpse of Perl 6":http://www.oreillynet.com/onlamp/blog/2006/05/lamp_linuxsapachesmysqlphpytho.html?CMP=OTC-6YE827253101&ATT=lamp+Linux+s+Apache+s+MySQL+P+hp+ython+erl+56
If that was too dry and technical for you, then instead go read about how he "he caught two idiots using his credit card":http://www.askbjoernhansen.com/archives/2005/03/25/catching_the_cr.html last year.
"Ovid":http://users.easystreet.com/ovid/ wrote a short article "giving a glimpse of Perl 6":http://www.oreillynet.com/onlamp/blog/2006/05/lamp_linuxsapachesmysqlphpytho.html?CMP=OTC-6YE827253101&ATT=lamp+Linux+s+Apache+s+MySQL+P+hp+ython+erl+56
If that was too dry and technical for you, then instead go read about how he "he caught two idiots using his credit card":http://www.askbjoernhansen.com/archives/2005/03/25/catching_the_cr.html last year.
I've always been interested in refactoring code, but one thing
that is always a little harder is refactoring databases... there
isn't enough documentation available on it.
I was quite excited to see a new book published this month. I've started
reading it through my Safari subscription.
I've inherited a fair bit of bad code in the past. Sometimes you
can see that things don't work, but you don't know what to fix.
The refactoring process is all about 'smells'. A smell is a
particular design pattern that might have been a bad
choice.
I'm particularly fond of this 'smells' term (commonly appearing
refactoring books). It makes me think of food; if it smells, it's
probably bad, or rotting. That's not *always* true …
I'll be coming to the MySQL User Conference next month, then hanging
around a little while longer for a support group meet.
After booking various things my bank called me about possible
fraudulent charges on my credit card. Apparently I wasn't
supposed to go?
I sat the MySQL Core Exam in November, and I'm happy to report
that I passed!
Last month came time to sit the pro exam, and not feeling as
confident after what was quite a tough core sitting, I thought it
was time for some study. While some things might appear obvious
to some, I thought I'd share the notes I took when I was reading
it:
The current version of mysqldump can export a database to a
tabbed output. This is nice, but it seems it can only do one
database at a time.
I wrote a quick script to attempt to merge multiple tab dumps.
It's incomplete -- and the chmod 777 in it is definitely
evil.
Tab dumping is faster for MySQL to import than an SQL dump, and
it produces a smaller file. With a bit of work, this is the way
to get your exports as small as possible. This helps if you had
to rebuild a slave on another network, and/or you pay too much
for bandwidth!
Your thoughts appreciated.
See: http://tocker.id.au/files/mysqltabdump.phps
It doesn't look like I'll be making it to the MySQL User
Conference (argh!). I've constructed a list of sessions I'll be
missing out on. Perhaps some of the others
in Brisbane will take notes for our user group
Monday:
Peter Zaitsev is often online at the same time as me. I like
to ask him all my idiot InnoDB questions -- he know's his
stuff.
Tuesday: