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

[erick_paper]

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.

 

[serv_co_za]

I would also love to know how this could be done,

Anyone ?

 

[serv_co_za]

Hi,

Tried following this article "skipping the removal steps" but also not working, http://www.cobaltfaqs.com/index.php/Install_MySQL_from_Source

Only one know how to get this to work ?

 

[rqsweat]

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.