I been using couchdb for the past 3.5 years for my previous start up venture. I consider very good at handling couchdb. For what you have explained, you would need a view using sum aggregate function (default couchdb built in function) to calculate cardinality. As for the mysql mirror, one possible way is to perform incremental insertion via cronjob, then a daily full sync.