maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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@xxxxxxxxxxx>:
> 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@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?
>
>
> Regards
>
> Federico
>
>
>
>
> --------------------------------------------
>
> 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
>
> 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@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
>
>



-- 
Roberto Spadim
SPAEmpresarial - Software ERP
Eng. Automação e Controle