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