May 2018
Intermediate to advanced
576 pages
30h 25m
English
Let's look at the basic architecture. Typically, individual database servers are referred to as nodes. The whole group of database servers involved in replication is known as a cluster. That is the common usage of the term, but be careful; the term cluster is also used for two other quite separate meanings elsewhere in PostgreSQL. Firstly, cluster is sometimes used to refer to the database instance, though I prefer the term database server. Secondly, there is a command named cluster. It is designed to sort data in a specific order within a table.
A database server that allows a user to make changes is known as a master or primary, or may be described as a source of changes.
A database server that only allows read-only access ...