World. Sunrise. Elbrus. PostgreSQL
summary
A case study of migrating Russia’s national passport/visa document system from proprietary mainframe stack (IBM DB2 on z/OS, WebSphere MQ, Tivoli) to an all-open-source stack using Linux, PostgreSQL, Ceph, Apache ActiveMQ, Redis, Zabbix, OTRS and others. It also covers running that open-source stack on domestic Elbrus processors and the challenges of deploying PostgreSQL as the core DBMS across territorial sites and the central data center.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 2:54About Mir system
- 7:06Import substitution and Elbrus
- 14:43PostgreSQL migration issues
- 21:29Long transactions and MVCC
- 26:45Working with domestic hardware
- 33:30PostgreSQL support on Elbrus
- 41:04Open Source myths and concerns
- 49:16Project cost and results
- 53:55Summary and plans
- 1:01:03Q&A
related talks
47mPostgreSQL in the Government of Moscow Region
08mUsing PostgreSQL in real life
46mBig databases, many servers, data center or cloud - it's all here!
45mLeveraging Open Source Databases for Strategic Advantage
38mOpen Source - A Blessing or a Curse?
48mMigrating to PostgreSQL: Strategies, Sovereignty, and Success
38mWhat we built with Open Source
49mLessons from Migrating a 10 TB PostgreSQL Cluster to AWS