TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Build Highly Available MySQL Applications Using Amazon Aurora Multi-Master

48 点作者 jinqueeny将近 6 年前

7 条评论

ianamartin将近 6 年前
People need to stop writing stuff about distributed systems if they won’t explicitly talk about the P in CAP theorem.<p>What happens here in the event of a network partition? There are several failure modes possible if I’m reading the diagram right. Network failure between the Aurora node and the shared storage layer.<p>I would expect that to result in a failed transaction and rollback, right? That’s not really all that available though, is it?<p>What about a network partition between availability zones? Maybe your local thinks it has a quorum because it can no longer see a different AZ? What happens when the partition is healed? How do the nodes reconcile? What if you’re working with multiple AZs and you have application nodes in each AZ writing to a cluster of nodes that all think they have a quorum because they can’t see each other?<p>What happens to those writes after the partition? Is every transaction terminated rolled back because us-east-1 can’t see us-west-3?<p>If they aren’t, how do the nodes achieve consensus? Are we doing a mongoDB thing here and just tossing everything after the last shared state? And even if that does work out,<p>What’s going on? And how is it achieved.<p>Look, if you need transactions at all, you most likely need isolation level: serializable. And that’s incredibly hard to get right.<p>Many systems really don’t need any of that at all, but when you need it, it has to be right.<p>This doesn’t address any of the really hardest parts of distributed systems. It doesn’t address why I would take any application at all that stores data in a RDBMS and use this.<p>I’m sure everyone there on that team is working hard. But people have to stop writing about distributed systems like this.
评论 #20652159 未加载
评论 #20653599 未加载
PeterZaitsev将近 6 年前
Amazon Aurora magic is in storage is the case at large extent because RDS was done on the EBS storage which is super inefficient for database workloads. If you use NVMe storage you often get much better performance... and when you can use Database Level replication for high availability <a href="https:&#x2F;&#x2F;www.percona.com&#x2F;blog&#x2F;2017&#x2F;11&#x2F;28&#x2F;best-practices-percona-xtradb-cluster-aws&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.percona.com&#x2F;blog&#x2F;2017&#x2F;11&#x2F;28&#x2F;best-practices-perco...</a> But even if you use EBS the Magic of RocksDB&#x2F;MyRocks may be better than magic of optimized storage as this blog post shows <a href="https:&#x2F;&#x2F;www.percona.com&#x2F;blog&#x2F;2019&#x2F;07&#x2F;17&#x2F;assessing-mysql-performance-amongst-aws-options-part-one&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.percona.com&#x2F;blog&#x2F;2019&#x2F;07&#x2F;17&#x2F;assessing-mysql-perf...</a>
joecot将近 6 年前
The important line is at the very end:<p>&gt; At launch, Aurora Multi-Master supports two node clusters in a single Region. Support for more writer nodes and placement of writers in multiple Regions is planned for future releases.<p>Great to see more high availability options, but yet again it&#x27;s just in the same region. When we see the East region go down entirely more often than single availability zones. At least this time they mention that limitation in the announcement and an intention to fix it later. In the mean time I&#x27;ll stick to our multi-region Galera setup.
etaioinshrdlu将近 6 年前
How cool would it be if we could use multi-master in combination with Parallel Query, global replication, and the serverless option???
评论 #20651606 未加载
ReD_CoDE将近 6 年前
Hi friends, can I ask another question related to MySQL? And maybe AWS!<p>I have a lot of spreadsheets and PDFs as a silo, and I want be able to build a searchable MySQL database from those documents. Does it possible? How?
评论 #20667391 未加载
vijaybritto将近 6 年前
This master slave wording has to change in tech. It&#x27;s 2019
评论 #20658411 未加载
评论 #20657146 未加载
polskibus将近 6 年前
I wish it was open source like MySQL.
评论 #20651926 未加载
评论 #20653446 未加载
评论 #20651834 未加载
评论 #20651919 未加载