Programming VIP

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 ...

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 ...

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 ...

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 \ ...

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, ...

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 ...

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 ...

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 ...

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 ...

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 ...