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