Thanks Isaac, I need to map an input string to a UUID globally with strong consistency. Once that ma

Thanks Isaac, I need to map an input string to a UUID globally with strong consistency. Once that mapping is created, it's placed in KV and read from there until the end of time, i.e. that input string no longer will pass through DO

However I need to do this mapping in chunks of 20-50 with strong consistency, not sure what type of solution I am looking for here

Mmatt Thanks Isaac, I need to map an input string to a UUID globally with strong consi...

Isaac McFadyen•5/22/23, 1:28 AM

D1 is strongly consistent as it stands right now. However when replicas are made available sometime in the future those replicas will likely be eventually consistent.

Isaac McFadyen•5/22/23, 1:29 AM

I'm not sure whether there will be an option to force a read from the primary - I would hope so but I don't know for sure.

Ggrey15 @geelen when D1 is out of beta, will there still be cold-starts? atm, happening ...

Isaac McFadyen•5/22/23, 1:47 AM

Are you using the new backend or the old backend?

Isaac McFadyen•5/22/23, 1:47 AM

(if you don't know or created your DB before 3 days ago you are using the old backend)

Isaac McFadyen•5/22/23, 2:30 AM

Interesting. I'm not sure whether that's expected - someone else here would need to confirm.

TigersWay•5/22/23, 6:45 AM

Hi, Would love a simple confirmation. With the new backend, inserting a null value inserts a 'null' (string) value. The same code was working fine with the old backend.

TigersWay•5/22/23, 6:46 AM

Not great... But good to know

I'll wait

Mozzy•5/22/23, 7:07 AM

Got a couple of new errors I haven't seen before

{
  "message": "D1_ERROR",
  "cause": "Error: D1 storage operation exceeded timeout which caused object to be reset."
}

{
  "message": "D1_ERROR",
  "cause": "Error: D1 storage operation exceeded timeout which caused object to be reset."
}

TigersWay•5/22/23, 7:53 AM

@geelen A simple value passed to bindbind
I don't have a short example but it's something like this
await env.DB.prepare("INSERT INTO myTable VALUES (?)").bind(cf?.city || null).run()await env.DB.prepare("INSERT INTO myTable VALUES (?)").bind(cf?.city || null).run()

TigersWay•5/22/23, 7:56 AM

In real, there's a lot more columns like that. But they all work the same. And I did not change anything between backends

TigersWay•5/22/23, 7:56 AM

OOh OK

Ggeelen ah, sorry, I was doing something wrong. Yes I can reproduce

TigersWay•5/22/23, 7:57 AM

If you need me to test anything, I'll be ready

TigersWay•5/22/23, 8:24 AM

@geelen it should be an easy fix on my side, so no trouble. Where can I catch updates?

TigersWay•5/22/23, 8:32 AM

@geelen Found it. Thanks again!

Ggrey15 will the upcoming read replication fully replicate the primary db, hence the ent...

Hello, I’m Allie!•5/22/23, 9:17 AM

At most, it would replicate to all DO Colos since Durable Objects support is require for D1.

Ggrey15 i assume the current five locations you offer now to put the primary

Hello, I’m Allie!•5/22/23, 9:20 AM

They aren't "locations" so much as hints. It will attempt to spawn the D1 Durable Object somewhere in that region if it can, but that may include many(or no) colos.

Ggrey15 so rather a handful and not 285

Hello, I’m Allie!•5/22/23, 9:30 AM

At current count, there are 27 DO-enabled Colos:

['DEN', 'DFW', 'LAX', 'SEA', 'SJC', 'AMS', 'CDG', 'LHR', 'MAD', 'ARN', 'FRA', 'HAM', 'MXP', 'PRG', 'VIE', 'WAW', 'SIN', 'MRS', 'NRT', 'IAD', 'MIA', 'ATL', 'TPE', 'EWR', 'ORD', 'KIX', 'HKG']

['DEN', 'DFW', 'LAX', 'SEA', 'SJC', 'AMS', 'CDG', 'LHR', 'MAD', 'ARN', 'FRA', 'HAM', 'MXP', 'PRG', 'VIE', 'WAW', 'SIN', 'MRS', 'NRT', 'IAD', 'MIA', 'ATL', 'TPE', 'EWR', 'ORD', 'KIX', 'HKG']

Ggrey15 thanks, and out of curiosity, what are these 285 nodes compared to colos?

Hello, I’m Allie!•5/22/23, 10:06 AM

I would assume those are just the colos themselves. Each colo is comprised of one or more datacenters in the surrounding metro area. At the moment, the DO monitor shows 261 active colos(or at least actively routable). The extra colos may be in China, which I don't have access to since I don't have an ICP license.

Thanks Isaac, I need to map an input string to a UUID globally with strong consistency. Once that ma

Similar Threads

Similar Threads

Similar Threads