? ? -> MASTER_LOG_POS=3293117;
Query OK, 0 rows affected, 2 warnings (0.01 sec)
--启动从库
slave@localhost[tempdb]> start slave;
Query OK, 0 rows affected (0.01 sec)
--需要注意的是，本文的mysqldump期间，--single-transaction 仅仅对innodb引擎有效
--如果仅使用--master-data，则会开启--lock-all-tables
The --master-data and --single-transaction options can be used simultaneously, which provides a convenient way to
? ? ? make an online backup suitable for use prior to point-in-time recovery if tables are stored using the InnoDB
? ? ? storage engine.