[midPoint] Midpoint Repository Load Balancing/Failover

[Kamil Jires]

Hi Jeremiah,

  Thanks for the question. Let me redirect the focus a little bit.

Midpoint using JDBC driver to connect to the database. The native 
repository design expect the postgresql database. In case we put these 
together the focus may be "targeted" to the postgresql JDBC driver which 
seems to natively support it.

By the documentation ( 
https://jdbc.postgresql.org/documentation/use/#connection-fail-over ) 
the example of the syntax may be:

- jdbc:postgresql://host1:port1,host2:port2/database

- jdbc:postgresql://node1,node2,node3/accounting?targetServerType=primary

- 
jdbc:postgresql://node1,node2,node3/accounting?targetServerType=preferSecondary&loadBalanceHosts=true

For sure it would be good to test it. In case of hands-on experience the 
feedback would be appreciated.

Thank you,

  Kamil

On 23/09/2022 22:17, Haywood, Jeremiah via midPoint wrote:
>
> Hey all,
>
> Does anyone know if Midpoint natively supports multiple 
> repository/failover nodes via config.xml 
> (configuration.midpoint.repository.jdbcUrl) or environment variable 
> (REPO_JDBC_URL)? Or would this need to be handled with a proxy in 
> front of the database nodes? Possibly Pgpool or HAProxy.
>
> Thank you,
>
> Jeremiah Haywood
>
> Lead IAM Administrator
>
> Office of Technology Solutions | Illinois State University
>
> Phone Number (309) 438-3829
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> https://lists.evolveum.com/mailman/listinfo/midpoint
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20221006/8ef22e06/attachment.htm>