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