I have used debug on monitor and agent:
- on agent I see:
/etc/init.d/mysql-mmm-agent start
Starting MMM Agent Daemon: 2013/03/13 16:19:52 DEBUG Created pid file
'/var/run/mysql-mmm/mmm_agentd.pid' with pid 13640
2013/03/13 16:19:52 DEBUG Listener: Waiting for connection...
2013/03/13 16:19:53 DEBU
Hi,
I think MMM's proper functionality depends a lot on network interface
configuration and sometimes it behaves odd. I moved to MySQL or in my
case to MariaDB + Galera + HaProxy configuration. It's not difficult to
setup. There is no SPO as in case with monitor host in MMM, much more
robust s
2013/3/11 Rafał Radecki
> Hi All.
>
> I use:
>
> cat /etc/redhat-release
> CentOS release 6.3 (Final)
>
> uname -a
> Linux prod1.local 2.6.32-279.14.1.el6.x86_64 #1 SMP Tue Nov 6 23:43:09
> UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
>
> on db host:
> rpm -qa | grep mmm
> mysql-mmm-2.2.1-1.el6.noarch
Hi All.
I use:
cat /etc/redhat-release
CentOS release 6.3 (Final)
uname -a
Linux prod1.local 2.6.32-279.14.1.el6.x86_64 #1 SMP Tue Nov 6 23:43:09
UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
on db host:
rpm -qa | grep mmm
mysql-mmm-2.2.1-1.el6.noarch
bmysql-mmm-agent-2.2.1-1.el6.noarch
on monitor h
slave
at the same time, with a built-in fail-over mechanism.
The article goes on to talk about setting up a Multimaster Replication
System.
At one point, I was lured into using the Multi-Master Replication
Manager for MySQL (MMM) since it was said to be a set of scripts that
made this
ave
at the same time, with a built-in fail-over mechanism.
The article goes on to talk about setting up a Multimaster Replication
System.
At one point, I was lured into using the Multi-Master Replication
Manager for MySQL (MMM) since it was said to be a set of scripts that
made this process e
MySQL Galera Multi-Master Replication
http://forge.mysql.com/wiki/MySQL_Galera_Multi-Master_Replication
This Thursday (February 11th, 14:00 UTC), Seppo Jaakola & Alex Yurchenko
will talk about MySQL Galera Multi-Master Replication. Galera provides
synchronous multi-master replication and us
> -Original Message-
> From: Dominik Klein [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 18, 2006 11:06
> To: mysql@lists.mysql.com
> Subject: Re: Multi master replication question
>
>
> > Replication setup:
> >
> > A -> B -> A
> >
Replication setup:
A -> B -> A
|
C
One thing I can't remember is do I have to set an option somewhere to
tell the masters to ignore the queries in the binlog that oringated from
them?
Make sure you set different Server IDs on each machine and you should be
just fine.
--
MySQ
I'm about to re-create a mulit master replication setup that was
dismantled during server hardware/software upgrades.
Replication setup:
A -> B -> A
|
C
One thing I can't remember is do I have to set an option somewhere to
tell the masters to ignore the queries in the binlog that
Hello again :)
On 4/10/06, Shawn Green <[EMAIL PROTECTED]> wrote:
>
> First rule: Do NOT share data files between server processes. Nothing
> should directly interact with a datafile other than the server to which
> it belongs. This includes other server processes as well as direct user
> actions
Shawn Green wrote:
I understand now.
You have 3 slave server processes replicating independently from their
own separate master servers. You have a fourth MySQL server process
that shares the same data files as your 3 slaves but it does not know
when replication occurs and when it hasn't (fo
--- Leonardus Setiabudi <[EMAIL PROTECTED]> wrote:
> let me re-explain my situation ..
>
> the mysql server was on /home/mysql/mysql4111
> and the data directory was on /home/mysql/mysql4111/data
> in data directory, there are 4 databases, db1, db2, db3, db4
> all configurations resided in /hom
>
> Hold on, "(it should be, its the same file)", you're saying that db2 on
> server1 and server2 are using the same database files (datadir)? If that's
> the case, why? That doesn't make any sense.
>
>
> Atle
> -
> Flying Crocodile Inc, Unix Systems Administrator
>
Im replying from another accoun
On Sat, 8 Apr 2006, Leonardus Setiabudi wrote:
> when i log into server 2 using port 3307, i can see the data in db2
> updated, which means the replication succeed (show slave status tells
> the same thing), and the same thing with server 3, i can see db3
> updated, also with server 4 where db4 up
[EMAIL PROTECTED] wrote:
Leonardus Setiabudi <[EMAIL PROTECTED]> wrote on 04/07/2006
05:33:50 AM:
> Hi All,
>
> I have a problem with my multi master replication plan.
> I have set my server (linux) to run 4 instance of mysqld, each with a
> different port, socket, tm
Leonardus Setiabudi <[EMAIL PROTECTED]> wrote on 04/07/2006 05:33:50
AM:
> Hi All,
>
> I have a problem with my multi master replication plan.
> I have set my server (linux) to run 4 instance of mysqld, each with a
> different port, socket, tmpdir, log file, relay log fil
Hi All,
I have a problem with my multi master replication plan.
I have set my server (linux) to run 4 instance of mysqld, each with a
different port, socket, tmpdir, log file, relay log file, master info
and relay info.
the illustration as follow :
Server 1 (non slave)
db1
db2
db3
On Mon, 27 Feb 2006, Marvin Wright wrote:
Hi,
I'm having a few problems at the moment with replication.
We are in the process of migrating a cache to 2 new database machines.
As the data is a cache its very large is refreshed constantly.
Currently we have 2 machines, 1 master and 1 slave.
Marvin,
> The process is working between Master, Slave1 and Slave2 but
>for some reason Slave2 is not writing bin-log information.
> So Slave3 is sitting empty and not getting any data because of no data
> in Slave2's bin-log.
I guess u don't have 'log-slave-updates' flag
Your subject is misleading, I would rather call this something like
Chained Replication. Unless your slaves all replicate from 'Master', in
that case your drawing is the culprit. :)
Does the error log on slave3 or slave2 indicate any problems?
Atle
-
Flying Crocodile Inc, Unix Systems Administra
Hi,
I'm having a few problems at the moment with replication.
We are in the process of migrating a cache to 2 new database machines.
As the data is a cache its very large is refreshed constantly.
Currently we have 2 machines, 1 master and 1 slave.
I am trying to set up this configuration but I
Hello,
I am working on a web application (php) that will have a largish mysql
database (millions of rows, eventually), and for which high availability
will be important. I am wondering if anyone here can suggest options for
multi-master replication or clustering.
The application will be mostly
On Thu, Jan 24, 2002 at 09:23:28AM -0600, Greg Donald wrote:
> Will MySQL, at any time in the near future, support multi-master
> replication?
Yes. It is being worked on. Well, at least dual-master is.
> What we need is a way to combine databases from different machines
> b
Will MySQL, at any time in the near future, support multi-master
replication? We're looking at splitting some very large databases up among
several machines, but we need a way to bring them back together for our
stats creation databases on the backend.
What we need is a way to combine data
25 matches
Mail list logo
