Re: Multiple MonetDB nodes behind HAProxy loadbalancer

Hi Dennis, There is a small manual on transaction-replication: https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/TransactionReplic... It is currently only available on the Default brach. Best, Dimitar

On 2015-Aug-18, at 10:15 , Stefan Manegold 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