请输入您要查询的百科知识:

 

词条 Slony-I
释义

  1. Terminology

  2. Unique features

  3. See also

  4. References

  5. External links

Slony-I is an asynchronous master-slave replication system for the PostgreSQL DBMS, providing support for cascading and failover. Asynchronous means that when a database transaction has been committed to the master server, it is not yet guaranteed to be available in slaves. Cascading means that replicas can be created (and updated) via other replicas, i.e. they needn't directly connect to the master.

Terminology

The name "slony" comes from the Russian word "слоны" which means "elephants".[1] This is a reference to the PostgreSQL elephant logo, as well as being a "tip of the hat" to Vadim Mikheev, who came up with some of the core ideas Slony-I uses to work. Note that there is a whole set of related terminology:

slony

is the plural word for elephants, and indicates that a cluster consists of multiple databases

slon

is the singular word for elephant; each replication node is managed by a program named "slon", which aggregate together into the aforementioned "cluster of elephants"

slonik

is the word for a "little elephant," and is the name of the program used to configure the cluster. In effect, the "little elephant" tells the cluster, "here's what you need to do!"

Unique features

Unlike many other replication solutions for PostgreSQL, Slony-I is not tied to any particular version of the database, which makes it possible to upgrade a database cluster one node at a time, without material downtime. (Version 2.0.0 requires PostgreSQL 8.3+, though)

See also

  • PostgreSQL
  • Replication (computer science)

References

1. ^{{cite web| title=Slony-I 2.2.5 Documentation: Slony-I Concepts| url=http://slony.info/adminguide/current/doc/adminguide/concepts.html| date=2016-05-31| accessdate=2017-02-02}}
{{refbegin}}
  • {{cite web

| url=http://www.linuxjournal.com/article/7834
| title=Database Replication with Slony-I
| author=Ludovic Marcotte
| date=2005-04-28
| publisher=Linux Journal
| accessdate=2017-02-02}}
  • {{cite web

| url=http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html
| title=Introducing Slony
| author=A. Elein Mustain
| date=2004-11-18
| publisher=O'Reilly OnLamp
| accessdate=2017-02-02}}{{refend}}

External links

  • Slony-I official website
  • [https://www.enterprisedb.com/resources/tutorials/how-setup-slony-i-replication-postgres-plus Slony tutorial: How to Setup Slony-I Replication with Postgres Plus]
{{database-stub}}

2 : Data synchronization|PostgreSQL

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/11/14 8:35:04