Fishbone°

Results 88 comments of Fishbone°

> The best solution by far is to use QEMU/KVM instead of VirtualBox. Hi, @myspaghetti. How can I run macOS 11/12 in QEMU/KVM under a Linux host? is there any...

```diff type KVStore interface { PutKeyValue(key string, value string) (err error) PutKVPairs(kvPairs []*KVPair) (err error) GetKeyValue(key string) (value string, found bool, err error) + DeleteRecursive(key string) (err error) DistributePairs(kvPairs [](*KVPair))...

Thanks for your reply! One more thing, is `Seconds_Behind_Master` reliable to determine replication lagging? I saw some blog posts that said that it's not reliable to use(better to use `pt-heartbeat`)....

Thanks! https://code.openark.org/blog/mysql/seconds_behind_master-vs-absolute-slave-lag

> > I wonder, can we use Seconds_Behind_Master for ReplicationLagQuery to determine replication lagging? > > If you don't specify `ReplicationLagQuery`, then `orchestrator` uses `Seconds_Behind_Master` by default. Aug 17 11:57:22...

Seems that I cannot extract `Seconds_Behind_Master` solely from the output of `SHOW SLAVE STATUS` (As of MariaDB 10.5.12) ~~`SELECT t.Seconds_Behind_Master FROM (SHOW SLAVE STATUS) AS t;`~~ won't work. [[MDEV-11123] `Seconds_Behind_Master`...

According to https://github.com/openark/orchestrator/blob/master/go/inst/instance_dao.go#L640-L654 ```go if config.Config.ReplicationLagQuery != "" && !isMaxScale { waitGroup.Add(1) go func() { defer waitGroup.Done() if err := db.QueryRow(config.Config.ReplicationLagQuery).Scan(&instance.ReplicationLagSeconds); err == nil { if instance.ReplicationLagSeconds.Valid && instance.ReplicationLagSeconds.Int64 <...

> > > I wonder, can we use Seconds_Behind_Master for ReplicationLagQuery to determine replication lagging? > > > > > > If you don't specify `ReplicationLagQuery`, then `orchestrator` uses `Seconds_Behind_Master`...

As I tested, why I can promote a downtimed instance from replica into master in web UI by graceful-master-takeover?

> If you are willing to make your build accessible to everybody. You can edit the Wiki page at https://github.com/trojan-gfw/trojan/wiki/Binary-&-Package-Distributions. Okay, I'll try some later time.