Mysql 2 servers, 2 mysql on each server, one database

[Stephan]

Hello,

I need a help with mysql. I currently have two servers and i want on each server to run mysql with the same database\same content. is it a way to mirror mysql?

please help me with that.

my linux: centos5
mysql 5

[id10t]

You want to look into replication

[Stephan]

You want to look into replication

can you explain what it is and how to do it?

[robertlouwen]

@ Stephan

Falko wrote a easy to follow, two pages tutorial for mysql replication.
You can find it here http://www.howtoforge.net/mysql_database_replication

Good luck
Robert

[Stephan]

thanks guys. i'll try Falko tutorial :rolleyes:

[Stephan]

mysql> LOAD DATA FROM MASTER;
ERROR 1189 (08S01): Net error reading from master

i get this error :confused:

[falko]

Use a database dump instead of the LOAD DATA FROM MASTER method.

[Stephan]

Use a database dump instead of the LOAD DATA FROM MASTER method.

i did it, but the content not mirroring on slave mysql :confused:

[falko]

Did you use this command to import the SQL dump on the slave?

mysql -u root -p<password> exampledb < /path/to/exampledb.sql

Did you see any errors?

[Stephan]

Did you use this command to import the SQL dump on the slave?

mysql -u root -p<password> exampledb < /path/to/exampledb.sql

Did you see any errors?

yes, i did...

ps
no errors at mysql restart

[falko]

And why exactly do you think that replication isn't working?
What's the output of
SHOW SLAVE STATUS\G
on the slave?

[Stephan]

And why exactly do you think that replication isn't working?
What's the output of
SHOW SLAVE STATUS\G
on the slave?
i'll try again later this day...

yesterday i tried interworx clustering panel and it sucks, my web site worked 3 times slower with it... so now I'm formating the system again

please check your pm