So, before hopping on my plane from Seattle to Chicago on
Tuesday, I met with one of the C# compiler developers at
Microsoft (thanks to CJ for arranging!) and this was indeed a
very interesting chat.
You may know that 40% of the MySQL userbase uses the Windows
platform in one form or another. What you may not know if you
don't use Microsoft stuff, is that Microsoft is actually
surprisingly open about many things; you can get inside info
about what they're working on, documentation on nearly
everything, and so on. Basically, one of the few things not open
is their sourcecode ;-). I'll grant you that's a key aspect in
many cases, but still... consider that Google uses open source
and releases some too (see code.google.com) but is otherwise a
very closed company. Just to give a crude comparison how the
world is not just black&white.
Anyway, talking to this developer was just one programmer talking
with another (he used to work …
The second thing on my list coming away from the MySQL Users Conference (first was a question about limits in mysqldump) was to do a writeup on how to use Linux LVM (Logical Volume Manager) to take quick snapshots of your database. Many folks are using this as an alternative to the tools provided with MySQL. It's a good choice for a backup when you need to backup in order to restore the entire database from files.
Taneli has already done a write-up of the steps to complete this process, I want to add in a few things:
LVM not a True Online Backup
LVM doesn't do a true online backup, although it gets close. The actual LVM snapshot command is fast, but to get a good copy of your …
[Read more]I want to thank Jay Pipes for showing me MySQL Forge. It was nice to finally meet him at the MySQL Users Conference. At his request, I posted my backup script to MySQL Forge, which covers a lot of things that are missing from the mysqldump utility, such as properly backing up a slave (with the relative master's log file & position). I've found this script very useful to perform general backups as well as using this to build a new slave.
In MySQL 5.1, a new engine has been provided that assists with the management and use of delimited data found in common flat files. Robin Schumacher takes a quick look at this new engine, along with the features and benefits it provides users of MySQL.
tim bray coined MARS: it stands for ?mysql +
apache + ruby + solaris.? (get the
shirt.)
bill de hóra proposed MADD: ?mysql + apache + django +
debian.?
when forwarding the above to an internal mailing list at mysql, i proposed
MAUDE: ?mysql + apache + ubuntu + django + eclipse.? the logo
would be a picture of bea arthur, of course.
but mårten mickos, ceo of mysql, came up with MARTEN: ?mysql +
apache + ruby + tomcat + eclipse + nagios.?
or would that be åpache?
I went to Microsoft with Arjen the other day. We talked with Eric Lippert about some new features of C# 3.0 and how MySQL might integrate itself more deeply into the Microsoft Development Environment.
More details if anyone makes noise about being interested.
© cjcollier for C.J.'s WordPress of studlyness, 2006. | Permalink | 5 comments
Add to del.icio.us
Search blogs linking this post with …
[Read more]SHOW ENGINE INNODB STATUS shows current InnoDB status, including deadlocks. I was thinking a while back it would be nice to have a log of all deadlocks. Well, I got my answer:
http://dev.mysql.com/doc/refman/5.0/en/innodb-monitor.html
To cause the standard InnoDB Monitor to write to the
standard output of mysqld, use the following SQL
statement:
CREATE TABLE innodb_monitor (a INT) ENGINE=INNODB;
The monitor can be stopped by issuing the following statement:
DROP TABLE innodb_monitor;
The ever cryptic Mr. Love posted a screenshot of a very funny NetworkManager easter egg with a checkbox for “sniff key and login automatically” when configuring the connection to wireless network. I wonder if we should make a GUI in the same spirit for setting up new MySQL replication slaves, with some kind of option “crack password and copy all data automatically”.
[Read more]
Recently I joined a networking group, and I received a
spreadsheet containing their membership rolls. Of course the
first thing I wanted to do was import it into MySQL. Then someone
in the forums asked about the very same thing, so I thought I'd
document this process here.
The first challenge was the fact that the membership list was on
three separate worksheets, and each had a different column
layout. I saved the worksheets into text files and imported them
into Microsoft Access since it has the facility to create tables
using columns derived from text in the first row of the file. I
then imported these tables into a MySQL database.
From there I was able to juxtapose the columns correctly and
merge these tables into one, with the addition of a new column
indicating which worksheet each row originally came from. Then
the fun began. There were two columns, one for current employer
and another with a list of past …