Re: [mapserver-users] mapserver connection string with multiple hosts
Typically, this is handled via a load balancer where the connection is pointed at a proxy and the proxy is configured with a list of hosts, not via the connection string, and then decides which host to forward the connection to. -Steve W On 3/18/2019 6:10 AM, Linsenmaier Dierk wrote: Hello altogether, we are running a postgresql cluster with patroni and haproxy. Therefore we'd like to address mutliple postgresql servers via haproxy in one connection string. Haproxy then decides which postgresql servers is master and has to be addressed. Is it possible to address multiple hosts in one connection string in a layer file? For examle something like this: CONNECTION "host=haproxy01,haproxy02,haproxy03 dbname=mydb user=myuser password=mypass port=5000" Thanks and cheers, Dierk --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] mapserver connection string with multiple hosts
Nope, just one host. I mean how would MapServer know which to choose? Does it work referencing just one proxy? From: mapserver-users on behalf of Linsenmaier Dierk Sent: Monday, March 18, 2019 5:10:50 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] mapserver connection string with multiple hosts Hello altogether, we are running a postgresql cluster with patroni and haproxy. Therefore we'd like to address mutliple postgresql servers via haproxy in one connection string. Haproxy then decides which postgresql servers is master and has to be addressed. Is it possible to address multiple hosts in one connection string in a layer file? For examle something like this: CONNECTION "host=haproxy01,haproxy02,haproxy03 dbname=mydb user=myuser password=mypass port=5000" Thanks and cheers, Dierk -- Dierk Linsenmaier Systemtechnik regioDATA Tullastr. 61 79108 Freiburg i. Brsg. Telefon 07621 91943-477 Telefax 07621 91943-465 dierk.linsenma...@regiodata-gmbh.de https://gcc01.safelinks.protection.outlook.com/?url=www.regiodata-gmbh.de&data=02%7C01%7Csteve.lime%40state.mn.us%7C961eacd21f2a4f7f425608d6ab8b195f%7Ceb14b04624c445198f26b89c2159828c%7C0%7C0%7C636885011272670266&sdata=CZ7NLY88oNEPIuO6MwvMxDw2ZKPxTVAQSi4SytMu%2BsQ%3D&reserved=0 regioDATA Gesellschaft für raumbezogene Informationssysteme mbH Sitz Lörrach, Amtsgericht Freiburg HRB 412719 Geschäftsführer: Michael Schade ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fmapserver-users&data=02%7C01%7Csteve.lime%40state.mn.us%7C961eacd21f2a4f7f425608d6ab8b195f%7Ceb14b04624c445198f26b89c2159828c%7C0%7C0%7C636885011272670266&sdata=4vcFt7wYvmCJogqfte3Aw%2Fo3pdJv0mrYVXmMdp8qw1o%3D&reserved=0 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] mapserver connection string with multiple hosts
Hello altogether, we are running a postgresql cluster with patroni and haproxy. Therefore we'd like to address mutliple postgresql servers via haproxy in one connection string. Haproxy then decides which postgresql servers is master and has to be addressed. Is it possible to address multiple hosts in one connection string in a layer file? For examle something like this: CONNECTION "host=haproxy01,haproxy02,haproxy03 dbname=mydb user=myuser password=mypass port=5000" Thanks and cheers, Dierk -- Dierk Linsenmaier Systemtechnik regioDATA Tullastr. 61 79108 Freiburg i. Brsg. Telefon 07621 91943-477 Telefax 07621 91943-465 dierk.linsenma...@regiodata-gmbh.de www.regiodata-gmbh.de regioDATA Gesellschaft für raumbezogene Informationssysteme mbH Sitz Lörrach, Amtsgericht Freiburg HRB 412719 Geschäftsführer: Michael Schade ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users