I have been trying a couple of hours today to sort out the multiple instances of Mysql running in the same box of linux.
According to mysql website only a copy of binaries is required. Today I manage to launch the instances listening in different port and socket file. Importantly you need to specify a different data directory.
Run mysql_db_install --user=mysql --datadir=/xxxx
After several weeks I resigned from BP, it was reported in reuters news today that BP CEO Tony Haywood has also resigned in wake of the worst oil spilt history in America. He will be replace by Rob Dubly whom two years ago was fleeing out of Russia when the TNK BP join venture went sour.
Coming from an Oracle background, there some learning steps for me to pick up Mysql.
We are using Mysql very 5.148, the latest on Ubuntu. One important feature is to enabled log_bin=on in /etc/my.cnf file. This is equivalent to archive logs feature.
Next we need to take care on how to archive these bin logs before it fills up. I have a cron script that runs and remove binary logs that are a couple of days old. Alternatively, there is a parameter 'expired%' that can specify the validity of binaries log before removed by system.
Come Monday mark as a new beginnings of my career life. For past three and half years, I have contributed and developed myself to prepare for new challenge ahead.
