Janux — Blog

Hi there this Aug. 1th I get a new year of life, amassing.

This time I’m gad ’cause I just finish some of my life projects, my goals to short time where done … the reflections too and every thing goes just fine.

New adventures and projects are coming !!

Tnks Friends, wife 4 all those years !! and advices

Hi there this time as usual I just play with another server at work, and replicating is really simple and easy check the steps bellow
a) You must have 2 servers running MySQL ( I like MySQL-Max )
b) There will be 2 configurations one p/ server ( Master ) and one per client ( Client ).

—- >Server / Master Side:

1) Edit /etc/hosts.allow and add this line ( you MUST change this IP’s for yours !! )
mysql: 192.168.10.70 192.168.10.13

2) Edit my.cnf …. In my case located at: /etc/my.cnf
* I’m going to show just a what you need the my.cnf file contains much more info.


####### Comment this lines:
bind-address = xxx.xxx.xxx.xxx
skip-networking
####### Make sure this lines exists in the [mysqld] Section:
log-bin=mysql-bin
server-id = 1


3) Now lets move to mysql using a power user like root xD

mysql> GRANT ALL ON databasename.* TO repl@'%' IDENTIFIED BY 'put_some_pass_here';
mysql> FLUSH PRIVILEGES;
mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO repl@'%' IDENTIFIED BY 'put_some_pass_here';


4) restart MySQL service
(more…)

We went to Jiquilpan to enjoy nature and Tapalpa too !

More … go to: Galeria !!

M31 ….. My Friend what can I say …. I’ll miss you !!

You still live in your Friend’s hearth

Condolences to you son and wife.

janux