•  Advanced Replication
  • Conventions
•  Advanced Replication
  •  Principles of operation
    • Replication models
    • Sending data from a master to a replica
    • Sending data from a replica to its master
    • Accepting propagated data on the master
    • Push-based synchronization with Sync Pull Notify
    • Configuring and administering synchronization environment
  • Typical applications
•  solidDB® data synchronization architecture
  •  Advanced replication topologies and synchronization models
    • Multitier redundancy model
    • Multi-master synchronization model
  •  solidDB® advanced replication architecture components
    • Master and replica databases
    • Publications, subscriptions, and refreshes
    • Asynchronous replication - messages
    • Synchronous replication - messageless REFRESH
    • Intelligent Transaction
  •  Sync Pull Notify
    • Replica Property Names
    • Introduction to Sync Pull Notify
    • Scheduling REFRESH or Sync Pull Notify
•  Getting started with data synchronization - evaluation setup
  • Overview of setting up advanced replication using the evaluation setup sample
  •  Preparing to use the advanced replication evaluation sample
    • Designing a database table for synchronization
  •  Configuring the servers and creating the publications
    • Configuring master database
    • Configuring the replica database
  • Creating stored procedures for populating master and replica databases
  • Enabling refresh of data and inserting data in replica
  • Synchronizing data using synchronization messages
•  Planning and designing for advanced replication applications
  •  Planning for advanced replication installation
    • Distributing data
    • Tailoring the synchronization process
    • Evaluating performance and scalability
  •  Designing and preparing databases for synchronization
    • Defining master and replica databases
    • Creating the database schema
    • Design the logical database
    • Defining a database table
    • Handling UPDATE triggers
    • Handling concurrency conflict in synchronized tables in replica
  • Determining user access requirements
  • Creating backups for fault tolerance
  •  Designing the application for synchronization
    • Providing a tentative data status on the user interface
    • Providing a user interface to manage synchronization
    • Providing Intelligent Transaction based on application needs
•  Using advanced replication with applications
  •  Using advanced replication data synchronization statements
    • Types of advanced replication statements
  •  Building messages for synchronization
    • Beginning messages
    • Propagating transactions from replica to master
    • Refreshing publication data from master to replica
    • Ending messages
    • Forwarding messages to the master database
    • Requesting a reply message from the master database
    • Configuring advanced replication messages
    • Executing a synchronization process
  • Using synchronous refresh
  •  Implementing security through access rights and roles
    • How advanced replication security works
    • Changing replica access to the master database
    • Setting up access rights
    • Implementing special advanced replication roles
    • Access rights summary
  •  Setting up databases for synchronization
    • Configuring the master database(s)
    • Registering replicas with the master database
  •  Creating publications
    • Creating incremental publications
    • Using the create publication statement
    • Subscribing to publications
  •  Designing and implementing Intelligent Transactions
    • Updating local data
    • Saving the transaction for later propagation
    • Using the advanced replication Parameter Bulletin Board
    • Creating stored procedures
    • Creating a synchronization error log table for an application
  •  Validating Intelligent Transactions
    • Designing complex validation logic
    • Error handling in the application
    • Specifying recovery from fatal errors
•  Updating and maintaining the schema of a distributed system
  •  Managing solidDB® tables and databases
    • Modifying the database schema
    • Changing master or replica database location
    • Unregistering a replica database
    • Creating large replica databases
    • Managing data with synchronization bookmarks
    • Exporting and importing subscriptions
    • Modifying publications and tables in publications
    • Modifying SQL procedures of intelligent transaction
  •  Upgrading the schema of a distributed system
    • Introduction to Maintenance Mode
    • Major features and functionality for upgrading the schema of a distributed system
    • Updating a distributed schema
    • Example: Upgrading a distributed schema
    • Considerations for using maintenance mode
    • Upgrading the server version
•  Administering advanced replication systems
  •  Monitoring solidDB® advanced replication
    • Monitoring the status of synchronization messages
    • Managing synchronization errors
  • Performing backup and recovery
•  Performance monitoring and tuning
  • Monitoring the progress of messages
  •  Tuning for data synchronization
    • Tuning publication definitions
    • Optimizing synchronization history data management
    • Read-only replica
    • Optimizing synchronization messages
•  Bulletin board parameters
  • Advanced replication system parameter categories
  • Parameters on replica
  • Parameters on master
  • Parameters on both master and replica
•  Synchronization events
  • Sequence of events
  • Parameters of synchronization-related events
  • Parameters of message progress events