From: Wagner Bianchi [mailto:wagnerbianch...@gmail.com] Sent: Thursday, January 28, 2010 2:03 PM To: Jerry Schwartz Subject: Re: WAMP vs LAMP
[JS] The file paths were all the same, actually, and the address for MySQL is just “localhost”. [WB]Consider to use MySQL on Unix like environment because the socket file. This way you will get more performance then use TCP/IP on MS Windows. [JS] That’s an interesting suggestion. Windows has socket files, but I’ve never looked at them. In fact, I don’t even know if MySQL can us a socket file and TCP/IP at the same time. We’re going to have more ODBC traffic than web traffic, I expect. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com Best regards. -- Wagner Bianchi 2010/1/28 Jerry Schwartz <jschwa...@the-infoshop.com> From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Wednesday, January 27, 2010 12:18 PM To: Jerry Schwartz Cc: shawn.gr...@sun.com; Daevid Vincent; Dan Nelson; mysql@lists.mysql.com Subject: Re: Event feature already working in Server 5.1.37 On Wed, Jan 27, 2010 at 5:52 PM, Jerry Schwartz <jschwa...@the-infoshop.com> wrote: [JS] I second this. Instead of using a LAMP development environment, I went with WAMP -- even though our production environment was LAMP. Generally a bad idea - you keep running into annoying minor differences between the systems. File paths, for example :-) [JS] The file paths were all the same, actually, and the address for MySQL is just “localhost”. I’ve only run into one incompatibility, and that one bit me yesterday: On Windows, the PHP rand() function has a native range of 1 – 32767. I replaced that with a call to mt_rand(), and all’s right with the world. (Why are we using random numbers? It would take a psychiatric evaluation of my predecessor to determine that.) It was a lot easier than setting up LAMP in a virtual machine. I'll set up up in under an hour, if you want :-) [JS] I’m sure you could. I actually did, before deciding that it wasn’t worth it what with the port forwarding and all. When we shut down our LAMP site for cost reasons, I moved it to a WAMP environment that I bought off the Wait. You shut down machines for cost reasons, and then go buy new ones ? [JS] The one we shut down was externally hosted, and had customer-accessible information on it. When management decided to consolidate our customer-accessible sites in Japan, there was no reason to have our administrative stuff hosted externally. shelf for $800. For that money I got 8GB of RAM, four cores, and a RAID controller. Another $90 for a second drive, and I've got mirroring going. Granted, it's a low-traffic site used for internal administration; but I think this box could handle a lot more traffic than it does. It seems to be loafing all of the time. Oh, probably. Webserving isn't all that hard of a job, if the site is reasonably well-designed. If you're implying that the LAMP setup you had earlier didn't perform quite as well, though, I'll go out on a leg and say that it probably wasn't managed very well. [JS] It was fine. It's a home/SOHO/gamer system, so it probably isn't as physically robust as a "server" grade machine at twice the price; but if it dies, I can be up and running on a newer, bigger, cheaper machine in little more than the time it takes me to run to the nearest big-box store. True. Me and my server grade machine, however, will not have had that downtime, because I'll have been notified that a redundant component has failed, and will have replaced it while the machine was running. It's ultimately a matter of how much your uptime is worth to you, and keep in mind that on a saturday evening you may not even find a new machine until monday morning, and then you still have to start installing everything, not to mention find the latest backups of your data. Me, I'll go for the expensive server ones for my professional needs, thanks :-) [JS] Since this is used internally by a relatively small number of people, the cost of downtime is mostly my embarrassment. Our stores are open on Sundays. The ones who would scream are the two in our Tokyo office who use it for a few minutes when they come in. There’s nothing I can do about that. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com <http://www.the-infoshop.com/> -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
