Master class on PostgreSQL developers Skype and other PostgreSQL the October events in Moscow

imageCompany organizing Committee the conference Highload++ are pleased to present to your attention a master class "How to design a scalable architecture PostgreSQL", which will be conducted by the experts of the company Skype ASKO Oy (Asko Oja) and Marco Creen (Marko Kreen). The event will be held on 8 October 2008 in Moscow in conference-center "InfoSpace".

"A master class from the developers of Skype will complete a three-day series of PostgreSQL events that we will hold 6-8 October, — says the Executive Director of the company "Postgresmain" Nikolay Samokhvalov. — In the evening of the 6th of October we will organize the next, the fourth open meeting of the Russian community of users of PostgreSQL with the participation of foreign guests. 7th all visitors of the conference Highload++ will be able to listen to an interesting series of reports focused on those using or starting to use PostgreSQL together with our foreign colleagues (and in addition experts Skype will be attended by the technical Director of the social network myYearbook.com Gavin Roy) we will try as much as possible to talk about improving performance for PostgreSQL applications. Well, in the course of participation in the master class from the developer Skype, I'm sure, will be able to get all the answers to all remaining questions and to master the priceless skills of designing major projects. Come, it will be very interesting!"

image
That's what told us about the seminar ASKO and Marco:

Quick overview

In the framework of the master class will present some of our design patterns and open source tools that we use Skype to maintain the health and condition of the growing databases, namely:
the
    the
  • Built-in language plProxy and examples of its use as a:
    the
      the
    • language remote calls
    • the
    • means horizontal scaling
    • the
    • load balancer in the "read-only"
    • the
    • layers of security and tools for creating SQL queries
  • the
  • Easy connection Manager pgBouncer. Why it should be used and that can provide different connection modes.
  • the
  • SkyTools Framework that contains many useful tools, code which it is convenient to use in your own solutions to specific problems.
We discuss:
the
    the
  • system WalMgr to create a server hot spare
  • the
  • basics of the generalized queue, PgQ and several examples of its use, based on scripts from the package SkyTools
  • the
  • Londiste — simple and powerful solution to master-slave replication of PostgreSQL database servers.
  • the
  • dbService — an interesting example of stored procedures that can handle multiple input and output record sets in a single call.

In addition, we will discuss how Skype organized database management and monitoring and describe management database in a cluster configuration, and President-app.

Target audience

Architects, designers, developers, and database to interesting ideas and solutions which they can use in everyday tasks. Database administrators who need to cope with the huge and growing number of transactions. People who want to know what PostgreSQL is different from other DBMS.

Where to apply this knowledge:
    the
  • Design the application architecture.
  • the
  • Choose middleware and access methods to the database.
  • the
  • Optimization and load control in fast-growing databases.
  • the
  • Increase availability and reduce load on database transaction processing (OLTP).
  • the
  • Writing solutions for mass data processing

speakers


Marco Creen (Marko Kreen), the engineer of company Skype, is the co-author and aims to support projects such as Skytools, plProxy, pgBouncer and pgcrypto.

Information for participants

Participation in the master class paid. It will be held on October 8, 2008, from 9:30 to 13:30 in the conference center InfoSpace. The maximum number of participants — 40 people. The participation fee is 4900 rubles if paid in September and 5900 rubles if paid in October. You can pay for participation in your personal account on the conference website Highload++.
Article based on information from habrahabr.ru

Комментарии

Популярные сообщения из этого блога

ODBC Firebird, Postgresql, executing queries in Powershell

garage48 for the first time in Kiev!

The Ministry of communications wants to ban phones without GLONASS