RE: WAMP vs LAMP
Thanks for the clarification. As I understand it, the syntax on the client end is to use "." as the host name. I was using "localhost" on the LAMP configuration, and never bothered to change it. With 7 or so web-based users, there isn't much rush. 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 >-Original Message- >From: shawn.gr...@sun.com [mailto:shawn.gr...@sun.com] >Sent: Monday, February 01, 2010 11:07 AM >To: Jerry Schwartz >Cc: 'Wagner Bianchi'; mysql@lists.mysql.com >Subject: Re: WAMP vs LAMP > >Jerry Schwartz wrote: >> 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. >> > >On Windows they aren't called "sockets", they are "named pipes" and yes >you can be listening to both internal and external connections at the >same time. > >--enabled-named-pipe >http://dev.mysql.com/doc/refman/4.1/en/server- >options.html#option_mysqld_enable-named-pipe > >When connecting locally, you have both options at your disposal >http://dev.mysql.com/doc/refman/4.1/en/connecting.html > >There is even another option for Windows, --shared-memory >http://dev.mysql.com/doc/refman/4.1/en/server- >options.html#option_mysqld_shared-memory > >This works similar to a named pipe and if you want to enable both (pipes >and shares) at the same time, you need to provide different names. The >TCP/IP ports are independent and also available. > >-- >Shawn Green, MySQL Senior Support Engineer >Sun Microsystems, Inc. >Office: Blountville, TN > > > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe:http://lists.mysql.com/mysql?unsub=jschwa...@the- >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: WAMP vs LAMP
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 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 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 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. [
Re: WAMP vs LAMP
Jerry Schwartz wrote: 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. On Windows they aren't called "sockets", they are "named pipes" and yes you can be listening to both internal and external connections at the same time. --enabled-named-pipe http://dev.mysql.com/doc/refman/4.1/en/server-options.html#option_mysqld_enable-named-pipe When connecting locally, you have both options at your disposal http://dev.mysql.com/doc/refman/4.1/en/connecting.html There is even another option for Windows, --shared-memory http://dev.mysql.com/doc/refman/4.1/en/server-options.html#option_mysqld_shared-memory This works similar to a named pipe and if you want to enable both (pipes and shares) at the same time, you need to provide different names. The TCP/IP ports are independent and also available. -- Shawn Green, MySQL Senior Support Engineer Sun Microsystems, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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: * *--protocol<http://dev.mysql.com/doc/refman/5.0/en/connecting.html#option_general_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 2010/1/29 Jerry Schwartz >*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 > > > > 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 new
RE: WAMP vs LAMP
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 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 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