Clerical Rigor

Category: Databases

  • New pre-release of the maxdb<->mysql bi-directional synchronization manager code

    Let me stress that this code is not complete and has not been tested. This is probably not something you want to get involved in. Move along. Thank you. Bye bye. Now that I am writing to an empty house…. I’ve pushed a new version of the synchronization manager code to my subversion repository. It…

  • 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…

  • YAPC::NA

  • 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…

  • On vacation

    So. I’m on vacation. But I’m thinking a bit about work-related stuff, like Raimi’s MySQL-related blog entries: http://www.lkcc.org/~raimi/nb/archives/cat_9/ In case any of you out there read German. I know enough to figure out that he’s got a link to me in it :) Mark Thomas has created a blog as well. http://blog.theoupneustos.com/?cat=2

  • Planet MaxDB, MaxDB Project

    Well, I set up an aggregator for folks who blog about MaxDB. If you are one of these folks, please email anybody who is aggregated at Planet MaxDB, or join us on #maxdb on irc.freenode.org I am using the monologue code to aggregate the blog feeds, and while I was altering the default template, I…

  • 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