With sales pouring in for SniperSpy in all direction, our current host Omnis.com got weird about the amount of flow of data happening there. First they had put a limit of 40,000 files per domain! Crap! Second, the backend MySQL database ran out of order, that one of the record table ceased creating new entries. The auto index value had reached over 3.3 million and currently there are over 1.2 million records. The table went down…
We have to do something, and really quick, me and James decided to make it get going first, so I created another table of same structure and changed the codes to use the new table instead of the old one. I tried that SELECT works with both while INSERT goes to the new table only.
The old table didn’t take SELECT now!
We decided its time to switch now, we pended development of Mobile-Spy, Quan is still working on it though, and get this done. I found Netfirms advanced hosting good enough, we decided to use that. The biggest problem was importing the old database to the new database on the new host.
James started exporting database, Omnis gave Internal Server Error and timed out several time. I wrote several scripts to do it, from Omnis to Omnis, Omnis to Localhost, Omnis to Netfirms, all with no help. Hand transferring them is something real crappy, though, James decided to do that. I can’t withstand watching him do it.
Moving 1.2 million records are seriously awful. And all users folder with screenshots in them, man!
Finally we decided to make it work like this: all login now goes to SniperSpy member panel on Netfirms, old customers with version 2.3 will have option to login to the Omnis domain from the URL below. The welcome page will clearly state that.
SniperSpy new version is now 2.4. And we look forward to have a better time with Netfirms. And hope to give our users a better experience.
SniperSpy Control Panel: http://www.sniperspy.net/
Old Control Panel: http://www.sniperspy.com/sniper/login.php
The Evergreen Front Page: http://www.sniperspy.com
On a side note, Harish Surana, had decided to give a hand on some PHP coding and technical support. Lets see how it goes. Basically, one more member to the RXS family.
0 comments:
Post a Comment