MySQL Exporter

Release Workstation using 0.14.0 and latest version also 0.14.0 How to install Unzip downloaded fileMove to /usr/local/binAnd create systemd service file [Unit] Description=Prometheus MySQL Exporter After=network.target User=prometheus Group=prometheus [Service] Type=simple Restart=always ExecStart=/usr/local/bin/mysqld_exporter \ --config.my-cnf /etc/.mysqld_exporter.cnf \ --collect.global_status \ --collect.info_schema.innodb_metrics \ --collect.auto_increment.columns \ --collect.info_schema.processlist \ --collect.binlog_size \ --collect.info_schema.tablestats \ --collect.global_variables \ --collect.info_schema.query_response_time \ --collect.info_schema.userstats \ --collect.info_schema.tables... Continue Reading →

Debian [Ubuntu/Raspbian] installation script

git clone https://github.com/jooservices/workspace cd workspace chmod +x install.sh Follow script for installation https://github.com/jooservices/workspace Xubuntu 20.04 for lightweight purpose Update & install required packages sudo apt update && sudo apt -y upgrade sudo apt -y install software-properties-common sudo apt -y install curl git unzip perl libnet-ssleay-perl openssl openssh-server libauthen-pam-perl libpam-runtime libio-pty-perl apt-show-versions python Web server sudo apt -y... Continue Reading →

Pages: 1 2 3 4

Setup Ubuntu 20.04 Workspace [Archived ]

Update system after installed sudo apt update && sudo apt -y upgrade Install required packages sudo apt -y install software-properties-common sudo apt -y install curl git unzip perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl apt-show-versions python curl openssh-server Redis & Memcache sudo apt -y redis redis-server redis-tools memcached MySQL 8.0 sudo apt -y install mysql-client mysql-sandbox... Continue Reading →

Pages: 1 2 3 4

XGallery – Bài toán queues và workers trên VPS Hostvn

Giải quyết bài toán crawling với queues / mongodb & redis / MySQL trên VPS 2 cores / 2 GB RAM

Pages: 1 2

https://www.codza.com/blog/mysql-server-not-configured-error

How to develop on Windows Subsystem for Linux ( Ubuntu )

Bài viết này sẽ dành cho các bạn developer sử dụng Windows ( khá nhảm nhưng thôi cứ xem là vậy ) và cần sử dụng Linux ( Ubuntu ) như 1 environment. Thật ra mà nói trên cơ bản thì ta vẫn sử dụng Linux như "server", chỉ có 1 vài thứ khác như... Continue Reading →

Update system after installed sudo apt update && sudo apt -y upgrade Install required packages sudo apt -y install python-software-properties sudo apt -y install software-properties-common MySQL sudo apt -y install mysql-server mysql-client mysql-workbench mysql-sandbox mysql-utilities mysql-testsuite sudo mysql_secure_installation sudo mysql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; FLUSH PRIVILEGES; sudo apt -y install apache2... Continue Reading →

Pages: 1 2 3

MySQL import / export via command line

mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql mysql -u username -p database_name < file.sql

Up ↑

%d bloggers like this: