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 <stephane@mariadb.com>:
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
-- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle