What customers say about us.
Searching for a True Master-Master MySQL Synchronization Solution
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.
One 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!
Enabling Offline Access to Web App for Mobile Marketing Managers
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: Kingscheme Information Technology Co., Ltd., Chengdu, Sichuan, China
- 差异同步。从表面上看，数据同步只是把数据从一个地方复制到另一个地方。但是，如果每有数据更新就要你复制整个数据集，有限的服务器处理能力和带宽将只能支持很少的分布式数据。 Pervasync内置了更新捕获机制，这样保持数据的同步只需要传送更新的数据。因此，大数据的大规模同步才成为可能。
- 支持数据子集同步。分布式数据库往往不能拥有中央数据库中所有的数据。 Pervasync允许用户同步中央数据库的一个数据子集到一个分布式数据库，每个分布式数据库可有一个不同子集。除了Pervasync，很少有同步框架可以支持大规模的数据库的子集同步。
- 保证数据的完整性。当数据从互联网的一端传送到另一端，有时发送者“完成” 发送，但接收者并没接收到。或者发送者“发现”发送失败而重发，但接收方实际已收到数据。在其他的同步解决方案中这些情况可能会导致数据重复或数据丢失的问题；而Pervasync保证了数据重复和数据丢失的情况不会发生。
- 支持网络断线重接。在一个大数据系统，一个数据子集的差异同步仍可能涉及相当多的数据传输。网络断线发生后， Pervasync能够施行重接，从而避免重复发送断线前发送的数据。这样可节省大量的网络带宽，同时使弱网络环境下同步成为可能。
- 数据更新冲突的检测和解决。在分布式系统中，同一个数据条可能在多个地方被同时更新。我们不能随意让其中一个更新覆盖其它更新。 Pervasync有内置的更新冲突检测和解决机制来处理这个问题。
Replacing Custom Sync Component for Hundreds of Clients In Less Than One Week
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.
Synchronizing Global Branch Office Databases with a Central Database
By: Joop Simons
Digital Data Warehouse is a small company in Breda, The Netherlands.
Five colleagues and a house cat...
Our website is just 1 page...but it is under construction. We have been working very hard to support our customers and one of our key products is called DanaVesta.
This product was developed for the design, production and trading of shoes. Our customers are large shoe companies, each of which has many sales representatives, working globally, different time zones. Our customer base is growing rapidly and you can find our clients throughout Europe, China and soon Canada. With a growing customer base we have also experienced an increased amount of issues in maintaining the consistency of the different underlying databases.
We have had some really in-depth discussions going on which resulted in a synchronization model-design....(on paper ). We did put a lot of effort in finding a proper tool. And I mean a lot of time. One of our colleagues found Pervasync, started to read, started a test, contacted Pervasync and we were really surprised by the performance. It covered 80% of our needs. It seems that our troubles are vanishing into thin air.
Synchronizing SaaS Based Application's Web DB with Local DB in Hospitals
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.”
Pervasync is a cost effective solution
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.