maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

 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