MySQL主从复制（重构板）2.0 使用教程

如果端口号不是3306如何解决

主库删除前一天的二进制日志后,无论怎么添加从库都会同步失败,错误信息提示这个
Last_IO_Error        Got fatal error 1236 from master when reading data from binary log: 'The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires. Replicate the missing transactions from elsewhere, or provision a new slave from backup. Consider increasing the master's binary log expiration period. The GTID sets and the missing purged transactions are too long to print in this message. For more information, please see the master's error log or the manual for GTID_SUBTRACT.'