Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted

2012-04-03 Thread Wes Modes
On 4/3/2012 3:04 AM, Ian wrote: > On 03/04/2012 00:47, Wes Modes wrote: >> Thanks again for sharing your knowledge. I do believe the answers I've >> receiving, but since I have requirements that I cannot easily alter, I'm >> also gently pushing my expert advisers here to look beyond their own >> p

Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted

2012-04-03 Thread Wes Modes
Am I right in seeing that if you can split reads and writes without the application having to be replication-aware, one does not need multiple masters? One can simply have standard MySQL replication, yes? For us, we only were interested in multiple masters so that we could read or write from any

JOIN giving duplicate records

2012-04-03 Thread Tompkins Neil
Hi Before sending the table definition, and queries etc, can anyone advise why my query with four INNER JOIN might be give me back duplicate results e.g 100,UK,12121 100,UK,12121 Basically the query the statement AND (hotel_facilities.hotelfacilitytype_id = 47 OR hotel_facilities.hotelfacilityt

Re: New Fast MySQL Compatible Server

2012-04-03 Thread Daniel Brown
On Tue, Apr 3, 2012 at 04:10, Johan De Meersman wrote: > - Original Message - >> From: "Singer X.J. Wang" >> >> Perhaps something called a VM can be use? > > Perhaps something called documentation can be provided? > > I also notice that the original poster seems to have vanished again, wh

Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted

2012-04-03 Thread Johan De Meersman
- Original Message - > From: "Ian" > > with each master having any number of slaves. Set MySQL Proxy to > send writes to the masters and reads to the slaves. Yes, except when you have replication delays (asynchronous, remember?) like someone else recently posted, your application write

Re: Percona: Contact Details - a word on poaching

2012-04-03 Thread Johan De Meersman
- Original Message - > From: "Martin Gainty" That... made no sense whatsoever. Good thing I'm not Dutch, I suppose. Anyway, I invoke Godwin's Law. Thread ended. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel

Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted

2012-04-03 Thread Ian
On 03/04/2012 00:47, Wes Modes wrote: > Thanks again for sharing your knowledge. I do believe the answers I've > receiving, but since I have requirements that I cannot easily alter, I'm > also gently pushing my expert advisers here to look beyond their own > preferences and direct experience. > >

RE: Percona: Contact Details - a word on poaching

2012-04-03 Thread Martin Gainty
Johann I would like to *think* the dutch would be agreeable to advice from German and or French supporters of the EU Occasionally I am contacted by someone in the Hague for Database Administrator Positions If you've been good about NOT doing strip searches on political enemies I can get you in

Re: Percona: Contact Details - a word on poaching

2012-04-03 Thread Johan De Meersman
- Original Message - > From: "Wes Modes" > > Hi, I received a suggestion from Baron Schwartz that I consider your > company for consulting advice as a solution to an enquiry I made to > the MySQL list. I did not respond to Baron Schwartz and now I receive > this email from an account exe

Re: New Fast MySQL Compatible Server

2012-04-03 Thread Johan De Meersman
- Original Message - > From: "Singer X.J. Wang" > > Perhaps something called a VM can be use? Perhaps something called documentation can be provided? I also notice that the original poster seems to have vanished again, which makes the whole thing even more shady. -- Bier met grenady