Programming VIP

Phenomenon: The application service sends a write request error to one of the MGR nodes mysql> (3101, 'Plugin instructed the server to rollback the current transaction.') Check the synchronization error of this node group mysql> SELECT * FROM performance_schema.replication_group_members; +---------------------------+- ...

This paper describes how to realize the application monitoring of Prometheus Monitoring Nginx nginx: 1.16.1,nginx-vts-exporter: 0.10.3,nginx-module-vts: 1.6.3 Monitoring Nginx mainly uses the following three modules: Nginx module VTS: monitoring module of nginx, which can provide data output in JSON format. Nginx VTS exporter: it is mainly us ...

Introduction to the basic dble architecture dble is a highly available and scalable distributed middleware based on mysql.The River Laker sent the nickname MyCat Plus. Open source address Let's start with the architecture diagram, where external applications are connected via NIO/AIO.First, let's talk about what NIO/AIO is. BIO, the traditiona ...

quick get start Next we use jython to call the classes in the custom jar package. Edit java file: Beach.java public class Beach { private String name; private String city; public Beach(String name, String city){ this.name = name; this.city = city; } public String getName() { return nam ...

catalog Displaying logs in database through log analyzer Environmental preparation Prepare server: Log server: Database server: Test whether the log server and database are connected: websrv server: Displaying logs in database through log analyzer Environmental ...

Understanding of using DBCP and CP30 to create database connection pool (for college students, please correct if there is something wrong) DBCP creates database connection pool CP30C create database connection pool Why use this first? First of all, in the early stage, I believe that many small partners will connect to the ...

I have a database of account numbers and card numbers. I match these files with files to update all card numbers to this account, so I only use the account. I created a view that links the table to the account / card database to return the Table ID and the associated account, and now I need to update those records whose ID matches the accou ...

Download: Xtrabackup https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.8/binary/redhat/7/x86_64/Percona-XtraBackup-2.4.8-r97330f7-el7-x86_64-bundle.tar Unzip, install yum tar -xvf Percona-XtraBackup-2.4.8-r97330f7-el7-x86_64-bundle.tar yum install percona-xtrabackup-24-2.4.8-1.el7.x86_64.rpm Full backup innobackupex –user=r ...

Githubd address Chinese Documents | DOCUMENT okcli can generate the specified data table as a corresponding model file and currently supports bringing column names, data types, default values, comments into the specified model.Like the following files: import "time" type ( Student struct { Id int32 `db:"id"` N ...

Especially remember a long time ago, if you want to save emoj expressions in mysql, you need to transcode emoj expressions and save them. Every time you read them, you need to decode and restore them. Every time you do this sb operation, you really feel the heart jam. Is there any way to save them directly? mysql itself can support emoj express ...