maria-discuss team mailing list archive

[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