The syntax you need to master to write a transaction

Under the default command line settings of MySQL, transactions are automatically committed, which means that the commit operation will be executed immediately after the SQL is executed alone. If we want to cancel automatic submission, we can do it in two ways: 1) . turn off auto submit settings In MySQL, you can use the SET autocommit statement ...

Added by gordong1968 on Wed, 17 Nov 2021 15:22:30 +0200

linux Network Programming -- socket server and client TCP programming and multi process programming

1. Basic communication process between client and server in network programming 2. Server and client programming < iterative server > 2.1. Iterative server programming 2.1.1. Command line parameter parsing The server parameter only has the port number. Add a help parameter < - H > to explain the usage of this commandThe co ...

Added by eduard on Fri, 12 Nov 2021 17:57:09 +0200

Linux disk partition

Linux disk partition preparation in advance The first step is to open the virtual machine and click Edit virtual machine settings Click the Add button Select the hard drive and click next Select SCSI typeSelect create new virtual hard disk Specify the disk size and select the second or third option (remember not to select the first one, ...

Added by Mr_jmm on Fri, 12 Nov 2021 06:13:39 +0200

How to realize one click upload with ftp

brief introduction ftp is the user interface of Internet standard file transfer protocol, which allows users to transfer files with remote network sites Using FTP client to upload files requires an FTP server. This paper mainly introduces the commands related to FTP client uploading. By default, the FTP server has been installed The FTP se ...

Added by mechamecha on Fri, 12 Nov 2021 01:55:31 +0200

Alibaba cloud server uses pagoda panel management and project deployment learning

1, Use pagoda panel management When we purchase servers from Alibaba cloud or Tencent cloud, we use the pagoda panel to manage the server. First, we need to install Xshell or SecureCRT. Here, take Xshell 6 as an example, 1.get into Xshell Then click "new" 2.In the pop-up box, enter the public address displayed in the instance of ...

Added by hl_tan on Thu, 11 Nov 2021 21:28:46 +0200

Java Web session Technology

1.Cookie object: cookie is a session technology, which is used to save the data in the session to the user's browser, so that the browser and server can better interact with each other; Create Serlet: Create a chapter05 project, create a package you like, and write a Servlet class called lastaccessservlet in the package to obtain Cookie info ...

Added by api on Wed, 10 Nov 2021 17:27:30 +0200

Logrotate log partition of Linux Log Management artifact

preface: Some services will automatically generate a large number of log files, which will occupy disk space if not limited. If you simply use the scheduled task crontab to delete, it is not flexible. At this time, you need the log artifact logrotate. logrotate tool is a tool built in the system to facilitate log management. The system will r ...

Added by ljzxtww on Fri, 05 Nov 2021 02:48:13 +0200

Java Network Programming -- ServerSocket

Java network programming (V) -- ServerSocket (II) In the last blog Java network programming (IV) - ServerSocket (I) This blog introduces what is a server Socket and how to use it. This blog continues to introduce other knowledge about ServerSocket. Request queue length When the server process is running, it may listen to connection reque ...

Added by gt500pwr on Thu, 04 Nov 2021 15:25:40 +0200

MySQL - MHA high availability configuration and failover

preface When building a mysql Cluster, a single master makes master-slave replication, which greatly improves the reading and writing ability of the database, but once a single point of failure occurs, the whole cluster will be paralyzed. Therefore, we usually configure the master to improve the redundancy ability of the cluster. 1, W ...

Added by camadan on Tue, 02 Nov 2021 19:44:44 +0200

Greenplum cluster deployment and installation guide

catalogue 1, Official installation link 2, Greenplum installation file download 2. Install Greenplum (1) Install gpdb (2) Set password free login (3) Create hostlist and standby on_ seg_ hosts,seg_only (4) Use gpssh exkeys to get through all servers (5) Confirm installation 3. Create a data store (1) Create a data store on the master ...

Added by sameveritt on Tue, 26 Oct 2021 13:32:34 +0300