Master class about PostgreSQL from Skype developers and other October PostgreSQL events in Moscow

The Postgresmen company and the Highload ++ conference organizing committee are pleased to bring to your attention a master class on “How to design a scalable PostgreSQL architecture” , which will be conducted by Skype experts Asko Oja and Marko Kreen . The event will be held on October 8, 2008 in Moscow in the conference center "Infospace" .

“A master class from Skype developers will complete the three-day series of PostgreSQL events we will hold on October 6-8, ” says Nikolay Samokhvalov, executive director of Postgresmen . - In the evening of October 6, we will organize the next, fourth in a row, open meeting of the Russian PostgreSQL user community with the participation of foreign guests. On the 7th, all visitors to the Highload ++ conference will be able to listen to an interesting series of reports targeted at those who use or begin to use PostgreSQL: together with our foreign colleagues (and besides Skype experts, technical director of the social network myYearbook.com Gevin Roy will attend) talk more about improving the performance of PostgreSQL applications. Well, in the process of participation in the master class from the developers of Skype, I am sure those who are interested will be able to get answers to all the remaining questions and master the invaluable skills of designing large projects. Come, it will be very interesting! "


Here is what Asko and Marco told us about the seminar:

Short review

As part of the master class, we will describe some of the design patterns and open source tools we developed that we use in Skype to maintain the health and health of fast-growing databases, namely:

• The built-in plProxy language and examples of its use as:
  
  • remote call language
  • means of horizontal scaling
  • load balancer in read-only mode
  • security layer and tools for proxying SQL queries
• Easy pgBouncer connection manager. Why it should be used and what different connection modes can give.
• The SkyTools framework, which contains many useful utilities, whose code is convenient to use in your own solutions to specific problems.

We will discuss:

• WalMgr hot standby servers
• PgQ generalized queue basics and some examples of its use based on scripts from the SkyTools package
• Londiste is a simple and powerful solution for master-slave replication of PostgreSQL servers.
• dbService is an interesting example of stored procedures that can process several input and output record sets in one call.

In addition, we will talk about how database management and monitoring is organized in Skype, we will describe the cluster configuration management database and the President-application.
')

The target audience

Architects, designers, database developers should get interesting ideas and solutions that they can use in everyday tasks. Database administrators who need to cope with a huge and growing number of transactions. People who want to know how PostgreSQL differs from other DBMSs.

Where to apply this knowledge:

• Designing application architecture.
• The choice of middleware and database access methods.
• Optimization and load control in fast growing databases.
• Increase availability and reduce database load with real-time transaction processing (OLTP).
• Writing solutions for mass data processing

Information about speakers

Asko Oja : Head of Database Development at Skype, has been actively developing with various DBMS for almost 20 years (including Oracle, MSSQL, MS Access, FoxPro, and so on). Asko participated in various projects not only as a developer, but also as a manager, therefore the widest range of issues falls within his area of ​​expertise. After 15 years of “reinventing the wheel” in various database systems, he decided to start publishing as much of the accumulated material as open source projects. Many users around the world now use these practices.

Marko Kreen , an engineer at Skype, is a co-author and is supporting projects such as Skytools, plProxy, pgBouncer and pgcrypto.

Information for participants

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