Clerical Rigor

Category: work

  • Moved blog, took long weekend

    For those of you who want to hear me read this instead of having to do so yourself (no hyperlinks), click here for .ogg and here for .mp3. I migrated the blogs’ database and code from moonunit to avenger, both of which run Debian Sarge. Y’all should now notice a vast improvement in throughput. The…

  • Trip to Microsoft on 2006/05/02

    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.

  • MySQL Meetup 2006/05/01

    Hannah, Scarlet and I attended the Seattle Meetup, since we heard Arjen was planning on being in town. We went to the normal location, but the owner told me they were closed due to their entire staff being involved in the civil rights march. We arrived to a table full of the regulars. Breadsticks, pizza,…

  • A quick over-view of RDBMSs’ general place in the world, and ours in particular

    [1][2][3] RDBMSs (or for clarity, Databases) are a basic element of any computer-based appliance in the same way as are an Operating System, Web Server and software development platform. As is common for developers of Open Source software, I am quite familiar with Linux as the Operating System, Apache as the Web Server, MaxDB and…

  • MySQL AB :: The MaxDB series on PlanetMySQL.

    We’ve published the first few episodes of the weekly MaxDB series in .pdf form. Please take a look and let us know what you think! MySQL AB :: The MaxDB series on PlanetMySQL.

  • Useful MaxDB commands

    To find a list of tables in a schema: $ sqlcli -u TEST,TEST -d SYNCMANA “SELECT * FROM TABLES WHERE SCHEMANAME = ‘TEST'” To find a list of triggers on a table: $ sqlcli -u DBSERVICE,SECRET -d SYNCMANA “SELECT * FROM TRIGGERS WHERE TABLENAME = ‘T'” To describe a table’s structure: $ cat me &&…

  • Synchronization Manager: MySQL as replication destination

    Earlier this week, I wrote about the Synchronization Manager and gave a step-by-step tutorial on getting an initial scenario implemented. In this article, I’ll expand on the previous tutorial by introducing the concept of uni-directional synchronization. Uni-directional participants act as destinations for replicated data. These participants are sometimes called “slaves,” because they are not capable…

  • Creating a Synchronization Management Scenario

    This is a follow-up to my earlier article on the MaxDB Synchronization Manager. In the months since my prior article, the Synchronization Manager has proved itself production ready and capable of replicating real-world databases in demanding scenarios. Take the following as theoretical and emperical examples of such scenarios (not necessarily in that order): i) For…

  • Customer’s experience with Sync Manager

    14:34 < MThomas> Time to install and configure Sync Manager in development environment: 4 days, one of which was 15 hours long. Time to install and configure in production: 30 minutes. I’ve written a bit of documentation that might help you get things running in the same way: http://wiki.colliertech.org/index.php/MaxDB:Installation http://dev.mysql.com/tech-resources/articles/syncman/part1.html Create a Synchronization Scenario

  • Rearranging blogs: EWN, Mono, poli-discuss, work

    I’m re-organizing my various blogs to this one. WordPress can syndicate categories. So I’m adding a category for each of the blogs I keep. Except for LiveJournal. I’ve got lots of posts there, and there’s no way (as far as I know) to copy all of them to this one. Plus, I like Brad and…