<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello,</p>
<p> the midPoint development and all the tests are done on single DB
node for the repository. Even in the big deployment the "bottle
neck" is usually the amount of the resources and / or the
effective speed of the communication with the resources. There is
usually no need to clustering of the repository for normal
operation. We have no explicit support for the scenario of the
repository on clustered DB. <br>
</p>
<p>There is good support for the clustering on DB side. There is
also support on jdbc driver level for the DB cluster - as you have
mentioned. In case you have good knowledge of postgreSQL DB it
should not be problem to set it up. I think as far as it will be
"transparent" and in case of "delayed" replication (not all nodes
has to confirm the operation to finish it) I don't expect any
issue.</p>
<p>In case of containers the HA can be handled by restarting pod in
case of application issue. In case of data problem on "regular SQL
transaction" ("wrong" update query) the HA cluster would replicate
the operation anyway.</p>
<p>The question of HA has not general answer. It may differs from
environment to environment. I would think about backup(s) and Time
To Recovery. Usually a small outage of the midPoint is not
critical as real time services (e.g. SSO) are handled by other
application(s). <br>
</p>
<p>In case you will work with HA in any form we strongly recommend
to have test environment where you can test your scenario before
applying to the production ! The load balancers are very sensitive
for the misconfiguration. In case you have any in the environment
and facing the issue in communication try to bypass it and access
the resource directly at least for the testing purpose to identify
the root cause of the issue.<br>
</p>
<p>Even the answer is generic I hope it will help you with the
decision.</p>
Best Regards,<br>
<br>
<div class="moz-signature">
<p style="margin: 0px;"><span
style="font-family: 'arial' , 'helvetica' , sans-serif , 'font-size';"><strong>Kamil
Jires</strong> | <span style="font-size: medium;"><small>Identity
Engineer</small></span></span></p>
<p style="margin: 0px;"><span
style="font-family: 'arial' , 'helvetica' , sans-serif;"><a
href="https://evolveum.com/"
rel="nofollow noopener noreferrer nofollow noopener noreferrer"
target="_blank"><img
src="https://evolveum.com/wp-content/uploads/evolveum-email-signature-evolveum-logo.png"
width="299" height="73"></a><br>
</span> <a href="mailto:kamil.jires@evolveum.com"
style="font-size: 13.3333px;"
rel="nofollow noopener noreferrer nofollow noopener noreferrer"
target="_blank" class="moz-txt-link-freetext">kamil.jires@evolveum.com</a>
<span style="font-size: 13.3333px;"> | </span> <a
href="http://www.evolveum.com/" style="font-size: 13.3333px;"
rel="nofollow noopener noreferrer nofollow noopener noreferrer"
target="_blank">www.evolveum.com</a><br>
<span style="font-size: medium;"><small> </small></span></p>
<div style="line-height: 40%;"></div>
<div class="moz-signature"><a
href="https://www.linkedin.com/company/evolveum"
rel="nofollow noopener noreferrer nofollow noopener noreferrer"
target="_blank"><img alt="Evolveum LinkedIn"
src="https://evolveum.com/wp-content/uploads/2017/04/LinkedIn.png"
width="23" height="23" border="0"></a> <a
href="https://twitter.com/evolveum"
rel="noopener nofollow noopener noreferrer nofollow noopener noreferrer"
target="_blank"><img alt="Evolveum Twitter"
src="https://evolveum.com/wp-content/uploads/Twitter-new.png" width="23"
height="23" border="0"></a> <a
href="https://www.facebook.com/evolveum"
rel="noopener nofollow noopener noreferrer nofollow noopener noreferrer"
target="_blank"><img alt="Evolveum Facebook"
src="https://evolveum.com/wp-content/uploads/Facebook.png"
width="23" height="23" border="0"></a></div>
<p style="margin: 0px;"><span style="font-size: 9pt;">Disclaimer:
The contents of this e-mail and attachment(s) thereto are
confidential and intended for the named recipient(s) only. It
shall not attach any liability on the originator or Evolveum
s.r.o. or its affiliates. Any views or opinions presented in
this email are solely those of the author and may not
necessarily reflect the opinions of Evolveum s.r.o. or its
affiliates. Any form of reproduction, dissemination, copying,
disclosure, modification, distribution and / or publication of
this message without the prior written consent of the author
of this e-mail is strictly prohibited. If you have received
this email in error please delete it and notify the sender
immediately.</span></p>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">On 5/3/24 23:14, Crowe, Jared via
midPoint wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CH0PR11MB531348A0ED809E667FC37168A51F2@CH0PR11MB5313.namprd11.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator"
content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<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;}@font-face
{font-family:Aptos;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;}span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;}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"><span style="font-size:11.0pt">Hello.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Is there are
recommended approach for implementing database high
availability? We are considering the dual-host jdbc
connection string as is supported (e.g.
jdbcUrl:postgresql://host1:port1,host2:port2/database) by
PostgreSQL. Is there any support for multiple connection
strings in the midpoint application’s native database
config? What is Evolveum’s recommendation on this concern,
in general.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Thank you.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#13294B;text-transform:uppercase;mso-ligatures:none">JARED
CROWE</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black;mso-ligatures:none"><br>
</span><i><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#13294B;mso-ligatures:none">ASSISTANT
DIRECTOR INTEGRATIONS<o:p></o:p></span></i></p>
<p class="MsoNormal" style="background:white"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#13294B;mso-ligatures:none">Administrative
Information Technology Services</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-ligatures:none"> (AITS)</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black;mso-ligatures:none"><br>
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#13294B;mso-ligatures:none">University
of Illinois System</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black;mso-ligatures:none"><br>
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#13294B;mso-ligatures:none">50
Gerty Dr. #133d | M/C 673</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-ligatures:none"> |
Champaign, IL 61820</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black;mso-ligatures:none"><br>
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#13294B;mso-ligatures:none">217.333.2098
| </span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-ligatures:none"><a
href="mailto:jmcrowe@illinois.edu" target="_blank"
moz-do-not-send="true"><span style="color:blue">jmcrowe@illinois.edu</span></a></span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black;mso-ligatures:none"><br>
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#13294B;mso-ligatures:none"><a
href="http://www.aits.uillinois.edu/"
target="_blank" moz-do-not-send="true"><span
style="color:blue">www.aits.uillinois.edu</span></a></span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#13294B;mso-ligatures:none"> </span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span
style="color:black"><a
href="https://www.uillinois.edu/" target="_blank"
moz-do-not-send="true"><span
style="font-size:11.0pt;color:black;text-decoration:none"><img
style="width:2.6562in;height:.1875in"
id="Picture_x0020_1"
src="cid:part1.3Xz7VMRo.GK758vNh@evolveum.com"
class="" width="255" height="18" border="0"></span></a></span><span
style="font-size:11.0pt;color:black"><br>
<br>
</span><i><span style="font-size:11.0pt;color:#666666">Under
the Illinois Freedom of Information Act any written
communication to or from university employees
regarding university business is a public record and
may be subject to public disclosure. </span></i><span
style="font-size:11.0pt"><o:p></o:p></span></p>
</div>
</div>
</div>
<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>