[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