[Bucardo-general] Bucardo multi-node replication performance/requirements
Greg Sabino Mullane
greg at endpoint.com
Sun Jun 9 18:16:56 UTC 2013
On Fri, Jun 07, 2013 at 02:56:57PM +0000, Kouzanidis, Antonios wrote:
> 1)However, can bucardo perform master-slave replication with
> a large number of slaves (e.g. 64 slave nodes)?
It should support a large number, but it depends on the work load, e.g.
number of syncs, number of rows changed, etc. Best way is to test your
situation and see.
> Where can I find any documentation/links regarding bucardo performance?
It's asynchronous, so we don't worry too much about copy speed, although
taking more than a second or two to propagate out is unusual. The big overhead
comes from the use of triggers on the affected tables. I've heard figures from
1 to 10% thrown around, but (again) the best way is to measure your own system.
If there is a particular peerormance concern, you can email this list.
> 2) What are the minimum requirements of bucardo installation on a slave node?
>
> For example, do I need to compile Postgres with Perl support on a slave node?
The only requirement is that you have a recent enough version of Postgres (8.4
I think), and a superuser (e.g. bucardo) that can connect to the database.
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130609/96d67c86/attachment.sig>
More information about the Bucardo-general
mailing list