title

text

Олег Правдин
Олег Правдин
11:00 05 February
45 мин

Опыт плавной миграции высоконагруженного проекта (20+ млн. пользователей) c MySQL на PostgreSQL

A brief story how MySQL → PG migration could increase company efficiency tenfold times:

  1. Program code has been reduced 50 times, with optimization of backend team (from 15 to 3 engineers)
  2. Software development of new features has become measuring in days, not in months
  3. Infrastructure costs per 1M users have been reduced 20 times
  4. Database structure and technical documentation were simplified significantly, from 100K high-dependent tables to just 20 simple tables
  5. New security level because of total forbidden on external SQL commands to the database
  6. Quick analytics aggregation on multiple parameters, without external analytics systems
  7. The last, but not the least: the main business was keeping alive during migration

Слайды

Видео

Другие доклады