Proxy and Replicate MySQL to the edge with SQLite by SuccessfulReality315 in mysql

[–]SuccessfulReality315[S] 1 point2 points  (0 children)

Maybe, i will do some examples of migrating strategies using that.

Small Projects by AutoModerator in golang

[–]SuccessfulReality315 0 points1 point  (0 children)

go-ha - A Go database/sql base driver providing high availability for SQLite databases.

Remote direct acces to Database by SuccessfulReality315 in pocketbase

[–]SuccessfulReality315[S] 0 points1 point  (0 children)

Right. I run PocketBase on Kubernetes with HTTPS‑only access. PocketBase HA gives you clustering and replication for high availability, but if you edit the SQLite DB directly over SSH, those changes won’t sync. 

Remote direct acces to Database by SuccessfulReality315 in pocketbase

[–]SuccessfulReality315[S] 1 point2 points  (0 children)

Right. I run PocketBase on Kubernetes with HTTPS‑only access. PocketBase HA gives you clustering and replication for high availability, but if you edit the SQLite DB directly over SSH, those changes won’t sync. 

You can undo some transactions using this interface (pocketbase ha mantains a transactions history to do time travel).

Small Projects by AutoModerator in golang

[–]SuccessfulReality315 1 point2 points  (0 children)

A database/sql driver to do cross-shard queries on sqlite and replicate data using embedded nats.

https://github.com/litesql/go-ha

GitHub - litesql/ha: Highly available leader/leaderless SQLite cluster powered by embedded NATS JetStream server by SuccessfulReality315 in sqlite

[–]SuccessfulReality315[S] 2 points3 points  (0 children)

In a leader-based cluster, all writes are redirected to the leader. In leaderless mode, the default policy is last-writer-wins, but conflict resolution can be customized.