Chapter 4 Introduction to Kubernetes Package Management Tool-helm

01 Overview Helm is a package management tool for kubernetes. It can install, manage and uninstall kubernetes applications conveniently and quickly. It is similar to the function of yum or apt-get software in Linux operating system. Its main design purposes are: Create a new chart package Packaging and compressing charts package files Integra ...

Posted by wmguk on Thu, 10 Oct 2019 00:30:00 -0700

Common Mariadb-mysql commands

mysql login (tcp/sock) # Connect in tcp mode [root@test data] mysql-uroot-p This is to log in to local MySQL. The default address is localhost-u+user, which is to receive a password after a user logs in-p. It is recommended not to input it directly on the screen. [root@test data]# mysql -h10.28.88.1 ...

Posted by blear on Tue, 01 Oct 2019 10:15:19 -0700

Mysql + Keepalived Implementation of High Availability Detailed Configuration of Dual Main and Mutual Standby

Mysql+Keepalived Dual Main Mutual Architecture FrameworkTiming before configuration #Install ntpdate tool yum install ntpdate -y #Use ntpdate to proofread time (followed by ntp server) ntpdate pool.ntp.org I. Configuration of mysql dual backup 0. Test mysql installation yum install mariadb mariadb-server -y systemctl restart mariadb systemctl ...

Posted by rodrigocaldeira on Wed, 18 Sep 2019 00:20:40 -0700

Basic usage of Sequelize

install $ npm install --save sequelize # You also need to install one of the following: $ npm install --save pg pg-hstore // postgreSql $ npm install --save mysql // mysql or mariadb $ npm install --save sqlite3 $ npm install --save tedious // MSSQL Establish connection const Sequelize = require('sequelize') const sequelize = new Sequelize(d ...

Posted by __greg on Mon, 16 Sep 2019 20:06:00 -0700

JumpServer Environment Deployment Component Installation

Introduction to Jumpserver Jumpserver Core Features List Jumpserver Environment Requirements Jumpserver Deployment Install redis Install Mariadb Modify Jumpserver configuration file Start Jumpserver Test Access Jumpserver Plugin Installation Koko Component Deployment Luna component deployment Guacamole Component Deployment Configure Nginx ...

Posted by kristalys on Tue, 03 Sep 2019 10:18:41 -0700

MariaDB Encryption Replication Test

Environmental Science: 192.168.205.37: as master server 192.168.205.47: as middle server 192.168.205.57: as slave server Edition: OS: centos 7 1810 with mini install mariadb-5.5.60 Purpose: Sometimes our database replication may need to be replicated across the network. If we don't want to be sniffed during the replication process, we can use ...

Posted by kryppienation on Sun, 11 Aug 2019 04:14:41 -0700

AWS RDS Mysql Opens Database Audit Function

Due to different security requirements, database audit is also a topic of concern to many customers. For RDS Mysql, can we audit each user's login and operation information? The answer is yes. MySQL Enterprise Edition has this function and belongs to the charging component. Community version of Mysql, the common audit plug-in is "MariaDB ...

Posted by php_joe on Sat, 27 Jul 2019 21:19:40 -0700

Install MySQL 5.7 in centos7 yum mode on Cloud Server

MariaDB is installed by default in CentOS, which is a branch of MySQL, but MySQL should be installed in the system for the sake of need, and MariaDB can be overwritten directly after installation. 1 Download and install MySQL's official Yum Repository [root@localhost ~]# wget -i -c http://dev.mysql ...

Posted by zuperxtreme on Sun, 21 Jul 2019 23:46:00 -0700

Implementation of master-slave monitoring of mysql database by zabbix

1. Establishment of Principal-Subordinate Relations Configure mysql-master side: 1) Modify the configuration file of mysql-master [root@localhost ~]# vim /etc/my.cnf [mysqld] server_id=1 innodb_file_per_table datadir=/data/mysql socket=/var/lib/mysql/mysql.sock log-bin=/data/log-bin/bin binlog_format=row ...... 2) Start the mysql service and ...

Posted by Vettel on Tue, 16 Jul 2019 14:10:00 -0700

mariadb Transaction Isolation Level Related Experiments

On the Isolation Level of SQLThe SQL standard defines four isolation levels, as follows:1. Read UncommittedAt this isolation level, all transactions can see the execution results of other uncommitted transactions. This isolation level is seldom used in practical applications, because its performance is not much better than other levels. Reading ...

Posted by Corvin on Sat, 15 Jun 2019 18:01:24 -0700