I've created a timestamp column so I can update the rows that I want to force replicate with the current_timestamp. It did the job! Thank you!
2016-01-27 10:16 GMT-02:00 Gustavo Tonini <[email protected]>: > Maybe you can identify updated rows in delta tables and create a script do > force replicate them again so the new server will be fully synchronized. > > On Wed, Jan 27, 2016 at 8:34 AM, Pedro França <[email protected]> > wrote: > >> Thank you for answering my question Gustavo. >> >> I did exactly like that yesterday but only the new data gets synced, I >> want to know if there is a way to sync the data that existed on the other >> two nodes before the third one joins. Maybe create a new sync with the >> option "onetimecopy=1" and "autokick=0" so I can manually kick a fullsync >> copy? >> >> 2016-01-27 0:02 GMT-02:00 Gustavo Tonini <[email protected]>: >> >>> Pedro, >>> Simply register the new node, add it in your sync creating a row on >>> dbmap table and restart bucardo. Validate sync will do all the magic. >>> >>> I dont know if it is the official method but I have used it for years >>> and never had problems. >>> >>> Gustavo. >>> >>> Em ter, 26 de jan de 2016 15:57, Pedro França < >>> [email protected]> escreveu: >>> >>>> Hello guys! I'm testing Bucardo for a multi-master environment and its >>>> been working really well with two nodes so far. They have both started with >>>> the same data and are still synced as inserts are happening on both nodes. >>>> Nice! >>>> >>>> But I wanted to know what is the best way to add a third node on the >>>> cluster with only a schema dump to start and if there is a way to do that >>>> with other two still accepting connection and wrriting. >>>> >>>> Sorry if that type of question is too simple but I couldn't find it >>>> anywhere. >>>> >>>> Thank you in advance. >>>> Pedro Ivo >>>> >>>> >>>> >>>> >>>> _______________________________________________ >>>> Bucardo-general mailing list >>>> [email protected] >>>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general >>>> >>> >> >> >> -- >> >> *PEDRO IVO* | Administrador de Banco de Dados GolSat | Líder em >> Sustentabilidade >> >> [email protected] <[email protected]> | (43) >> 3315.9545 | www.golsat.com.br >> >> >> > > > -- > Gustavo. > -- *PEDRO IVO* | Administrador de Banco de Dados GolSat | Líder em Sustentabilidade [email protected] <[email protected]> | (43) 3315.9545 | www.golsat.com.br
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
