Redis (13) - redis's AOF mode of persistence

AOF mode: log every operation Advantages: the security is much higher than RDB; Disadvantages: the efficiency is much lower than RDB; To configure: Edit redis.conf [root@localhost redis]# vi redis.conf Pull down to find: The following picture: appendonly no the aof mode is turned off by default. We change it to yes to ...

Added by linfidel on Sat, 04 Apr 2020 00:36:45 +0300

mysqldump export data backup -- set gtid purged = off

When exporting, backing up and restoring Mysql database from the master database to the slave database, you need to pay attention to whether to enable GTID mode for the database. If you enable it, you should add the parameter -- set GTID purged = off to mysqldump data. See reprint for details: Here are the first 30 lines of a.sql exported with ...

Added by Jack_Slocum on Fri, 03 Apr 2020 08:48:03 +0300

Mybatis generator automatic code generation tool is embedded in maven project. The path obtained in eclipse and intellij is different

Before reading this article, please read another article about the embedding of mybatis generator into maven projectMybatis generator automatic code generation tool is embedded in Maven project to generate java and xml files corresponding to database tables with one click The method introduced in this paper can run the main method ...

Added by r3n on Thu, 02 Apr 2020 23:13:16 +0300

Common scripts related to Oracle Performance

In the absence of visualization tools to monitor database performance, common scripts come in handy. Here are a few scripts related to Oracle Performance for your reference. The following scripts have passed the Oracle 10g test, and Oracle 11g may need to be adjusted accordingly. 1. Find SQL statements with the most buffer \ ...

Added by tarleton on Thu, 02 Apr 2020 18:31:04 +0300

Android advanced - using LitePal to operate database

Learn to use LitePal to operate database About LitePal: LitePal is an Android open source library, which makes it very easy for developers to use SQLite database. You can do most of the database operations without writing a single SQL statement, including creating tables, updating tables, constraining operations, ...

Added by freeloader on Wed, 01 Apr 2020 21:23:32 +0300

Small c learning Linux(27)--mysql service installation

mysql general binary format installation premise mysql binary format compression package install 1) decompression tar -xf mysql-5.5.58-linux-glibc2.12-x86_64.tar.gz copy the extracted installation package to the system installation location / usr / local / mysql-5.5.58-linux-glibc2.12-x86_ cp -r mysql-5.5.58-lin ...

Added by szym9341 on Tue, 31 Mar 2020 13:31:27 +0300

System Analysis and Design Job 5(lesson 7)

Domain Modeling Read the Asg_RH documentation and build a domain model by use case. Database Modeling (ER Model) ER Model Diagram Export MySQL database script Simple Description of Differences and Differences between Database Logical Model and Domain Model Domain Modeling Read the Asg_RH documentation and ...

Added by pfdesigns on Sat, 28 Mar 2020 18:55:20 +0200

Details of php pdo object usage: connecting database and exec method

To use pdo, you need to open the pdo extension first. I have opened the pdo extension of mysql here ghostwu@dev:~$ php -m | grep pdo pdo_mysql ghostwu@dev:~$ 1. Connect to the database mysql> show create database shop \G; *************************** 1. row *************************** Database: shop Create Database: CREA ...

Added by jvanv8 on Fri, 27 Mar 2020 17:03:39 +0200

Recommendation for large table breakdown using gravity

gravity is a heterogeneous/isomorphic data replication channel software for Mobay bicycle ticketing, providing support for mainstream software and native k8s cloud.Better see its development. Project address: https://github.com/moiot/gravity Official documents: https://github.com/moiot/gravity/blob/master/docs/2.0/01-quick-start.md The comp ...

Added by Dev on Thu, 26 Mar 2020 19:51:25 +0200

New features interpretation | 8.0 new DML statement (TABLE & VALUES)

Author: Yang Taotao Senior database expert, specializing in MySQL for more than ten years. Good at mysql, PostgreSQL, MongoDB and other open-source database related backup and recovery, SQL tuning, monitoring operation and maintenance, high availability architecture design, etc. At present, he is working in aikesheng, providing MySQL related ...

Added by akop on Wed, 25 Mar 2020 11:15:53 +0200