1

I have a VPS where I have ssh access and shared host with CPanel. Both have MySQL.

I need to create a master/slave setup among the two server. As per this tutorial: How To Set Up Database Replication In MySQL, I will need to modify the my.conf file.

Is it possible to achieve this with the following permissions on both the servers?

  • VPS

    I have root access with ssh login where I can modify /etc/my.conf file.

  • Shared host

    Cpanel with phpmyadmin.

asked Mar 18, 2013 at 6:35

1 Answer 1

1

if you have MySQL root access on the shared host, there is a change that it works, just make sure that you:

  • Use the VPS as master
  • Enable the shared host ip to connect on vps host
  • run a SELECT @@server_id on shared host and set the vps to use a different one.
  • follow the steps described on tutorial
  • run the CHANGE MASTER TO on SQL tab on PhpMyAdmin
answered Mar 20, 2013 at 19:10
2
  • gr8 thanks for reply, as per point 2 in my shared host i have access to phpmyadmin and cpanel. Commented Mar 21, 2013 at 11:27
  • try to create the replication user via cpanel Commented Mar 21, 2013 at 15:45

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.