Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer 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
share|improve this answer
    
gr8 thanks for reply, as per point 2 in my shared host i have access to phpmyadmin and cpanel. –  ashofphoenix Mar 21 '13 at 11:27
    
try to create the replication user via cpanel –  altmannmarcelo Mar 21 '13 at 15:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.