Add real-time sync to MySQL
Sync Streams handle partial syncing under the hood, giving every user just the data they need.
replication
HTTP
stream
How data syncs from MySQL to client-side SQLite
PowerSync connects to your MySQL database over TCP with read access to all synced tables and permissions to read binary logs (binlogs).
After an initial snapshot of data is taken, PowerSync subscribes to the binlog stream to capture row-level changes.
PowerSync automatically handles most schema change scenarios in MySQL, with no need for client-side migrations.
PowerSync filters the binlog stream based on configured Sync Streams to sync only the relevant tables and rows.
The PowerSync Service tracks changes to data, allowing for efficient delta syncing to clients.
You define Sync Streams that control which data can be synced by clients. Data is grouped and shared efficiently between users to avoid duplication.
Clients authenticate against the PowerSync Service using JWTs.
The client SDK does an initial sync of data based on the user's Sync Streams subscriptions, and then incrementally keeps it updated in real-time.
Writes are immediately applied locally, and queued for upload to your backend API. The PowerSync client SDK automatically handles failures and retries.
On the client, data is persisted to a SQLite database.
Live reactive queries can be used to update the UI when data changes.
PowerSync uses a server-authoritative architecture with a checkpoint system to guarantee consistency.
Your backend accepts uploaded writes and then applies them to your MySQL database.
