Building MySQL Replication cluster high availability architecture based on MMM

MMM introduction MMM is Multi-Master Replication Manager for MySQL It is a multi master replication manager provided by mysql. Its core is a set of scripts written in perl. In fact, mmm is a relatively early and even a little old way to build a highly available MySQL architecture, but because it has certain application scenarios, this article ...

Posted on Sat, 01 Feb 2020 07:59:11 -0800 by filmixt

Annotated and non annotated processor mapper and processor adapter in srpingmvc.xml

Catalog 1. non annotations 1.1 non annotated processor adapter 1.2 non annotated processor mapper 1.2.1 BeanNameUrlHandlerMapping 1.2.2 SimpleUrlHandlerMapping 1.3 summary 2. notes 1. non annotations 1.1 non annotated processor adapter <! -- non annotated processor adapter -- > <! ...

Posted on Sat, 01 Feb 2020 04:36:35 -0800 by mazazino

Data table display of jqGrid framework

Summarize the problems encountered in the project and solve them.   Problem: jgrid loads the local data (not the data from the database), local data information and so on, and displays them to the front desk. Solution: Customize the column name, and then update the data table according to the $("ාtransferList").jq ...

Posted on Fri, 31 Jan 2020 17:38:01 -0800 by quikone

PHP implements a rude sign-in page

PHP implements a rude sign-in page Today I came to the water with a funny face without** use. The code is simple, bloated and incomplete. Every big man is blowsy, and I hope he can give me some advice. First, consider the need for at least four pages: register.html, register.php, login.html, and login.php.register.html is written as follows: &l ...

Posted on Fri, 31 Jan 2020 16:14:11 -0800 by TWD

Personal understanding of postgresql replication slots

os: centos 7.4 postgresql: 9.6.9 replication slots was introduced from postgresql 9.4. It mainly provides an automatic method to ensure that the master computer will not remove all the backup computers before they receive the WAL segments, and the master computer will not remove the rows that may cause recovery conflicts, eve ...

Posted on Fri, 31 Jan 2020 12:34:44 -0800 by donkeychoker

Oracle EBS file upload and download (II) - customized OAF development

Business background In the project of XX company, it is required to upload the pictures, technical drawings, operation instructions and other files of all materials. Because the upload function files of Oracle EBS standard attachments are saved in the data table FND_LOBS, when the number of uploaded files is large, daily produ ...

Posted on Fri, 31 Jan 2020 11:28:26 -0800 by jc94062

The conversion of Name and Comment in pdm physical model in PowerDesigner

When using PowerDesigner to design the conceptual model and physical model of database, Chinese is usually written in name or Comment, and English is written in Code. Name is used to display. The Code corresponds to the Column name in the database. The text in the Comment will be saved to the Comment in the database Table or Column. When the ...

Posted on Fri, 31 Jan 2020 10:25:08 -0800 by blackswan

Install and configure MySQL 5.8 on Windows 10

Download MySQL 8.0 windows zip package Download address Extract to installation directory Add the installation directory / bin to the PATH environment variable Create a new file my.ini in the installation directory and write the basic configuration [mysqld] # Remove leading # and set to the amount of RAM for the most impor ...

Posted on Fri, 31 Jan 2020 09:38:05 -0800 by trystan

C ා connect to SQL Server database

Executing SQL statements: Command object 1.Command object overview The    command object is a data command object. Its main function is to send SQL statements of query, update, delete and modify operations to the database. Command objects are mainly in the following ways.   &emsp ...

Posted on Fri, 31 Jan 2020 07:49:13 -0800 by nestorvaldez

Mybatis generatorconfig auto generate

Document preparation Using Mybatis Generator requires Two jar packages -- mybatis-generator-core-1.3.2.jar and database connection jar package A configuration file GeneratorConfig.xml (encoded in UTF-8) Execution statement File download link: https://download.csdn.net/download/evlisric/10559545 There are two ways of path ...

Posted on Fri, 31 Jan 2020 05:03:18 -0800 by gljaber