title

text

Aleksei Plotnikov
Aleksei Plotnikov Skype
17:00 16 March
45 мин

Database platform architecture and administrating PostgreSQL in Skype

Most of the main Skype services use a database platform based on PostgreSQL and other open-source technologies, such as Skytools, plProxy, pgBouncer, etc. This platform consists of several hundreds of servers with thousands of databases, which process hundreds of thousands of transactions per second. At the same time, the platform architecture allows its users (applications and their developers) to work with "logical" databases, without any worries about their real “physical” structure.

Our Skype Database Platform team is responsible for the database platform infrastructure. We develop automation systems for various processes that help us ensure service reliability and facilitate development, testing, and deployment of code. In this presentation, I will outline the database platform architecture, review its main components, and tell you about the methods we use in our every-day work to ensure high availability, scalability, replication, fault tolerance, and more.

слайды

Видео

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

  • Hans-Jürgen Schönig
    Hans-Jürgen Schönig Cybertec Schönig & Schönig GmbH
    45 мин

    Processing 1 BILLION rows per second with PostgreSQL

    Database systems are increasing in size and so is the need to process huge amounts of data in real time. As commercial database vendors are bragging about their capabilities we decided to push PostgreSQL to the next level and exceed 1 billion rows per second to show what we can do with Open Source. To those who need even more: 1 billion rows is by far not the limit - a lot more is possible. Watch and see how we did it.

    VIDEO

  • Kamil Islamov
    Kamil Islamov Stickeroid Ai
    22 мин

    Postgresql Functions and ORM cooperation at Django example

    We will discuss some tricks and patterns while developing web-application architecture based on ORM technology with Postgresql functions implementation with Python Django as an example. Also we will consider some ways of building the business logic inside a database with keeping Django framework opportunities and implementation of it's built-in admin panel.

    VIDEO

  • Andrey Borodin
    Andrey Borodin Яндекс
    45 мин

    GiST speedup: patches, hacks and tweaks

    This report overviews some ideas and implementations to speedup different parts of generalized search trees (GiST): 1. Intrapage indexing 2. Fractal tree technology 3. Modern algorithms for spatial indexing (RR*-tree) 4.. Possible advancements of GiST API

    VIDEO

  • Peter Gribanov
    Peter Gribanov
    22 мин

    1C:Enterprise business platform: working with PostgreSQL

    "1C:Enterprise" is the most popular in Russia/Eastern Europe business applications development framework supports PostgreSQL for 10+ years. We'll review some cases and pecularities of 1C and PostgreSQL tandem.