i know server is old to run both process at same machine (iops become too small and hardware must be changed) running with two machines is ok my doubt is if i could execute only one mysqld and replicate table at background flexview have a cdc tool to read binlog that's why i was considering it running at background and "doing the replicate" to another table ~ a "materialized view B", but if mariadb have other solution or idea is ok too
2015-07-03 18:39 GMT-03:00 Stephane VAROQUI <[email protected]>: > 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 <[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 > > -- 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
