主库插入重复主键导致从库不工作了,错误消息如下 Error ‘Duplicate entry ’10… 继续阅读 mysql主从问题 Error ‘Duplicate entry ‘10587590’ for key ‘PRIMARY” on query. Default database: ‘test’. Query: ‘INSERT INTO `user_invite_relation` (`user_info_id`, `parent_id`, `level`) VALUES (‘10592996’, ‘10592991’, ’82’)’

报错信息: Replicate_Wild_Ignore_Table: Last_Errno: 141… 继续阅读 mysql主从出错:Replicate_Wild_Ignore_Table: Last_Errno: 1418 Last_Error: Error ‘This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_tr ust_function_creators variable)’ on query. Default database: ‘test123’. Query: ‘CREATE DEFINER=`root`@`%` FUNCTION `hello`(s char(20)) RETURNS char(50) CHARSET utf8mb4

在node上安装nfs: yum install nfs-common nfs-utils -y