Publish ELK

[fuinyroot]

Publish ELK

• https://db-engines.com/en/system/Elasticsearch
• https://elk-docker.readthedocs.io/
• https://stackoverflow.com/questions/33340153/elasticsearch-bulk-index-json-data

Steps

Export json as rows

SELECT json
FROM artifactinfo
INTO outfile '/var/lib/mysql-files/artifactinfo.data'

Get the file

 sudo mv /var/lib/mysql-files/artifactinfo.data 

File size as of June 19, 2023 - 21 GB

fuinyroot@Server64:~/Downloads$ ls -alh
total 25G
drwxr-xr-x  4 fuinyroot fuinyroot  241 Jun 19 04:08 .
drwxr-xr-x 28 fuinyroot fuinyroot 4.0K Jun 19 04:02 ..
-rw-r-----  1 mysql     mysql      21G Jun 19 04:07 artifactinfo.data

Import the data file to ELK

• Like Shell script import it in parallel

Export the

• Export the ELK index