Explores and identifies the main issues, concepts, principles and evolution of software testing, including software quality engineering and testing co
- Author : Hans-Jürgen Schönig, Zoltan Böszörmenyi
- Year : 2013
- Pages : 250
- File size : 2.8 MB
- File format : PDF
- Category : Programming, Postgresql
PostgreSQL offers a comprehensive set of replication related features, which can be used to make your database servers more robust and way more scalable. Unleashing the power of PostgreSQL provides the user with countless opportunities and a competitive advantage over other database systems. To make things more powerful, PostgreSQL can be used in conjunction with a handful of sophisticated tools serving various different needs such as queuing, logical replication, or simplified transaction log handling.
“PostgreSQL Replication” is a practical, hands-on guide to PostgreSQL replication. It will provide you with the theoretical background as well as simple examples showing you how to make replication work on your system. A broad toolchain will be presented along with mature PostgreSQL-core technology.
“PostgreSQL Replication” starts with an introduction to replication concepts as well as the physical limitations of different replication solutions. You will be guided through various techniques such as Point-In-Time-Recovery, transaction-log-based replication and you will be introduced to a set of replication-related tools. In the final chapter you will learn to scale PostgreSQL to many different servers using PL/Proxy.
You will learn how to reset PostgreSQL to a certain point in time and figure out how to replicate data in many ways. You will deal with both synchronous as well as asynchronous replication. In addition to that, the book covers important topics, such as Slony, and upgrades with virtually no downtime. We will also cover important performance-related topics to make sure your database setups will provide you with high speed AND high availability.
“PostgreSQL Replication” contains all the information you need to design and operate replicated setups. You will learn everything you need to know for your daily work and a lot more.
What you will learn from this book
- Recover a PostgreSQL database to a certain point in time
- Set up asynchronous and synchronous streaming replication
- Handle transaction log files efficiently
- Learn about Linux High Availability
- Get to grips with Slony replication
- Get PL/Proxy to scale infinitely
- Understand pgpool and pgbouncer to improve speed and reliability
- Perform fast on-the-fly backups
- Increase reliability and throughput
- Improve data security and geographically distribute data
This book has a chapter dedicated to each aspect of replication. The new features of PostgreSQL 9 are introduced and there are lots of practical examples and screenshots.
eBooks in the same categorie :
Learn Objective-C and its latest release, and learn how to mix Swift with it. You have a great idea for an app, but how do you bring it to fruition?
A guide to designing and implementing VPLS services over an IP/MPLS switched service provider backbone Today’s communication providers are loo
Key Features Create a PostgreSQL cluster that stays online even when disaster strikes Avoid costly downtime and data loss that can ruin your business
PostgreSQL is a powerful, open source, object-relational database system, fast becoming one of the world’s most popular server databases with an
This book will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework
Carry out data analysis with PySpark SQL, graphframes, and graph data processing using a problem-solution approach. This book provides solutions to pr
Get started with PostgreSQL on the cloud and discover the advantages, disadvantages, and limitations of the cloud services from Amazon, Rackspace, Goo
PostgreSQL is an open source database management system. It is used for a wide variety of development practices such as software and web design, as we