Sybase developed MobiLink synchronization technology to enable efficient and scalable data synchronization between many client databases and a single central database (referred to as the consolidated database) or application server. MobiLink is included with SQL Anywhere. Client databases can be UltraLite, or SQL Anywhere databases. Supported consolidated databases include SQL Anywhere, Sybase Adaptive Server Enterprise, Sybase IQ, Microsoft SQL Server, Oracle, MySQL, and IBM DB2 LUW.
The goal of this paper is to give you an understanding of MobiLink server performance and to help you assess its applicability to your data synchronization needs. First, this paper describes the time-consuming steps in MobiLink synchronization.
After a brief description of the testing methodology, this paper presents performance results and analysis for varying the following conditions:
- The number of MobiLink database worker threads and automatic adjustment of the number.
- The retry delay and connection limit when synchronizing with large numbers of client databases.
- The number of client databases synchronizing simultaneously.
- The amount of data transferred in each synchronization.
- The type of network protocol used to connect client databases to the MobiLink server.
We then give recommendations on how to get the best performance with MobiLink synchronization.