Re: WL#946 and Changing time literal format

2009-02-05 Thread Konstantin Osipov
* Konstantin Osipov kos...@sun.com [09/02/05 03:35]: People are using MySQL because it's different and can satisfy their needs. Standards are useful, but not important for our current or future users. Getting the job done and not having downtime, even when upgrading, that is important!

Instance scale-out

2009-02-05 Thread Claudio Nanni
I succesfully install multiple instances on the same host since many years (good old 3.23), my rule of the game is: different os user, different os user homedir, different my.cnf (with different port/socket) and start the server ecluding the possibility to read other than its own my.cnf with

Re: Instance scale-out

2009-02-05 Thread John Daisley
I think you are confusing a network interface (such as a tcp port) with a physical network device (such as a LAN card). For me the study guide is correct. I succesfully install multiple instances on the same host since many years (good old 3.23), my rule of the game is: different os user,

Re: Instance scale-out

2009-02-05 Thread Claudio Nanni
Hi John, So according to this interpretation a port IS a network interface, it means that I have thousands of network interfaces on my servers? I never thought of a port as a network interface, I always thought of it as an attribute(address of an application on the host) of the tcp/ip protocol,

Re: Instance scale-out

2009-02-05 Thread Andy Smith
Hi Claudio, I don't think its your English, I agree with you that its not just confusing it is wrong. Each server must have its own network interface At least for my 10 years experience in IT and UNIX I would understand network interface as physical network interface unless specified as

Re: How much memory can mysql 5.1 take advantage of?

2009-02-05 Thread Luis Motta Campos
Jake Maul wrote: Didn't want this to go unanswered, although I don't have any great info for you. As long as you're running a 64-bit OS and a 64-bit version of MySQL, there's no technical reason it would be limited to less than the addressable space (that I know of). The main gain would

Re: Instance scale-out

2009-02-05 Thread John Daisley
An interface by definition is a point of interconnection. Maybe its a bit of a grey area where the interpretation can be different depending on whether you think in terms of hardware or software. Its the port which is used to communicate with the MySQL (or indeed any other) server software so

Re: Instance scale-out

2009-02-05 Thread Claudio Nanni
John, I don't want to argue too much on this but I'd also like the opinion of the big heads in MySQL I think there's no grey area here. An interface is an interface and can be of any type and supporting any protocol(TCP/IP on ethernet card, UDP idem. DSL on WAN card, PPP on POTS modem) A port is

Re: Instance scale-out

2009-02-05 Thread John Daisley
Claudio, Nobody is arguing, its a discussion list not an arguing list and this is a good discussion to have on here. Im very interested in seeing what others have to say about this but here is how I interpret it (based on my 18 years of IT experience which includes many years working with MySQL

Installing MySQL client into workstations using GPO

2009-02-05 Thread Scott Hamm
My objective is to have all Windows XP workstation (300+) report their activities using mysql client that exports in CSV format to our Active Directory's MySQL server. Is it possible to install just the MySQL client over GPO, is this possible? Thanks, Scott Hamm Technology Coordinator MOT

Re: Instance scale-out

2009-02-05 Thread Andy Smith
Quoting John Daisley john.dais...@mypostoffice.co.uk: I would say in terms of the MySQL server the interface is either a TCP/IP Port, a Named Pipe, shared memory or a UNIX Socket. Depending on the host operating system it can use any of those interfaces but each instance must have its own

Re: Instance scale-out

2009-02-05 Thread John Daisley
Andy, Like I said, I would like to hear what others think and I'd be particularly interested in some comment from within MySQL. For the purposes of the exam, which I think the original question related to, I would say you have to accept mysql's interpretation of 'network interface' as being a

Re: Instance scale-out

2009-02-05 Thread Claudio Nanni
First to help people join the discussion, the guilty paragraph of certification study guide 42.1 -- Each server must have its own network interfaces, including the TCP/IP port, the named

MySQL founder Monty leaves Sun

2009-02-05 Thread Daevid Vincent
Monty leaves Sun; this time for sure: http://monty-says.blogspot.com/2009/02/time-to-move-on.html Incidentally a friend of mine met Ted Leung of Sun (local geek celebrity and author of a few books) at the UW Python mini-conference last Saturday. Sun seems very keen on supporting dynamic

Re: Instance scale-out

2009-02-05 Thread Baron Schwartz
For the purposes of the exam, which I think the original question related to, I would say you have to accept mysql's interpretation of 'network interface' as being a port, socket, pipe etc. Thats what it says in the study guide and the reference manual and thats what they are going to test you on.