Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

How to Run a Database on AWS with Better Performance and Lower Cost

pingcap.com

Post reply on HN
Print view View original

11–17 of 17 posts

Re: How to Run a Database on AWS with Better Performance and Lower Cost

#11

Post by sudeepj »

rubiquity wrote: post #4

Disclosure (I used the right word!): I work at AWS. Opinions are my own. This is a nice article with some fun comparisons and important details around the specifics of operating TiDB and systems like it on AWS. If I were running a replicated database such as TiDB, hypothetically of course, I'd probably opt for an instance type with locally attached storage. EBS volumes are already replicated themselves for durability…

> EBS volumes are already replicated themselves for durability

That is only within the same AZ right? Only snapshots are cross-AZ replicated?

PS: why, oh why ppl use this hard-to-read gray font color? Is there allergy to the black font color on white background?

Re: How to Run a Database on AWS with Better Performance and Lower Cost

#12

Post by rubiquity »

sudeepj wrote: post #11
rubiquity wrote: post #4

Disclosure (I used the right word!): I work at AWS. Opinions are my own. This is a nice article with some fun comparisons and important details around the specifics of operating TiDB and systems like it on AWS. If I were running a replicated database such as TiDB, hypothetically of course, I'd probably opt for an instance type with locally attached storage. EBS volumes are already replicated themselves for durability…

> EBS volumes are already replicated themselves for durability That is only within the same AZ right? Only snapshots are cross-AZ replicated? PS: why, oh why ppl use this hard-to-read gray font color? Is there allergy to the black font color on white background?

That’s right. But AZs can be big and network paths can vary. Always monitor.

Re: How to Run a Database on AWS with Better Performance and Lower Cost

#13

Post by [deleted] »

rubiquity wrote: post #4

Disclosure (I used the right word!): I work at AWS. Opinions are my own. This is a nice article with some fun comparisons and important details around the specifics of operating TiDB and systems like it on AWS. If I were running a replicated database such as TiDB, hypothetically of course, I'd probably opt for an instance type with locally attached storage. EBS volumes are already replicated themselves for durability…

[deleted]

Re: How to Run a Database on AWS with Better Performance and Lower Cost

#14

Post by gregwebs »

jtdev wrote: post #8

I’m not sure how this could be cheaper than RDS...? Nor do I see how the complexity of this solution could be justified except in the most performance sensitive situations.

TiDB is for larger scale data and thus a better comparison would probably be with AWS Aurora. We do see customers saving money by taking on the complexity of operating a database themselves rather than using the AWS offering.

Re: How to Run a Database on AWS with Better Performance and Lower Cost

#15

Post by CharlesW »

tabokie wrote: post #10
CharlesW wrote: post #2

A less clickbait-y title would be, "How to Run Our Database on AWS at a Reasonable Cost". "Reasonable Cost" comes from the conclusion, and I omitted "Better Performance" since they never compare to alternatives (although they do mention Aurora).

Sorry if the title sounds misleading to you. We are simply trying to give our customers (or potentially other cloud database users) a solution that has best performance with limited resources. Competitive analysis is not the focus of this post.

(This advice is offered in the spirit of improving your content marketing efforts.)

I understand the desire to "reel in" more readers than a post might otherwise warrant, but in my experience you're better off not promising general advice if you're not providing it.

For example, you might say, "How we configure TiDB on AWS to handle XXX transactions per second for XXX/month", or "Squeezing the highest TiDB performance from AWS m5 instances". There are definitely interesting ways to title posts in a way that's supported by the content.

Re: How to Run a Database on AWS with Better Performance and Lower Cost

#16

Post by CharlesW »

gkop wrote: post #3
CharlesW wrote: post #2

A less clickbait-y title would be, "How to Run Our Database on AWS at a Reasonable Cost". "Reasonable Cost" comes from the conclusion, and I omitted "Better Performance" since they never compare to alternatives (although they do mention Aurora).

For what it’s worth, there’s a good amount of content in the article that I found interesting for my purposes operating Postgres on RDS.

Interesting. What changes are you making to future Amazon RDS for PostgreSQL instances as a result?

Re: How to Run a Database on AWS with Better Performance and Lower Cost

#17

Post by gkop »

CharlesW wrote: post #16
gkop wrote: post #3

Earlier quoted context omitted.

For what it’s worth, there’s a good amount of content in the article that I found interesting for my purposes operating Postgres on RDS.

Interesting. What changes are you making to future Amazon RDS for PostgreSQL instances as a result?

I bookmarked the article and will consult it next time I’m reviewing instance types for a cluster.
Post reply on HN