WordPress running 100% on-chain on the Internet Computer with PHP 8.5 and WASQL

Exciting news here :smiley: Quick update for anyone who’s been following the WASP project: After lots of work, WordPress is now running fully on ICP; frontend and wp-admin. No external database, no off-chain cache, no proxy or TEE VPS. Just canisters.

The thing that was blocking us for months was ICP’s per-message instruction limit. A single WordPress admin page does a lot of work, and it kept blowing past the budget and 503-ing. We didn’t make the limit bigger, we changed the shape of the app so we don’t need it to be.

The new setup is three canisters instead of one:

-Router: a tiny front door with a page cache. Anonymous visitors hit a cached page via a query call, which is basically free and instant. Most of your site’s traffic never even touches PHP.

-Worker: where PHP actually runs. It’s now a wasm64 canister with 8 GB of memory, and it can pause a request when it runs out of budget and resume it on the next call. So a heavy admin page just spans a few messages instead of dying on one.

-WASQL: the database, in its own canister, in stable memory. WordPress talks to it through a normal mysqli driver, so plugins don’t know anything weird is happening.

Result: the public site feels snappy (cache hits are query-fast), wp-admin works.

Admin is running smoothly :slight_smile:

Still rough edges to polish and lot of quirks, first page load is about 7 to 10 seconds, but the architecture wall is behind us.

Take a peek at the basic site here with a minimal theme : https://rnftg-fiaaa-aaaam-abxja-cai.raw.icp0.io/

Wow congrats this is exciting! Maybe DFINITY can provide useful support to help you take this further. Separately to Wordpress, there are probably lots of ways this can be a lightning rod for general improvements to ICP, and we’re looking at a lot of things right now.

Awesome achievement! This is very exciting news.

How much work do you think it would take to allow people to migrate their existing WordPress sites to the IC? I’d be very interested to know what sort of cycle burn rates can be expected for different types of example WordPress sites.

Keep up the great work! :clap:

very awesome. kinda obvious in retrospective despite tech obstacles. lets see if blog based websites have any future but thats another story. is it expensive to run on the ic?

Impressive. Keep up the good work!

Thanks Dom :slight_smile: Would be glad to get whatever help you guys can provide. Will be waiting for a call and until then, will be trying to optimize and speed up the beast.

Hi Lorimer,

Migrating will be very easy, I have a beta Wordpress plugin that will move a site from your hosting to a canister automatically then, only need to change and setup your DNS and everything should be up and running. Cost wise, my expectation for a 10 page site, should be under 15$/month at 80% cache hit and 2000 visits/month. This is a rough evaluation, maybe subject to change :smiley: I have version that is running WooCommerce but it is very slow and consuming, need more work.

For the cost, depends on number of visits, queries and transactions

replying to bump the thread & show support

thank you for making ICP easier to use and to build on!

wen support discuz??