Delete replication on replication

I have configured mysql replication and test to insert some records.
Both nodes synchronized but when I delete 1 record from the main node,
why the second node not synchronized? TIA.



Willy


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Delete replication on replication

--001e680f13385e5162046d09a8fb
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

what do yo get when you run "show slave status" on the slave?
are you replicating the database you are modifying?

Isart Montane

On Tue, Jun 23, 2009 at 7:29 AM, sangprabv wrote:

> I have configured mysql replication and test to insert some records.
> Both nodes synchronized but when I delete 1 record from the main node,
> why the second node not synchronized? TIA.
>
>
>
> Willy
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=isart.montane@gmail.com
>
>

--001e680f13385e5162046d09a8fb--

Re: Delete replication on replication

Hi Isart,
Thx for the reply. Currently it has been solved. I rolled back and re
configure it. What I wonder is what cause the problem, since I did all
the same procedures. FYI I didn't make any structure change on my DB and
table. TIA.



WM


On Tue, 2009-06-23 at 21:15 +0100, Isart Montane wrote:
> what do yo get when you run "show slave status" on the slave?
> are you replicating the database you are modifying?
>
> Isart Montane
>
> On Tue, Jun 23, 2009 at 7:29 AM, sangprabv
> wrote:
> I have configured mysql replication and test to insert some
> records.
> Both nodes synchronized but when I delete 1 record from the
> main node,
> why the second node not synchronized? TIA.
>
>
>
> Willy
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=isart.montane@gmail.com
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org