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