Re: Duplicate database primary and secondary email server

[Adam Nelson]

According to the documentation, the Group Replication processes can be run over SSL. In which case it should be encrypted. I don't think Group Replication is available in 5.5, however, in 5.7 details on SSL can be found here :

https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html

As for locking the tables .. I haven't had the replication process lock the table. From my understanding there is no need for the replication process to lock the table. It's essentially row based replication at that level. The Primary does the change and replication the change to the row (or rows) impacted. At least that is my understanding of it. The only lock that would occur on the slave would be the row. However, this assumes you are running InnoDB.