Cloud is great, but sometimes you want local data too. This session takes a look at how to synchronize your data between Amazon’s cloud-based data hosting (AWS) and InterBase local storage. Learn the advantages of such a system and when you might want such an architecture.

What is Local Cloud?

• There is no “Cloud”. It’s just somebody else’s computer.
• The Cloud is a server someone else manages for you!

Cloud Benefits

Cloud Drawbacks

• Reduced control
• Privacy issues
• Security concerns
• Jurisdiction complications

Local / Private Cloud

The benefits of cloud, but on-premises and fully under your control.

Hybrid Cloud

• Combining the private and public cloud gaining the benefits of both.
• Operating locally and in the cloud.

Cloud Deployment Models

Public, Private, Hybrid Clouds – On Premise, IaaS, PaaS, or SaaS

What is Amazon Web Services?

• Most comprehensive and broadly adopted cloud platform
• Provides on-demand cloud computing platforms and APIs
• Cloud computing web services
• Provides a variety of basic abstract technical infrastructure and distributed computing building blocks and tools.
• Billed using metered pay-as-you-go basis, based on
  • Hardware
  • Operating system
  • Software
  • Networking features
  • API calls
• Implemented at server farms throughout the world

Amazon Elastic Compute Cloud (Amazon EC2)

• Secure and resizable compute capacity.
• Access reliable, scalable infrastructure on demand.  Scale capacity within minutes with SLA commitment of 99.99% availability.
• Provide secure compute for your applications. Security is built into the foundation of Amazon EC2 with the AWS Nitro System.
• Optimize performance and cost with flexible options like AWS Graviton-based instances, Amazon EC2 Spot instances, and AWS Savings Plans.
• Migrate and build apps with ease using AWS Migration Tools, AWS Managed Services, or Amazon Lightsail. Learn how AWS can help.

EC2 Hosting Docker Containers

“Isn’t that the same as a Virtual Machine?”

InterBase Overview

Embed, Deploy, Relax!

InterBase installations are found everywhere; Trusted for solid, reliable use in mission-critical contexts such as patient management, railways, medical labs, multi-national POS, CRM, and emergency response systems. InterBase runs non-stop, round-the-clock. Lightweight, yet rock-solid.

Feature Rich Database for Enterprise and IoT

InterBase contains award winning technologies, build with ISV business solutions and the IoT age in mind.

• Admin Free
• Change Views (SQL based change tracking)
• Transparent Data Encryption
• Journaling and Point in Time Recovery
• Disaster Recovery

Traditional Data Briefcase

Using Change Views

Create a Subscription

_{docwiki.embarcadero.com/InterBase/2020/en/Creating_Subscriptions_to_Change_Views}

Grant & Revoke Subscription Access

GRANT and REVOKE commands similar to Privileges for accessing tables

Using Subscription

InterBase on Docker

• Embarcadero has an official Docker container image
  • hub.docker.com/r/radstudio/pa-radserver-ib
• Also includes PA Server and RAD Server
• There are other unofficial InterBase container images
• Or you can make your own…
  • github.com/Embarcadero/pa-radserver-ib-docker

More Information

• Replay, Links, Slides
  • blogs.embarcadero.com/?p=138413
• Amazon EC2 + Docker
  • docs.aws.amazon.com/AmazonECS/latest/userguide/docker-basics.html
• InterBase Change Views
  • docwiki.embarcadero.com/InterBase/2020/en/Change_Views
• Official InterBase Docker container image
  • hub.docker.com/r/radstudio/pa-radserver-ib
• Dockerfile source for image
  • github.com/Embarcadero/pa-radserver-ib-docker

Learning how to use data management will be easy with the Cross-Platform Desktop App Development tool, which is ultrafast, scalable, and embeddable, with commercial-grade data security, disaster recovery, and change synchronization. You may try the Free trial for the full version & the Free Developer Edition.