IIRC it used to be the recommendation to use `prepare: false` on certain DBs but no longer

IIRC it used to be the recommendation to use

prepare: false

prepare: false

prepare: false

prepare: false on certain DBs but no longer

IIsaac McFadyen IIRC it *used* to be the recommendation to use `prepare: false` on certain DBs b...

AJR•4/5/25, 5:46 PM

Yeah, before we added support for prepared statements you couldn't use postgres.js at all without it. Happy to have that sorted out now.

Walshy•4/5/25, 5:47 PM

Info like this is good for the knowledge bank and runbook

Isaac McFadyenOP•4/5/25, 5:49 PM

If it's not in the docs it might be a good addition to some sort of "troubleshooting" section too

AJR•4/5/25, 5:49 PM

Agreed. I think @thomasgauvin has added a section like that, or an FAQ, recently.

AJR•4/5/25, 5:49 PM

I'll check in with him and add a mention of it.

The Infinite•4/7/25, 9:32 PM

I can use hyperdrive with anything? Hmm, gotta try it out with Diesel

TThe Infinite I can use hyperdrive with anything? Hmm, gotta try it out with Diesel

AJR•4/7/25, 9:39 PM

Recommended drivers are postgres.js and node-postgres. For Rust use, I'd recommend tokio-postgres with the query_typedquery_typed and query_simplequery_simple patterns.

TThe Infinite I can use hyperdrive with anything? Hmm, gotta try it out with Diesel

AJR•4/7/25, 9:40 PM

We haven't tested with Diesel, so YMMV.

Cchimame We are currently investigating when this problem started, but when connecting to...

AJR•4/8/25, 2:54 AM

Nope, we're observing high latencies as well, as of about 21:00 UTC. Just adjusted some things and are seeing it come back down towards normal levels now.

AJR•4/8/25, 2:55 AM

It should be back to standard within an hour, at the rates we're seeing.

AJR•4/8/25, 3:01 AM

I'll update here when the changes are all the way out and we should be back to baseline (it's about halfway, right now).

AJR•4/8/25, 4:00 AM

Alright, looks like we're back to baseline latencies. CC @chimame

AAJR We haven't tested with Diesel, so YMMV.

The Infinite•4/8/25, 7:02 AM

Diesel uses sqlx under the hood I believe

The Infinite•4/8/25, 7:02 AM

I'd have to see

TThe Infinite Diesel uses sqlx under the hood I believe

AJR•4/8/25, 10:33 AM

Ah, I didn't know that. sqlx is not well supported today, I'm afraid.

It sends explicit Close messages that chew up an extra round trip instead of just dropping the connection and letting the origin DB garbage collect the prepared statements it generated, and that's not something we support currently. The bookkeeping for that is surprisingly complicated for a tx-mode pooler, and there would be a big performance penalty for doing it naively. I've poked at it a couple times.

AAJR Ah, I didn't know that. sqlx is not well supported today, I'm afraid. It sends...

The Infinite•4/8/25, 10:36 AM

It might be using tokio-postgres too though, I am really not sure

The Infinite•4/8/25, 10:36 AM

Since I am using Deadpool for pools with diesel-async

The Infinite•4/8/25, 10:38 AM

Well, aparently it uses libpg directly

The Infinite•4/8/25, 10:38 AM

This is the maintainer

The Infinite•4/8/25, 10:38 AM

I know him

The Infinite•4/8/25, 10:40 AM

I was wondering...

The Infinite•4/8/25, 10:41 AM

Wait I shall ask on #off-topic

Matt Silverlock•4/8/25, 1:00 PM

@Hyperdrive Two big ones today for Hyperdrive:

Hyperdrive now supports MySQL: https://developers.cloudflare.com/changelog/2025-04-08-hyperdrive-mysql-support/
... and it's now on the Workers Free plan: https://developers.cloudflare.com/changelog/2025-04-08-hyperdrive-free-plan/

AJR•4/8/25, 1:03 PM

Heyyyyy there we go. :soontm: has arrived! I can finally talk about MySQL stuff.

AJR•4/8/25, 1:20 PM

Ah, also. Here's a blog on now Hyperdrive actually works. We're finally able to really get into the weeds of it, and I had a blast writing this.

https://blog.cloudflare.com/how-hyperdrive-speeds-up-database-access/

The Cloudflare Blog

Pools across the sea: how Hyperdrive speeds up access to databases ...

Hyperdrive, Cloudflare's global connection pooler, relies on some key innovations to make your database connections work. We go deep into the details of what that looks like, in celebration of announcing its availability for Free Plan customers.

nubb•4/8/25, 1:24 PM

Cloudflare is the best

AAJR Ah, also. Here's a blog on now Hyperdrive actually works. We're finally able to...

Isaac McFadyenOP•4/8/25, 1:26 PM

This is a very neat blog post/deep dive, thank you!

Isaac McFadyenOP•4/8/25, 1:31 PM

I remember the SQC days :lul:

Isaac McFadyenOP•4/8/25, 1:31 PM

We never knew what it was and had to guess what the acronym was when it showed up :lul:

IIsaac McFadyen I remember the SQC days :lul:

AJR•4/8/25, 1:33 PM

Funnily enough I didn't join Cloudflare until after it had a product name, so I kept wondering what this competing product was I kept seeing references to in code/docs. Eventually someone noticed and clued me in....

MMatt Silverlock @Hyperdrive Two big ones today for Hyperdrive: * Hyperdrive now supports MySQL: ...

thomasgauvin•4/8/25, 1:54 PM

Super excited for these two to land! We've been putting a ton of work to make Hyperdrive your go-to choice, looking forward to getting all the feedback!

<@235148962103951360>•4/8/25, 1:56 PM

cloudflare is the goat

<@235148962103951360>•4/8/25, 1:56 PM

Mmariano Great news!, I was trying to test it connecting to my MYSQL 8 server in a GCP in...

AJR•4/8/25, 2:50 PM

We tested in GCP and do support it. We also explicitly do support mysql_native_passwordmysql_native_password. I'm surprised, that's basically the happy path for us.

@thomasgauvin first bit of beta feedback here. I'll defer to you on the best way to capture details here.

Nick•4/8/25, 3:02 PM

I'm super excited for mysql hyperdrive. I am wondering, there was a question a year ago about read replicas. It sounds like that's not necessarily supported right now?

AJR•4/8/25, 3:03 PM

Not at the moment, no. It's still something we're looking at doing, but no firm commitments on whether/when just yet.

Nick•4/8/25, 3:03 PM

okay, i guess one option is to have two clients, one for writing and one for reading, and use hyperdrive for writing?

AJR•4/8/25, 3:04 PM

That's one option. It's probaly more performant to have hyperdrive for both, imo. Just point the reading configs at your replicas. Our internal teams do it that way for the moment.

Nick•4/8/25, 3:05 PM

okay, if i have geographically distributed read replicas is it smart enough to have endpoints in multiple regions?

Nick•4/8/25, 3:05 PM

or would i need to know which read replica to point to?

AJR•4/8/25, 3:06 PM

Ah. Unfortunately the second one, for now. That gap is why we're considering building in proper support.

Nick•4/8/25, 3:06 PM

right, gotcha

Nick•4/8/25, 3:07 PM

im not sure if planetscale has a way to point to a specific replica, will need to dig into it. thanks!

AAJR Ah. Unfortunately the second one, for now. That gap is why we're considering b...

kunal•4/8/25, 4:01 PM

For now, we have multiple hyperdrives (one for each replica), and use the cf geolocation headers to pick the right DB. But would be very excited to get rid of that custom logic and let Cloudflare route to the actual closest DB

AAJR Alright, looks like we're back to baseline latencies. CC @chimame

kunal•4/8/25, 4:04 PM

We got a bunch of alerts last night as well, and couldn't find any issues wrong with our Postgres instances so assumed it was Hyperdrive. Any chance these can be added to Cloudflare status in the future so it's a little easier to tell if its our fault or not?

Kkunal We got a bunch of alerts last night as well, and couldn't find any issues wrong ...

AJR•4/8/25, 4:17 PM

That's reasonable. Let me talk to the team about it and get back to you.

KingMaker•4/8/25, 4:37 PM

@AJR hey. Needed a little help with scaling hyperdrive.

We currently use Postgres with neon and we are currently hitting connection limits (1M requests per minute). We’ve plugged in hyperdrive and got it working but will occasionally hit connection limits.

Any pointers?

IIRC it used to be the recommendation to use `prepare: false` on certain DBs but no longer

Similar Threads

Similar Threads

Similar Threads

IIRC it *used* to be the recommendation to use `prepare: false` on certain DBs but no longer

Similar Threads

Similar Threads

Similar Threads

IIRC it used to be the recommendation to use `prepare: false` on certain DBs but no longer