Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2011
    Posts
    71

    [MySQL] Master to master replication/synchronization between different OS

    Hello,

    I tried to perform a master-to-master real-time replication on two different installations (CentOS and Ubuntu) using the tutorial on how to forge (sorry can't post any link here).

    The CentOS part works fine but the Ubuntu MySQl complained that it could not find mysql.server and mysqld_safe when I add those into my.cnf:
    [mysql.server]
    user=mysql
    basedir=/var/lib

    [mysqld_safe]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid


    Does anyone know what is the proper equivalent of these configuration subset in Ubuntu 10.04?

    Thanks!

  2. #2
    Join Date
    Jan 2011
    Location
    Canada
    Posts
    934
    [mysqld] and [mysqld_safe]

    No idea why it would say mysqld_safe couldn't be found though.

  3. #3
    Join Date
    May 2010
    Location
    Toronto, Canada
    Posts
    454
    what does 'show master status\G;' say on the failing master?
    Stack Star | Shift8 Web
    ★ Managed VPS Hosting ★ Managed Wordpress Hosting ★ Managed Dedicated Hosting ★ Web Development ★ Web Design
    Managed Wordpress Hosting Web Design Toronto

  4. #4
    Join Date
    Jan 2011
    Posts
    71
    Mmm...interesting...seems the master is not running as well, do I have to do start master?

    Code:
    mysql> show master status\G;
    *************************** 1. row ***************************
                File: mysqld-bin.000001
            Position: 2619686
        Binlog_Do_DB: *** <- DB name
    Binlog_Ignore_DB: mysql,test
    1 row in set (0.00 sec)
    
    ERROR:
    No query specified
    Quote Originally Posted by kevinnivek View Post
    what does 'show master status\G;' say on the failing master?

  5. #5
    Join Date
    Jan 2011
    Posts
    71
    Here is the error I got:

    Code:
     service mysql start
    Starting MySQL
     * Couldn't find MySQL manager (/usr/local/bin/mysqlmanager) or server (/usr/local/bin/mysqld_safe)
    Quote Originally Posted by tchen View Post
    [mysqld] and [mysqld_safe]

    No idea why it would say mysqld_safe couldn't be found though.

  6. #6
    Join Date
    Jan 2011
    Posts
    71
    and the interesting thing is, this is the only spot in the entire machine that I can find mysqlmanager file:

    /usr/local/mysql/libexec/mysqlmanager
    Quote Originally Posted by zhuanyi View Post
    Here is the error I got:

    Code:
     service mysql start
    Starting MySQL
     * Couldn't find MySQL manager (/usr/local/bin/mysqlmanager) or server (/usr/local/bin/mysqld_safe)

  7. #7
    Join Date
    Feb 2005
    Location
    Australia
    Posts
    5,842
    Do you actually have the mysql-server package installed?
    Code:
    apt-get install mysql-server
    Chris

    "Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them." - Laurence J. Peter

  8. #8
    Join Date
    Jan 2011
    Posts
    71
    Quote Originally Posted by foobic View Post
    Do you actually have the mysql-server package installed?
    Code:
    apt-get install mysql-server
    Yes I have. I have decided to reinstall the whole box and put up an identical setup to save myself some hassle. Thanks for all the input!

Similar Threads

  1. is it safe to restart mysql master server in replication?
    By sweatseo in forum Hosting Security and Technology
    Replies: 5
    Last Post: 02-01-2011, 01:15 PM
  2. MySQL replication masters - need help with CHANGE MASTER retaining logs
    By quad3datwork in forum Hosting Security and Technology
    Replies: 6
    Last Post: 11-08-2010, 01:14 PM
  3. mysql master-slave replication
    By anonymous718 in forum Hosting Security and Technology
    Replies: 3
    Last Post: 07-23-2008, 05:43 PM
  4. Replies: 4
    Last Post: 10-15-2007, 04:28 PM
  5. MySQL master/slave replication delay
    By ricocheting in forum Hosting Security and Technology
    Replies: 2
    Last Post: 02-03-2006, 01:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •