2014/1/17 Richard Reina gatorre...@gmail.com
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.
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
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
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 old.
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
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
://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: Replication question
I have been
To activate log-slave-updates do I just add log-slave-updates to the
my.cnf file?
2013/4/30, Manuel Arostegui man...@tuenti.com:
2013/4/30 Richard Reina gatorre...@gmail.com
I have a few slaves set up on my local network that get updates from
my main mysql database master. I was hoping to
That is correct.
On Mon, May 6, 2013 at 11:06 AM, Richard Reina gatorre...@gmail.com wrote:
To activate log-slave-updates do I just add log-slave-updates to the
my.cnf file?
2013/4/30, Manuel Arostegui man...@tuenti.com:
2013/4/30 Richard Reina gatorre...@gmail.com
I have a few
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.
-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
1) Enable log-bin on master2 (slave
]
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 log-bin on master2 (slave that will be converted to a master)
2) Enable log-slave
2013/4/30 Richard Reina gatorre...@gmail.com
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
2012/10/25 Sabika M sabika.makhd...@gmail.com
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
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
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 writing to server C, can I use
the change master statement to make the C
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
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?
add
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
.
-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
-
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 that was it done this
many times in the last
@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
many times in the last years and it takes 30 seconds if you are fast
enough to type the slave-commands
Am 24.08.2012 23:35
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
--
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 杨涛涛 david.y...@actionsky.com:
Ok, I'll not post any more! Just reading!
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My
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 vegiv...@tuxera.be写道:
Glad to hear I'm not
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 杨涛涛 david.y...@actionsky.com:
This way is very well, but it has to do lots of human work.
David Yeung, In China, Beijing.
My
Glad to hear I'm not the only one annoyed :-) I've plonked him in the
meantime.
2010/12/23 Jorg W Young jorgwyoung...@gmail.com jorgwyoung%2...@gmail.com
This guy has been saying nothing meaningful on this list, but
advertise his blog everywhere.
Just be shame. He should be kicked out from
-
From: Machiel 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
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
:
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
at 1:20 PM, Machiel Richards machi...@rdc.co.za
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.
We are trying to find out how to setup 3 different masters to
replicate
On Wed, Nov 24, 2010 at 2:50 PM, John Daisley daisleyj...@googlemail.comwrote:
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
: Machiel 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
client
: 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 MASTER TO command.
Its
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-MySQL
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
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 layer, sending
all the updates (insert
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,
: 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, and
the devs have said they're not interested in trying to turn
the regular
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
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 fails, it's
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
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 project
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
-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
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
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
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.
--
MySQL
-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
|
C
One thing I can't remember is do I have to set
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:
no.
- Original Message -
From: Robinson, Eric [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 you
: 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: mysql@lists.mysql.com
Sent: Friday, April 28, 2006 8:51 AM
Subject: Quick Replication Question
When you have
- 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 to a
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 from a
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]
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?
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
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 over 2
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 slave for
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
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
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
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-increment, can you tell it where to start
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
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 slave server
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 [EMAIL
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?
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 slave on my
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 architectures
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
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
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.
I
-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 it possible to have 2 database on one server
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
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 1064' so
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]
Subject: replication question
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 replication is working, but I have two
questions
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:
|
+-A|
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?
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
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 has
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-d - slave.
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
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
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
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 any advice for this one
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
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
--
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]
/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)
Rgds,
Ringo
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 replication
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
I am in the process of setting up replication for my mysql servers, and
had a couple of questions I wanted to clarify. One of the slaves will
be located in an offsite hotsite, and another local. The hotsite slave
will only be used to mirror the data, in the event of a failure or
accident at the
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
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:02woody at nfri dot com :
I am in the process of setting up replication for my mysql servers, and
had a
1 - 100 of 162 matches
Mail list logo