Миграция с MongoDB на PostgreSQL
MongoDB is a successful database in the NoSQL space, mostly used for OLTP-type workloads. However, due to the lack of ACID (transactions in particular) and significant performance issues with OLAP/DW workloads, more and more MongoDB users are considering migrating off of MongoDB to a RDBMS, where PostgreSQL is the usual choice. This represents a significant opportunity for the PostgreSQL ecosystem, to "bring NoSQL to SQL". This talk will present the challenges that MongoDB users are facing and the state of the art of the available tools and open source solutions available to perform ETL and live migrations to PostgreSQL. In particular, ToroDB Stampede will be discussed, an open source solution that replicates live from MongoDB, transform JSON documents into relational tables, and stores the data in PostgreSQL.
VIDEO
Слайды
Другие доклады
-
22 мин
Ivan Panchenko Postgres ProfessionalДва года профессионального постгреса
A summary of what the Postgres Professional company has achieved in its two-year history:
- Our achievements in PostgreSQL development.
- What is the Russian Postgres Pro DBMS, and how is it related to PostgreSQL?
- What is Postgres Pro Enterprise, and why Enterprise?
- What about trainings and certification?
VIDEO
-
45 мин
Alexander Kukushkin Zalando SEОтказоустойчивый PostgreSQL кластер с Patroni
In the modern world, an increasing number of IT companies are moving their resources to the cloud and Zalando is not an exception. A rapid growth our company is experiencing along with an adoption of microservices were the main driving forces behind the changes introduced into the deployment procedure of new PostgreSQL clusters and the solution of the automatic failover problem. The majority of existing solutions for automatic failover require manual configuration of every cluster instance and complicates provisioning new clusters and new nodes into existing cluster.
-
45 мин
Anton Doroshkevich ИнфоСофтPostgreSQL - реальная альтернатива для высоконагруженных систем на базе 1С
- Why is it time to consider switching to PostgreSQL?
- 1С and PostgreSQL interoperability.
- Why should we start with Windows?
- The first experience of migrating big enough 1С databases to Postgres.
- Large-scale projects on high-load systems, in figures.
-
22 мин
Oleg Bartunov Postgres ProfessionalJSON в PostgreSQL: дорожная карта
The new ISO/IEC 9075-2:2016 standard specifies JSON data and operations syntax and semantics specifics for SQL. This talk overviews the requirements of this standard, and focuses on the differences between them and the actual implementation of JSON/JSONB in PostgreSQL. Special attention will be paid to JSON Path (XPath analogue), SQL/JSON functions and our plans to make Postgres compliant with this standard.
VIDEO