First, if you want no duplicate parent_id, make it unique key (as JW saids).
Look at INSERT ... ON DUPLICATE KEY UPDATE, I think this will solve the problem
with one statement.
Rodrigo Ferreira
--- On Wed, 3/24/10, Johnny Withers wrote:
From: Johnny Withers
Subject: Re: SELECT and INSERT if
Hi Monteiro,
Probably, InnoDB in not enabled by default on your MySQL server.
I guess the statement "show engines" can help you.
Please, strip "LEGAL ADVICE" from your subsequent messages to the list.
Thanks,
Rodrigo Ferreira
CMDEV, CMDBA, Msc.
--- On Mon, 1/31/11, M. Rod
---+
| Code | sid | ip | time |
+++--++
| 611179 | 312713 | 66.249.68.87 | 1268650281 |
+++--++
1 row in set (0.00 sec)
Any idea?
Rodrigo Ferreira
CMDBA, CMDEV
--+
1 row in set (0.00 sec)
mysql>
--- On Wed, 3/2/11, Johan De Meersman wrote:
From: Johan De Meersman
Subject: Re: Two Identical Values on Primary Key Column
To: "Rodrigo Ferreira"
Cc: mysql@lists.mysql.com
Date: Wednesday, March 2, 2011, 11:21 AM
#yiv704254679 p {margin:0;}
conferir:
http://www.optmax.com.br/main/php/monitoramento.php
Obrigado,
Rodrigo Ferreira
Hi,
Is that a way to make multi-master asynchronous replication with mysql ou
external lib?
I know galera cluster but it is synchronous.
The problem is a set of eventually disconected nodes need to send all changes
(when connected) to a master always connected node.
Thanks!
Rodrigo
disconected, and one node disconnected (suppose one whole day disconnected) can
delay the whole replication.
Any suggestion?
Rodrigo
On Monday, November 24, 2014 1:43 PM, Johan De Meersman
wrote:
- Original Message -
> From: "Rodrigo Ferreira"
> Subject: Multi-Mas
Sorry, I will check this = "with recent MariaDB, a slave can have multiple
masters"
On Monday, November 24, 2014 2:26 PM, Rodrigo Ferreira
wrote:
Thanks for your response.
In this case, circular replication is not apropriate because there are about 10
to 15 nodes, and i
