Apache ShardingSphere on Ubuntu 24.04 LTS by cloudimg

## Apache ShardingSphere on Ubuntu 24.04 LTS

Apache ShardingSphere-Proxy is a database middleware that transparently shards, routes, and rewrites SQL across multiple backend databases while exposing a single MySQL/PostgreSQL wire-protocol endpoint to your application. This image is built and maintained by cloudimg on a hardened, fully patched Ubuntu 24.04 LTS base.

### What's included

• ShardingSphere-Proxy 5.5 on OpenJDK 17, speaking the MySQL protocol on port 3307 (loopback)
• A local MySQL 8 backend with a preconfigured logical `sharding_db` (an inline-sharded demo table across two data nodes)
• A unique password generated on first boot (no shared default credential)
• Backend data and proxy logs on a dedicated managed data disk
• Automatic security updates enabled

### Getting started

Retrieve the generated password with `sudo cat /root/shardingsphere-credentials.txt`, then connect with any MySQL client: `mysql -h 127.0.0.1 -P 3307 -u root -p`. Run `SHOW DATABASES` and query the sharded demo table to see routing in action. The deployment guide on cloudimg.co.uk covers defining sharding rules and adding data nodes.