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

Discussion in 'Server Operation' started by Stephan, Jun 14, 2009.

  1. Stephan

    Stephan New Member


    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
  2. id10t

    id10t Member

    You want to look into replication
  3. Stephan

    Stephan New Member

    can you explain what it is and how to do it?
  4. robertlouwen

    robertlouwen New Member

  5. Stephan

    Stephan New Member

    thanks guys. i'll try Falko tutorial :rolleyes:
    Last edited: Jun 15, 2009
  6. Stephan

    Stephan New Member

    ERROR 1189 (08S01): Net error reading from master

    i get this error :confused:
  7. falko

    falko Super Moderator ISPConfig Developer

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

    Stephan New Member

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

    falko Super Moderator ISPConfig Developer

    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?
  10. Stephan

    Stephan New Member

    yes, i did...

    no errors at mysql restart
  11. falko

    falko Super Moderator ISPConfig Developer

    And why exactly do you think that replication isn't working?
    What's the output of
    on the slave?
  12. Stephan

    Stephan New Member

    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
    Last edited: Jun 17, 2009

Share This Page