-
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