maria-discuss team mailing list archive
Mailing list archive
R: doubt - replication at same mysqld process
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?
Ven 3/7/15, Roberto Spadim <roberto@xxxxxxxxxxxxx> ha scritto:
Oggetto: [Maria-discuss] doubt - replication at same mysqld process
A: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Data: Venerdì 3 luglio 2015, 22:23
hi guys, i have a doubt about
replciation on same machine, i never did
i have a table running many writes and few reads, and
start reading a lot, my today solution is replication on two
(on same machine or other machine), the point is... could i
in same server (with only one server running / only one
something like change table A, and a background process
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
lot, both engines i have problem with lock, i consider
another mysqld process as the only solution, but i'm
running only one mysqld process (if possible)
i was thinking about something like HA in spider, but i
maybe with flexviewcdc i could have a materialized view "B"
any idea/help is wellcome
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp