Cybertec

PL/Proxy

In many real world scenarios applications are so big that it is not possible anymore to stand the load with just one, big machine. Do you have to serve more than 20.000 or even 50.000 reading transactions a second? Then this is the right page to read.

Horizontal scaling
PL/Proxy allows you to scale an application beyond one machine. In contrast to Cybercluster, PL/Proxy does not replicate data between machines. Instead, each machine will only hold a small subset of data. This makes it ideal for huge amounts of data.
In other words: If your load increases you can simply add machines to make your partitions smaller. If 4 machines are not enough for a certain workload – use 8. If 8 machines are not enough – move to 16 machines.
As PL/Proxy is ideal for partitioning it can be used to serve simple requests (such as phone book lookups) thousands of times a second.

What Cybertec and PL/Proxy can do for you
Cybertec will help you to properly design your PL/Proxy application. In addition to that we will help you to setup and to optimize PL/Proxy.
We provide support and we will make sure that your system is up and running 24x7.

How it all works
PL/Proxy has been designed to distribute stored procedure calls. It automatically distributes data and makes sure that a certain piece of data ends up at a certain node inside your cluster. When a request comes in, your PL/Proxy frontend servers will automatically find the partition where your data resides and it will fetch the data from the right node.
The main advantage is that your application does not have to know where the data actually comes from (this is handled by PL/Proxy) – it just calls a stored procedure and waits for the answer.
As all machines will be serving requests concurrently your application can nicely scale infinitely.

Scaling infinitely with PL/Proxy

Cybertec is a company offering a comprehensive set of services for the world's most advanced Open Source database, PostgreSQL.
Our products work on all platforms including Linux, Solaris, and Windows. No matter whether your application is small or complex - we have the right solution for you.