logstash 8.2.3 install
# DataBase/Elasticsearch2022. 6. 17. 13:34logstash 8.2.3 install

다운로드 https://www.elastic.co/kr/downloads/logstash Download Logstash Free | Get Started Now Download Logstash or the complete Elastic Stack (formerly ELK stack) for free and start collecting, searching, and analyzing your data with Elastic in minutes. www.elastic.co 설치환경 [darksharavim.tistory.com]cat /etc/redhat-release Rocky Linux release 8.6 (Green Obsidian) logstash 레포지토리 추가 [darksharavim.tist..

[elasticsearch]bootstrap check failure
# DataBase/Elasticsearch2022. 6. 16. 15:47[elasticsearch]bootstrap check failure

엘라스틱서치 아래와 같이 설정 변경 후 구동시 에러발생 [darksharavim.tistory.com]vi /etc/elasticsearch/elasticsearch.yml network.host: _site_ [2022-06-16T16:39:36,037][ERROR][o.e.b.Bootstrap ] [node-1] node validation exception [1] bootstrap checks failed. You must address the points described in the following [1] lines before starting Elasticsearch. bootstrap check failure [1] of [1]: memory locking requested for elas..

elasticsearch 8.2.3 install
# DataBase/Elasticsearch2022. 6. 16. 08:57elasticsearch 8.2.3 install

다운로드 https://www.elastic.co/kr/downloads/elasticsearch Download Elasticsearch Download Elasticsearch or the complete Elastic Stack (formerly ELK stack) for free and start searching and analyzing in minutes with Elastic. www.elastic.co 설치환경 [darksharavim.tistory.com]cat /etc/redhat-release Rocky Linux release 8.6 (Green Obsidian) 엘라스틱서치 GPG키 및 레포지토리 추가 [darksharavim.tistory.com]rpm --import https..

mysql ssl 설정 및 적용
# DataBase/Mysql(MariaDB)2022. 5. 3. 19:58mysql ssl 설정 및 적용

vi my.cnf [mysqld] ssl-ca = /home/mysql/fullchain3.pem ssl-key = /home/mysql/privkey3.pem ssl-cert = /home/mysql/cert3.pem service restart mysqld or mariadb MariaDB [(none)]> show variables like '%ssl%'; +---------------------+-----------------------------+ | Variable_name | Value | +---------------------+-----------------------------+ | have_openssl | YES | | have_ssl | DISABLED | | ssl_ca | /h..

mysql 현재 기준 한달이전 확인 쿼리
# DataBase/Mysql(MariaDB)2022. 4. 28. 18:02mysql 현재 기준 한달이전 확인 쿼리

SELECT count(*) FROM [table] WHERE [date_colum]

image