Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 8

Displaying posts with tag: sync manager (reset)

MaxDB Synchronization Manager User Report
+0 Vote Up -0Vote Down

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 Hall of Just 4 Dental (who, by the way, also uses the Synchronization Manager in production).

I think the document has come together well and does a good job of …

  [Read more...]
Interaction
+0 Vote Up -0Vote Down

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 myself over-extended and I need to cut back on some of the things I focus on. Please let me know what is important to you so I know how best to re-organize my time, energy and other resources.

© cjcollier for C.J.'s WordPress of studlyness, 2006. …

  [Read more...]
Moved blog, took long weekend
+0 Vote Up -0Vote Down

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 ISP that Moonunit …

  [Read more...]
MySQL Meetup 2006/05/01
+0 Vote Up -0Vote Down

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

  [Read more...]
Useful MaxDB commands
+0 Vote Up -0Vote Down

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 && echo "-----" && 
   loadercli -d SYNCMANA -u TEST,TEST -b ./me && echo "-----" && 
   cat tabledef.txt
dataextract for dataload table T
outstream file 'tabledef.txt'
outstream file 'idontcare'

-----
Loader protocol: '/home/cjcollier/.sdb/loader/log/loader.prt'
Loader packages: '/home/cjcollier/sdb/loader/packages'

User TEST connected …
  [Read more...]
Synchronization Manager: MySQL as replication destination
+0 Vote Up -0Vote Down

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 of replicating changes to other members of the synchronization scenario. Theoretically, any RDBMS that provides an appropriate JDBC interface can participate as a replication destination with little effort on the part …

  [Read more...]
Creating a Synchronization Management Scenario
+0 Vote Up -0Vote Down

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 its yearly trade show, a company needs to process user registration. Because of the high volume of attendees, there must be more than one system through which registration takes place. Therefore, the registration …

  [Read more...]
Customer?s experience with Sync Manager
+0 Vote Up -0Vote Down
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:

  [Read more...]
Showing entries 1 to 8

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.