Tue Apr 1 02:26:10 PDT 2008
- Next message: [Slony1-general] Feature request for next slony version: initial replication of large DBs
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
As said Christopher Brown new commands are coming : CLONE PREPARE and CLONE FINISH to bypass this mecanism see http://lists.slony.info/pipermail/slony1-commit/2008-January/002145.html Henry wrote: > Good morning all, > > I seem to recall (I think it was touched on by someone else) that this > aspect *might* be addressed in a near-future version of slony: > > Given that some users of slony have large (your definition of large will > vary, but let's say DBs in excess of 100GB) databases, and that the > initial replication of a DB can take weeks, would it not be a great idea > to have a more efficient initial 'copy' mode? ie, either allow a user to > dump/restore to all slaves, then start replication from that point > (without truncating/copying/etc), or, build this functionality into slony > so it does the dump/restore, but does not then truncate all tables and > start from scratch? > > For smaller DBs this doesn't present a problem, but for larger DDs coupled > with LARGE clusters, this is a major problem. > > Regards > Henry > > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > -- Cyril SCETBON - Ingénieur bases de données AUSY pour France Télécom - OPF/PORTAILS/DOP/HEBEX Tél : +33 (0)4 97 12 87 60 Jabber : cscetbon at jabber.org France Telecom - Orange 790 Avenue du Docteur Maurice Donat Bâtiment Marco Polo C2 06250 Mougins France *********************************** Ce message et toutes les pieces jointes (ci-apres le 'message') sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. Le Groupe France Telecom decline toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. Si vous n'etes pas destinataire de ce message, merci de le detruire immediatement et d'avertir l'expediteur. *********************************** This message and any attachments (the 'message') are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not recipient of this message, please cancel it immediately and inform the sender. ************************************
- Next message: [Slony1-general] Feature request for next slony version: initial replication of large DBs
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list