[Bucardo-general] Syncing a third master into the cluster

[Pedro França]

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 <gustavotonini at gmail.com>:

> 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 <pedro.franca at golsat.com.br>
> 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 <gustavotonini at gmail.com>:
>>
>>> 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 <
>>> pedro.franca at golsat.com.br> 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
>>>> Bucardo-general at bucardo.org
>>>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>>>>
>>>
>>
>>
>> --
>>
>> *PEDRO IVO* | Administrador de Banco de Dados GolSat | Líder em
>> Sustentabilidade
>>
>> pedro.franca at golsat.com.br <gabriel.zambrim at golsat.com.br> | (43)
>> 3315.9545 | www.golsat.com.br
>>
>>
>>
>
>
> --
> Gustavo.
>



-- 

*PEDRO IVO* | Administrador de Banco de Dados GolSat | Líder em
Sustentabilidade

pedro.franca at golsat.com.br <gabriel.zambrim at golsat.com.br> | (43) 3315.9545
| www.golsat.com.br
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160127/348879d4/attachment.html>