MySQL Forums
Forum List  »  InnoDB

High concurrency for master and high reading from slave slowing down insert
Posted by: Frwa Onto
Date: June 20, 2017 09:21AM

Hi All,
I am having a system which receive data from around 30K gps . Each unit will be inserting concurrently around 1 minute.
1.What tweak should I add to cater for this? I target my ram to be 48Gb with 24 cpus.
2. Once the data grow should I do partition or leave it . I am worried as the data grow the insert will be slow?
3. What should I anticipate and handling for heavy traffic?
4. I plan to have replication data so that the reading can be done from the slave? But what I am worried is that if I delete data from the master then it will effect slave too right?
5. Is possible to delete the partition from master but not from the slave?

Options: ReplyQuote


Subject
Views
Written By
Posted
High concurrency for master and high reading from slave slowing down insert
91
June 20, 2017 09:21AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.