Providing educational resources and monetary grants to IT professionals.

Reviewing MONyog

I was contacted by the folks at MONyog and asked if I would review MONyog. Since using MONyog is something I have been wanting to do for a while, I jumped at the chance. Of course, "jumped" is relative; Rohit asked me at the MySQL User Conference back ...

Liveblogging: Automated System Management

Usenix 2008 - Automated System Management, by Æleen Frisch of Exponential Consulting (and numerous books)

What is automation?

generic [perl|shell] scripts with cron,at

Problem: overlap of effort

So folks developed automation systems. General automation tools are around:

cfengine, puppet, cfg2

These are general -- files, directories, etc. Don't need to use chmod and ...

BoF Tonight At Usenix Boston: Pros and Cons of Managed Services

From 7:30 - 8:30 pm tonight, Wed. June 25th, in the Berkeley room of the Sheraton Boston, I will be hosting a Birds of a Feather conversation entitled "Pros and Cons of Managed Services". This will go beyond MySQL and even beyond remote database management, and just deal with ...

SQL Mode ANSI_QUOTES

I was asked today about the ANSI_QUOTES SQL mode.

According to http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html, ANSI_QUOTES mode changes the functionality of double quotes (") to be like the backtick (`). Normally the functionality of double quotes is more like that of single quotes (').

You might use this when you have a table with ...

What to do When Your Data Smiles At You…

I have *never* had this happen to me.

Maybe it's because it's MySQL 6.0.4, maybe it's because it's on Windows, or perhaps I am just up working too late.

I have seen mojibake before, but usually it is unintelligible. But this? After I post this I am backing away slowly ...

The Guru is In: Usenix 2008, Boston

If you are attending Usenix 2008 at the Sheraton Hotel in downtown Boston, you can meet me and ask your burning MySQL questions at my "The Guru is In" session. On Friday, June 27th, 2008 from 2 - 3:30 pm in Constitution B, I will be helping folks out ...

Backups: A Video Presentation By Keith Murphy From the June 2008 Boston MySQL User Group

The Boston MySQL User Group was lucky enough to get Keith Murphy to speak at the June User Group meeting, about backups.

Direct play the video at:
http://technocation.org/node/559/play

Direct download the video (351 MB) at:
http://technocation.org/node/559/download

Links referred to in the presentation:

MyLVMBackup by Lenz Grimmer
http://lenz.homelinux.org/mylvmbackup/

Backups: A Video Presentation By Keith Murphy From the June 2008 Boston MySQL User Group

The Boston MySQL User Group was lucky enough to get Keith Murphy to speak at the June User Group meeting, about backups.

Links referred to in the presentation:

MyLVMBackup by Lenz Grimmer
http://lenz.homelinux.org/mylvmbackup/

InnoDB Hot Backup:
Prices are at:
http://www.innodb.com/hot-backup/order/
and at the time of this writing are:
1-Year License € 390 USD$ 605 per server
Perpetual License € 990 USD$ 1540 per server

BigTable Thoughts

So, Paul's blog post pointing to Todd's blog post got me thinking.

The main point Paul summarized was that duplicating data was a great way to scale, and used Todd's reference to Flickr and how in their partition-by-user scheme, they put a comment in the commenter's shard as well as in ...

Twitter Should Get Back to Basics

Twitter has had many outages recently. On May 17th, 2008 http://blog.twitter.com/2007/05/devils-in-details.html was posted and says:

What went wrong? We checked in code to provide more accurate pagination, to better distribute and optimize our messaging system—basically we just kept tweaking when we should have called it a day. Details are great ...

Pages