This is the first public announcement of rubyrep, an open source
software for asynchronous, master-master replication of relational
databases.
It has been designed for
- database independence (currently supported: PostgreSQL and MySQL)
- being ridiculously easy to use
Getting from zero to working
Hi Scott,
Thanks for the information. I'll look into linux-ha seriously.
Regards,
Ben
Scott Tanner wrote:
Ben,
Check out Linux-ha ( http://linux-ha.org). We are using version 1 at my company, which is fairly easy to set up and there are a lot of good articles on it. With this you can cr
Ben,
Check out Linux-ha ( http://linux-ha.org). We are using version 1 at my
company, which is fairly easy to set up and there are a lot of good articles on
it. With this you can create a virtual address to fail-over between systems,
run commands / scripts during a fail over, and even kill
I forgot to mention that I am running Linux.
If anybody has some idea of software which can do this, I'd be very
interested.
Regards,
Ben
Ben Clewett wrote:
Dear MySql,
I'm looking into availability and wonder if any member might be able to
help me.
I have two databases, one Primary and
Dear MySql,
I'm looking into availability and wonder if any member might be able to
help me.
I have two databases, one Primary and one full Replication.
Normally the primary is used for data input, reports are drawn from the
replication.
If I loose the Primary, do any members have any soft
Hello All.
We have replication setup thus:- Master A --> Slave B. Now, the data
center will like to implement ca-unicenter on server-A and do some
testings for automation purpose. You've guessed it, Mysql-A will be
up-and-down for the next couple weeks. To provide business continuity, I
have be
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
All,
I have been tasked with setting up DR between two different sites. Is there
a favorite tool or GUI that someone could recommend for this task?
Regards,
Alan L. Fisher
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
This is really cool! Can something be done with this to use a
materialized view log on a table in Oracle and sync with a table in
mysql?
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 9:54 AM
To: mysql@lists.mysql.com
Subject: RE: databas
Thanks !
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 08, 2004 3:18 AM
To: [EMAIL PROTECTED]
Subject: Re: Load data question in cross database replication
Hello.
It seems to be a bug:
http://bugs.mysql.com/bug.php?id=6353
"Sa
ch are not using
> --replicate-rewrite-db. It do not work for those which are using this.
>
> Thanks for you reply.
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 03, 2004 4:14 AM
> To: [EMAIL PROTECTE
:[EMAIL PROTECTED]
Sent: Friday, December 03, 2004 4:14 AM
To: [EMAIL PROTECTED]
Subject: Re: Load data question in cross database replication
Hello.
--replicate-rewrite-db is not taken into account while executing LOAD
DATA
FROM MASTER. See:
http://dev.mysql.com/doc/mysql/en
Hello.
--replicate-rewrite-db is not taken into account while executing LOAD DATA
FROM MASTER. See:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA_FROM_MASTER.html
"Sanjeev Sagar" <[EMAIL PROTECTED]> wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Hello Everyone,
I have a question on using LOAD DATA command in cross database
replication setup. MySQL version is 4.0.21
I have replication farm where few slaves have been set up as cross
database replication slave by using (replicate-rewrite-db).
When Load data command get executed
EMAIL PROTECTED]>
To: "'Richard Bewley'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, December 04, 2003 3:15
AM
Subject: RE: More database
replication
> Anyone have any ideas about this?> > Thanks,>
Richard> > -Original Message-
Anyone have any ideas about this?
Thanks,
Richard
-Original Message-
From: Richard Bewley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 7:10 PM
To: [EMAIL PROTECTED]
Subject: More database replication
Hi,
I have a "mission critical" database, that I want to be
Hi,
I have a "mission critical" database, that I want to be redundant, so I'm
using, as discussed in another thread, the Cisco LocalDirector, two mysql
machines, and db replication. mySQL version 4.0.16, compiled from source.
Should I make both servers both master and slave, or will this cause
p
Richard Bewley wrote:
Ok, but the slave would also replicate to the master? Is anyone using this
type of setup?
Both machines would be set up as both masters and slaves.
We tried it during the Mysql class I took a few weeks ago. Worked
fine, except for when there were conflicting updates.
-
Ok, but the slave would also replicate to the master? Is anyone using this
type of setup?
Thanks,
Richard
-Original Message-
From: Chuck Gadd [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 29, 2003 6:34 PM
To: Richard Bewley
Subject: Re: Database replication
Richard Bewley wrote
Hi,
I'm working on setting up db replication, and I have a question. If I have
a master server, which will replicate to a slave, what about vice versa?
What I'm thinking I want to do, is load balance between two database servers
(our mail authentication database) using the Cisco LocalDiretor. My
3 12:19 PM
To: [EMAIL PROTECTED]
Subject: Database Replication Over the internet
Can MySQL database be replicated over the internet ?
If so, Please give me a pointer on that
Thanks and regards
Manivannan
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
On Thu, Jul 03, 2003 at 09:19:07AM -0700, Priya Manivannan wrote:
> Can MySQL database be replicated over the internet ?
>
> If so, Please give me a pointer on that
Yes.
Type "replication" into the search box in the on-line manual.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Y
Can MySQL database be replicated over the internet ?
If so, Please give me a pointer on that
Thanks and regards
Manivannan
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http:/
* Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
> On Tue, Jun 24, 2003 at 09:14:18PM -0700, Carl B. Constantine wrote:
> > I want to be able to take a database running on a primary server and
> > duplicate/mirror it on a secondary server. I want to be able to update
> > the secondary server on a select
On Tue, Jun 24, 2003 at 09:14:18PM -0700, Carl B. Constantine wrote:
> I want to be able to take a database running on a primary server and
> duplicate/mirror it on a secondary server. I want to be able to update
> the secondary server on a selectable interval (every 15 mins, every
> hour, etc). Wh
I want to be able to take a database running on a primary server and
duplicate/mirror it on a secondary server. I want to be able to update
the secondary server on a selectable interval (every 15 mins, every
hour, etc). What is the best way to accomplish this task? Consider that
at least one table
Paolo Pasetti wrote:
Do you usually use a cron job to start and stop slave or just leave it always on?
Always leave it on.
Basically, check how big your binary logs are for a day by rotating them
at midnight two days in a row and that's approximately the network
traffic for the day.
SQL,
Hello,
I'd like to know how much traffic the slave generates to retrieve sql data on master
server in a database replication configuration.
I'm interested in knowing this: does the slave generate traffic even if no updates are
done on the master (traffic for waiting data?) ?
Do y
o know how much traffic the slave generates on master server in a database
>replication configuration.
>
>I'm interested in knowing this: does the slave generate traffic even if no updates
>are done on the master (tr
> -Original Message-
> From: Paul Darius [mailto:[EMAIL PROTECTED]]
> Subject: Database Replication
>
>
> 'lock database with read lock' command already done before the above
> replication started and followed by 'unlock all' when finished.
&
Dear all,
Hope this question did not disturb you.
I have one linux box with mysql install and working fine. Thank you MySQL.
Due to the information stored into database are really crittical data, I
decide to make another copy of the whole data into another linux box with the
same version of m
I highly recommend you update the slave to the same version as the master.
Mark D. Wallace wrote:
> I'm trying to set up a replication database and cannot get the slave
> to parse the log files on the master.
> The slave is connecting to the master as indicated in the log file.
>
> I have trie
I'm trying to set up a replication database and cannot get the slave to
parse the log files on the master.
The slave is connecting to the master as indicated in the log file.
I have tried to connect directly to the master database from the mysql
client on the slave and have no problem using the
Hi,
I have installed mysql 4.0 in redhat 7.2 now. I have two such servers
with mysql on it and I am now trying to configure them for replication.
1. I could not find my.cnf or my.ini on the box after installing
mysql. Won't mysql create those file during installation or do I
need to create
:
Subject: Database Replication
I have setup replication between two servers. Everything works great.
I wanted to change the location of the bin-log file. I tried
'log-bin=/somedirectory/replication.log' but I get this error
'replication.1 not found (Errcode: 2)'. I took this from the manual:
|--
-Original Message-
From: Thi Cao [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 12:04 PM
To: Thi Cao
Cc: MySQL
Subject: RE: MySQL Database Replication
ds,
If I understand you correctly, that also means that the user repl can access
the mysql database where all the privilege info is
11:02 AM
To: Thi Cao
Cc: MySQL
Subject: RE: MySQL Database Replication
On Wed, 2002-03-06 at 14:26, Thi Cao wrote:
> When I grant privileges as follows, the slave gets updated:
>
> GRANT FILE ON *.* to repl@'%' identified by 'some_password';
>
> Could someone
you don't need to grant
any additional privileges. For example, to create a user named repl
which can access your master from any host, you might use this command:
GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY '';
>
> Thi Cao wrote:
> >
> > Hello everyone
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 10:42 AM
To: Thi Cao
Cc: MySQL
Subject: Re: MySql Database Replication Question
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
> All,
>
> How can I notify an application running on the slave server that the
> slav
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
> All,
>
> How can I notify an application running on the slave server that the
> slave database has just updated itself by means of replication. The
> reason I ask is that I know MySql currently doesn't support
> triggers, but my applicat
All,
How can I notify an application running on the slave server that the slave
database has just updated itself by means of replication. The reason I ask
is that I know MySql currently doesn't support triggers, but my application
needs to be notified when an update on the slave has just taken p
hanks everyone.
Thi
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi Cao wrote:
>
> Hello everyone,
>
> This is my first attempt at MySQL database replica
Yes, I did flush the privileges when nothing else worked but that didn't do
the trick either. Thanks for trying.
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi Cao wrote:
>
> Hello everyone,
>
> This is my first attempt at MySQL database replication. Can't seem to get
> it to work yet. The problem reported in the error log of the slave server
> is as follows:
>
> Error reading packet from server: Access den
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work yet. The problem reported in the error log of the slave server
is as follows:
Error reading packet from server: Access denied for user 'repl@slave_host'
(Using password: YES
Thanks for the reply.
Jim
- Original Message -
From: "Rafal Jank" <[EMAIL PROTECTED]>
To: "Jim Lucas" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 21, 2001 1:25 AM
Subject: Re: Database Replication problem
> Jim Luca
Jim Lucas wrote:
>
> just wondering, when you start the database replicating, the bin files start
> counting
> at .000
>
> -bin.001
> -bin.002
> -bin.003
> ...
> -bin.999
>
> what happens when you reach .999?
>
> does it start over at .001 and over-write you initial files, or does it
> continu
just wondering, when you start the database replicating, the bin files start
counting
at .000
-bin.001
-bin.002
-bin.003
...
-bin.999
what happens when you reach .999?
does it start over at .001 and over-write you initial files, or does it
continue on?
Thanks,
Jim Lucas
-
On Fri, Jul 20, 2001 at 12:23:11PM +0800, Russell Teo Wee Liang wrote:
> Hi all,
>
> I am running mysql 3.23.33 on a Sun Ultra-250 and is running slave
> databases on 2 other machines. Everything was running fine until
> someone created a new database and it wasn't updated in the slave
> databas
On Tue, Jul 17, 2001 at 09:37:19PM -0700, Ricardo Kleemann wrote:
>
> Hi everyone,
>
> I'm wondering how I should configure my.cnf if I have a master-slave
> scenario where I would like to declare the slave master if the
> master goes down.
>
> What I mean is, let's say I have 2 database server
Hi all,
I am running mysql 3.23.33 on a Sun Ultra-250 and is running slave databases on 2
other machines. Everything was running fine until someone created a new database and
it wasn't updated in the slave databases.
Is there anyway to work around this?
regards,
Russell.
Make sure it is world readable.
Jeremy Zawodny wrote:
> On Tue, Jul 17, 2001 at 02:49:15PM +0100, Ben Smith wrote:
>
>> We are looking to replicate a couple of databases on to a second
>> server. Having looked through the manual it says we need to add
>> various commands to my.cnf.
>>
>> It t
Hi everyone,
I'm wondering how I should configure my.cnf if I have a master-slave
scenario where I would like to declare the slave master if the master goes
down.
What I mean is, let's say I have 2 database servers:
server1 = master
server2 = slave
so normally my.cnf for server2 would have se
On Tue, Jul 17, 2001 at 04:11:44PM -0500, doug wrote:
> > MySQL 3.23.29: up 31 days, processed 237,155,060 queries (87/sec. avg)
>
> Ok Jeremy I have to ask: How do you get your MySQL stats in your
> signature like that?:->
It's a bit of a hack, but you're not the first to ask... So here goes.
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 3:14 PM
Subject: Re: Database Replication
> On Tue, Jul 17, 2001 at 02:49:15PM +0100, Ben Smith wrote:
> >
> > We are looking to replicate a couple of databases on to a second
> > server. Ha
On Tue, Jul 17, 2001 at 02:49:15PM +0100, Ben Smith wrote:
>
> We are looking to replicate a couple of databases on to a second
> server. Having looked through the manual it says we need to add
> various commands to my.cnf.
>
> It turns out that we do not have a my.cnf (so apprently MySQL just
Hello,
We are looking to replicate a couple of databases on to a second server.
Having looked through the manual it says we need to add various commands to
my.cnf.
It turns out that we do not have a my.cnf (so apprently MySQL just
defaults), so can we just create this file with the replication c
On Sat, May 19, 2001 at 01:18:42PM -0500, David Gullett wrote:
>
> I have 10 or so MySQL servers in the field, all writing data to a
> database of the same name. I would like to set up replication from
> all masters back to a single slave server and have each master write
> to a different databa
I have 10 or so MySQL servers in the field, all writing data to a database
of the same name. I would like to set up replication from all masters back
to a single slave server and have each master write to a different database.
Is there an easy way to do this, short of running multiple instances
60 matches
Mail list logo
