the main table have 29M rows (39GB, servers are "small" and old (2008), 16GB ram, 8core dual-cpu xeon, raid 10 hd with 4 sata disks 250gb each, 4 1Gbps network card ) 20+ process updating, deleting, inserting (oltp, 1000+ qps, i think it will not grow with time) 5+ process running olap with big selects/group/order/min/max/sum/count etc (some queries take more than 5 minutes to end, it's not a problem to user, but a problem when use oltp+olap apps at same table) today using replication to another server or mysqld process at same machine i don't have problem, olap and oltp runs nice with different mysqld process but when i try oltp + olap at same table at same mysqld, locks begin a problem, i was thinking about creating a replication at same server but to different table (replicate table a to table b) 2015-07-03 18:28 GMT-03:00 Stephane VAROQUI <stephane@mariadb.com>:
Hi,
How many writes do you have ? How much do you plan ? When you read how many records and what is your business case ?
/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
-- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle