Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
PostgreSQL Replication, Second Edition

You're reading from  PostgreSQL Replication, Second Edition

Product type Book
Published in Jul 2015
Publisher
ISBN-13 9781783550609
Pages 322 pages
Edition 1st Edition
Languages

Table of Contents (22) Chapters

PostgreSQL Replication Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. Understanding the Concepts of Replication 2. Understanding the PostgreSQL Transaction Log 3. Understanding Point-in-time Recovery 4. Setting Up Asynchronous Replication 5. Setting Up Synchronous Replication 6. Monitoring Your Setup 7. Understanding Linux High Availability 8. Working with PgBouncer 9. Working with pgpool 10. Configuring Slony 11. Using SkyTools 12. Working with Postgres-XC 13. Scaling with PL/Proxy 14. Scaling with BDR 15. Working with Walbouncer Index

Configuring a simple cluster


In this chapter, we want to set up a cluster consisting of three data nodes. A Coordinator and a GTM will be in charge of the cluster. For each component, we have to create a directory:

[hs@localhost data]$ ls -l
total 0
drwxrwxr-x 2 hs hs 6 Feb 26 01:16 gtm
drwxrwxr-x 2 hs hs 6 Feb 26 01:16 node1
drwxrwxr-x 2 hs hs 6 Feb 26 01:16 node2
drwxrwxr-x 2 hs hs 6 Feb 26 01:16 node3
drwxrwxr-x 2 hs hs 6 Feb 26 01:16 node4

Keep in mind that, to make life simple, we will set up the entire cluster on a single server. In production, you would logically use different nodes for different components. It is not very common to use many XC nodes on the same box to speed things up.

Creating the GTM

In the first step, we have to initialize the directory that handles the GTM. To do so, we can simply call initgtm:

[hs@localhost data]$ initgtm -Z gtm /data/gtm/
The files belonging to this GTM system will be owned by user "hs".
This user must also own the server process.


fixing permissions...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}