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

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

 

You want to look into replication

 

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

 

@ 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

 

thanks guys. i'll try Falko tutorial

 

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

i get this error

 

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

 

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

 

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

Code:

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

Did you see any errors?

 

yes, i did...

ps
no errors at mysql restart

 

And why exactly do you think that replication isn't working?
What's the output of

Code:

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