How is it architecturally correct to collect data?

Question

linux

Good afternoon, I go to the server and collect data, for example, rpm -qa, cat /passwd/ var/log/secure etc, how to collect it correctly?
1. will it be correct for the script to work on the remote computer and upload the table to mysql?
2. or copied the script on my laptop and uploaded it to the database?
3. your choice

Answer 1

1. That's right, but storing texts in MySQL is a cool story, except for the logs line by line with metadata, for cat /etc/passwd there are MongoDB and other document-oriented DBMS.
2. If you want to drive data - please.
3. Agent for fees → DB for storage. Beats/Elasticsearch, rsyslog/MySQL, lots of options.