| Atle Veka 2006-04-07, 1:28 pm |
| Do you have control over your DELETE queries? If so, 'SET SQL_LOG_BIN=0'
would be an easy implementation.
A common approach in my experience is to have a script query the master
and archive data to a second database before any deletes are done.
If you have no control over the DELETE queries and when they occur, you
may have to look into parsing the binlogs yourself...
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Fri, 7 Apr 2006, Ian Collins wrote:
> Hi,
> I have a customer who wants to be able to replicate their live MySQL
> database to a second server, but not to have any data deleted.
> i.e., they want to accumulate the data.
>
> I don't believe you can do this with replication. Does anyone know a way
> of doing this?
>
> Cheers,
> Ian.
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|