has anyone implemented database sharding to scale an osquery backend database ? we’re trying to scale our cloud sql deployment to a large # of instances, and were hoping that we could shard using the

osquery_host_id

key. it seems here that we’d have to deal with this foreign key: https://github.com/kolide/fleet/blob/master/server/datastore/mysql/migrations/tables/20161128234849_CreateTableNetworkInterfaces.go#L33, so im hoping there’s some sort of identifier (or someone who’s had similar experience) that might relate 🙂