DevOps
fromInfoQ
9 hours agoReplacing Database Sequences at Scale Without Breaking 100+ Services
Validating requirements can simplify complex problems, and embedding sequence generation reduces network calls, enhancing performance and reliability.
Ever since version 10.3, MariaDB has been steadily adding Oracle compatibility features, making it easier to port Oracle to MariaDB as-is. Oracle compatibility is opt-in. All you need to do is issue the command SET SQL_MODE='ORACLE' to activate it for a given set of SQL statements. Existing MariaDB behaviors will also be preserved wherever possible.
Netflix has completed a major consolidation of its relational database infrastructure onto Amazon Aurora, reporting performance improvements of up to 75% and a 28% reduction in costs. The streaming giant's move from self-managed PostgreSQL on EC2 to the managed Aurora service highlights a broader industry trend toward offloading operational overhead to cloud-native database platforms. Facing challenges with a fragmented database landscape, Netflix's Online Data Stores (ODS) team struggled with the operational toil of managing deployed custom binaries, patching, and manual scaling.
Percona, a provider of open source database support services and Database-as-a-Service (DBaaS), has warned that more than half its MySQL instances remain on MySQL 8.0, support for which ends on April 30, 2026. Peter Zaitsev, Percona co-founder, told The Register: "Every piece of complex software has bugs which may not have been found yet. Some of those bugs are also security bugs.
IBM is collaborating with Cockroach Labs to help mainframe users modernize business-critical applications. The two companies have signed an OEM agreement to integrate CockroachDB, the distributed relational database with PostgreSQL compatibility, into IBM's hybrid infrastructure. According to The Register, IBM aims to enable organizations to use cloud-native databases on systems such as LinuxONE, Linux on Z, Power Systems, and Red Hat OpenShift.
Atlassian migrated over 4 million Jira PostgreSQL databases to Amazon Aurora to improve reliability and reduce costs, developing custom orchestration tools for the transition.