Thursday 20th June, 2013
3:45pm to 4:30pm
Replication is a staple of every database technology. It offers the potential for better availability, more scaling, and more reliability. It also offers the potential for late nights and inaccurate perceptions of reliability. Knowing your options is the best bet for your to choose the right technology, and to always be able to answer “it depends” when someone asks you if, and which, replication solution to implement. This talk strives to answer “it depends” with joy.
The purpose of this talk is to explore the different kinds of replication technologies available (streaming\binary, object-specific, WAL-shipping), and what the pros and cons are of each. Next, I’ll dive a little deeper into the built-in replication technologies available in Postgres 9.x, including what is new to 9.2. Finally, I will touch on Bucardo, PgPool and potentially other popular third-party replication options, to give the audience a clear picture of what is out there, what each one offers, and what the caveats are.
Sign in to add slides, notes or videos to this session