MySQL Master - Slave Replication

[sirmbhe]

Hello,

I am using vestacp for a while and very happy with it. Now, i am on a project and need some kind of a redundancy.
I am not by any mean a webmaster, in fact i am just a noob whom still learning my way.

Currently i want to setup, a master-slave mysql database replication (this is my first time doing this). I have read some tutorial, and i think i quite understand how it works but already find a difficulties on my first step already. In many tutorial i read, the first step the mention are about changing the "bind-address" setting, on the my.cnf file. (i am using debian, so it is located on /etc/mysql/my.cnf)

I check on the my.cnf and find out, it does not have any "bind-address" setting. So, my question is, where are that "bind-address" config located? Does vesta have a different place to put other mysql config?

If not, is there someone here, help me about how to / tutorial guide of creating mysql master-slave replication between 2 machines, both using vestacp?

Any help would be appreciate, and i really need all the help you can give.
Thanks, and have a nice weekend everybody

----------------------------------------------

Edit :
This is my current mysql my.cnf config on my webserver

Code: Select all

[client]
port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
max_connections=500
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
innodb_file_per_table
innodb_use_native_aio=0
query_cache_size = 128M
tmp_table_size = 128M
max_heap_table_size = 128M
thread_cache_size = 128
query_cache_limit = 1024M
slow_query_log = 1

!includedir /etc/mysql/conf.d/

[skurudo]

I check on the my.cnf and find out, it does not have any "bind-address" setting. So, my question is, where are that "bind-address" config located? Does vesta have a different place to put other mysql config?

In default config - nowhere. You can add this option yourself, manually, by your hands. )

If not, is there someone here, help me about how to / tutorial guide of creating mysql master-slave replication between 2 machines, both using vestacp?

It's not VestaCP case, it's mysql only case. Try read docs - http://dev.mysql.com/doc/refman/5.5/en/ ... howto.html, then use manual - http://www.rackspace.com/knowledge_cent ... asterslave or http://plusbryan.com/mysql-replication-without-downtime