I have a annoying problem.
My game’s php/content/database/etc… is hosted on joyents scaleable hosting. The flash game connects via sockets to different remote servers depending upon your location. Those servers need to send stats back to the main content server. Kills/Deaths/Etc…
A simple mysql socket connection to my main server from the gameservers wont work, because joyent doesn’t allow remote mysql.
My current plan is to have a 1 minute cron job on each gameserver pushing new game data back to my joyent server. This would be done with php. Any thoughts??? Any other solutions to this headache?