The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Replication: Master/Slave on the SAME dedicated server (different ports?)

Discussion in 'General Discussion' started by erick_paper, Jun 7, 2007.

  1. erick_paper

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16
    HI

    I am getting started reading up on replication. I want a simple thing..not for backup, just for efficient SELECTs. Right now, a huge table of ours gets locked up every time we do an insert and update, so all I need is:

    1. A master that accepts INSERT and UPDATE
    2. A slave that accepts SELECT
    3. This is only for one DB (for one domain). The rest of the domains hosted on my dedicated hosting servers should continue to use the regular MySQL, from my single my.cnf -- which is probably the master?

    Has anyone set something like this up? How would you go about it? The MySQL replication manual site is horrendous in giving step-by-step help, and most of the tutorials google spews out assume that you have several PHYSICAL servers that become master and slave. All I want is perhaps two processes running on the same server.

    Would appreciate some thoughts, or pointers! Many thanks.
     
  2. serv_co_za

    serv_co_za Member

    Joined:
    Jul 18, 2004
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    South africa
    I would also love to know how this could be done,

    Anyone ?
     
  3. serv_co_za

    serv_co_za Member

    Joined:
    Jul 18, 2004
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    South africa
  4. rqsweat

    rqsweat Active Member

    Joined:
    Mar 25, 2003
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    New Jersey
    This would be pretty tricky to do...and probably not reccomended. But if you want to try it, I'd suggest asking for advice on the MySQL Forums.
     
Loading...

Share This Page