On Mon, 6 May 2002 07:44:04 +0200
"Ewan Sadie" <[EMAIL PROTECTED]> wrote:
> I have installed MySQL on two of my MS-Proxy servers. I am logging all
> web browser logs to MySQL.
> I want to replicate the database to a central server where I can do
> queries on the data. I do not want to run select statement agains the
> proxy server itself.
> How can I replicate the data to a different server (like with slave
> master replication) and then delete the data on the proxy server,
> without deleting it on the central server.
> What I actually want to do is something like a selecy into but between
> different server/databases.
>
> I am evaluation MySQL and if I can get this right I will chuck out my
> MS-SQL databases.
>From my experience, I can tell you this :
Master ------------------> Slave
Replication
Every query that change the data on master will be replicated on slave.
But I think you can try this :
binlog-db : DB_A
biglog-ignore-db : DB_B
DB_A is the database which will be replicated.
you can do the "delete" query with using "DB_B" database,
e.g. : "use DB_B; delete from table DB_A.Table_A;"
Correct me if i'm wrong ... ;-)
--
We are using Linux daily to UP our productivity - so UP yours!
-- Adapted from Pat Paulsen by Joe Sloan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
