TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

MySQL Cluster Auto-Recovery

38 pointsby dc352about 6 years ago

4 comments

fiparabout 6 years ago
It&#x27;s worth pointing that &quot;MySQL Cluster&quot; is actually a different product[1] and not what is used in the article (Innodb Cluster or Group Replication).<p>[1]: <a href="https:&#x2F;&#x2F;dev.mysql.com&#x2F;doc&#x2F;refman&#x2F;8.0&#x2F;en&#x2F;mysql-cluster-overview.htmlhttps:&#x2F;&#x2F;dev.mysql.com&#x2F;doc&#x2F;refman&#x2F;8.0&#x2F;en&#x2F;mysql-cluster-overview.html" rel="nofollow">https:&#x2F;&#x2F;dev.mysql.com&#x2F;doc&#x2F;refman&#x2F;8.0&#x2F;en&#x2F;mysql-cluster-overvi...</a>
tyingqabout 6 years ago
<i>&quot;To cut the story short, I had to accept that there is nothing I can do with the networking issues and there are likely to be significant “bursts” of dropped packets that will cause disconnection of our MySQL8 cluster nodes.<p>So we know there is very likely an infrastructure problem. The question is, can we mitigate it on the application layer?&quot;</i><p>That seems unwise. It&#x27;s on DigitalOcean, so they could have migrated to different VPS instances and checked to see if the problem followed.
评论 #19834471 未加载
评论 #19834383 未加载
lefredabout 6 years ago
MySQL evangelist here ;-), for any cluster&#x2F;HA solution relying on multiple machines linked by a network, if you can&#x27;t rely on the network, it&#x27;s very complicated to rely on the solution. This is valid for MySQL InnoDB Cluster but for any other quorum based solution. The third point of the requirements is Network Performance (<a href="https:&#x2F;&#x2F;dev.mysql.com&#x2F;doc&#x2F;refman&#x2F;8.0&#x2F;en&#x2F;group-replication-requirements.html" rel="nofollow">https:&#x2F;&#x2F;dev.mysql.com&#x2F;doc&#x2F;refman&#x2F;8.0&#x2F;en&#x2F;group-replication-re...</a>) maybe we should add &quot;and Reliability&quot; Of course as you may have noticed, 8.0.16 already brings new features helping with a flaky network and even if we will never encourage people to deploy MySQL InnoDB Cluster (Group Replication) on a bad network, we are constantly working on improving the user experience even on such environment.
brataoabout 6 years ago
I recommend looking at TiDB for anyone using a cluster. I still not migrate to it, but from my tests, things are looking great.
评论 #19835646 未加载