Heavy Performance question: Load Data Infile or standalone MySQL server? :S

I was just reading Load Data Infile error troubleshooting FAQ (Troubleshooting - Analytics Platform - Matomo) when I realized it only works when mySql and application server are localhost… Is it?

Reading also forum threads about heavy Piwik usage, I didn’t figured out if could be better having the two server decoupled on different machines or only one machine with Load Data Infiles enabled?

Does anyone have some kind of balanced configuration? Let’s debate! X(

Bumping my general purpose post, because of support requests in the wrong forum :frowning:

when I realized it only works when mySql and application server are localhost… Is it?

No it should work mysql and application are on different server as well ?