Best way to host MYSQL on Mac?

[gsrock76]

I am about to take over the hosting of a MYSQL db. I am wondering what is the best way to go about it. I have an old G4 (350 Mhz) 512Mb RAM and a 500 Mhz iMac G3 (256 Mb RAM) that I can use for a server. I can easily swap RAM.

I have software CDs & licenses for OS 10.3, 10.4 and OS X server 10.0.3 (no built in MYSQL support). I could also purchase Server 10.3 (Built in support for MYSQL).

What combination of hardware & software would be most advantageous?

Thanks
Gary

 

[macworks]

Well the iMac G3 is the one that you wish to use as the server and it does have a faster processor, so I would go with that. I would also feel totally comfortable with either 10.3 or 10.4 client on them. Server is not necessary and especially and old version of server like that.

10.3 would run better with 256 MB of RAM than 10.4, but either way, I would get more RAM for both machines if you want to get good performance out of them.

I've been developing dynamic web sites for several years now and utilize MySQL and PHP on my machines to accomplish those tasks. Additionally, I've been a Mac Sales and Service specialist (including Mac OS X Server) for nearly a decade now.

If I can be of any further assistance, please feel free to visit my site and contact me through iChat (link on my site): http://www.macworks.biz/

 

[cfr]

You don't need Mac OS Server to host MYSQL unless you prefer to do it that way. I'm running such a server on my laptop and the only reason nobody elsewhere can connect to it is that I set it up that way, have the firewall running without opening any of the ports for services of this kind etc. I have the free and, in some loose sense of the term, open-source version of MYSQL, but you'd obviously need to purchase that if the free licence doesn't allow you to use it in the way you want.

Most of the functionality of Server is also in Client, though not everything, but Server has GUI applications to configure functions that have to be configured in some other way in Client. I don't know much about Server never having used it, though, so don't take my word for this.

- cfr