I cofigured heartbeat wotk great.
If need configuration steps I can post it.
When I stop the master server. Slave goes on.
After that I power on it (slave).
Create new Client on srv1, but there are no replication now.
on srv2 I did not see new client.
in show slave status:
Code:
Error 'Table 'attempts_login' already exists' on query. Default database: 'dbispconfig2'. Query: 'CREATE TABLE `attempts_login` (
`ip` varchar(39) NOT NULL,
`times` int(11) DEFAULT NULL,
`login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8'
How to solve it?
Recent comments
16 hours 58 min ago
1 day 2 hours ago
1 day 3 hours ago
1 day 6 hours ago
1 day 11 hours ago
1 day 11 hours ago
1 day 13 hours ago
1 day 23 hours ago
2 days 4 hours ago
2 days 6 hours ago