Analysis of Mysql 5.7 Error Reporting 1546, 1577 and 1682

Environmental description:The backup data of xtrabackup on MySQL 5.6.40 is imported into MySQL 5.7.24 instance, the service of MySQL 5.7 is started, and the database MySQL 5.7 instance is logged in. However, when drop user user@'127.0.0.1', the error is reported as follows: 2019-08-15T19:02:31.160910+08:00 1546 [ERROR] /usr/local/mysql5.7/bin/ ...

Posted on Fri, 04 Oct 2019 15:52:26 -0400 by danrah

Build slave library with full backup files of xtrabackup on the same day

Environmental Science: Two mysql instances 3306 and 3307 are opened by a single machine.Both 3306 and 3307 instances turn on Gtid, and make sure the server-id is different Full Backup Command: time innobackupex --defaults-file=/data/mysql5.7/my3306.cnf -ubackupuser -p123456ccs --host=127.0.0.1 -S /tmp/3306.sock /data/backup/ The location of ...

Posted on Fri, 04 Oct 2019 13:35:13 -0400 by MaxBodine

4. Spring Annotation Development, Day 4

Day 4: Spring annotation development Directory: 1. bean Life Cycle - Initialization and Destruction Method 2, @Value Assignment 3, @PropertySource Loading External Configuration File 4, @Profile Registering According to External Environment I. Life Cycle of Beans - Initialization and Destruction Methods Construction (object creation) Single in ...

Posted on Fri, 04 Oct 2019 13:00:59 -0400 by ricky spires

springboot - Integrated druid

Configuration of pom.xml <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>s ...

Posted on Fri, 04 Oct 2019 11:21:52 -0400 by Ajdija

Use of mysql_fdw extension in postgres

Function of mysql_fdw: Used to quickly access MySQL data in PG. Experimental version: CentOS 7.5 Postgrsql 11.5 Compiler Installation Version SQL 5.7 rpm Demo environment, MySQL and PG are deployed on the same machine, IP address 192.168.2.4. 1. Account Authorization in MySQL Create account and authorization on 192.168.2.4 MySQL server. cr ...

Posted on Fri, 04 Oct 2019 08:41:52 -0400 by csaba

JAVA Learning Path 10: Simple Small Project of javaweb+mybatis

A simple small project loads the data in the database into the front-end interface to realize the paging function. The results are shown as follows: I. Development environment and tools Development tools: IDEA; Environment: jdk1.8, maven 3.6.1, Tomcat 8.5, MySQL Server 5.7; The front end uses jquery, ...

Posted on Fri, 04 Oct 2019 07:07:18 -0400 by atitthaker

CentOS 7 Build Source Pack Build LNMP Environment

1. Install epel source yum install -y epel-release 2. Install the required software yum install -y gcc automake autoconf libtool make gcc-c++ glibc libxslt-devel \ libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 \ libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 \ bzip2-devel ncurses ncurs ...

Posted on Fri, 04 Oct 2019 05:21:10 -0400 by bobthebuilder

Campus Activity Platform Project (swing+mysql)

Campus Activity Platform Project (swing+mysql) After studying JAVASE in the school studio for some time, we completed the studio project. Project requirements: I. Blue Point Campus Activity Platform Basic needs: 1. With login and registration function 2. Administrator Audit activities (decid ...

Posted on Thu, 03 Oct 2019 21:50:58 -0400 by GoRide!

replication-manager for MySQL ha Installation Test Notes

1. Configure yum source [root@mgr1 ~]# cat /etc/yum.repos.d/signal18.repo [signal18] name=Signal18 repositories baseurl=http://repo.signal18.io/centos/$releasever/$basearch/ gpgcheck=0 enabled=1 2. yum installation process [root@mgr1 ~]# yum install replication-manager-osc Loaded plugins: fastestmirror Loading mirror speeds from cached hostfi ...

Posted on Thu, 03 Oct 2019 17:52:18 -0400 by Japher

java code implements mysql table (user behavior record)

Setting up pneumatic execution times (checking table records once a day) public class DayInterval implements ServletContextListener{ private static SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); public static void showDayTime() { Timer dTimer = new Timer(); dTimer ...

Posted on Thu, 03 Oct 2019 16:10:05 -0400 by edzulis