On Jan 27, 2010, at 7:30 AM, Chan Chung Hang Christopher <christopher.c...@bradbury.edu.hk > wrote:
> > mysql's isam tables have a reputation for surviving just about > anything > and great builtin replication support... > > postgresql less so (I suspect due to fake fsync/fsyncdata in the days > before barriers) but maybe things have improved a lot nowadays. It has changed a lot since then, where it depended on the OS' fsync routine to assure data integrity. Now it uses barriers (where supported). But if your doing mysql on top of LVM your basically doing the same, cause LVM (other then current kernels) doesn't support barriers. Still if you have a battery backed write-caching controller that negates the fsync risk, LVM or not, mysql or postgresql. -Ross _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
