![Elena Skvortsova Elena Skvortsova](/media//2023/03/16/СкворцоваЕлена-ИТ-Экспертиза-kv.png.180x180.jpg)
Migration of high-loaded 1C solutions to Linux/Postgres infrastructure
How to migrate a high-loaded information system based on 1С:Enterprise from MS Windows/MS SQL Server to Linux/PostgreSQL and don't face considerable pains?
We'll share our migration strategies and what was key to its success. We'll talk about projects involving migrations and pay attention to some nuances.
Слайды
Видео
Видео доступно участникам мероприятия, выполнившим вход в личный кабинет
Другие доклады
-
Sergey Mokeev Maxim Technology
-
Alfred Stolyarov ООО "Еваппс" (EvApps)
How we switched Oracle for PostgreSQL for a client, before it became mainstream
The history of import substitution did not start last year after well-known events. Its launch dates back to 2014. It was from this year that state and near-state companies began to think of switching to the so called "recommended software". One of these companies approached us back in 2020 with a project to move from Oracle to PostgreSQL. This project was designed to solve the accumulated architectural problems (imperfect storage system for telemetry data, the DBMS itself worked inside a virtual machine), and optimize the use of disk space (make space in the main storage, debug saving archived data, ensure correct backup). Since the customer's system should have worked uninterrupted 24/7, it was necessary to switch from one DBMS to another "seamlessly" without downtime, with simultaneous operation of both to ensure step-by-step translation of subsystems and the ability to control the correctness of the data. And, of course, the work had to be completed as quickly as possible.
In the report we will discuss how we managed to solve this case.
-
Michael Shurutov СтандартПроект
A set of Ansible roles for PostgreSQL
There is set of Ansible roles for any Postgres configuration: a standalone instance; a streaming replica; patroni+etcd; stolon+etcd; patroni+consul; stolon+consul. In this talk, we will discuss why using this set of Ansible roles is better than other solutions.
-
Pavel Konotopov inCountry
RTT, RTO, RPO and synchronous replication
How does network latency affect performance when using synchronous replication? If a primary node fails, how long will our cluster not be reachable? How much data can be lost? Will there be any anomalies when reading from standby? We are designing our network architecture, give us a minimum RTT value for cluster solution! Many DBAs have to face these issues when designing and implementing cluster solutions. In this short talk we will tell how to quickly estimate RTT, RTO, RPO values, with the help of which Open Source tools one can test cluster solution and experimentally verify the design parameters, which metrics values can be used as a guide in design.