am3n portfolio

My friend asked me how to get MySQL running as Windows standalone application. So he can execute the mysql start-up command by putting it inside his application. So every time his application run, it also start up mysql daemon. He doesn’t want MySQL running as service every time Windows starts as someone can access the data from outside his program. So after couple of times trying, here it is.

Note:

• I am using 3.23.58 version because it’s the simplest mysql binaries for Windows. But for enhanced feature and security, I think it can be done on newest mysql version.
• I assume you save the zip file on drive C:\> and extract it there.

(more…)

Integration Project: as it’s name will integrate all branch infrastructure and operation work flow. In this project my job is to setup servers for 17 branches and 1 big server on HQ. The Branches servers act as child for parent (HQ) server. One way to integrate data, we transferred them using FTP from PDA to Branch Server then to HQ Server or from PDA directly to HQ Server using GPRS technology. So all servers must be configured to act as FTP Server, in this case I choose built-in Windows IIS Server. Then this Integration Server also act as Primary Domain Controller, File Server and Symantec AV Server .

Complete Integration Server Installation Manual – Password required to open

(more…)