Video yükleniyor...

Video Yüklenemedi

Ana Sayfaya Dön

I am once again begging you to put your database servers and application servers in the same region.

1,422,580 görüntüleme • 1 yıl önce •via X (Twitter)

61 Yorum

E profil fotoğrafı
E1 yıl önce

I can do it even better:

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

Incredible.

Jorge Trujillo profil fotoğrafı
Jorge Trujillo1 yıl önce

whoever did the us-east-1 ↔ ap-east-1 combo must already have the open to work picture

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

😂

Dimitris GR 900 Liverpol Fan Account profil fotoğrafı
Dimitris GR 900 Liverpol Fan Account1 yıl önce

People put them in different regions? For reals?

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

@Dimitris_Efsta Sometimes, yes.

Ronan Berder (SF + SG) profil fotoğrafı
Ronan Berder (SF + SG)1 yıl önce

Better yet: use SQLite and have the DB on the same server.

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

What happens when your one server goes down or has a failing disk?

Ronan Berder (SF + SG) profil fotoğrafı
Ronan Berder (SF + SG)1 yıl önce

Litestream + R2 or S3

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

That's cool. My two big questions are: (1) How can to commit writes with acceptable latency? (2) If a node goes down, how fast is a restore? Is one having to take downtime?

Ronan Berder (SF + SG) profil fotoğrafı
Ronan Berder (SF + SG)1 yıl önce

> How can to commit writes with acceptable latency? I use Litestream for backups. If you really want a more complex setup, Turso or D1 is your friend. > If a node goes down, how fast is a restore? Is one having to take downtime? It's a file, pretty fast. Faster than getting a new node set up and the code running. I wasn't taking a dig on Planetscale BTW, I only just realized you work there.

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

No need to apologize! I want to learn more about cool tech.

Ronan Berder (SF + SG) profil fotoğrafı
Ronan Berder (SF + SG)1 yıl önce

In that case, I'd check Limbo from the Turso folks: Sounds like a pretty cool attempt to rewrite SQLite.

Radic Davydov profil fotoğrafı
Radic Davydov1 yıl önce

They should be in the same data center with < 1ms latency.

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

Radic gets it.

nle profil fotoğrafı
nle1 yıl önce

Is there any reason to put them in different regions though? Naturally people just start out on a single region for a long time until they need to scale up multi regions, in that case they still keep db separated in each region

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

@oscarle_x There are cases where multi-region databases are needed for ultra-high durability cases, like financial transactions. I would not recommend having a multi-master setup though. Have one region replicate from the other.

Ben Hollis profil fotoğrafı
Ben Hollis1 yıl önce

What kind of criminal would NOT have their DB in the same region as the app servers!?

Oosta Soroosh profil fotoğrafı
Oosta Soroosh1 yıl önce

what's the difference between the first and the second one?

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

Intra-AZ vs inter-AZ. For further reading check this out:

Patrick Kuhnke profil fotoğrafı
Patrick Kuhnke1 yıl önce

What about not using a database at all?

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

@ku_ds17868 Interesting. Say more.

Patrick Kuhnke profil fotoğrafı
Patrick Kuhnke1 yıl önce

So the state of your application is stored in memory on the server and serialized to disk. You still need to make sure that the server is nearby though.

Jonathan profil fotoğrafı
Jonathan1 yıl önce

People don’t do this????

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

Some don't!

Jonathan profil fotoğrafı
Jonathan1 yıl önce

Diabolical behavior

Jamie Turner profil fotoğrafı
Jamie Turner1 yıl önce

Are there people who don't do that?

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

This tweet is to ensure we eliminate the few that do 🫡

Holly Guevara profil fotoğrafı
Holly Guevara1 yıl önce

He can't keep getting away with this

Ernesto Diaz profil fotoğrafı
Ernesto Diaz1 yıl önce

Care to explain this one?

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

Check out

𝒫𝑒𝓇 𝒜𝓇𝓃𝑒𝓃𝑔 【🐧λ🦀⎈】 profil fotoğrafı
𝒫𝑒𝓇 𝒜𝓇𝓃𝑒𝓃𝑔 【🐧λ🦀⎈】1 yıl önce

Same availability zone even.

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

Absolutely! We shouldn't rely on same-AZ since we generally need to replicate across multiple AZs for high-availability, but this is certainly optimal.

Tyler F. Cloutier profil fotoğrafı
Tyler F. Cloutier1 yıl önce

I am once again asking you to put your database servers and application servers in the same process. @spacetimedb

PRIZ ;] profil fotoğrafı
PRIZ ;]1 yıl önce

I am once again begging you to STOP USING SPEED BALLS

Marc Steele profil fotoğrafı
Marc Steele1 yıl önce

Load balancers in Australia, app servers in the US and database in Europe. Think I’ve got it. Thanks for the tip!

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

@steelegbr 😅

Jamie Voynow profil fotoğrafı
Jamie Voynow1 yıl önce

@levelsio wait but I thought python was the bottleneck not the database ? 🤣

AJ Stuyvenberg profil fotoğrafı
AJ Stuyvenberg1 yıl önce

You and these balls man, you can't keep getting away with this

NightinWolf profil fotoğrafı
NightinWolf1 yıl önce

anything below 100ms is a decent result. misleading video.

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

For a full website page load, sure. For for a single round-trip from application to database, 100ms is far too long.

NightinWolf profil fotoğrafı
NightinWolf1 yıl önce

you have extreme expectations which i admire as I see you are involved with planetscale. big ups for that. but no website gets such result. i clicked on your reply and according to firefox, it took 735ms. so by ur standards, twitter is taking way way toooo long.

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

Sure, but loading page on X easily requires 10, 20, or even 50+ queries for a single web page load. Every millisecond we can shave off each query adds up.

etkaute profil fotoğrafı
etkaute1 yıl önce

This graphic scratches an itch in my brain

Jackson profil fotoğrafı
Jackson1 yıl önce

cool visual, but pretty sure nobody is doing this

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

Unfortunately it does happen.

Agustin Falaz profil fotoğrafı
Agustin Falaz1 yıl önce

us-east-1 talking to ap-east-1 is a vibecoded TODO app or admin panel

kortress profil fotoğrafı
kortress1 yıl önce

As far as I know, if they are in different regions, extra fee exists.

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

Yeah, this is true even of cross-AZ traffic. My understanding is that AWS charges bandwidth fees for traffic that's not within the same AZ.

Jeferson profil fotoğrafı
Jeferson1 yıl önce

Edge computing can be a good strategy.

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

Edge is great for caching resources and such. You have to be careful about connecting to a centralized database from far-away edge nodes though.

Rajiv Khaneja profil fotoğrafı
Rajiv Khaneja1 yıl önce

For certain workloads put your database and application on the same server. I've seen 10x increase in requests/sec

network_pun profil fotoğrafı
network_pun1 yıl önce

why do we need to keep inventing pretty pictures to say "latency exists"?

lala profil fotoğrafı
lala1 yıl önce

Nice visual

Devaansh Bhandari profil fotoğrafı
Devaansh Bhandari1 yıl önce

I'm not very experienced with infrastructure, but don't companies keep servers in different locations to reduce latency and for failover backup? For example, if the US server goes down, can it connect to the CA one? How is failover usually handled?

Alex Havryleshko profil fotoğrafı
Alex Havryleshko1 yıl önce

It started concerning me recently actually. I didn’t understand latency. With each query, the request travels across the network. Good rule of thumb in system design: configure it for the same region, and ideally same availability zone.

Josh Stein profil fotoğrafı
Josh Stein1 yıl önce

where can I slide it all the way?

Scott | 1A x 2A 🇺🇲 profil fotoğrafı
Scott | 1A x 2A 🇺🇲1 yıl önce

Does Planetscale have a presence in each of these AWS datacenters? How does the cost compare to RDS?

Ben Dicken profil fotoğrafı
Ben Dicken1 yıl önce

We've got this info on our pricing page:

Chase Miller profil fotoğrafı
Chase Miller1 yıl önce

The cost savings is huge too.

Jake Casto profil fotoğrafı
Jake Casto1 yıl önce

Explain Neon using balls

Benzer Videolar