Case Study - Platform Stability and Data Locality
Bioclinica achieves platform stability, data-locality and lowers TCO with CloudBasic database replication tools
MDDX (acquired by Bioclinica) uses a sophisticated cloud deployment model to employ fully accessible Geo-Read-Replicas for reporting; advanced database replication technology for improved system performance; and a cross-region Disaster Recovery solution. DevOps tools help automate DLM.
EXECUTIVE SUMMARY: MDDX (acquired by Bioclinica), a medical image management company, developed an advanced cloud-based platform that offers a 20-year image repository for clinical trials, providing numerous legal and technological benefits to the medical research industry. With zero tolerance for downtime, the company relied on CloudBasic’s robust RDS SQL Server replication technology to ensure uninterrupted platform availability in the cloud. It also used the fully accessible read-replicas, an integral part of CloudBasic’s solution (and unavailable in the standard AWS RDS Multi-AZ option for SQL Server), to power the performance analytics tools on the platform.
MDDX, a medical imaging company, developed an advanced web-based platform for medical research image management. Its primary goal is to eliminate some systematic difficulties related to clinical trial imaging. One of the primary features of the platform is an image depositary with a 20-year lifespan, with instant image retrieval. The company also developed image processing and data analytics tools to help researchers gain unprecedented insight into their medical data, even long after the clinical trials have been concluded.
The innovative technologies behind the platform, along with the included research site and lab performance metrics, provide an extremely valuable solution to the medical research institutions, positioning the company as a leader in the medical imaging field. MDDX clients include some of the most prominent names in the industry, such as GE Healthcare, as well as top tier research universities like Harvard and Cornell..
Medical images generated by CT and MRI scanners are stored in a special medical image format called DICOM (Digital Imaging and Communications in Medicine). Those files contain metadata, which facilitates the analysis of the images and the results from the clinical trials. However, the US Health Insurance Portability and Accountability Act (HIPAA), specifies several types of potentially identifying information (such as name, date of birth, gender, biometric data, and many more), which should be removed from the DICOM data.
The company image management software platform guarantees 100% de-identification of all DICOM images, which helps avoid any legal compliance issues related to improper image labeling. In addition to alleviating these legal concerns for the medical researchers, the company also guarantees protection against incompatible formats and data corruption. All that image data must be stored in a depositary for a long period of time. The vast amounts of accumulated data must remain accessible at all times for various research analyses and system performance metrics.
Both the legal and the technical aspects of this service require that the platform is powered by the most robust and reliable server technology. To ensure wide adoption of the platform at hundreds of medical research sites all over the world, it is even more critical that the data management technology behind the platform is rock solid, with no downtime or interruption of any kind.
With CloudBasic’s RDS AlwaysOn you can deploy true Multi-Region server replication scenarios, even with MS SQL Server Web Edition, with full access to the Read-Replica, while still paying 1/2 less than the AWS Multi-AZ deployment. View sample replication scenarios to compare cost and benefits.
Considering the high importance of the medical image data, the stringent platform availability requirements, and the need to offer advance performance metrics to the users without burdening the main servers, the company chose CloudBasic’s RDS AlwaysOn/Geo-Replicate for SQL Server.
As a high-performance lightweight RDS SQL Server replication solution for AWS, RDS AlwaysOn provides fully accessible Geo-Read-Replicas for the analytics tools of the platform. All reporting tools use the replicas, rather than the primary server, which reduces the load on source databases and improves the overall stability of the platform. In addition to the load balancing and reporting function of replicas, they also provide seamless Disaster Recovery solution.
MDDX also leverages CloudBasic for DevOps DLM operations, integrating the tool into their DevOps tools (such as Jenkings), allowing them to achieve both continuous updating of data from production databases to staging/development instances and to clone production databases and create individual development instances on a regular basis.
Improved system performance, platform stability, and lower TCO!
The CloudBasic replication engine delivered more functionality than the classic AWS RDS Multi-AZ at a substantially lower cost.
The cross-region server replication set up of the read-replicas is a built-in Disaster Recover solution, where a Secondary replica can be promoted to Primary, should there be any cloud infrastructure disruption.
CloudBasic DevOps DLM tools enabled MDDX to move RDS SQL databases form dev to test to staging environments in an automated manner. Automating Database Lifecycle Management helps achieve true one-click deployments.
The sophisticated cloud deployment of this innovative platform, including the multiple Geo-Read-Replicas in different regions for data locality, ensured its continuous availability, and resulted in its wide adoption throughout the medical research industry. The company’s medical imaging tools are now used at over 150 research sites in more than 40 countries around the world, which are supported by customer service teams in multiple time zones.
Leverage the cloud at its best! For more information about CloudBasic and its cloud technology products and services, please contact CloudBasic.
UPDATE, November 2017: Bioclinica®, the world-leading provider of scientific-enabled Medical Imaging, eHealth, and patient-centric solutions supporting clinical research, announced on 11/6/2017 that it has acquired Silicon Valley-based MDDX Research & Informatics, adding the industry’s most advanced cloud research image management and submission technologies to its extensive suite of eHealth solutions. To learn more about the aquistion read the announcement or visit http://www.bioclinica.com.
RDS SQL Server Multi-AZ and Multi-AR (Cross-Region) Readable-Replicas for HA/DR, reporting, off-loading of primaries. On-Premise to AWS replication for Cloud HA/DR.
You'll be in good company:
Amazing Product for RDS SQL Server replication
Cloudbasic RDS Always-On/Geo-Replicate for SQL Server provided us with just what we were looking for. It saved us a lot of time during our migration process by taking care of the database schema replication and keeping large amounts of data in sync. Also, the support has been amazing in terms of being available in-spite of the time zone differences. Read full review >>
Great product, fantastic support team!
We’re a small, growing company so our AWS budget is tight and the CloudBasic replication product is the perfect solution for our needs. This product has allowed us to implement a reliable, near real-time replication solution without resorting to expensive SQL Server/RDS replication solutions. The CloudBasic product has proven to be fast, reliable, easy to set up, use and manage.
Before our AWS migration we managed our own physical SQL Server installation and used SQL Server log shipping to sync our online and reporting databases with typical latencies of 15-30 minute range. With the CloudBasic solution our latencies are now in the 2-5 second range… Read full review >>
CloudBasic is an AWS Rockstar!
The CloudBasic RDS Always-On/Geo-Replicate for SQL Server solution is an absolute lifesaver when working with RDS SQL Server! SQL Server on RDS falls short in a lot of aspects when it comes to replication and disaster recovery, and this solution makes the process seamless. We’re able to migrate very large amounts of data and keep the in sync while we move applications around, as well as create usable read-replicas that RDS simply doesn’t provide. Anytime we’ve run into any snags in the process, CloudBasic support has been right there available to help get things going right away. I’m truly impressed with the product and the company behind it! Read full review >>
Great product, simplifies architecture and hassle free
CLOUDBASIC RDS Always-On/Geo-Replicate for SQL Server HA/DR/Redshift/S3 provided us a way to replicate multiple on site MSSQL DBs to other datacenters as well as Amazon RDS\EC2 and also from the cloud into our datacenters. After spending weeks of investigating how we could manage this using SQL’s own replication or writing our own replication jobs we found Cloudbasic. We were up and running within a hour and our DBA team could test replication paths hassle free and have full control over the source and destination DBs. The ability to replicate into SQL Web version saves us $10,000’s every year whilst maintaining the ability to have read\write replicas. The Cloudbasic support has been fantastic, helping us with any questions we have and also releasing new features to meet specific needs, we couldn’t ask for more from a product support group. I would highly recommend you trial this product if you are looking at any form of hybrid MSSQL replication and want the most cost optimised solution that works straight out the box (AMI). Read full review >>
Excellent product and support!
CloudBasic RDS AlwaysOn/Geo-Replicate for SQL Server HA/DR is an excellent product backed by great support. Using the pre-configured AMI we were up and running in minutes. Used CloudBasic to migrate SQL Server databases into RDS, followed by setting up cross-region Multi-AR RDS SQL replications for Disaster Recovery and Multi-AZ High Availability. It works well with RDS Multi-AZ, creates SQL Server read-replicas which can be used for reporting, data-locality and offloading of primary RDS SQL Servers. With help form the responsive CloudBasic support team we were able to migrate our databases with no down time. Setting up DR and HA was straightforward.
I strongly recommend the product and the CloudBasic advisory support team… Read full review >>
I’m really happy I found your product
I’m really happy I found your product as there are not many options for this sort of thing with RDS and SQL Server.
Does what it says on the box, easy to use, amazing support.
I found this tool when I was looking for a way to transfer databases between our development systems and our production systems. These comprised of a mix of in house physical SQL, EC2 SQL and and RDS. Cloudbasic Geo-replicate solved this problem.
The product improvements I asked for were implemented within days allowing me to extend our use of this product into our devops continuous delivery model.
Affordable SQL Server High Availability Solution
As a consultant I look for affordable and easy to maintain solutions for my customers. This SQL Server HA solution features a simple web interface. I did not have to worry about configuring server clusters, log shipping etc. I was able to setup a DB instance replication to a cross-region AlwaysOn RDS in minutes. I was pleasantly surprised that MSSQL Web Edition is also supported. I had to call for support related to DB issues on my end. I was assigned a dedicated support representative who proved to be very helpful. I did an extensive testing to ensure that this product is very reliable. With this product I am planning to scale up my Cloud Disaster Recovery implementation efforts.
Simple, Powerful, with Stellar Support
The software delivers what it promises. Its easy to use. The support is fantastic. We were impressed how fast they reached out to us to want to help. The software is fast, economical and affordable. It doesn’t put any stress on your source and destination databases. It seamlessly does what it does and it does it well. I highly recommend this product to anyone.
Simple cross-region RDS replication solution
We were looking for a way to continuously replicate our RDS based SQL Servers from west to east coast, for disaster recovery and reporting purposes. We started from looking for a SQL Server log shipping and high availability based solution ..then found CloudBasic’s Geo-Replicate server. We launched the server from the market place, entered RDS source and destination information and within minutes were able to stream data. The secondary DBs seeded very fast, and … Read All
Easy setup. Various deployment scenarios.
We were looking to utilize AWS as a fail-over site for our on-premise SQL Server based applications. We turned to the AWS Market place to find solutions to help us speed up implementation. Found this product, and within minutes were able to steam SQL Server data to an RDS SQL Server on AWS. All we had to do is enter source and destination SQL server connection strings. Then selected if we wanted a one time migration of the SQL server or also… Read full review >>
Works very well. Easy to use. Some minor issues need to be addressed.
We intended to use this software to do a one time migration of SQL databases from our co-located datacenter to AWS. Then figured it is very easy to setup continuous replication from East to West coast (AWS in California to AWS in Virginia). We currently use EC2 SQL Server Web edition in California, replicating to a small RDS Web Edition in Virginia… Read full review >>
Simple and inexpensive solution to replicate SQL Servers from West to East coast
Our customer base spans 100+ hospitals, including Tenet Healthcare, Baptist Health of South Florida and Texas Health Resources. We migrated our systems to AWS a year ago. Then shortly after, as part of our business continuity planning, selected the pre-AWS Marketplace version of CLOUDBASIC REPLICATE to … Read full review >>
Powerful Yet Simple Replication Solution
The most important feature we were looking for was to be able to access the end point of the replica for our reporting. This product replicates between SQL servers manages by us. We have to ensure the destination SQL Server is used in read-only mode, but this gives us the flexibility to setup replication in various scenarios: on-prem to AWS, across AWS regions, zone-to-zone. It does seem that SQL Server Web edition is supported in all scenarios as well… Read full review >>
CloudBasic SQL Migrate to RDS Solution
I used CloudBasic to Migrate my SQL2012 to an RDS 2012 instance. Install of CloudBasic was easy and once the connection strings were set on the CloudBasic Server webpage, my database connectivity was verified and the db migrated very fast to the RDS instance. CloudBasic is the easiest and fastest solution to replicate your data to an RDS instance for production and or testing. Thank You for making my job easier!!! Read full review >>
CloudBasic works great! Easy to setup and comes with outstanding support.
CloudBasic has a nice web user interface. There’s a quick setup feature to start replicating your databases in minutes after you setup the AMI from Amazon’s Marketplace. If you have any questions, RJ and their support team will go to great lengths to make sure CloudBasic gives you the ROI that you’re looking for in a database replication solution. Awesome product. Read full review >>