Cyril SCETBON scetbon at echo.fr
Fri Sep 12 08:09:13 PDT 2008

Andrew Sullivan wrote:
> On Fri, Sep 12, 2008 at 04:00:12PM +0200, Cyril SCETBON wrote:
>   
>> Cause we have a lot of update (14 Millions) to do. It takes 12/14 hours if 
>> we want to keep a replication with a tolerated lag. If we load it directly 
>> on each host in parallel ot takes 2/3 hours. I've used the 
>> alterTableRestore and alterTableForReplication to load data but it stop 
>> replication and I don't want it.
>>     
>
> Wait, you want to bulk load a given table and still be replicating
> that table (because it is receiving data in other transactions)
> _also_?  
yes !!! but the field bulk updated won't be updated by our application 
at the same time
> Forget it.  Can't be done.
>
> A
>
>   

-- 
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 - Bureau 202
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.
************************************



More information about the Slony1-general mailing list