<div><div dir="auto">If there are only 2 nodes, it's better to stick to drbd8.</div><div dir="auto"><br></div><div dir="auto">Yannis</div><div dir="auto"><br></div><br><div class="gmail_quote"><div>On Tue, 29 Aug 2017 at 05:28, Digimer <<a href="mailto:lists@alteeve.ca">lists@alteeve.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 2017-08-28 09:28 PM, 大川敬臣 wrote:<br>
> I'm planning to build two MySQL DB servers that synchronized by DRBD 9.0<br>
> with RHEL 7.3.<br>
> I want to enable checksum-based synchronization by adding "csums-alg<br>
> <algorithm>" to drbd.conf.<br>
> After I read user's guide [5.11. Configuring checksum-based<br>
> synchronization], I had a simple question.<br>
><br>
> The user's guide said :<br>
> "<algorithm> may be any message digest algorithm supported by the kernel<br>
> crypto API<br>
> in your system’s kernel configuration.<br>
> Normally, you should be able to choose at least from sha1, md5, and<br>
> crc32c."<br>
><br>
> My question is , Is there recommendation algorithm for DB server?<br>
> The algorithms (sha1, md5, crs32) are king of old ones. Can I use sha256?<br>
> Is there some reason that sha256 is not used?<br>
><br>
> Please give me any adovices.<br>
><br>
> Thanks,<br>
<br>
This verifies that the blocks are the same on both nodes, not the<br>
encrypt data. So the real question is; How concerned are you that a) two<br>
blocks don't match and b) those differences are just perfectly different<br>
to cause a hash collision/false match?<br>
<br>
The stronger the algorithm, the more load it will place on the system. I<br>
would stick with something fast, maybe md5 at the most.<br>
<br>
This all said, I am not an expert. If someone else says I am wrong,<br>
believe them. :)<br>
<br>
--<br>
Digimer<br>
Papers and Projects: <a href="https://alteeve.com/w/" rel="noreferrer" target="_blank">https://alteeve.com/w/</a><br>
"I am, somehow, less interested in the weight and convolutions of<br>
Einstein’s brain than in the near certainty that people of equal talent<br>
have lived and died in cotton fields and sweatshops." - Stephen Jay Gould<br>
_______________________________________________<br>
drbd-user mailing list<br>
<a href="mailto:drbd-user@lists.linbit.com" target="_blank">drbd-user@lists.linbit.com</a><br>
<a href="http://lists.linbit.com/mailman/listinfo/drbd-user" rel="noreferrer" target="_blank">http://lists.linbit.com/mailman/listinfo/drbd-user</a><br>
</blockquote></div></div><div dir="ltr">-- <br></div><div class="gmail_signature" data-smartmail="gmail_signature">Sent from Gmail Mobile</div>