Key Takeaways
- Successfully migrated business-critical supply chain applications from on-premises Oracle to EDB BigAnimal Postgres-as-a-Service on company’s preferred AWS cloud infrastructure
- Met goals for near-zero downtime by deploying EDB Postgres Distributed on BigAnimal across multiple AWS cloud availability zones
- Geo-distributed, active/ active architectures protect the business from regional failures leading to downtime
Products
- EDB BigAnimal
- EDB Postgres Distributed (PGD)
- EDB Postgres Advanced Server (EPAS)
- Remote EDB DBA resources
Industry
- Agriculture
About
This international agricultural company’s business operations rely on high-volume applications used for critical supply chain functions, including:
- Quality assurance of pasteurization and production processes
- Tracking delivery trucks and company personnel dropping off and picking up products, with this app also integrated with invoicing, billing and driver payment functions
- Analyzing logistics data to optimize delivery routing
Challenges
The company ran these applications in an on-premises Oracle database environment, with a DBA team managing the infrastructure. However, there was a strategic commitment to move these applications, as well as the organization’s next-generation apps, to an AWS cloud infrastructure. With leadership determining that Postgres could handle production workloads, they preferred to run an AWS Postgres database solution on their AWS cloud infrastructure.
On closer review, concerns surfaced about whether the AWS Postgres solution could meet their near-zero downtime requirements for these critical supply chain applications. If these apps go down for extended periods, production and delivery applications are disrupted, and adverse business impacts are immediate—a situation to be avoided at all costs.
As a result, leadership began assessing other Postgres offerings capable of overcoming regional cloud availability zone, network or disk failures that could lead to extended downtime.
Solution
The company met its goals for near-zero downtime and successfully migrated essential supply chain workloads from its on-premises Oracle database solution to AWS cloud by deploying EDB Postgres Distributed on the fully
managed EDB BigAnimal Postgres-as-a-Service across multiple AWS cloud availability zones.
With EDB’s solution offering support that would help them accelerate their journey to the cloud, minimize risk and hit their timelines, the leadership team viewed the unmatched Oracle compatibility delivered by running EDB Postgres Advanced Server technology on BigAnimal as a valuable differentiator.
EDB Remote DBA resources also provided expert tuning and customization of the EDB Postgres environment running on AWS.
Results
Initially, the company was concerned about unexpected challenges that might arise from moving to the cloud.
After reviewing other Postgres solutions that would meet their risk mitigation requirements, EDB Postgres Distributed on BigAnimal was seen as the only solution equipped to provide geo-distributed, active/active architectures that delivered near zero-downtime assurances. As a result, the company is protected from regional failures that could lead to business downtime.
Future
For a company focused on maximizing cloud for hosting their next generation of applications and business expansion, the leadership team is confident they can move forward by leveraging EDB Postgres Distributed on BigAnimal to build highly resilient Postgres applications on AWS cloud.
Learn more about EDB Postgres Distributed running on BigAnimal. Get started today with $300
in free credits.