多个不同的主从复制数据库在同一台服务器上

huangapple go评论69阅读模式
英文:

Multiple different master-replication databases on one server

问题

我想知道是否可以在单个Firebird服务器上实现多个不同的主从复制。

也就是说,在一个Firebird服务器上有多个主数据库,它们分别复制到另一个服务器上的相应副本。

文件 - replication.conf:

#主库侧

database = /your/db.fdb
{
  journal_directory = /your/db/journal
  journal_archive_directory = /your/db/archive
  journal_archive_timeout = 10
}

database2 = /your/db2.fdb
{
  journal_directory = /your/db2/journal
  journal_archive_directory = /your/db2/archive
  journal_archive_timeout = 10
}

我已经尝试过类似的配置。但它只能识别其中一个。

英文:

I would like to know if it is possible to have multiple different master-slave replications on a single Firebird server.

That is, several masters on a Firebird server, replicating to their corresponding replicas on another server.

file - replication.conf:

#master side

database = /your/db.fdb
{
  journal_directory = /your/db/journal
  journal_archive_directory = /your/db/archive
  journal_archive_timeout = 10
}

database2 = /your/db2.fdb
{
  journal_directory = /your/db2/journal
  journal_archive_directory = /your/db2/archive
  journal_archive_timeout = 10
}

I already tried something like that. But it only recognizes one.

答案1

得分: 1

user13964273的评论中提到,您需要在replication.conf中的所有条目中使用database = <path>

它不像databases.conf那样工作,您不需要创建<alias> = <path>形式的条目,只需对要复制的每个数据库使用database = <path>

英文:

As mentioned in the comments by user13964273, you need to use database = &lt;path&gt; for all entries in replication.conf.

It doesn't work like databases.conf where you create entries as &lt;alias&gt; = &lt;path&gt;, it is just plain database = &lt;path&gt; for each and every database you want to replicate.

huangapple
  • 本文由 发表于 2023年7月27日 22:38:52
  • 转载请务必保留本文链接:https://go.coder-hub.com/76780849.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定