WHAT THE INDUSTRY SAYS ABOUT PERVASYNC DATABASE SYNCHRONIZATION SOLUTIONS
By: Nathan McMinn, Software Engineer
Ansell Limited, Red Bank, NJ, United States
Ansell Limited is a global leader in healthcare barrier protective solutions, with operations in the Americas, Europe and Asia. Ansell relies on a custom client application based on the Eclipse RCP to conduct customer surveys. This survey information is used to generate product recommendations and build customized presentations for current and potential customers. A central requirement for this application is data synchronization from the client applications in the field back to a central server for analysis and reporting. Synchronization from the server to the client is also required, ensuring that representatives in the field have the most up-to-date product and customer information. With hundreds of instances of this client application in the field, a fast, robust and scalable synchronization solution was needed. After experiences with a custom-written synchronization tool, Ansell development went looking for a suitable commercial replacement.
Pervasync proved to be an excellent fit for the application. The Java API simplified integration with the RCP-based client, while the sync server component was easily deployed alongside existing J2EE web applications. Pervasync's support for MySQL permitted a new sync solution to be implemented quickly without switching out the underlying database, which would have been required with most of the other vendor-specific tools. Switching to Pervasync was relatively painless, and resulted in a synchronization process that is several times faster than the previous custom solution. We have found Pervasync to be an excellent product that solved a very difficult problem faced by our development team. Pervasync also offered new features that have proven to be very useful. Specifically, the server sync console has become invaluable for identifying client sync issues in the field and tracking user synchronization trends. With the assistance of Pervasync support, the Ansell development team was able to replace the custom sync component in less than a week, solving a major business challenge in a fast, cost-effective manner.
P.S. The following link is Nathan's blog entry regarding Pervasync where he provided additional information about his experiences with synchronization in general, and Pervasync in particular:
Nathan's blog entry: Pervasync (It is duplicated here for your convenience.)
By: ZEDNÍČEK a.s.
ZEDNÍČEK is a production and trading company, operating on European market with cooled foodstuffs under its own brands and brands of European producers. As the largest cooled foodstuff supplier and manufacturer in Czech Republic, our product assortment consists of more than 500 different items which we deliver to 1000 stores in the Czech Republic and more than 900 stores in Slovakia. ZEDNÍČEK Company has become a significant Czech producer of meat products. The IT Manager, Petr Svačina, says that “We are using own web application for orders by our marketing managers outside of the office, so we sometimes need offline access to the server database, if managers have no internet access all the time they need to." Compared to other sync solutions or a homegrown solution, "Pervasync is cheaper, web based, easy to install, easy to use, and working well :-) " Petr Svačina says.
By: ComplyMD, Birmingham, AL, United States
ComplyMD is progressive facilitator of encounter documentation for the three key participants in surgical care: Physicians, Patients and Facilities. ComplyMD provides workflows to optimize the physician’s mind-share, provide personalized intelligence to efficiently document procedures in real-time compliance and facilitate accurate diagnosis for fair reimbursement. ComplyMD Surgeon Notes™ shifts the encounter documentation process from unstructured dictation and into an enhanced, rich-data creation.
Based in Birmingham Alabama, partnered with world-class medical providers and facilities, ComplyMD is radically shortening the time for surgical documentation to be closed as the invasive procedures are closed. The secret to ComplyMD is not really a secret but rather a Software-as-a-Service, SaaS, solution accessed from a secured web browser in the Operating Rooms with a hosted service in St. Louis and, in some cases, located on-site at the hospital.
Currently, ComplyMD has three medical facilities performing over 1,000 surgical cases a month in production through the solution and ComplyMD has begun a regional sales campaign to secure dozens more facilities in 2010. The compelling business service that ComplyMD offers is that physicians, regardless of which surgical center or hospital they operate, and their office team can see the workflow of all of their practice’s surgical cases, whereas the hospitals who license ComplyMD can manage their surgical cases. Effectively, a matrix relationship of physicians and facilities can access, edit, and move operative documentation efficiently through their respective workflows while better assuring compliance and better capturing diagnosis and procedures to claim full reimbursement quickly.
The architectural challenge that ComplyMD encountered in 2009 was the reality that some hospitals do not have the internet bandwidth to support the data transmission load expected of a patient-care application delivered as a SaaS. A reasonable approach was for the facilities that had these data transmission bottlenecks that ComplyMD could place a local server on their network. This would have our latest software and the full production database for the physicians who have privileges at that facility. The unknown, was how to synchronize the data from the hospital to the www server and then scale this approach to two facilities, then to ten facilities and onto however many facilities we would ultimately distribute a local server.
Our engineering team felt strong enough to build a streamline synchronization solution that focused on the core entities that needed to be shared between hospitals and physician offices. With the ComplyMD solution built in Ruby on Rails, RoR, persisting data in MySQL, the solution felt tantalizing simple. It wasn’t. After missing important client deliverables and key non-functional requirements on uptime and data transmission, the Engineering Team looked into data synchronization solutions.
To our joy and satisfaction we found Pervasync. Here was a robust solution, built for MySQL that quickly meet our implementation and configuration expectations of being seamless. Our teams piloted the synchronization of two hospitals and our globally hosted solution and within the month had the solution managing production data for dozens of surgical cases. The stability provided by Pervasync for the physicians to see the patient surgical information from the convenience of the hospital, their office or even their iPhone took a mission critical issue off of ComplyMD’s Product Team’s Focus and allowed us to begin the design of our next generation product for release in 2010.
The Chief Operations Officer, Jim Orrison, had been an Oracle specialist and consultant. His experience included synchronizing production-grade data stores across an enterprise; he knew that with the right specialist, enough patience and enough money, synchronization could be successful. With Pervasync, our RoR development team, with Pervasync support, within a month and at a low operational cost solved this problem. Jim says that “Custom application development is risky and expensive when done right. In healthcare solutions, data management not only has to be done right, but has to be pristine. With Pervasync, we have exceeded our non-functional requirements of seamless data access through facilities and significantly reduced the risks of any data loss. I am very pleased with the product, the service and results that Pervasync's team has built. I sleep much better at night knowing Pervasync is facilitating our database synchronization efforts.”
By: Christopher Greimes, CEO
Allied Titanium, Inc. is a cutting edge manufacturer of titanium products. At the center of our operation are MySQL databases that house the images, CAD files and other data for the 13,000+ products we produce.
Connected to the Internet is a high speed MySQL
server that allows our sales reps, managers, factories and customers to
both add and retrieve data via web browsers. Obviously, the data on
this server is in a continuous state of flux.
For our home office, another MySQL server is
connected to a local Intranet where the hi-resolution images, CAD files
and other data created during product development are entered. The data
on this server is accessed via both web browsers and Microsoft Access.
The data is only in a state of flux during normal local office hours.
Some of our customers around the globe also operate Microsoft SQL servers and MySQL servers that connect via the internet to our 24/7 high speed server in order to continuously keep their data up to date.
As you can imagine, traditional database replication
will not work in our business model because we are spread around the
globe and there isn't a point in time where the data
alterations can be halted. In effect, all of the servers in our
architecture are masters because new data is being added and existing
data is being updated at multiple locations simultaneously, so this
precludes database replication as well.
Until we found Pervasync, synchronizing all of these servers was a phenomenal task fraught with both error and fear. We talked to provider after provider and all said the same thing, "Master - Master synchronization isn't feasible or practical." They recommended that we change our entire business structure to enable either the implementation of database replication or switch to using a single server.
Faced with a horrendous synchronization task every
morning and night, we took a hard look at toning down our aggressive
business model, but held our ground for three reasons:
First, speed. Trying to build a single database server at one location that can serve up to the entire world is expensive and no matter how fast or big it is, the data still has to flow around the globe, which means access to the system will be slow for some users, no matter what you do.
The second reason is redundancy, knowing that the
data our entire company relies upon is duplicated securely at multiple
locations with the sync frequency controlled by us allows me to sleep
peacefully at night.
The final reason is customer service. Many of our
customers already have database servers and for us to tell them that in
order to do business with us they must create and maintain a new
replicated MySQL database on their site (which they can't even enter data into) is totally unacceptable.
Many of the other synchronization software providers claim that their software will do Master - Master synchronization. Upon digging deeper (In some cases buying their software!), their idea of master - master synchronization was to compare rows and rows of changed data manually, choosing the data from the server that we wanted to sync to the other server in table-like forms.
of the areas that is unusual in our system, compared to many others, is
that we are storing hi-resolution images in our MySQL database that
must be synced across the globe as well. This means that any
synchronization software that relies on reading the data storage size
in every column in order to determine what has changed will be
incredibly slow, something we found out the hard way.
As far as we know at this time, Pervasync is the only true Master - Master synchronization system available for MySQL. Once set up and initially synced, it is blazingly fast. To see Pervasync in action, visit www.alliedtitanium.com.
P.S. Pervasync's customer service has been absolutely stellar!
By: Joop Simons
Digital Data Warehouse is a small company in Breda, The Netherlands.
By: Kingscheme Information Technology Co., Ltd., Chengdu, Sichuan, China
By: Android App Developer
I need to sync between androids and central Postgres servers due to the requirements to support “offline availability” and “team work”. My app is a kind of inspection tool, basically targeting wind turbine operating and maintenance industry. I already had my sync procedure based on server timestamp, but it’s too time consuming to solve conflict cases whenever it happens and also the problem happens too frequently. That’s the reason to look for a sync solution to replace my custom sync logic.
I have looked at Pervasync and other products, for Postgres-SQLite solution. Some product looks fancy first because it’s open-source, seems to have much more users and forum posts, but it just is out of budget and it would be better to solve the problem myself. Pervasync is the only possible option that I can afford. It is a cost effective solution. I’m always pressed for time.
© 2008-2016 Pervasync, LLC. All rights reserved.