Instance scale-out

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

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

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

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: Instance scale-out

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

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

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

Re: Instance scale-out

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

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

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

Re: Instance scale-out

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.