How to Run CockroachDB on a Raspberry Pi

Not even close. It's like Google's Spanner database.

Well, the basic design of Cockroach (assuming no bugs) prioritizes consistency over availability, which means that your data should be safe even if the network is misbehaves arbitrarily. So the really interesting question is, how much availability can you expect?

"Mesh network" implies that the network should reconfigure itself if individual nodes or links fail. That's fine, but it will necessarily take some time to detect a failed connection, which means temporary unavailability while the database performs a leader election. CockroachDB is sharded, so if any single shard loses a majority of its nodes or becomes too badly partitioned, that shard becomes unavailabile until the network is restored. There's a tradeoff here -- if you're willing to accept slower performance, you can increase the number of replicas per shard.

(It's also interesting to think about what happens under heavy load. If the Cockroach daemons are handling requests as fast as they can, then whatever daemon is responsible for the mesh routing decision-making could become starved for CPU, leading to high packet loss or intermittent network partitions.)

What do you mean exactly? It is designed to run across multiple nodes, preferably out of multiple datacenters that don't have common points of failure (network connectivity, power).

But it is designed to run on systems that you control, as opposed to some other peer-to-peer systems.

> how would this work out?

Poorly.