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 <[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
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
