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.
- Once the data grow should I do partition or leave it . I am worried as the data grow the insert will be slow?
- What should I anticipate and handling for heavy traffic?
- 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?
- Is possible to delete the partition from master but not from the slave?