Case Studies
Success stories of 2ndQuadrant and PostgreSQL
Decades of experience allows the 2ndQuadrant team of PostgreSQL experts to quickly identify and overcome challenges, enabling organizations to effectively meet business requirements. The case studies below are examples of successful PostgreSQL services and solutions from 2ndQuadrant for mission-critical databases.
Topics
Database Migrations
Global Online Gaming Provider Migrates Tightly Regulated Database to PostgreSQL
Global gaming company, IGT, migrated to PostgreSQL to deliver entertaining and responsible gaming experiences for players across all channels and regulated segments. IGT was seeking a more cost-efficient solution for their globally distributed database that was running on a popular, yet expensive, DBMS. In addition to reducing costs, they wanted to minimize OLTP workloads. IGT chose to migrate their database to the cost-effective and feature-rich PostgreSQL. Find out how 2ndQuadrant helped IGT successfully migrate to PostgreSQL and have reported zero outages in the last year since the switch.
Healthcare Software Company Migrates High Workload Database to PostgreSQL
Leading provider of RIS (Radiology Information Systems) to public healthcare organizations – Healthcare Software Systems (HSS) – chose to migrate their patient record database from Oracle to PostgreSQL. The HSS database manages the provision of critical systems to public healthcare organizations, health trusts, hospitals and clinics. The critical nature of the patient record system could not be jeopardized in any way – whether that be loss of access or reduced performance – and HSS leaned on the expertise of 2ndQuadrant to ensure a successful transition with ongoing support. Learn more about the Healthcare Software Systems’ migration experience with 2ndQuadrant’s world class experts.
Electronic Cartography Company Migrates to PostgreSQL and Implements Barman for Backup & Disaster Recovery
Navionics identified PostgreSQL as a highly scalable system with a backup and recovery strategy for its mission-critical environment. Navionics has the world’s largest database of marine and lake charts, covering the salt waters of the entire planet. 2ndQuadrant and its team of world-class experts helped Navionics during the migration process and implemented a proactive failure-proof backup and recovery strategy.
Performance
Scaling Infrastructure, Performance Tuning, & Highly Available Clusters for worldwide learning platform
Chicago-based learning success platform BenchPrep scaled its infrastructure with PostgreSQL to provide unmatched learning experience to its customers. Over the past few years, due to exponential increase in the demand for online training, the number of organizations using BenchPrep for their learning needs grew significantly. The platform turned to PostgreSQL to address performance issues due to the unexpected load. Find out how 2ndQuadrant helped BenchPrep scale its infrastructure to provide an exceptional experience to its customers.
Critical Financial Database gets 4x Performance Boost
Retail brokerage firm tastyworks uses PostgreSQL as its backend database for its cutting edge technology applications that are leading a financial revolution. 2ndQuadrant worked with tastyworks to address performance issues and optimize their database, updating their PostgreSQL configuration using best practices. They seamlessly migrated to new servers, achieving a 4x performance boost and high availability.
Distributed Database Clusters
Global Performance Consistency Achieved using BDR
SaaS project management and collaboration software company, ClickUp, uses BDR to achieve consistent performance for their global customers. After tremendous growth, the complexity of their application’s scalability and performance requirements increased and it became clear that they were hitting limits of performance and scalability. Learn how 2ndQuadrant’s BDR helped ClickUp achieve consistent performance for their global customers.
Most Complete Map of Milky Way Galaxy developed using Postgres-XL
The Geneva Data Center of Europe’s gateway to space, ESA, used Postgres-XL to develop a scalable and open solution with a massively parallel and distributed database for their largest milestone missions yet: The Gaia Project. The Gaia Project is a mission to create the largest and most precise 3D map of the Milky Way Galaxy. Find out how 2ndQuadrant and Postgres-XL helped the ESA Geneva Data Center exceed timeline expectations for their most advanced mission yet.
Massive productivity increase on overall production of Globally Distributed database
Animal Logic, groundbreaking animation and visual effects company, has been using PostgreSQL as a core database technology for many years and identified BDR as a superior solution to help establish a stable and highly available globally distributed database infrastructure. BDR combined with 2ndQuadrant Support service, helped this award-winning studio achieve a highly efficient management of their data.
BDR provides High Availability to International Telecommunications Company
Chilean telecommunications company, Telefonica del Sur, uses BDR to ensure efficient management of data with a high performing and highly available database environment. After evaluating several PostgreSQL replication tools, BDR stood out as the best option for their requirements and has helped Telefónica del Sur achieve an effective and accurate replication system for geographically distributed Postgres databases.
Database Upgrades
Leading Polar & Marine Research Institution Upgrades to Highly Efficient Database Infrastructure
Internationally recognized institute known for expertise in polar and marine research, AWI, invested in various PostgreSQL versions and operating systems for their applications. 2ndQuadrant helped AWI set up a homogenous PostgreSQL and OS versions environment with a standardized backup plan to better operate in a variety of polar and marine research stations, which are constantly collecting an enormous amount of data.
Support & Database Administration
2ndQuadrant Support used by Global Leader in Weather and Climate
Global leader in weather and climate science, Met Office, uses PostgreSQL to reduce costs and introduce flexibility in terms of platform development and special requirements. 2ndQuadrant was chosen as a support partner, to provide guidance, training and support for use of PostgreSQL as an alternative to Oracle. Discover why the Met Office chose PostgreSQL as their backend database and how 2ndQuadrant’s experts have supported them for success.
GPS Fleet Tracking Solution uses RDBA for Mission-Critical Databases
GPS fleet-tracking solution chooses 2ndQuadrant’s team of experts for a worry-free 24/7 RDBA service combined with Production Support as a solution to their scaling needs. After an incremental growth, thanks to the rising demand for vehicle tracking solutions, support from 2ndQuadrant helped Agilis Systems provide customers uninterrupted services and increase productivity of internal resources and much more!
Production Support & RDBA chosen by London’s Official Promotional Organization
Not-for-profit, public/private partnership London & Partners turns to PostgreSQL to achieve high availability and systems that are fail-proof for operation of their highly robust IT infrastructure. Discover how 2ndQuadrant aided in the major transformation of their PostgreSQL database, helping London & Partners achieve their performance goals.
.
