i didn't tested but spider have HA/federate, maybe i could use it? 2015-07-03 18:00 GMT-03:00 Federico Razzoli <[email protected]>: > 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 <[email protected]> ha scritto: > > Oggetto: [Maria-discuss] doubt - replication at same mysqld process > A: "Maria Discuss" <[email protected]> > 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 : [email protected] > 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 : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
