Multi-Master Asynchronous Replication

2014-11-24 Thread 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

Re: Multi-Master Asynchronous Replication

2014-11-24 Thread Rodrigo Ferreira
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 vegiv...@tuxera.be wrote: - Original Message - From: Rodrigo Ferreira rodrigof_si...@yahoo.com

Re: Multi-Master Asynchronous Replication

2014-11-24 Thread Rodrigo Ferreira
Sorry, I will check this = with recent MariaDB, a slave can have multiple masters On Monday, November 24, 2014 2:26 PM, Rodrigo Ferreira rodrigof_si...@yahoo.com wrote: Thanks for your response. In this case, circular replication is not apropriate because there are about 10 to 15

OPTMAX MySQL Monitor

2012-07-17 Thread Rodrigo Ferreira
conferir: http://www.optmax.com.br/main/php/monitoramento.php  Obrigado, Rodrigo Ferreira

Two Identical Values on Primary Key Column

2011-03-02 Thread Rodrigo Ferreira
   | time   | +++--++ | 611179 | 312713 | 66.249.68.87 | 1268650281 | +++--++ 1 row in set (0.00 sec) Any idea? Rodrigo Ferreira CMDBA, CMDEV

Re: Two Identical Values on Primary Key Column

2011-03-02 Thread Rodrigo Ferreira
/2/11, Johan De Meersman vegiv...@tuxera.be wrote: From: Johan De Meersman vegiv...@tuxera.be Subject: Re: Two Identical Values on Primary Key Column To: Rodrigo Ferreira rodrigof_si...@yahoo.com Cc: mysql@lists.mysql.com Date: Wednesday, March 2, 2011, 11:21 AM #yiv704254679 p {margin:0

Re: Table creation

2011-01-31 Thread Rodrigo Ferreira
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. Rodrigo Monteiro fale

Re: SELECT and INSERT if no row is returned

2010-03-24 Thread Rodrigo Ferreira
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 joh...@pixelated.net wrote: From: Johnny Withers joh