Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
PostgreSQL Replication

Buy
PostgreSQL Replication, 9781849516723 (1849516723), Packt Publishing, 2013

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

Approach

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.

(HTML tags aren't allowed.)

Health Care for Us All: Getting More for Our Investment
Health Care for Us All: Getting More for Our Investment

Health Care for Us All challenges the common belief that health care problems in the United States are difficult and possibly insoluble. Americans want to get more for their health care spending, including insurance coverage for all that is personal, portable, and permanent. They want a system that respects incentives for quality care, exhibits...

HP-UX 11i Systems Administration Handbook and Toolkit, Second Edition
HP-UX 11i Systems Administration Handbook and Toolkit, Second Edition

Your complete single source for HP-UX system administration!

Now, there's a single source for all the information HP-UX administrators needto succeed! Marty Poniatowski has updated the world's #1 HP-UX systemadministration guide to cover all the latest HP-UX 11i enhancements, plus all theUNIX commands...

Building the Mobile Internet (Networking Technology)
Building the Mobile Internet (Networking Technology)

The complete guide to technologies and protocols for delivering seamless mobile Internet experiences

 

In Building the MobileInternet, three leading mobility architects and implementers from Cisco present complete foundational knowledge about...


Everyday Matters in Science and Mathematics: Studies of Complex Classroom Events
Everyday Matters in Science and Mathematics: Studies of Complex Classroom Events
This book results from a multiyear collaboration made possible by the National
Center for Improving Student Learning and Achievement housed at
the Wisconsin Center for Educational Research, University of Wisconsin,
Madison. This collaboration focused on investigating the nature of learning
in science and mathematics classrooms
...
Corporate Ethics: How to Update or Develop Your Ethics Code so That it is in Compliance With the New Laws of Corporate Responsibility
Corporate Ethics: How to Update or Develop Your Ethics Code so That it is in Compliance With the New Laws of Corporate Responsibility

Never has ethical business conduct received as much attention and focus as it does at present, in the wake of the far-reaching financial and societal effects of the dramatic collapses that have thundered through Corporate America. Whether your company is private, publicly-held, works with the government – either contractually or through...

Pro Apache Geronimo
Pro Apache Geronimo

Pro Apache Geronimo teaches you all about using Apache Geronimo, the open source lightweight J2EE/Java EE 5 web application server. Geronimo's GBeans enable you to deploy sophisticated server-side enterprise Java applications and perform special enterprise-level Java development for transactional support. This book is a must-have...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy