Let's say I've got 2 zpools -- one with a database's database files and one with the database transaction logs.
If I do a zfs snapshot -r database@snapshot will the resulting snapshots all be taken at exactly the same time? Or will each pool's snapshot be internally consistent but they won't be consistent across pools?