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
6 hours 49 min ago
16 hours 17 min ago
17 hours 6 min ago
20 hours 39 min ago
1 day 1 hour ago
1 day 1 hour ago
1 day 3 hours ago
1 day 13 hours ago
1 day 18 hours ago
1 day 20 hours ago