Tuesday, December 12, 2006

Mysql multi instance with replication

From mysql 5.0 onwards the the mysql_mutli has been depreciated and it is being taken care by mysqlmanager. The settings and everything is the same and it relies on the my.cnf entirely for the the setup of the instances. You can bind the instances to an IP address or to a different port. The multiple instances can be configured to act as a slave server to a master server. The problem I faced while configuring this setup was because of a route rule. I had given permission for a user from the multi slave server to access the master server. The mutli slave was bond to an IP. So what was happening actually was it would send a request from the default gateway which doesn't have permission to access the mysql server. This can be solved by adding a static route rule to the server from the mysql multi bond IP.

Tuesday, December 05, 2006

Moi back

It's been a while since I have written anything. Lot of things happened in between like got married, moved to a new address, project got postponed, couldn't attend the seminar which I was waiting for, etc. Now I am back very much in sync with the world and hands deep at work. The photo was taken by my cousin Subin at my marriage function. Of the lots I like this image the best.