mysql_async

MySQL async example

In this example, we showcase how to make async (non blocking) connections to MySQL-compatible databases (e.g., MySQL, MariaDB, TiDB, Aurora etc.) from WasmEdge Rust apps. It utilizes the mysql_async_wasi crate, which is derived from mysql_async.

Install

This example demonstrates making TLS connections to a remote MySQL server. It requires the WasmEdge TLS plugin. The command to install it is as follows.

curl -sSf https://raw.githubusercontent.com/WasmEdge/WasmEdge/master/utils/install.sh | bash -s -- --plugins wasmedge_rustls

Of course, you can connect to MySQL servers without TLS. Just remove features = [ "default-rustls" ] from Cargo.toml and SslOpts from the code. In that case, you will not need to install the wasmedge_rustls plugin.

Usage

You can run the examples against an unencrypted local database using the following commands:

cargo build --target wasm32-wasi
wasmedge --env "DATABASE_URL=mysql://user:[email protected]:3306/mysql" target/wasm32-wasi/debug/crud.wasm

Or, you can use TLS to connect to a cloud database.

cargo build --target wasm32-wasi
wasmedge --env "DATABASE_SSL=1" --env "DATABASE_URL=mysql://user:[email protected]:3306/mysql" target/wasm32-wasi/debug/crud.wasm