Manuel,
Thank you very much for this information. This sounds like a very good
strategy. I think I will try switching some slaves from one relay to another to
familiarize myself and get practice and them do it to deploy a new master.
Again, thank you very much.
Richard
> El Jan 18, 2014, a
2014/1/17 Richard Reina
> I have 3 relay MySQL database servers on my small office LAN backing up a
> master and 3 more machines backing up each relay (1 each). They are all
> replicating all databases and all tables. The master although running fine
> is almost eight years old. I'm thinking it's
Am 17.01.2014 22:42, schrieb Richard Reina:
> I have 3 relay MySQL database servers on my small office LAN backing up a
> master and 3 more machines backing up each relay (1 each). They are all
> replicating all databases and all tables. The master although running fine
> is almost eight years ol
I have 3 relay MySQL database servers on my small office LAN backing up a
master and 3 more machines backing up each relay (1 each). They are all
replicating all databases and all tables. The master although running fine
is almost eight years old. I'm thinking it's probably time to make one of
the
On 24/07/2013 19:52, Rick James wrote:
4) 3 tables from the slaves are to be replicated back to the master
NO.
However, consider Percona XtraDb Cluster or MariaDB+Galera. They allow
multiple writable masters. But they won't let you be so selective about tables
not being replicated.
Here ar
http://mysql.rjweb.org/doc.php/galera
If you can live with them (plus replicating everything), it may be best for you.
> -Original Message-
> From: rich gray [mailto:r...@richgray.com]
> Sent: Wednesday, July 24, 2013 8:21 AM
> To: mysql@lists.mysql.com
> Subject: Repl
I have been asked to set up multiple database replication which I have
done before for simple cases however there are some nuances with this
instance that add some complexity and I'd like to hear your collective
expertise on this proposed scenario:-
1) Single master database
2) n (probably 3 t
That is correct.
On Mon, May 6, 2013 at 11:06 AM, Richard Reina wrote:
> To activate log-slave-updates do I just add "log-slave-updates" to the
> my.cnf file?
>
>
>
> 2013/4/30, Manuel Arostegui :
> > 2013/4/30 Richard Reina
> >
> >> I have a few slaves set up on my local network that get upda
To activate log-slave-updates do I just add "log-slave-updates" to the
my.cnf file?
2013/4/30, Manuel Arostegui :
> 2013/4/30 Richard Reina
>
>> I have a few slaves set up on my local network that get updates from
>> my main mysql database master. I was hoping to turn one into a master
>> while
rom: Richard Reina [mailto:gatorre...@gmail.com]
> Sent: Wednesday, May 01, 2013 6:00 AM
> To: Manuel Arostegui
> Cc: mysql@lists.mysql.com
> Subject: Re: Chain Replication QUestion
>
> Hello Manuel,
>
> Thank you for your reply. Could I do the following?:
>
> 1) Enable l
ql.com/why-mysql/white-papers/mysql-replication-tutorial/
Andrew.
> -Original Message-
> From: Rick James [mailto:rja...@yahoo-inc.com]
> Sent: 01 May 2013 16:29
> To: Richard Reina; Manuel Arostegui
> Cc: mysql@lists.mysql.com
> Subject: RE: Chain Replication QUestion
>
&
Hello Manuel,
Thank you for your reply. Could I do the following?:
1) Enable log-bin on master2 (slave that will be converted to a master)
2) Enable log-slave-updates on master2
3) Execute CHANGE MASTER to on another existing slave so that it gets
it's updates from master2 instead of master1.
Th
2013/4/30 Richard Reina
> I have a few slaves set up on my local network that get updates from
> my main mysql database master. I was hoping to turn one into a master
> while keeping it a slave so that I can set up a chain. Does anyone
> know where I can find a "how to" or other documentation fo
2012/10/25 Sabika M
> I have replication setup in the following way:
>
> A -> B ->C
>
> I am making updates to server A. I want to stop all my updates and point
> them to server C. After I start writing to server C, can I use the change
> master statement to make the C the master of A (take B out
ursday, October 25, 2012 10:16 AM
> To: MySql
> Subject: Replication Question
>
> I have replication setup in the following way:
>
> A -> B ->C
>
> I am making updates to server A. I want to stop all my updates and
> point them to server C. After I start writin
I have replication setup in the following way:
A -> B ->C
I am making updates to server A. I want to stop all my updates and point
them to server C. After I start writing to server C, can I use the change
master statement to make the C the master of A (take B out of the topology)
and proceed to s
Are you trying to promote a slave as a new master and replace current master or
create intermediate slave? If it is the latter all you need to do is to:
1. Stop the slave
2. Add "log_slave_updates = 1" in the slave's config file
3. Copy the slave files to the new slave(s)
4. Start your intermedia
nge.net]
>> Sent: Friday, August 24, 2012 2:43 PM
>> To: mysql@lists.mysql.com
>> Subject: Re: Replication question: How to make a slave a master?
>>
>> what would be tricky?
>>
>> remove all relay-logs, remove master.info adn that was it done this
>>
Message-
> From: Reindl Harald [mailto:h.rei...@thelounge.net]
> Sent: Friday, August 24, 2012 2:43 PM
> To: mysql@lists.mysql.com
> Subject: Re: Replication question: How to make a slave a master?
>
> what would be tricky?
>
> remove all relay-logs, remove master.info adn th
cky.
>
>> -Original Message-
>> From: Reindl Harald [mailto:h.rei...@thelounge.net]
>> Sent: Friday, August 24, 2012 8:29 AM
>> To: mysql@lists.mysql.com
>> Subject: Re: Replication question: How to make a slave a master?
>>
>>
>>
>&
Pointing the other slave to the new master is a bit tricky.
> -Original Message-
> From: Reindl Harald [mailto:h.rei...@thelounge.net]
> Sent: Friday, August 24, 2012 8:29 AM
> To: mysql@lists.mysql.com
> Subject: Re: Replication question: How to make a slave a master
Am 24.08.2012 17:25, schrieb Richard Reina:
> I have a couple of mysql database slaves and would like to make one of them
> be a master as well so that I can set another machine to replicate from it.
> Can anyone tell me how I should go about it or know of any howtos for this
> specific task?
ad
I have a couple of mysql database slaves and would like to make one of them
be a master as well so that I can set another machine to replicate from it.
Can anyone tell me how I should go about it or know of any howtos for this
specific task?
Thanks,
Richard
--
Richard Reina
Rush Logistics, Inc.
Watch our 3 minute movie:
http://www.rushlogistics.com/movie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
really really a little noisy.
这下犯众怒了吧,招人烦了~ 囧
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
2010/12/29 杨涛涛 :
> Ok, I'll not post any more! Just reading!
>
>
> David Yeung, In China, Beijing.
> My First Blog:http://yueliangdao0608.cublog.cn
> My Second Blog:http://yu
Ok, I'll not post any more! Just reading!
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao0...@gmail.com
在 2010年12月23日 下午8:14,Johan De Meersman 写道:
> Glad to hear I'm not the only one annoy
Glad to hear I'm not the only one annoyed :-) I've plonked him in the
meantime.
2010/12/23 Jorg W Young
>
> This guy has been saying nothing meaningful on this list, but
> advertise his blog everywhere.
> Just be shame. He should be kicked out from the list.
>
> Jorg.
>
> 2010/12/23 杨涛涛 :
> > Th
This guy has been saying nothing meaningful on this list, but
advertise his blog everywhere.
Just be shame. He should be kicked out from the list.
Jorg.
2010/12/23 杨涛涛 :
> This way is very well, but it has to do lots of human work.
> David Yeung, In China, Beijing.
> My First Blog:http://yuelian
)
> AIM & Skype : RolandoLogicWorx
> redwa...@logicworks.net
> http://www.linkedin.com/in/rolandoedwards
>
>
> -Original Message-----
> From: Machiel Richards [mailto:machi...@rdc.co.za]
> Sent: Wednesday, November 24, 2010 7:20 AM
> To: mysql mailing list
> Subjec
inal Message-
From: Rolando Edwards [mailto:redwa...@logicworks.net]
Sent: Wednesday, November 24, 2010 6:53 AM
To: Machiel Richards; mysql mailing list
Subject: RE: Another replication question
MySQL, by design, cannot do that.
A DB Server can be Master to Multiple Slaves
Think of the CHANGE
chiel Richards [mailto:machi...@rdc.co.za]
Sent: Wednesday, November 24, 2010 7:20 AM
To: mysql mailing list
Subject: 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
clien
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
t;
> On Wed, Nov 24, 2010 at 1:20 PM, Machiel Richards >wrote:
>
> > 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.
> >
> >
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 ne
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
> from what i've read and seen geographical load balancer
> works as: multiple DNS A records routes to multiple
> Apache Servers(mod_php tucks in as a module under Apache)
> each web servers would connect to MySQL on their own
> localhost 1.2.3.4-WebServer would communicate directly to
> 1.2.3.4-M
> Do you want geographic redundancy or do you want to scale reads?
> In this case you're talking about scaling reads for a bunch of
> apps all running together. If you want performance in that case,
> then first you'd want to isolate the apps from each other.
Geographic redundancy is my primary g
25, 2009 4:18 PM
To: Gavin Towey
Cc: mysql@lists.mysql.com
Subject: Re: Master/Slave Replication Question
> Moreover, it works today as opposed to waiting until the end
> of time for the database developers to add features like that
> (which mysql cluster is already a distributed database
> Moreover, it works today as opposed to waiting until the end
> of time for the database developers to add features like that
> (which mysql cluster is already a distributed database, and
> the devs have said they're not interested in trying to turn
> the regular mysql into a distributed product,
ey were designed to scale well.
Regards,
Gavin Towey
-Original Message-
From: Tim Gustafson [mailto:t...@soe.ucsc.edu]
Sent: Friday, September 25, 2009 2:44 PM
To: mysql@lists.mysql.com
Subject: Re: Master/Slave Replication Question
> Another thought would be at the application laye
> Another thought would be at the application layer, sending
> all the updates (insert,delete, update, etc) to server A,
> and the selects to the local slave servers.
This has been suggested before, and I'm totally against it. Applications like
PHPBB, Drupal, WordPress, etc can't be easily confi
Hi,
I'm a big fan of mySQL's multi-master replication, but I've run into gotchas
over the years. Off the top of my head, I can think of:
- auto_increment complications,
- if you have a->b->c->a, it's not exactly graceful to insert a "d" server for
a->b->c->d->a
- if you have a->b->c->a and b
In the last episode (Oct 13), AM Corona said:
> In mysql 4, can one replicate a database to another server but have the DB
> name on the slave server be different?
>
> Master : dbname1
> Slave: dbname1
> AND
> Slave : dbname2 (but contains data from db2name1)
So you want the same data in two d
On Mon, Oct 13, 2008 at 11:43 AM, AM Corona <[EMAIL PROTECTED]> wrote:
> In mysql 4, can one replicate a database to another server but have the DB
> name on the slave server be different?
>
> Master : dbname1
> Slave: dbname1
> AND
> Slave : dbname2 (but contains data from db2name1)
>
> A proj
In mysql 4, can one replicate a database to another server but have the DB
name on the slave server be different?
Master : dbname1
Slave: dbname1
AND
Slave : dbname2 (but contains data from db2name1)
A project manager is asking for this.. don't blame the guy asking :-)
Regards,
Martin Corona
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've been looking for a way to fake replication from mysql to a local
BDB database. I'm not finding anything. Anybody ever come across this?
It seems like it wouldn't be too terribly difficult to read from the
relay-log and keep track of where you a
In the last episode (Jul 03), mos said:
> If I'm replicating a master database to a slave (MyISAM tables), but
> the slave is busy serving up web pages, how does it get write access
> to the slave's table if it is always being read? TIA
Mysql places inserts in front of selects in its internal
If I'm replicating a master database to a slave (MyISAM tables), but the
slave is busy serving up web pages, how does it get write access to the
slave's table if it is always being read? TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
As I know, master will replicate all database to the slave in
default. If I want to replicate only specified database, we can use
parameter in master.
binlog-do-db=databasename
I found that we can also use parameters to replicate database even
table in slave.
replicate-do-db=db_name (repli
> -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
: Friday, April 28, 2006 9:05 AM
To: Robinson, Eric; mysql@lists.mysql.com
Subject: Re: Quick Replication Question
no.
- Original Message -
From: "Robinson, Eric" <[EMAIL PROTECTED]>
To:
Sent: Friday, April 28, 2006 8:51 AM
Subject: Quick Replication Question
When you h
no.
- Original Message -
From: "Robinson, Eric" <[EMAIL PROTECTED]>
To:
Sent: Friday, April 28, 2006 8:51 AM
Subject: Quick Replication Question
When you have master-slave replication enabled, and something goes wrong
with one of the tables on the master, and
When you have master-slave replication enabled, and something goes wrong with
one of the tables on the master, and you have to run mysqlcheck -r to fix it,
does the fix get written to the binlog and replicated to the slave?
--Eric
--
MySQL General Mailing List
For list archives: http://lists.my
Hello.
According to:
http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
you shouldn't have any problems, but 4.0.16 is a very old version.
I strongly recommend you to upgrade.
"Jeff" <[EMAIL PROTECTED]> wrote:
> Does anyone know if there are any problems replicating fr
- Original Message -
From: "Kishore Jalleda"
as per
http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
there should be no problems
On 8/17/05, Jeff <[EMAIL PROTECTED]> wrote:
> Does anyone know if there are any problems replicating from a master
> database on version 4.0.16 t
as per
http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
there should be no problems
Kishore Jalleda
On 8/17/05, Jeff <[EMAIL PROTECTED]> wrote:
> Does anyone know if there are any problems replicating from a master
> database on version 4.0.16 to a slave running version 4.1.13
Does anyone know if there are any problems replicating from a master
database on version 4.0.16 to a slave running version 4.1.13?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
In my replication setup with 4.1.11 master and 5.0.4 slave
CREATE TABLE and CREATE DATABASE statements are replicated
perfectly.
"Shannon R." <[EMAIL PROTECTED]> wrote:
> Hi All!
>
> I'm using the latest mysql 4.0.x and I've successfully
> set-up database replication on it
Hi All!
I'm using the latest mysql 4.0.x and I've successfully
set-up database replication on it over 2 machines.
I have noticed though that mysql doesn't seem to
replicate CREATE TABLE operations on the master to the
slave. Is this a limitation? Or I just missed
something. If so, can someone ple
Jason Lixfeld <[EMAIL PROTECTED]> wrote on 03/12/2004 03:32:32:
> I'm very new to mysql and replication. I've got a case where I have 2
> servers, each have database A and database B. I want server 1 to be
> master for database A and slave for database B and I would like server
> 2 to be slav
I'm very new to mysql and replication. I've got a case where I have 2
servers, each have database A and database B. I want server 1 to be
master for database A and slave for database B and I would like server
2 to be slave for database A and master for database B.
From what I've read, if a se
The binary logs used for replication set the value used for
autoincrementing before each insert query. The number on the master
will always be replicated properly. If a row already exists with the
autoincrement value, my guess is that replication will die with an
error.
I'm not too sure which vers
5001
Peter
> -Original Message-
> From: Robinson, Eric [mailto:[EMAIL PROTECTED]
> Sent: 18 November 2004 21:35
> To: [EMAIL PROTECTED]
> Subject: Auto-Increment Starting Point? (Multimaster Replication
> Question)
>
>
> When you set a field to auto-incremen
When you set a field to auto-increment, can you tell it where to start?
I'm trying to set up multimaster replication, but I'm worried about
auto-increment collisions.
Q: If server A starts auto-incrementing at 0, and server B starts
auto-incrementing at some point higher than the maximum n
Very good, gmail does not handle mailing lists properly..
Sorry for sending this off-list to you, Alec.
On Fri, 9 Jul 2004 17:09:45 -0300, João Paulo Vasconcellos
<[EMAIL PROTECTED]> wrote:
>
>
> On Fri, 9 Jul 2004 10:44:42 +0100, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> > "L. Yeung
"L. Yeung" <[EMAIL PROTECTED]> wrote on 09/07/2004 08:38:38:
> Hi! I wanted to set-up a master-slave replication on
> my win2k box. When my master server fails, my slave
> server will automatically becomes my new "master
> server". And when my master server is back online, any
> changes on my slav
Hi! I wanted to set-up a master-slave replication on
my win2k box. When my master server fails, my slave
server will automatically becomes my new "master
server". And when my master server is back online, any
changes on my slave server is replicated back to my
master server.
Normal: A -> B
Jonas Lindén <[EMAIL PROTECTED]> wrote on 26/03/2004 07:56:18:
> Hello list, I am about to embark on a little repliction mission;) I
> was thinking about setting up a MySQL slave on my Windows box and
> replicate my MySQL 5.0 Master which runs on my Linux box. Could the
> mix of architectur
ml)
good luck!
--bmansell
From: Jonas Lindén [mailto:[EMAIL PROTECTED]
Sent: Thu 3/25/2004 11:56 PM
To: [EMAIL PROTECTED]
Subject: Replication question
Hello list, I am about to embark on a little repliction mission;) I was thinking about
setting up a MySQL s
Hello list, I am about to embark on a little repliction mission;) I was thinking about
setting up a MySQL slave on my Windows box and replicate my MySQL 5.0 Master which
runs on my Linux box. Could the mix of architectures become a problem? I also use
innodb tables alot, are they replicateble? o
Greetings,
I am replicating from 4.0.17 to 4.0.16. I read through the replication
docs, and I didn't see anything relating to what I'm trying.
What I am hoping to do ... is slave the multiple databases ( the whole
thing ), in order to avoid shutting down ( or at least locking ) the
master and ma
> -Original Message-
> From: Tobias Asplund [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 22, 2003 11:21 AM
> To: Jeff McKeon
> Cc: [EMAIL PROTECTED]
> Subject: Re: Replication Question
>
>
> On Mon, 22 Dec 2003, Jeff McKeon wrote:
>
> > Is i
On Mon, 22 Dec 2003, Jeff McKeon wrote:
> Is it possible to have 2 database on one server replicating from the
> same Master server?
yes.
> In other words. DB01 is the Master on System01,
> System02 has DB01_rep1 and DB01_rep2, each with their own replication
> from DB01.
Shouldn't be a problem.
Is it possible to have 2 database on one server replicating from the
same Master server?
In other words. DB01 is the Master on System01,
System02 has DB01_rep1 and DB01_rep2, each with their own replication
from DB01.
I need to do this to have a development copy of DB01 on System02. I
have prod
Didn't have the list cc-ed.
-Forwarded Message-
> From: Andrew Hall <[EMAIL PROTECTED]>
> To: Mike Johnson <[EMAIL PROTECTED]>
> Subject: RE: replication question
> Date: Fri, 05 Dec 2003 16:17:14 -0500
>
> Ok, at this point it appears my rep
DUH!! I should have tried that...
Thank you!
Drew
On Fri, 2003-12-05 at 15:49, Victor Pendleton wrote:
> Try slave start
>
> -Original Message-
> From: Andrew Hall [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 05, 2003 2:46 PM
> To: [EMAIL PROTECTED]
>
Try slave start
-Original Message-
From: Andrew Hall [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 2:46 PM
To: [EMAIL PROTECTED]
Subject: replication question
Greetings,
Firstly I have searched the archives and received exactly 0 results
returned for 'START SLAVE 106
Greetings,
Firstly I have searched the archives and received exactly 0 results
returned for 'START SLAVE 1064' so...
I have a mysql server I wish to replicate, its running 3.23.54. I have
two test FreeBSD 5.1 servers I installed and from ports version
3.23.58. I completed the following steps to
Hi,
I'm trying to use replication and the slave stopped with error:
"Could not parse relay log event entry. The possible reasons are: the
master's binary log is corrupted (you can check this by running
'mysqlbinlog' on the binary log), the slave's relay log is corrupted
(you can check this by
SQL
> Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> >
> > Sorry. I am wrong. Situation is worse.
> > Both tables aren't replicate to the slave.
> > But query try run it on slave :(
> >
> > slave: mysql-4.0.13
> > master: mysql-4.0.14
>
> What replication options do you use?
Full scheme is:
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
>
> Sorry. I am wrong. Situation is worse.
> Both tables aren't replicate to the slave.
> But query try run it on slave :(
>
> slave: mysql-4.0.13
> master: mysql-4.0.14
What replication options do you use?
>
>>
>> I have 2 servers. 1-st is master, 2
Hi, All!
SQL, mysql
Sorry. I am wrong. Situation is worse.
Both tables aren't replicate to the slave.
But query try run it on slave :(
slave: mysql-4.0.13
master: mysql-4.0.14
>
> I have 2 servers. 1-st is master, 2-d - slave.
> But slave store only some tables of master.
> For example, master h
I'm pretty sure you need to sync the entire database (all tables) to all
slaves before starting replication..Your servers are technically
already out of sync..
And no wonder it crashes, tables are missing in it's view..You need to
hit the initial replication setup manual pages..
On Thu,
Hi, All!
SQL, mysql
I have 2 servers. 1-st is master, 2-d - slave.
But slave store only some tables of master.
For example, master has tables A, B
But slave has only A table
The problem:
query: UPDATE A,B SET A.a=B.a WHERE A.c=B.c;
the result: crash replication on slave;
Is it right?
Best
Here is the scenario:
4.0.15 as the master
3.23.57 is the slave
I can't get them to replicate until I downgraded 4.0.15 to 3.23.57
This was the error produced
030911 23:45:47 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication star
ted in log 'FIRST' at position 79
030911 23:45:4
Hi All,
I'm having a few issues getting things up and running
in regards to replication.
I believe I have everything setup correctly the slave
is roughly in the same spot as the master as far as
the logs are concerned. However, when I make changes
in the master db I don't see them show up in the
Hi All,
I'm having a few issues getting things up and running
in regards to replication.
I believe I have everything setup correctly the slave
is roughly in the same spot as the master as far as
the logs are concerned. However, when I make changes
in the master db I don't see them show up in the
Should be fine as long as the column on C has a default and is not a
unique index.
-->-Original Message-
-->From: Jeff McKeon [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, August 20, 2003 6:05 AM
-->To: MySql
-->Subject: RE: Replication question
-->
-->Nobody has an
Nobody has any advice for this one?
Jeff
> -Original Message-
> From: Jeff McKeon
> Sent: Tuesday, August 19, 2003 8:22 AM
> To: [EMAIL PROTECTED]
> Subject: Replication question
>
>
> Hey all,
>
> I have 3 databases replicating (ver 3.23) A to B
Hey all,
I have 3 databases replicating (ver 3.23) A to B and B to C
On C I want to modify one of the tables and add a column. Tables A and
B will not have this new column added. Will this cause a problem
replicating data form B to C?
Thanks,
Jeff
--
MySQL General Mailing List
For list arch
I have connect my web server (master) to my local server (slave) through
dial-up and replicate 2 databases.
a) Is there a log file describing the replications that happend (if any)?
b) how do I know when to stop the dial-up so not to stop any data transfer
through repliication?
Thanx Nikos
--
trick")
Cheers
/rudy
-Original Message-
From: unplug [mailto:[EMAIL PROTECTED]
Sent: maandag 4 augustus 2003 12:03
To: mysql
Subject: replication question
HI all,
Is it possible to perform replication as follow? HOW?
master (innodb) ---replication---> slave (myisam)
HI all,
Is it possible to perform replication as follow? HOW?
master (innodb) ---replication---> slave (myisam)
Rgds,
Ringo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GlacierI have connect my web server (master) to my local server (slave)
through dial-up and replicate 2 databases.
a) Is there a log file describing the replications that happend (if any)?
b) how do I know when to stop the dial-up so not to stop any data transfer
through repliication?
Thanx Nikos
Chris Petersen <[EMAIL PROTECTED]> wrote:
> I work for a small (but very fast-growing) company, and we're about to
> start deploying our new website. Because it has a "live inventory"
> setup, and because our internal tools are so integrated with the
> ecommerce side of things, I figure that repli
I work for a small (but very fast-growing) company, and we're about to
start deploying our new website. Because it has a "live inventory"
setup, and because our internal tools are so integrated with the
ecommerce side of things, I figure that replication is the best tool for
us - we'd have a fast
Hi Woody,
I can't answer your question, but I just wanted you to know that I like your
signature ;-). Thats definitely a good one.!!
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 4日 金曜日 18:02、woody at nfri dot com さんは書きました:
> I am in the process of setting up replication for my mysql servers
At 04:02 AM 7/4/2003 -0500, woody at nfri dot com wrote:
What kind of traffic volume is generated with replication, our database
has a pretty steady read/update volume throughout the day and its pretty
much 50/50 read/write. I do plan to offload some of the reads (such as
for daily reports and in
1 - 100 of 166 matches
Mail list logo