Synch Manager, part V article outline

Hey all,

Here is the rough outline for the upcoming Synchronization Manager article. I expect to have it fleshed out and ready for publication by the end of next week or shortly thereafter. Please give feedback if you see anything missing or are not interested in particular topics.

Thanks!

• Concepts
  
  
  
  • Replication Units
    
    
    
    • Master Unit
    
    
    • Client Unit
    
    
    • Activating Replication Units
    
    
    
    
  • Message Server, msgserver
  
  
  • Synchronization Service, syncservice
  
  
  • Conflicts
  
  
  • Table name mapping
  
  
  • Master database
  
  
  • Client databases
  
  
  • Shadow Tables
  
  
  
  
  



• Example settings
  
  
  
  • Usernames
  
  
  • Passwords
  
  
  • Table names
  
  
  • Creating users on MySQL database for synchronization
  
  
  
  



• Creating Example Tables
  
  
  
  • DBMASTER
  
  
  • DBCLIENT
  
  
  • DBCL2
    
    
    
    • Note about why we went with DBCL2, and not DBCLIENT2
    
    
    
    
  • synchMan, the MySQL write-only table
  
  
  
  • Scripts
  
  
  • SQL Schemas
  
  
  
  



• Future Plans
  
  
  
  • Triggers for shadow tables on MySQL with innodb
  
  
  
  



• Misc
  
  
  
  • Re-creating indexes of broken database
  
  
  • The createdb.maxdb.pl script
  
  
  • dbvis, the java database visualizer