Deployment and Use of Data Migration Tool DataX

Summary DataX is an offline data synchronization tool/platform widely used in Alibaba Group. It implements efficient data synchronization among various heterogeneous data sources, including MySQL, Oracle, SqlServer, Postgre, HDFS, Hive, ADS, HBase, TableStore(OTS), MaxCompute(ODPS), DRDS and so on.Aliyun has already source this tool, the curren ...

Posted by pqdrummer on Thu, 22 Aug 2019 12:47:04 +0200

MySQL index optimization analysis 3-single table query optimization

MySQL Index Optimizing Analysis 3-Single Table Query for SQL Query Optimizing 1. Data preparation 1.1 Formulation 1.2 Setting parameter log_bin_trust_function_creators 1.3 Create SQL functions to ensure that each data is different 1.4 Create SQL ...

Posted by ezekiel on Thu, 22 Aug 2019 10:49:08 +0200

Jushan Learning Notes | SequoiaDB MySQL Import and Export Tool Using Actual Warfare

This article is from community users. Thank you for your technology sharing. Brief Introduction of Jushan Database Architecture Jushan database, as a distributed database, is a computing and storage separation architecture, which consists of database instance layer and storage engine layer. Storage engine layer is responsible for database core ...

Posted by lachhekumar on Thu, 22 Aug 2019 06:13:36 +0200

PostgreSQL execution plan

Links to the original text: https://blog.csdn.net/JAVA528416037/article/details/91998019 Reproduced from: https://blog.csdn.net/JAVA528416037/article/details/91998019 brief introduction PostgreSQL is "the most advanced open source ...

Posted by cigardude on Tue, 20 Aug 2019 11:56:18 +0200

Database middleware MyCat

What is MyCat? Look at the introduction on the official website. A Completely Open Source Large Database Cluster for Enterprise Application Development Enhanced database supporting transactions, ACID, and MySQL alternatives An enterprise-level database that can be considered a MySQL cluster to replace the expensive Oracle cluster ...

Posted by shelbytll on Tue, 20 Aug 2019 11:48:09 +0200

Detailed Timing Tasks for SpringBoot

Links to the original text: https://www.cnblogs.com/mmzs/p/10161936.html Read the catalogue: Preface I. Static: Annotation-based II. Dynamics: Interface-based Multithread Timing Tasks   Read the text:   Preface Using SpringBoo ...

Posted by fisicx on Tue, 20 Aug 2019 11:40:57 +0200

Jvm Monitoring of Skywalking_k8s Cluster

Here's a directory that doesn't need to exist Skywalking monitors intrusion-free-k8s cluster for jvm introduce server deployment busybox elasticsearch oap ui ingress agent deployment docker Mirror Making agent Embedding summary Skywalki ...

Posted by soulreaver on Mon, 19 Aug 2019 11:53:25 +0200

Getting Started with MySQL--DML Statement Text

Foreword: In the previous article, we mainly introduced the use of DDL statements, which may have been discovered by careful students.This article will focus on DML statements to explain table data related operations. This explains the classification of DDL and DML statements, which may be unclear to some students.DDL(Data Definition Language ...

Posted by nexgen_x on Sun, 18 Aug 2019 08:17:11 +0200

Restore MySQL data to data before the table was deleted by mistake

1. Demonstration environment description: System CentOS Linux release 7.2.1511 (Core) X_86 64-bit minimal installationThe mysql version is the official binary version 5.7.22-22. mysql is a binary installation. Open two mysql instances on a single machine, open the timer event_scheduler=ON for the mysql instances, and open Gtid for both mysql i ...

Posted by sgs on Sat, 17 Aug 2019 06:14:56 +0200

Personal Information Network Management System for Company Employees

Personal Information Network Management System for Company Employees mysql Database Creation Statement of Personal Information Network Management System for Company Employees Company employees personal information network management system oracle ...

Posted by vestax1984 on Thu, 15 Aug 2019 15:31:47 +0200