Archive for April, 2008

Auto vertical output lands in MySQL 6.0.4

Have you ever executed a query from the MySQL command line client only to find that the output wrapped and the result is unreadable? In the past you have to run the query again with \G instead of ; or \g to get it to display the output in a vertical mode. My feature in [...]

April 21, 2008 • Posted in: Geek, MySQL • 5 Comments

Replication tutorial notes – part 2

This is a continuation of the MySQL User Conference replication notes part one. The session is opening up talking about failover. The shared disk in this case is drbd. DRBD is a fine product for replicating block devices of single disk systems. It’s made redundant by raid and doesn’t provide as much protection as binary [...]

April 14, 2008 • Posted in: Geek, MySQL • 4 Comments

Replication tutorial notes – part 1

I’m attempting to live blog corrections and notes while sitting in the replication tutorial. Lars is covering available options in MySQL replication. I’m going to attempt to cover some recommended best practices and things that are possible to do in MySQL but should be avoided. Please keep in mind that I’m writing this during the [...]

April 14, 2008 • Posted in: Geek, MySQL • 2 Comments