View Single Post
  #10  
Old 26th November 2012, 17:32
Captain Captain is offline
Senior Member
 
Join Date: Feb 2009
Posts: 285
Thanks: 79
Thanked 7 Times in 6 Posts
Question

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?

Last edited by Captain; 26th November 2012 at 17:50.
Reply With Quote