Cloudflare Developers•9mo ago

Will hyperdrive ever support mysql/mariadb?

IiRazvan2745 Will hyperdrive ever support mysql/mariadb?

Isaac McFadyen•4/10/25, 3:41 PM

As of yesterday it does

iRazvan2745OP•4/10/25, 3:42 PM

Nice

Isaac McFadyen•4/10/25, 3:42 PM

https://discord.com/channels/595317990191398933/1040420029080018945/1359147325305393194

avi•4/10/25, 6:37 PM

any chance someone on the hyperdrive team can give the folks working on the cloudflare vite plugin a gentle nudge. while wrangler dev succesfully polyfills everything required for mysql2 to run, the cloudflare vite plug in doesn't. my best guess is this is due to unenv not handling safer-buffer https://github.com/unjs/unenv/issues/486

GitHub

Add npm shim for `safer-buffer` · Issue #486 · unjs/unenv

Describe the feature safer-buffer used by mysql2 mysql2 3.13.0 └─┬ iconv-lite 0.6.3 └── safer-buffer 2.1.2 it breaks compatibility with cloudflare Additional information Would you be willing to hel...

Aavi any chance someone on the hyperdrive team can give the folks working on the clou...

yevgen•4/10/25, 7:20 PM

done

Ppenalosa Any chance you could put together a reproduction & open an issue on https://gith...

avi•4/11/25, 2:33 PM

sure thing. https://github.com/cloudflare/workers-sdk/issues/8907 thanks for taking a look

GitHub

@cloudflare/vite-plugin throws buffer.hasOwnProperty is not a funct...

Which Cloudflare product(s) does this pertain to? Vite Plugin What versions & operating system are you using? mysql2: ^3.14.0, @cloudflare/vite-plugin: ^1.0.5, wrangler: ^4.10.0 Please provide ...

Original message was deleted

Isaac McFadyen•4/11/25, 5:25 PM

?crossposting #r2

SuperHelpflare•4/11/25, 5:25 PM

Please do not post your question in multiple channels/post it multiple times per the rules at #

welcome-and-rules. It creates confusion for people trying to help you and doesn't get your issue or question solved any faster.

Artem Zhelinskyy•4/11/25, 5:25 PM

ok but there is no answer

AJR•4/11/25, 5:26 PM

I'm afraid nobody in the Hyperdrive channel is going to be able to help with that, friend.

AArtem Zhelinskyy ok but there is no answer

Isaac McFadyen•4/11/25, 5:26 PM

Sure but asking in unrelated channels won't get an answer faster.

Artem Zhelinskyy•4/11/25, 5:26 PM

you think so, but support is suck

Artem Zhelinskyy•4/11/25, 5:27 PM

no answer in 5hours

Artem Zhelinskyy•4/11/25, 5:27 PM

company stop working

ToonyGen•4/12/25, 3:24 AM

Hi, just saw cloudflare will launch container in summer. Is this mean we can use hyperdrive on expressjs/fastapi environment on cloudflare container platform?

TToonyGen Hi, just saw cloudflare will launch container in summer. Is this mean we can use...

Sameer Ali•4/12/25, 5:39 AM

yes, pretty much everything.

fforres•4/12/25, 6:48 AM

Has anyone tested hyperdrive on postgres:17?

Seeing some issues and trying to rule-out possible cases

muqsit•4/12/25, 8:38 AM

does cf offer a way for hyperdrive to connect with private mysql servers ?

muqsit•4/12/25, 8:39 AM

background: i host mysql at 127.0.0.1:3306 and rely on gre tunnels for inter-server communication

muqsit•4/12/25, 8:39 AM

it appears, with hyperdrive you have to expose your server to public ip

Alex•4/14/25, 2:00 AM

So my Hyperdrive connection with MySQL just started throwing errors, or well it started not responding. https://screen.bouma.link/fGflgtK5X2vH5wrX98nZ

From the Cloudflare Dashboard everything is "Active" (Hyperdrive) and "Healthy" (the Tunnel) and cloudflared also is runnign without any log output. But workers connecting throw:

Connection lost: The server closed the connection.

Connection lost: The server closed the connection.

Any clue where to start debugging this? The MySQL server is doing fine and nothing has changed on my end (I was asleep when the incident started). But I expected there to be some visible fault somewhere

Cloudflare side issue?

CleanShot Cloud

Screenshot 2025-04-14 at 03.56.10

Screenshot

Jikyu•4/14/25, 3:57 PM

Any news on manual cache busting for hyperdrive?

EEric The [cloudflare openapi schema for hyperdrive](https://developers.cloudflare.com...

Eric•4/15/25, 4:19 AM

Bumping this here as suggested for visibility

Kiwi•4/16/25, 1:39 AM

I cannot for the life of me create a hyperdrive connection to my Neon PG DB. It is always stuck in "inactive" and returns an error when attempting to use it "SERVER_ERROR: NeonDbError: Server error (HTTP status 530): error code: 1016"
Is there some black magic I need to perform on the Neon side of things (because the hyperdrive side seems super simple)

João Castro•4/16/25, 2:54 PM

Just to make sure, Worker -> Hyperdrive connections count towards the 6 open connections limit?

JJoão Castro Just to make sure, Worker -> Hyperdrive connections count towards the 6 open con...

AJR•4/16/25, 2:54 PM

Yes, they do.

João Castro•4/16/25, 2:54 PM

Thanks!

Ramtin•4/19/25, 5:38 AM

Hi all,
Do we need to create a new SQL connection for every request with Hyperdrive and close it after fetching the data, or should we create a single connection instance and reuse it? The latter approach seems more reasonable to me but it doesn't appear to work on Workers.

plurk•4/20/25, 9:37 PM

We are using hyperdrive with postgres and drizzle which is being called from pages worker functions. We encountered a nasty bug which took a few days to be narrowed to one API call.

API endpoint is beyond simple, does just 1 db query:

const map = await db.query.maps.findFirst({
  where: eq(maps.geoguessrId, params.geoguessrId)
});
if (!map) {
  return json({ mapFound: false }, { status: 404 });
}

return json({
  mapFound: true
});

const map = await db.query.maps.findFirst({
  where: eq(maps.geoguessrId, params.geoguessrId)
});
if (!map) {
  return json({ mapFound: false }, { status: 404 });
}

return json({
  mapFound: true
});

Clients were falsely receiving

mapFound: true

mapFound: true

on occasion. Logging in pages functions is very limited, but we we were able to reproduce the bug by barraging the API with requests until it falsely returns

mapFound: true

mapFound: true

.

The

maps

maps

table doesn't change often - a few modifications a day at best. Seems like a hyperdrive bug to me, but I don't have any evidence to support it except for the info provided above.

plurk•4/20/25, 9:42 PM

The problem does not happen locally. We added

map.geoguessrId !== params.geoguessrId

map.geoguessrId !== params.geoguessrId

as a bandaid fix in a desperate attempt to fix it and it seems to be doing the trick. No idea what map object is being returned, logging would really help

plurk•4/20/25, 9:42 PM

And ye, no caching in hyperdrive conf.

Niveth•4/21/25, 6:31 AM

Hi Hyperdrive team,

Around 2025-04-20 21:34:41:216 UTC, we received a

PostgresError: Internal error

PostgresError: Internal error

from Hyperdrive.

We've reviewed the Hyperdrive troubleshooting documentation (https://developers.cloudflare.com/hyperdrive/observability/troubleshooting/#hyperdrive-specific-errors) and the Cloudflare status page, and haven't found any reported outages during that time.

We're trying to understand if this error is related to our usage pattern, which we might be able to address, or if simply retrying the request is the recommended action.

We can provide our account ID and Hyperdrive ID if that would be helpful for investigation.

Cloudflare Docs

Troubleshoot and debug · Hyperdrive docs

Troubleshoot and debug errors commonly associated with connecting to a database with Hyperdrive.

NNiveth Hi Hyperdrive team, Around 2025-04-20 21:34:41:216 UTC, we received a `Postgres...

AJR•4/21/25, 1:12 PM

Hello!

Yes, a Hyperdrive ID would be helpful so we can double check whether there's anything specific to your usage that might be good to adjust.

In general, we do recommend application-level retries. With a network in the mix, there will always be some queries that fail and it's good to build around that where possible. We do expect to continue to improve our own retry behavior over time, but there will always be some gap because it won't always be clear to Hyperdrive what queries are safe to retry so we are very conservative on that front.

Aalex Is there any recommended way to effectively use hyperdrive caching + postgres rl...

AJR•4/21/25, 1:27 PM

No, we don't have good guidance around that yet. Our architecture is pretty much built around "1 Hyperdrive = 1 user", and trying to use session state to end-run that without letting it corrupt other connections/queries is tricky.

CC @thomasgauvin this is the second time we've had someone bump into this. Might be worth thinking through options here for our upcoming roadmap?

AJR•4/21/25, 2:12 PM

This is something we'll need to tinker with a bit to get a good design that offers security without degrading perf. We have similar challenges around how to handle bypassing caching and potentially similar challenges around replica routing. @thomasgauvin we should see about folding some of that into our design for cache flexibility. It feels like it sits in a similar spot.

midnight•4/21/25, 4:34 PM

I am working on standing up a CF tunnel to connect to a local postgres DB for development tier. I have

cloudflared

cloudflared

running in a docker container and the postgres bitnami contianer running but keep receiving this error when creating my hyperdrive config via Pulumi with v6.1.0:

failed to make http request: POST "https://api.cloudflare.com/client/v4/accounts/<redacted>/hyperdrive/configs": 400 Bad Request {
  "result": null,
  "success": false,
  "errors": [
    {
      "code": 2011,
      "message": "Network connection to the provided database was refused. Please check the that host and port are correct and that the database allows connections from public IP addresses
."
    }
  ],
  "messages": null
}

failed to make http request: POST "https://api.cloudflare.com/client/v4/accounts/<redacted>/hyperdrive/configs": 400 Bad Request {
  "result": null,
  "success": false,
  "errors": [
    {
      "code": 2011,
      "message": "Network connection to the provided database was refused. Please check the that host and port are correct and that the database allows connections from public IP addresses
."
    }
  ],
  "messages": null
}

I can login to the local machine and run the psql connection to connect to the postgres container successfully, I even ran psql using a second container to connect.

AAJR Yeah, before we added support for prepared statements you couldn't use postgres....

alaister•4/22/25, 8:32 AM

Hey, I made the original post on the forum and just want to add some additional details:
I think my assumption that it wasn't caching at all was incorrect. The responses just seem to be a lot slower...

For example my worker with:

await sql`select 'hello' as "message";`

await sql`select 'hello' as "message";`

usually responds in 20-50ms whereas:

await sql`select ${'hello'} as "message";`

await sql`select ${'hello'} as "message";`

usually responds in 200-300ms.

The reason I say my assumption was incorrect is the cached percentage in my hyperdrive dashboard is now showing a high percentage, so it must be something to do with how the caching is working.

I've tried with both

prepare: false

prepare: false

and

prepare: true

prepare: true

and neither seem to make a big difference to the times...

Any help here would be appreciated! My app is able to cache a large percentage of the data, so I could see some serious performance gains if I can work out what's wrong.

oritwoen•4/24/25, 6:08 PM

Emoji not possible on mysql hyperdrive?

Ooritwoen Emoji not possible on mysql hyperdrive?

AJR•4/24/25, 6:11 PM

Currently supports only UTF8 in queries. Most emojii are in UTF8, but I imagine there are plenty that aren't?

AAJR Currently supports only UTF8 in queries. Most emojii are in UTF8, but I imagine ...

oritwoen•4/24/25, 6:17 PM

return ??? after query

Ooritwoen 🚀 return ??? after query

AJR•4/24/25, 6:17 PM

Sorry, I'm not sure what your question is.

oritwoen•4/24/25, 6:19 PM

This text:

"Hello world

"
in normal mysl query (mariadb, mysql) return without change (with emoji),

in hyperdrive, query return:

"Hello world ???"

AJR•4/24/25, 6:21 PM

Hmmmm. Ok, I'll write up a ticket to investigate. Thanks for letting us know.

const map = await db.query.maps.findFirst({ where: eq(maps.geoguessrId, params.geoguessrId) }); if (!map) { return json({ mapFound: false }, { status: 404 }); } return json({ mapFound: true });

failed to make http request: POST "https://api.cloudflare.com/client/v4/accounts/<redacted>/hyperdrive/configs": 400 Bad Request { "result": null, "success": false, "errors": [ { "code": 2011, "message": "Network connection to the provided database was refused. Please check the that host and port are correct and that the database allows connections from public IP addresses ." } ], "messages": null }

Will hyperdrive ever support mysql/mariadb?

Similar Threads

Similar Threads

Similar Threads