Hi,

I've got a server with two databases on it. What's the best way to replicate them?

A single cluster with multiple databases (I'm not sure how I would do this, any sample scripts out there?)

Or

Two clusters replicating one database each.

I ask this question because I've setup two clusters already replicating one database each to a single slave server and I'm getting this error message

   remoteWorkerThread_1: transactions earlier than XID 3916431719 are still in progress
   remoteWorkerThread_1: data copy for set 1 failed - sleep 60 seconds

I'm wondering what the better option is.

Thanks.

Anoop

Anoop Bhat
Systems Administrator
Trustwave
70 W. Madison
Chicago, IL, 60602
O: 312.873.7446
C: 312.925.3271