MySQL backup and recovery

preface In enterprises, the value of data is very important, and data ensures the normal operation of enterprise business. Therefore, data security and data Reliability is the top priority of operation and maintenance. Any loss of data may have serious consequences for the enterprise. 1: Classification of database backup 1.1: what are t ...

Posted by corsc on Thu, 12 May 2022 07:41:45 +0300

Oracle - Summary of the use of Mybatis and sql optimization

preface Before writing, this blog will be updated constantly to sort out and summarize the sql optimization problems in the development work (actual combat process); Because the author works in the big data Department, the amount of data is basically very large, so he pays more attention to the performance under big data (but for some oper ...

Posted by AustinP on Wed, 11 May 2022 13:43:15 +0300

Containerization | building RadonDB MySQL Cluster Monitoring Platform

In the previous article, we demonstrated how to restore RadonDB MySQL Cluster Data in S3 backup. This article will demonstrate how to use Prometheus[2] + Grafana[3] in KubeSphere[1] to build a MySQL monitoring platform and enable the required monitoring indicators. background Prometheus text-based exposure format has become the de facto standar ...

Posted by Develop_Sake on Wed, 11 May 2022 09:46:01 +0300

Development oriented memory debugging artifact, how to use ASAN to detect memory leakage, stack overflow and other problems

The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.[toc]introduceFirst of all, let's introduce it Sanitizer The project is an open source project produced by Google. The project includes memory and thread error detection tools such as ASAN, LSAN, MSAN and ...

Posted by realnsleo on Wed, 11 May 2022 07:47:07 +0300

The characteristics of zookeeper and the use of common commands

The characteristics of zookeeper and the use of common commands zookeeper is a distributed, open source distributed application coordination service. It is a software that provides consistency services for distributed applications. The application scenarios of zookeeper are as follows: Data publishing subscription load balancing Naming ser ...

Posted by neoboffins on Wed, 11 May 2022 07:06:37 +0300

Installation of Oracle Database 11g Enterprise on CentOS (the most detailed and simple tutorial in the whole network)

Installation of Oracle Database 11g Enterprise on CentOS environment VMware Workstation 15 Pro CentOS 7 64 bit (CentOS-7-x86_64-DVD-1810.iso) If the environment is not ready, you can refer to: Installing CentOS for VMware virtual machines tool SecureCRT 8.7 SecureFX 8.7 Navicat Premium 12 PL/SQL Installation package Oracle Databa ...

Posted by sy-co on Tue, 10 May 2022 21:06:46 +0300

MyBatis learning notes (including SSM integration and reverse engineering)

1. Introduction to mybatis 1.1 what is MyBatis? MyBatis official website MyBatis is an excellent persistence layer framework that supports common SQL queries, stored procedures and advanced mapping. MyBatis eliminates almost all the manual setting of JDBC code and parameters and the retrieval of result sets. MyBatis uses simple XML or ann ...

Posted by kyme on Tue, 10 May 2022 16:23:56 +0300

SQL optimization case: implicit conversion

MySQL is one of the most popular relational databases at present. With the rapid development of the Internet, MySQL database is widely used in the production systems of e-commerce, finance and many other industries. In the actual development, operation and maintenance process, we must often encounter the problem of slow SQL. A SQL with poor per ...

Posted by volant on Tue, 10 May 2022 09:16:01 +0300

Hyperledger Fabric chain code development practice log

1. Overview of chain code structure Here, the development of chain code uses Go language. Therefore, we need to simply learn Go language first. It is a lightweight language. Interestingly, it has its own channel and can be concurrent, which is very suitable for the development of large-scale distributed systems. To Start the chain code, you mu ...

Posted by pmcconaghy on Mon, 09 May 2022 12:16:02 +0300

Troubleshoot high CPU usage in MongoDB

Analyze the requests being executed by the MongoDB database 1. Connect to the instance through Mongo Shell. For details, see Mongo Shell connecting to a single node instance, Mongo Shell connecting to a replica set instance, and Mongo Shell connecting to a sharded cluster instance. 2. Execute the db.currentOp() command to view the operations cu ...

Posted by scarhand on Mon, 09 May 2022 07:46:34 +0300