That's kinda interesting. I assume the overhead is minimal for serverful applications that run all t

That's kinda interesting. I assume the overhead is minimal for serverful applications that run all the time but is worse for Hyperdrive? Is that message needed only at driver connection time or for all queries?

TTyveris With Aurora DSQL now generally available, any chance we will get improved Hyperd...

AJR•5/30/25, 1:18 PM

That's not currently on our roadmap, but it's something we've kicked around internally a bit.

Ultimately we don't get a lot of requests for it relative to observability/stability/other features, so it's unlikely to happen very soon unless we hear a bunch of people wanting it.

CC @thomasgauvin , in case he has more/different thoughts to share here.

AJR•5/30/25, 1:19 PM

That does raise a good question, though.

How many folks around here are using DSQL in anger? How's your experience been, and is it something you'd be particularly interested in having more robust Hyperdrive support for? I haven't heard a ton about it after the initial launch, aside from the official AWS blog posts, and I'd be very curious to know what everyone is seeing about it.

IIsaac McFadyen That's kinda interesting. I assume the overhead is minimal for serverful applica...

AJR•5/30/25, 3:04 PM

I think that's more or less correct, the round trips are most punishing for short-lived connections that don't re-use the prepared statement much.

That attribute fetch is needed for each new prepared statement, so if you re-run the same query with different params multiple times you only pay the overhead once. If you run N different extended-protocol queries you'll pay the overhead on each one.

dave•5/30/25, 4:06 PM

Still no support for connecting to Hyperdrive from a non-Worker source, right?

Ddave Still no support for connecting to Hyperdrive from a non-Worker source, right?

AJR•5/30/25, 4:07 PM

Correct. Though we're actively keeping an eye on cloudchamber and how we can best integrate with it once it's in a good spot to do so, if you count that.

AAJR That does raise a good question, though. How many folks around here are using...

dave•5/30/25, 4:12 PM

I was interested in DSQL at first, but IMO sticking "regular" AWS RDS Aurora Serverless v2 is way easier. There's a bunch of extra PostgreSQL features that DSQL doesn't support.

dave•5/30/25, 4:16 PM

DSQL also seems like 10x more expensive per query, and 3x more expensive on storage?

Ddave I was interested in DSQL at first, but IMO sticking "regular" AWS RDS Aurora Ser...

dave•5/30/25, 4:17 PM

the lack of foreign keys is pretty terrible

dave•5/30/25, 4:18 PM

imo the main benefit I see of DSQL over RDS Aurora Serverless v2 is support for public IPv6 lol

AJR•5/30/25, 4:20 PM

That all makes sense, thank you!

Muhajir•6/1/25, 2:18 AM

Hey folks, I just got this error today

Hyperdrive does not currently support MySQL multi-statement queries

Hyperdrive does not currently support MySQL multi-statement queries

 (log) 🔍 SQL Query: select `id`, `email`, `name`, `google_id` from `users` where `users`.`email` = ? limit ?
  (log) 📋 Parameters: [ 'muhajirframe@gmail.com', 1 ]
  (log) 🔍 SQL Query: insert into `sessions` (`id`, `user_id`, `expires_at`, `ip_address`, `user_agent`, `payload`, `last_activity`) values (?, ?, ?, ?, ?, ?, ?)
  (log) 📋 Parameters: [
  'd76a430d62722d6e0bced8540fea85dc1e8d1cfe1dcf2127c1b462bed5f5b070',
  6264,
  '2025-07-01 02:05:50.340',
  '2a09:bac5:3a11:18c8::278:7b',
  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36',
  '{"userId":6264}',
  1748743550
]
  (error) 02:05:50 ❌ ERROR Google OAuth error
       {
         "error": "Hyperdrive does not currently support MySQL multi-statement queries",
         "stack": "Error\n    at PromiseConnection.query (server.js:68443:26)\n    at MySql2PreparedQuery.execute (server.js:131993:32)\n    at QueryPromise.execute (server.js:131405:27)\n    at QueryPromise.then (server.js:126940:17)",

 (log) 🔍 SQL Query: select `id`, `email`, `name`, `google_id` from `users` where `users`.`email` = ? limit ?
  (log) 📋 Parameters: [ 'muhajirframe@gmail.com', 1 ]
  (log) 🔍 SQL Query: insert into `sessions` (`id`, `user_id`, `expires_at`, `ip_address`, `user_agent`, `payload`, `last_activity`) values (?, ?, ?, ?, ?, ?, ?)
  (log) 📋 Parameters: [
  'd76a430d62722d6e0bced8540fea85dc1e8d1cfe1dcf2127c1b462bed5f5b070',
  6264,
  '2025-07-01 02:05:50.340',
  '2a09:bac5:3a11:18c8::278:7b',
  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36',
  '{"userId":6264}',
  1748743550
]
  (error) 02:05:50 ❌ ERROR Google OAuth error
       {
         "error": "Hyperdrive does not currently support MySQL multi-statement queries",
         "stack": "Error\n    at PromiseConnection.query (server.js:68443:26)\n    at MySql2PreparedQuery.execute (server.js:131993:32)\n    at QueryPromise.execute (server.js:131405:27)\n    at QueryPromise.then (server.js:126940:17)",

ALECKS•6/4/25, 7:34 PM

Does the local wrangler version of hyperdrive behave the same as prod with regards to caching?

João Castro•6/10/25, 8:34 PM

We seem to be having problems with Hyperdrive during high traffic right now, the ID is b0a82a0544c94249a57d9a17611c9455

João Castro•6/10/25, 8:35 PM

Account ID 978f7d8fe0d7c314743586a46e505f14

João Castro•6/10/25, 8:35 PM

Apparently connections are timing out. Maybe we need to increase the max connections to our origin DB? Could someone help us with this?

AJR•6/10/25, 8:36 PM

Let me take a look

João Castro•6/10/25, 8:39 PM

The connection limit in our origin is around ~900

João Castro•6/10/25, 8:40 PM

So feel free to increase it if thats the problem

AJR•6/10/25, 8:40 PM

Yep, that's going to be 99% of it, you're on the default 60 still

AJR•6/10/25, 8:41 PM

Okay, we'll roll out an increase for you with the next release, put you up to 400. That'll give you about 6x the headroom you've had so far, while still keeping under that 900 if you wind up with two pools during high load

AJR•6/10/25, 8:41 PM

That'll go out by end of next week

AJR•6/10/25, 8:42 PM

Does that work for you?

João Castro•6/10/25, 8:42 PM

We kinda need this for right now, or website in currently down because of this

AJR•6/10/25, 8:42 PM

Ah. Okay, let me see what I can do here.

AJR•6/10/25, 8:42 PM

Sec

AJR•6/10/25, 8:44 PM

going to start cutting this change now. it's going to go out quick, but will take some time

AJR•6/10/25, 8:44 PM

I'll keep you posted via DM

João Castro•6/10/25, 8:44 PM

How much time do you think?

AJR•6/10/25, 8:45 PM

Can't really do this in <2 hours

João Castro•6/10/25, 8:46 PM

Ok, I'll try to create another binding and get connections from both of them instead of just one. Would this work or it limits the pool with the DB id or something like this?

AJR•6/10/25, 8:46 PM

Nope, that'll work for now.

João Castro•6/10/25, 8:46 PM

Nice, thanks

AJR•6/10/25, 8:52 PM

As an aside, this is something we're going to be making self service very shortly. Apologies for this inconvenience

Dan (Openside)•6/13/25, 2:51 AM

hello, wondering if hyperdrive supports dynamic databases. Use case is we create databases on the fly per customer in digitalocean. wondering if we can use the API to create the hyperdrive for each new database, then use them within cloudflare workers without binding them. Is that possible? Also, is the 25 limit per account able to be increased upon request? Is this use case supported for hyperdrive?

AJR•6/13/25, 2:57 AM

That's not a use case we support very well today, but it's something we've been discussing a lot internally, actually. @thomasgauvin has been doing a lot of thinking in that direction and likely has better input on that topic than I do.

AAJR That's not a use case we support very well today, but it's something we've been ...

João Castro•6/13/25, 4:07 AM

This would probably be useful for a product I’m building as well btw

DDan (Openside)hello, wondering if hyperdrive supports dynamic databases. Use case is we create...

1984 Ford Laser•6/13/25, 10:09 AM

Durable Objects not suitable for this?

AAJR Okay, we'll roll out an increase for you with the next release, put you up to 40...

dave•6/13/25, 12:10 PM

Can we see what our current connection count to Hyperdrive is?

AJR•6/13/25, 12:45 PM

If we haven't done an override you're at 60 for paid and 20 for free. Each config gets its own allotment

Ddave Can we see what our current connection count to Hyperdrive is?

thomasgauvin•6/13/25, 2:43 PM

We're planning to work on exposing in the dashboard, along with configurability of connections that you allot to Hyperdrive over the summer

AAJR If we haven't done an override you're at 60 for paid and 20 for free. Each confi...

dave•6/13/25, 2:45 PM

that basically ends up being 60 isolates globally right?

dave•6/13/25, 2:46 PM

bit confused on why hyperdrive can't scale connections very well here; if I have 1,000 requests in an Worker all at once, Hyperdrive can't handle that?

Ddave that basically ends up being 60 isolates globally right?

thomasgauvin•6/13/25, 2:50 PM

Connections are returned to the pool while being unused, so there is definitely more than 60-100 isolates at a time, and this is why we recommend against wrapping everything in a transactions to avoid exhausting connections https://developers.cloudflare.com/hyperdrive/configuration/how-hyperdrive-works/#pooling-mode

AJR•6/13/25, 2:55 PM

Part of the benefit of the split connection approach Hyperdrive uses. You can have a truly absurd number of isolates, the connections to origin are kept separately in their own pool and checked out for the minimum time needed to interact with the origin DB

11984 Ford Laser Durable Objects not suitable for this?

Dan (Openside)•6/13/25, 11:41 PM

you mean using DO for its databases? I need postgresql databases for our use case. If DO ever supports postgres then definitely might consider.

Matt 2•6/15/25, 12:08 PM

Hi, is there any examples of using hyperdrive in nextjs api?

Titan•6/16/25, 2:59 PM

can I connect to hyperdrive from within a worker while using a mysql2 pool? Kysely only supports using mysql connection pools and I'm getting a "the server closed the connection" error

omar•6/16/25, 4:27 PM

unable to configure Hyperdrive with RDS (MySQL) , error attached

(log) 🔍 SQL Query: select `id`, `email`, `name`, `google_id` from `users` where `users`.`email` = ? limit ? (log) 📋 Parameters: [ 'muhajirframe@gmail.com', 1 ] (log) 🔍 SQL Query: insert into `sessions` (`id`, `user_id`, `expires_at`, `ip_address`, `user_agent`, `payload`, `last_activity`) values (?, ?, ?, ?, ?, ?, ?) (log) 📋 Parameters: [ 'd76a430d62722d6e0bced8540fea85dc1e8d1cfe1dcf2127c1b462bed5f5b070', 6264, '2025-07-01 02:05:50.340', '2a09:bac5:3a11:18c8::278:7b', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36', '{"userId":6264}', 1748743550 ] (error) 02:05:50 ❌ ERROR Google OAuth error { "error": "Hyperdrive does not currently support MySQL multi-statement queries", "stack": "Error\n at PromiseConnection.query (server.js:68443:26)\n at MySql2PreparedQuery.execute (server.js:131993:32)\n at QueryPromise.execute (server.js:131405:27)\n at QueryPromise.then (server.js:126940:17)",

That's kinda interesting. I assume the overhead is minimal for serverful applications that run all t

Similar Threads

Similar Threads

Similar Threads