On Tuesday 15 April 2008 07:06:56 Nonong wrote: > Halo Semua, > > Mau tanya, saya kemarin coba bikin server slave MySQL di ubuntu untuk > menjadi backup server utama dari server database MySql saya. > > Di server Master pada /etc/mysql/my.cnf dah terisi baris berikut: > > server-id = 1 > log-bin = /var/log/mysql/mysql-bin.log > > kemudian di mysql dah dikasih perintah: > > GRANT FILE ON *.* TO [EMAIL PROTECTED] (alamat server slave) > identified by 'paijo' (passwd-nya); > > Kemudian restart MySQL > > Di server slave pada /etc/mysql/my.cnf dah terisi: > > server-id = 2 > master-host= 192.168.4.12 // alamat server master > master-user= replicate > master-password= paijo > > Kemudian restart mysql. > > Pertanyaannya, kenapa tidak terjadi perubahan di database mysql server > slave saat di server master ada perubahan data. > > Mohon pencerahan. Terima kasih sebelumnya.
Halo Nonong,
Ada step yang kurang:
Login into slave mysql server, and:
mysql> CHANGE MASTER TO
-> MASTER_HOST='master_host_name',
-> MASTER_USER='replication_user_name',
-> MASTER_PASSWORD='replication_password',
-> MASTER_LOG_FILE='recorded_log_file_name',
-> MASTER_LOG_POS=recorded_log_position;
mysql> START SLAVE;
Coba dibaca2 lagi howto detailnya.
--
Fajar Priyanto | Reg'd Linux User #327841 | Linux tutorial
http://linux2.arinet.org
13:43:57 up 4:57, 2.6.22-14-generic GNU/Linux
Let's use OpenOffice. http://www.openoffice.org
The real challenge of teaching is getting your students motivated to learn.
signature.asc
Description: This is a digitally signed message part.
