Re: sync

yes, they should be identical , am thinking to use the howtoforge mysql_database_replication document. On Mon, Sep 1, 2008 at 4:58 PM, Ranjeet Walunj <[EMAIL PROTECTED]>wrote: > Mad Unix wrote: > >> I was wandering if anyone know a good way to sync 2mysql databases >> _one_way >> The mysql is alo

RE: sync

gt; Date: Mon, 1 Sep 2008 17:58:10 +0530> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: sync> > Mad Unix wrote:> > I was wandering if anyone know a good way to sync 2mysql databases _one_way> > The mysql is alocated on a web

Re: sync

Mad Unix wrote: I was wandering if anyone know a good way to sync 2mysql databases _one_way The mysql is alocated on a web php application Do they (DB) need to be identical ? Have you checked replication ? Regards, Ranjeet Walunj -- MySQL General Mailing List For list archives: http://lists

Re: sync

Hi, Have you tried mk-table-sync from the Maatkit toolset http://www.maatkit.org/tools.html Ewen On Mon, Sep 1, 2008 at 2:12 PM, Mad Unix <[EMAIL PROTECTED]> wrote: > I was wandering if anyone know a good way to sync 2mysql databases _one_way > The mysql is alocated on a web php application. >

Re: Sync 2 live MySQL Databases

This is precisly the problem that I'm sitting with. It look like unless MySQL AB desides to build such a feature into one of the future releases this would beable to work. Mnr Cecil J.C. Brand Computer Services/ RekenaarDienste University of the Free State/ Universiteit van die Vrystaat PO Box

Re: Sync 2 live MySQL Databases

On 26/05/2005 6:40 p.m., Cecil Brand wrote: Hi, I was wandering if anyone know of a stable and reliabile way to sync 2 live mysql databases, both ways. I know I can use a master and slave, and yes have setup a few without any problem, but as all of us know this is just a one way downstream sync.

Re: Sync db

It's safe to implement two-way replication (properly called multimaster replication) in MySQL if each master is guaranteed to only update a unique subset of that data (ie data that no other master database changes). Each master database would be able to safely read all the data, however. For e

Re: Sync db

Two way replication is possible. However, it does not work like you think it would. It would not be safe to modify data on both databases at the same time. See the FAQ on replication: http://dev.mysql.com/doc/mysql/en/Replication_FAQ.html There is some information regarding two-way replication tha

Re: Sync db

yeah, I seen that have. Have you tried that before? I need to do it two-way. But have not seen any special setup for that. Each site will be entering data and all sites will need to see the updated change. On Fri, 01 Oct 2004 10:38:07 -0400, Michael Stassen <[EMAIL PROTECTED]> wrote: > Have y

Re: Sync db

Have you considered replication ? Michael spiv007 wrote: I want to know what to best way to keep a 4 mysql servers sync. I have 4 remote locations, I am thinking about putting a mysql server in each location and every hour have the 1 db that I