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:wagnerbianch...@gmail.com]
Sent: Friday, January 29, 2010 5:49 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
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 <jschwa...@the-infoshop.com>
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