From: Jerry Schwartz Date: February 1 2010 4:15pm Subject: RE: WAMP vs LAMP List-Archive: http://lists.mysql.com/mysql/220536 Message-Id: <028301caa359$c8a7fdf0$59f7f9d0$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0284_01CAA32F.DFD1F5F0" ------=_NextPart_000_0284_01CAA32F.DFD1F5F0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable =20 =20 Regards, =20 Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 =20 860.674.8796 / FAX: 860.674.8341 =20 www.the-infoshop.com =20 From: Wagner Bianchi [mailto:wagnerbianchijr@stripped]=20 Sent: Friday, January 29, 2010 5:49 PM To: Jerry Schwartz Cc: mysql@stripped Subject: Re: WAMP vs LAMP =20 Hi JS, I never see socket file on MS Windows...are you sure about it? But, the = other question is "yes", if you make a connection with the MySQL Server = (mysqld) using -h localhost, you will connect with the server using a = socket file (linux only), but, if you make using -h 127.0.0.1, TCP/IP = will be use. See this:=20 = --protocol Value Connection Protocol Allowable Operating Systems TCP TCP/IP connection to local or remote server All SOCKET Unix socket file connection to local server Unix only PIPE Named-pipe connection to local or remote server Windows only MEMORY Shared-memory connection to local server Windows only Source: http://dev.mysql.com/doc/refman/5.0/en/connecting.html=20 -- Wagner Bianchi [JS] Perhaps I misspoke, but the basic principle is the same. On *nix, a = socket file is an inode that is used as a handle for processes to = =E2=80=9Cfind=E2=80=9D the appropriate memory-based data. = There=E2=80=99s no data in the file itself. On Windows, IPC via file mapping is pretty close to the same thing. It = is one of many IPC mechanisms that Microsoft has implemented over the = years. It isn=E2=80=99t mentioned in the table above, but perhaps they = included it under the heading of =E2=80=9Cmemory=E2=80=9D. Windows also supports the DCE standard. =20 2010/1/29 Jerry Schwartz From: Wagner Bianchi [mailto:wagnerbianchijr@stripped]=20 Sent: Thursday, January 28, 2010 2:03 PM To: Jerry Schwartz Subject: Re: WAMP vs LAMP =20 [JS] The file paths were all the same, actually, and the address for = MySQL is just =E2=80=9Clocalhost=E2=80=9D. [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. =20 [JS] That=E2=80=99s an interesting suggestion. Windows has socket files, = but I=E2=80=99ve never looked at them. In fact, I don=E2=80=99t even = know if MySQL can us a socket file and TCP/IP at the same time. = We=E2=80=99re going to have more ODBC traffic than web traffic, I = expect. =20 Regards, =20 Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 =20 860.674.8796 / FAX: 860.674.8341 =20 www.the-infoshop.com =20 =20 =20 =20 Best regards. -- Wagner Bianchi 2010/1/28 Jerry Schwartz From: vegivamp@stripped [mailto:vegivamp@stripped] On Behalf Of Johan = De Meersman Sent: Wednesday, January 27, 2010 12:18 PM To: Jerry Schwartz Cc: Shawn.Green@stripped; Daevid Vincent; Dan Nelson; = mysql@stripped Subject: Re: Event feature already working in Server 5.1.37 On Wed, Jan 27, 2010 at 5:52 PM, Jerry Schwartz = 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 =E2=80=9Clocalhost=E2=80=9D. I=E2=80=99ve only run into one incompatibility, and that one bit me = yesterday: On Windows, the PHP rand() function has a native range of 1 = =E2=80=93 32767. I replaced that with a call to mt_rand(), and = all=E2=80=99s 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=E2=80=99m sure you could. I actually did, before deciding that it = wasn=E2=80=99t 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=E2=80=99s = 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 =20 -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel =20 =20 ------=_NextPart_000_0284_01CAA32F.DFD1F5F0--