postgresql 同步 mysql_PostgreSQL的同步级别与MySQL的半同步after_sync比较

MySQL的半同步中通过binlog进行流复制，同步级别和PostgreSQL对比可以发现：

PostgreSQL                MySQL

off

local                         after_commit

remote_write            after_sync

remote_apply

on

所以，整体来说MySQL的日志同步上还是没有PostgreSQL做的严谨，在金融系统中，PostgreSQL的日志同步级别都是设置为on，即日志接收到，apply，然后等待数据刷盘才返回commit的ack。

Specifies whether transaction commit will wait for WAL records to be written to disk before the command returns a “success” indication to the client. Valid values are on, remote_apply, remote_write, local, and off. The default, and safe, setting is on. When off, there can be a delay between when success is reported to the client and when the transaction is really guaranteed to be safe against a server crash. (The maximum delay is three times wal_writer_delay.) Unlike fsync, setting this parameter to off does not create any risk of database inconsist