Hi Frederico, So far i don't see why you would need multiple mysqld on the same server unless you have flash cards doing 128K iops The read scalability now a day of mariadb can get you very far on the same table , and read will not lock records . It looks like a simple better configuration and indexing can get you to the limit of a single server , than it will be time to talk about spider and flexview. Tell us more about your workload, how many read write queries and how many records read per sec (handler or innodb reads status ) and the hardware to you are running . We can give you an idea if such extra tools are needed . /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@yahoo.it>:
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@spadim.com.br> ha scritto:
Oggetto: [Maria-discuss] doubt - replication at same mysqld process A: "Maria Discuss" <maria-discuss@lists.launchpad.net> 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@lists.launchpad.net 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp