Hiya
I have four servers.
1 - 2
||
4 5
I have master - master replication working flawlessly between server id
1 and 2.
Server id 4 is a slave of 1.
Server id 2 is a slave of 2.
For the slaves replications it works great, but ... I just realised ...
if I
Clark brentgclarkl...@gmail.comwrote:
Hiya
I have four servers.
1 - 2
||
4 5
I have master - master replication working flawlessly between server id 1
and 2.
Server id 4 is a slave of 1.
Server id 2 is a slave of 2.
For the slaves replications it works great
On 15/01/2010 11:54, Krishna Chandra Prajapati wrote:
Hi Brent,
I believe you missed log_slave_updates component on 2 and 1. You have
to enable binary logs + log_slave_updates on 2 and 1.
http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates
: Replications...
On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote:
Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between several master servers
On Mon, Sep 09, 2002 at 12:35:10PM -0500, Jeremy Tinley wrote:
This handles part of the problem but a true load balanced master
solution is needed. There's no real advantage in spending 5, 10 or
$20,000 on a failover master if you can't load balance and the spare
will just sit idle.
Sure
This handles part of the problem but a true load balanced master
solution is needed. There's no real advantage in spending 5, 10 or
$20,000 on a failover master if you can't load balance and the spare
will just sit idle.
Sure there is. If your master blows up, you have a spare waiting to
Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote:
Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between
On Sun, Sep 08, 2002 at 11:53:41PM +, Sam Przyswa wrote:
Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
Does multi-master mean master to master, imagine you have 3 MySQL
servers, A, B, C, with a load balancer in front end, if we make an
update on A, is it possible to replicate/sync the
Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
http://jeremy.zawodny.com/mysql/managing-mysql-replication_files/slide0121.htm
Just make B a slave of A, C a slave of B, and A a slave of C.
This is a good approach.
Except that it's fragile. One machine can go down and break the
cycle
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between several master servers in cluster ?
Multi-master replication works as well in 4.x as it does in 3.23.xx.
Jeremy
--
Jeremy D. Zawodny | Perl, Web
Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between several master servers in cluster ?
Multi-master replication works as well in 4.x as it does in 3.23.xx
On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote:
Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between several master servers in cluster
Hi,
Does the next MySQL 4.x version will support cross replications between several
master servers in cluster ?
Thanks in advance.
Sam.
--
Sam Przyswa - Chef de projet
Arial Concept - Intégrateur Internet
36, rue de Turin - 75008 - Paris
Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01
Web: http
Description:
Using set character set cp1251_koi8 before updates insert right
data on master server (cp1251 from client recode to koi8 on server),
but replication on slave server wrong (data dosn't recode from
cp1251 to koi8).
How-To-Repeat:
Setup
Hello all,
I'm moving from ASP to PHP MSSQL to Mysql, but I have some
doubt.
It is possible in MySQL Bi-Directional Replications? If it's,
then I need to find some documentation about it. Where can I find it?
TIA
Pedro
Description:
We have a master server which replicates to a slave. Both
are Solaris 2.7 machines running mysql-3.23.33 (Official MySQL binary).
The appropriate Master's my.cnf file looks like this:
server-id=221
binlog-do-db=Shopping
and the slave's looks like this:
server-id=200
16 matches
Mail list logo