I am looking for an expert in MySQL to improve our database.
We have two databases synching over WLAN. Database 1 (on local PC) receives data from a device connected to it with approx. 4,000row/sec. This database will be synching to the master database located on a server on the network. This database will receive input from multiple PCs on the WLAN simultaneously and must be able to receive up to 40,000rows per second. We also need the ability to add/remove data from the database without disrupting the continuous performance.