← Back to team overview

maria-discuss team mailing list archive

Re: doubt - replication at same mysqld process

 

Hi,

How many writes do you have ? How much do you plan ? 
When you read how many records and what is your business case  ?

/stephane 
Stéphane Varoqui, Senior Consultant
Phone: +33 695-926-401, skype: svaroqui
http://www.mariadb.com

Le Jul 3, 2015 à 11:23 PM, Roberto Spadim a écrit :

> i didn't tested but spider have HA/federate, maybe i could use it?
> 
> 2015-07-03 18:00 GMT-03:00 Federico Razzoli <federico_raz@xxxxxxxx>:
>> I'm not sure. Flexviews should be a good solution.
>> 
>> Or you can used triggers to "replicate" the table instantly.
>> 
>> I don't understand your idea with SPIDER, how will it help you?
>> 
>> Regards
>> Federico
>> 
>> 
>> 
>> --------------------------------------------
>> Ven 3/7/15, Roberto Spadim <roberto@xxxxxxxxxxxxx> ha scritto:
>> 
>> Oggetto: [Maria-discuss] doubt - replication at same mysqld process
>> A: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
>> Data: Venerdì 3 luglio 2015, 22:23
>> 
>> hi guys, i have a doubt about
>> replciation on same machine, i never did
>> this before
>> 
>> 
>> i have a table running many writes and few reads, and
>> another process
>> start reading a lot, my today solution is replication on two
>> servers
>> (on same machine or other machine), the point is... could i
>> replicate
>> in same server (with only one server running / only one
>> mysqld
>> process) ?
>> 
>> something like change table A, and a background process
>> replicate to
>> table B? "many writes" will write at table A, reads will
>> read table B
>> (read can be out of sync)
>> 
>> innodb is locking a lot of rows, and myisam/aria is locking
>> table a
>> lot, both engines i have problem with lock, i consider
>> replication to
>> another mysqld process as the only solution, but i'm
>> considering
>> running only one mysqld process (if possible)
>> i was thinking about something like HA in spider, but i
>> didn't tested,
>> maybe with flexviewcdc i could have a materialized view "B"
>> of table
>> A?
>> 
>> any idea/help is wellcome
>> 
>> --
>> Roberto Spadim
>> 
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>> 
> 
> 
> 
> -- 
> Roberto Spadim
> SPAEmpresarial - Software ERP
> Eng. Automação e Controle
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp


Follow ups

References