Cluster solution for Postgresql 9.5

Поиск
Список
Период
Сортировка
От Poul Kristensen
Тема Cluster solution for Postgresql 9.5
Дата
Msg-id CAAOuvVoosWkuc7tFwJArMhxjwNmfJ5JUmypVQBfFiK6BT72Ngg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Cluster solution for Postgresql 9.5  (Scott Mead <scottm@openscg.com>)
Список pgsql-admin
Hi !

According to the documentation a shared disk failover is possible as shown below.
According to discussions on the Internet it is a problem missing 1-2 seconds
in a failover situation.
Does anyone know of the latest news in this case?

 Comparison of Different Solutions

Shared Disk Failover

Shared disk failover avoids synchronization overhead by having only one copy of the database. It uses a single disk array that is shared by multiple servers. If the main database server fails, the standby server is able to mount and start the database as though it were recovering from a database crash. This allows rapid failover with no data loss.

Shared hardware functionality is common in network storage devices. Using a network file system is also possible, though care must be taken that the file system has fullPOSIX behavior (see Section 17.2.2). One significant limitation of this method is that if the shared disk array fails or becomes corrupt, the primary and standby servers are both nonfunctional. Another issue is that the standby server should never access the shared storage while the primary server is running.

TIA !

Poul

В списке pgsql-admin по дате отправления:

Предыдущее
От: Thomas SIMON
Дата:
Сообщение: Re: Wrong stat on pg_stat_user_tables
Следующее
От: Scott Mead
Дата:
Сообщение: Re: Cluster solution for Postgresql 9.5