pydbclib: a general database operation tool for python
pydbclib It is a general python relational database operation toolkit. It uses a unified interface to operate various relational databases (such as oracle, mysql, postgres, hive, impala, etc.) for addition, deletion, and query. It is a connection driver package for various python databases (such as sqlalchemy, pymysql, CX_ The encapsulation of ...
Posted by timbuckthree on Tue, 02 Jun 2020 08:05:41 -0700
MySql Easy Start Series --- The first stop is to easily understand MySQL overall framework from the source point of view
One: Background
1. Storytelling
Recently, looking at the major technical communities, whether they know, the Nuggets, the Blog Garden or csdn, we can hardly see any articles about sqlserver class shared by small partners. It looks like sqlserver has disappeared in recent years and no one has written it since. It is impossible to write sqlserver ...
Posted by Modernvox on Mon, 01 Jun 2020 17:54:38 -0700
Using Shell script to automatically backup MySQL database
Purpose:
The 192.168.100.20 server backs up the MySQL database on the 192.168.100.10 server.
1. Configure MySQL server
1) 100.10 MySQL server log in to MYSQL to create two databases
[root@centos01 ~]# mysql -uroot -ppwd@123
mysql> create database liyanxin;
mysql> create database wangzhaojun;
2) liyanxin database creates tables and write ...
Posted by maliskoleather on Mon, 01 Jun 2020 08:09:44 -0700
Implement LNMP architecture, deploy WordPress and configure NGINX virtual host
1. Compile and install LNMP and wordpress
1.1 install PHP, php mysql, mysql, PHP FPM
[root@c1 ~]# yum install php php-mysql ngnix mariadb-server php-fpm -y
1.2 compile and install nginx
1.2.1 installation dependency package
[root@c1 nginx]# yum install gcc pcre-devel openssl-devel zlib-devel -y
1.2.2 creating nginx users
[root@c1 ~]# useradd ...
Posted by murali on Mon, 01 Jun 2020 07:59:42 -0700
Building a big data environment for user portrait -- building a real-time user portrait from scratch
In this chapter, we started to formally build a big data environment, with the goal of building a stable big data environment that can be operated and monitored. We will use Ambari to build the underlying Hadoop environment, and use the native way to build Flink, Druid, Superset and other real-time computing environments. Use the combinatio ...
Posted by allinurl on Sun, 31 May 2020 20:43:34 -0700
ZABBIX4.0 upgrade 5.0 & ES6.1 upgrade 7.0
Upgrade plan
Scope of influence:
During the upgrade, the existing system will not be affected, and the system will maintain normal operation. After the upgrade, the availability test will be conducted for a period of time, and the monitoring on production will be replaced after the system is stable.
Upgrade method:
This upgrade adopts the blue ...
Posted by koolswans on Sun, 31 May 2020 10:01:07 -0700
type column parsing of explain
1,const
Indicates that the execution step returns at most one row of data. const usually appears in the equivalent query of the primary key or unique index, such as the equivalent query of the primary key id of the t table:It can be considered that it is as fast as a rocket to locate a record by comparing the equivalence between the primary key ...
Posted by cachemony on Sun, 31 May 2020 08:54:30 -0700
Install MySQL-5.7.18RPM Bundle under CentOS 7.2 (applicable to the latest version of 5.7.20)
1, Environment
1. Operating system: CentOS Linux release 7.2.1511 (Core) minimized installation version
2. MySQL version: MySQL-5.7.18 (mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar )
2, Installation process
1. Install wget.
[root@Geeklp-MySQL ~]# yum -y install wget
2. Download the installation package.
wget -c ...
Posted by mrmitch on Sat, 30 May 2020 09:44:20 -0700
Three ways to check the normal running time of MySQL/MariaDB database on Linux - Zhihu
Each service has its own command to check the uptime of the service. But you can also use other commands for this.
Source: https://linux.cn/article-12263-1.html
By Magesh Maruthamuthu
Translator: geekpi
We all know the purpose of using the uptime command in Linux. It is used for checking Linux system uptime And the time s ...
Posted by kevinritt on Fri, 29 May 2020 17:56:15 -0700
Java combines query operations with connected databases (20.5.29)
IDEA Connect to MySQL Database
Add MySQL database connector to project
Using mysql-connector-java-8.0.15.jar as an example, add jar files to your project
The JDBC-MySQL connector is now added successfully
Create the appropriate connection
Connect the corresponding class in the jar file
try {
...
Posted by pellky on Fri, 29 May 2020 11:57:32 -0700