Hi Stefan & Dimitar,

Thank you both for your replies. Good to hear that transaction-replication is coming to MonetDB.

Fortunately though we don't require that at the moment because we generally use MonetDB as a read-only backend en do nightly batch updates from an external source. That is exactly why we want to run multiple MonetDB nodes behind a load-balancer so that we can also do (rolling) batch updates during business hours by taking nodes offline/online as needed.

We'll be starting with a proof-of-concept soon to see if it's a feasible idea. Hopefully with the Jul2015 version of MonetDB :)

Best regards,

Dennis

On Tue, Aug 18, 2015 at 1:05 PM, Dimitar Nedev <dimitar.nedev@monetdbsolutions.com> wrote:

Hi Dennis,

There is a small manual on transaction-replication:
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/TransactionReplication

It is currently only available on the Default brach.

Best,
Dimitar

> On 2015-Aug-18, at 10:15 , Stefan Manegold <Stefan.Manegold@cwi.nl> wrote:
>
> Hi Dennis,
>
> very similar setups were the trigger for us to create monetdbd with it's funnel functionality;
> see the "MULTIPLEX-FUNNELS" section of the monetdbd manpage:
> https://www.monetdb.org/Documentation/monetdbd-man-page
>
> Admittedly, this multiplexes / broadcasts queries rather than doing active load balancing.
>
> For the required synchronisation of the multiple database copies, you might want to
> check the new --- so far neither documented nor released --- transaction-replication
> functionality of MonetDB ...
>
> Best,
> Stefan
>
> ----- On Aug 18, 2015, at 9:29 AM, Dennis Pallett dennis@pallett.nl wrote:
>
>> Hi all,
>>
>> We're thinking about running multiple MonetDB servers with the same databases
>> behind a single HAProxy loadbalancer (see attached diagram). Would this be a
>> good idea? bad idea? Any experiences with this kind of setup?
>>
>> We are thinking about this route primarily so that we can bring a new dataset
>> online during business hours without disrupting end-users who are running
>> queries from our application. An additional benefit would be the ability to
>> handle more load and enable horizontal scalability.
>>
>> Any insights would be much appreciated!
>>
>> Best regards,
>> Dennis
>>
>>
>>
>> _______________________________________________
>> users-list mailing list
>> users-list@monetdb.org
>> https://www.monetdb.org/mailman/listinfo/users-list
>
> --
> | Stefan.Manegold@CWI.nl | DB Architectures (DA) |
> | www.CWI.nl/~manegold/ | Science Park 123 (L321) |
> | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list