Using multiple servers/endpoints

[amotl]

Hi there,

@SchabiDesigns reported a possible flaw over at Python crate using multiple cursors parallel. Thanks.

connection.connection.dbapi_connection.client.active_servers apparently only includes a single element. Specifically, it is the first server configured.

With kind regards,
Andreas.

[amotl]

Thinking about it, I am not sure if and how the SQLAlchemy driver interface can process multiple hosts, and if the CrateDB dialect is properly prepared to handle that right, if at all.

[seut]

I'm not sure if it is really worth to support multiple servers. Even if crate-python supports this, it's more a poor-man round-robin solution and in production I'd really recommend the use of a real load-balancer. So maybe let's remove the support for multiple servers instead?

[amotl]

Thanks. @SchabiDesigns is also asking about the same thing:

→ I think I will go for a load balancer and use that as entry point for the cluster. Do you have a recommendation?

/cc @WalBeh, @hlcianfagna