MySQL Forums
Forum List  »  Synchronization

Announcing Release Of Pervasync 3.0.0 And The Support Of Sync-Based-On-Network-Characteristics
Posted by: Pervasync Software
Date: October 03, 2010 04:19PM

We are pleased to announce the availability of Release 3.0.0 of Pervasync, the leading synchronization software for MySQL and Oracle databases.

Pervasync enables mobile users to work offline and have their offline data automatically synced with a central server when a network connection becomes available. With the support of sync based on network characteristics, administrators can control what data to sync based on which network is being active on end user’s devices. This is another example of Pervasync’s “innovation based on customer needs”.

New feature in Pervasync version 3.0.0 include:

- support of sync based on network characteristics
- support of client groups and group subscriptions
- support of syncing data and files in a single transaction
- support of sync tables with no primary key
- support user interfaces in Chinese

Download and test drive Pervasync today! We encourage you to compare Pervasync with other solutions in terms of easiness of use, robustness, performance and scalability.

Pervasync Software
http://www.pervasync.com


P.S.

Sync Based on Network Characteristics

A mobile computer usually has multiple network interfaces, e.g. cable, Wi-Fi and cellular wireless (mobile data), to connect to the Internet, through which to connect to the central sync server. Some of the network interfaces are slower or more expensive compared with others. On the other hand, of all the subscribed publications for synchronization, some may involved much larger amount of data than others. One example is a folder of media files (photos or videos) or a database table of blobs of data items. When you are on a slow or expensive network, you may want to exclude these publications from synchronization. The “Sync Based on Network Characteristics” feature was implemented for this purpose.

Defining Network Characteristics Using a Matching String

First we need to find a way to identify the network interfaces. Use the utility listnetworks.bat (or listnetworks.sh for Linux) in the bin folder of Pervasync home to list all the attributes of all the network interfaces. Pay attention to the display names, hardware addresses and IP addresses.

C:\pervasync\bin>listnetworks.bat

C:\pervasync\bin>java -classpath ../classes pervasync.util.Util listNetworks

Network Name: lo
Status: Active
Display Name: MS TCP Loopback interface
Hardware Address:
IP Address: 127.0.0.1
IP Address: 0:0:0:0:0:0:0:1
IP Address: fe80:0:0:0:0:0:0:1%1

Network Name: eth0
Status: Active
Display Name: Intel(R) PRO/Wireless 3945ABG Network Connection - McAfee NDIS Intermediate Filter Miniport
Hardware Address: 0018DE157BA9
IP Address: 182.138.0.102
IP Address: fe80:0:0:0:218:deff:fe15:7ba9%4

Network Name: eth1
Status: Non-Active
Display Name: Broadcom NetXtreme 57xx Gigabit Controller - McAfee NDIS Intermediate Filter Miniport
Hardware Address: 0015C54B210F

According to the network attributes, admin comes up with strings that match the display name, hardware address and/or IP address. The matching string defines a specific network card or a type of network. The matching string may contain operators “&&” and “||”. For example, the following matching string will match network eth0 in the above listing:

Intel && Wireless && Network Connection

The following matching string will match network cards that have an IP address that starts with “182.138” or “193.111.2”:

182.138. || 193.111.2

Specifying No-Sync Lists Associated with Sync Schemas and Sync Folders

Pervasync adds two no-sync-list attributes to the sync schema and sync folder definition: NO_INIT_SYNC_NETWORKS and NO_SYNC_NETWORKS. The values of the attributes are the matching strings that identify a specific network card or a type of network. Values can be specified at publication level, group subscription level and client subscription level. Publication level values are inherited and can be overridden by group subscription values, which in turn are inherited and can be overridden by client subscription values.

Pervasync client will match the active network with the no-sync list matching strings before starting a synchronization. If there is match, the sync schema/folder will be excluded from synchronization. For example, if schema “schema1” has a NO_SYNC_NETWORKS value of “182.138. || 193.111.2” and the current active network card has an IP of 193.111.222.111, “schema1” will be excluded from the synchronization.

NOTE: NO_INIT_SYNC_NETWORKS only apply to initial sync of a publication while NO_SYNC_NETWORKS apply to both initial and incremental syncs.
On the Pervasync admin console’s publications and subscriptions UI, sync folders and sync schemas are displayed on same pages. Admins have a complete view of all the available schema and folder publications. Admin could easily make sure related folders and schemas are either included or excluded together for a certain network type. At subscription time, admin again could easily make sure related folders and schema are either included or excluded together in a group or client subscription.

No-sync lists are part of the sync metadata that admin can update at any time. When a sync session detects new metadata changes, it will postpone data and file syncs and will instead sync these metadata changes to device. Device will then use these new metadata in following syncs.

Options: ReplyQuote


Subject
Views
Written By
Posted
Announcing Release Of Pervasync 3.0.0 And The Support Of Sync-Based-On-Network-Characteristics
4504
October 03, 2010 04:19PM


Sorry, you can't reply to this topic. It has been closed.

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.