title

text

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

Real case of smooth MySQL → PG migration of highloaded project (20+M users)

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
слайды

Видео

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

  • Kamil Islamov
    Kamil Islamov Stickeroid Ai
    22 мин

    Sequences used for business-logic implementation

    Examples of Sequences' opportunities implementations for developing business-logic powered by stored functions.

  • Георгий Рылов
    Георгий Рылов Яндекс
    22 мин

    WAL-G: new features and expansion of the community

    Open-source maintainers face many challenges as projects grow. How to write more required features, fix more issues and have time to watch more pull requests? On the example of WAL-G(backup tool for PostgreSQL) I will tell you about how we solved these problems by launching a course of Open-source development at Ural Federal University, what we achieved and what will we do next.

  • Kirill Borovikov
    Kirill Borovikov ООО "Компания "Тензор"
    45 мин

    Plan + query = ?.. Finding pleasure in analyzing query plans

    Odd things in query plan analysis - wasted time and "unnecessary" buffers.
    Structural hints in a plan. How to help a developer with optimization without writing a single line of code. How to match plan nodes with query text and take advantage of this information.

  • Jose Cores Finotto
    Jose Cores Finotto Gitlab Inc
    45 мин

    Managing PostgreSQL at Gitlab.com

    I would like to present the main projects for the evolution of our database, how we execute the administration, the problems and pitfalls we found, and how we solve them,the number and how are the database clusters from Gitlab.com , and what is our planning for the future, sharding, kubernetes... Our environment is in an exponential growth, with millions of users and thousands of requests per second, and we keep our platform stable and scaling. Join our session and discover our how we are doing it!