-
MaxDB Synchronization Manager User Report
United Drugs had occasion to use the Synchronization Manager in production at this year’s convention. Mark Thomas (of United Drugs) and the MaxDB team at MySQL have been getting a use case document together to present the experiences. We had a great deal of help from the SyncMan dev team at SAP Berlin and Chris…
-
Interaction
Hey all. Please comment on this entry. I’m trying to get an idea of who’s listening to what I say. Why do you read this blog? Are you interested in community wireless networks? OpenGL development on Linux? Family? Business Intelligence? Synchronizaton Manager news? Freecycle™ development? Random Perl bits? Something else I’ve forgotten about? I’m finding…
-
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…
-
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…
-
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