maria-discuss team mailing list archive
Mailing list archive
Re: doubt - replication at same mysqld process
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 .
Stéphane Varoqui, Senior Consultant
Phone: +33 695-926-401, skype: svaroqui
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@xxxxxxxx>:
>> 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
>> 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
>> (on same machine or other machine), the point is... could i
>> in same server (with only one server running / only one
>> 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
>> 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
>> any idea/help is wellcome
>> Roberto Spadim
>> 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
> Roberto Spadim
> SPAEmpresarial - Software ERP
> Eng. Automação e Controle
> 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