RE: Another replication question

If you use a chain of masters, you can accomplish the same effect: Master1->Master2->Master->3->Slave However I don't recommend this since the more links you have in a replication chain, the easier it is to break it in a way that's very not-fun to deal with. -Original Message- From: Ro

RE: localhost vs domain for connection string

>-Original Message- >From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De >Meersman >Sent: Wednesday, November 24, 2010 2:39 AM >To: Jerry Schwartz >Cc: Brent Clark; mysql mailing list >Subject: Re: localhost vs domain for connection string > >On Tue, Nov 23, 2010 at 7

Re: SQLStats 1.1 available

If you downloaded this earlier today, note that there is now a 1.2 version available, that also shows ROWS_EXAMINED in INFORMATION_SCHEMA tables. /Karlsson Claudio Nanni wrote On 2010-11-24 09:02: Cool! On Nov 24, 2010 8:46 AM, "Anders Karlsson" > wrote: >

RE: Another replication question

MySQL, by design, cannot do that. A DB Server can be Master to Multiple Slaves Think of the CHANGE MASTER TO command. Its internal design cannot accommodate reading from more than one set of relay logs. You could attempt something convoluted, like 1) STOP SLAVE; 2) CHANGE MASTER TO 3) START SLA

Re: Another replication question

On Wed, Nov 24, 2010 at 2:50 PM, John Daisley wrote: > Are you sure mmm couldn't handle this? > That, I don't know, but MySQL's internal replication mechanisms definitely don't support multimaster slaves. If mmm does it, it'll likely be akin to the offline log shipping I proposed earlier. > May

Re: Another replication question

Johan, Are you sure mmm couldn't handle this? Machiel, Maybe you could `simulate` the whole thing using some federated tables on one of the slave instances? Then although you are replicating to 3 instances you could access all the data from a single instance? Regards John On 24 November 2010

Re: Mysql server full with idle connections

On Wed, Nov 24, 2010 at 1:13 PM, Nigel Wood wrote: > Quick thought: what is your idle timeout set to on the MySQL server? > Could you have configured it to reap these idle connections? > I could, probably, but the applications are generally well-behaved, and it's not a recurring problem. I hope.

Re: Another replication question

You can't, plain and simple - a slave may only have a single master. You could script binlog shipping, I suppose, if you're so inclined, and apply them on the slave. No guarantees about it working as expected, though. On Wed, Nov 24, 2010 at 1:20 PM, Machiel Richards wrote: > Hi All > >I am

Re: Mysql server full with idle connections

Seen this a lot with poorly written web apps which open connections but dont close them when finished. Try setting wait_timeout and/or interactive_timeout to close unused connections. John On 24 November 2010 11:27, Johan De Meersman wrote: > Hey, > > Late last night, I got a call that one of

Another replication question

Hi All I am back once again with another replication question (maybe this can also be handled by MMM but not sure) this time for a different client. We are trying to find out how to setup 3 different masters to replicate to a single slave server (without the need to have 3 different insta

Mysql server full with idle connections

Hey, Late last night, I got a call that one of our servers was down. Turns out the machine had all 2500 connection slots in use, but none of them appeared to be doing anything: hardly any CPU was being used, load 0.05, and tcpdump confirmed that pretty much no data was being sent, either. Disks w

Re: MMM setup and requirements

> > >1. From what I understand the setup requires a > management server (3rd machine) which will be used to monitor and manage > the two database nodes and the replication. >- Am I correct in thinking that this will have > to be almost the same specs seeing t

MMM setup and requirements

Good day all I was asked to research the MMM multi master setup and viability for a specific environment in order to assist with load balancing and high availability. I do however have some questions and hope that someone out there have had enough experience to assist me with this a

Re: SQLStats 1.1 available

Cool! On Nov 24, 2010 8:46 AM, "Anders Karlsson" wrote: > SQLStats is a MySQL 5.5 plugin that allows MySQL SQL Statement > monitoring in "real time", without any Proxies, source code > modifications, different connectors or anything. Read more on my blog here: > http://karlssonondatabases.blogspot