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
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
If your internet connections aren't very fast and stable, or perhaps
dialup or similar you can do a poor-mans replication. I do this and
after lots of starts and stops on my scripts that get the data to the
slave server it's finally working very good. When you turn on bin-log in
my.cnf it just star
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
* 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
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,
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>sql,query
>
>If you just reply to this message, and include the entire text of it in the
>reply, your reply w
> -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.
>
> Question, how to sync an unsync table o
I finally got the log-bin to work. You CANNOT put an extension.
log-bin = /mysql/log/replication
Eric Baines
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
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
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
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
20 matches
Mail list logo
