<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Jeremiah,</p>
<p> Thanks for the question. Let me redirect the focus a little bit.</p>
<p>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.</p>
<p>By the documentation (
<a class="moz-txt-link-freetext" href="https://jdbc.postgresql.org/documentation/use/#connection-fail-over">https://jdbc.postgresql.org/documentation/use/#connection-fail-over</a>
) the example of the syntax may be:</p>
<p>- jdbc:postgresql://host1:port1,host2:port2/database</p>
<p>-
jdbc:postgresql://node1,node2,node3/accounting?targetServerType=primary</p>
<p>-
jdbc:postgresql://node1,node2,node3/accounting?targetServerType=preferSecondary&loadBalanceHosts=true</p>
<p>For sure it would be good to test it. In case of hands-on
experience the feedback would be appreciated.</p>
<p>Thank you,</p>
<p> Kamil<br>
</p>
On 23/09/2022 22:17, Haywood, Jeremiah via midPoint wrote:<br>
<blockquote type="cite"
cite="mid:CH0PR03MB6050D49CA0CA5A543F2BAC2FE4519@CH0PR03MB6050.namprd03.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}span.EmailStyle19
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hey all, <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you, <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Jeremiah Haywood<o:p></o:p></p>
<p class="MsoNormal">Lead IAM Administrator<o:p></o:p></p>
<p class="MsoNormal">Office of Technology Solutions | Illinois
State University<o:p></o:p></p>
<p class="MsoNormal">Phone Number (309) 438-3829<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="https://lists.evolveum.com/mailman/listinfo/midpoint">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
</body>
</html>