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
From: Wagner Bianchi [mailto:wagnerbianchijr@stripped]
Sent: Friday, January 29, 2010 5:49 PM
To: Jerry Schwartz
Cc: mysql@stripped
Subject: Re: WAMP vs LAMP
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:
<http://dev.mysql.com/doc/refman/5.0/en/connecting.html#option_general_protocol>
--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
--
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 “find” the appropriate
memory-based data. There’s 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’t mentioned in the
table above, but perhaps they included it under the heading of “memory”.
Windows also supports the DCE standard.
2010/1/29 Jerry Schwartz <jschwartz@stripped>
From: Wagner Bianchi [mailto:wagnerbianchijr@stripped]
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 <jschwartz@stripped>
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 <jschwartz@stripped> 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
