Database Administrator

MySQL table sharding auto-incremental ID Solution After we perform the table sharding operation on MySQL, we cannot rely on the automatic increment of MySQL to generate a unique ID, because the data has been distributed to multiple tables. Avoid

Use XtraBackup to perform Online Incremental backup and database restoration for MySQL 1. Introduction to Percona Xtrabackup 1. Xtrabackup bin directory file Introduction 1) innobackupex Innobackupex is a symbolic link of xtrabackup. innobackupex

Install the oracle client in linux and the linuxoracle Client 1. Prepare the required installation

SQL server interview questions, SQL SERVER interview questions I went to the interview today and got caught by a small database problem. I am ashamed and brave. SQL interview questions 1. I can't help but want to say this, because the field

PostgreSQL replication cluster overview, PostgreSQL replication Cluster For pg replication, high availability, and load balancing clusters, write an overview for future reference. Pg has the following various replication-Based Cluster solutions,

Use the basic SQLite3 command and the unzip tusqlite3 command in ubuntu System Platform: ubuntu10.04 IntroductionSqlite3 is mainly used for Embedded lightweight databases. This article aims to provide technical documents for familiar with sqlite3

Transaction Processing and concurrency control, transaction processing Concurrency Control What is a transaction? Is a mechanism, an operation sequence, it contains a group of database operation commands, and all the commands as a whole, together to

[Translated from mos] Does oracle Support Symbolic Links Under rdbms home ?, Does oracle Support Symbolic Links Under rdbms home? Reference Original:Does Oracle support Symbolic Links in the RDBMS home? (Docid 813116.1) Applicable:Oracle

[Introduction to Data Mining]-Introduction to data types and Data MiningData TypeDifferent datasets are manifested in many aspects. For example, attributes describing data objects can have different types: quantitative or qualitative. In addition, a

Log System ELK usage (4) -- kibana installation and use, elk -- kibanaOverview Log System ELK usage (1)-How to UseLog System ELK usage (2)-Logstash Installation and UseLog System ELK usage (III)-elasticsearch InstallationLog System ELK usage

Key-Value Pair design in Redis and Redis key-Value Design The rich data structure makes redis design very interesting. Unlike relational databases, DEV and DBA need to communicate in depth, and review does not require DBA participation for each row

Use the MySQL Workbench remote management tool to remotely manage Mysql errors and solutions.Overview: Recently, MySQL Workbench is used for remote management of MySQL on virtual machines. However, some problems are encountered during the

Kaggle Data Mining -- Take Titanic as an example to introduce the general steps of data processing, kaggletitanic Titanic is a just for fun question on kaggle, there is no bonus, but the data is neat, it is best to practice it. This article uses

Since the introduction of the relational database model by edugatd in 1970, relational databases began to emerge. After more than 40 years of evolution, today's relational databases have a wide variety of features and are widely used. In the face of

Expdp when encountering ORA-31693 & ORA-00922, expdpora-31693Expdp ORA-31693 & ORA-00922The following error is reported when executing expdp:ORA-31693: Table data object "HQ_X1". "B3901_P" failed to load/unload and is being skipped due to error:ORA-0

Phenomenon: GG do init data load report error OGG-00869 OGG-0019915:54:18 INFO OGG-03501 Oracle GoldenGate Delivery for Oracle, initrep. prm: WARNING: NLS_LANG environment variable is invalid or not set. Using operating system character set value of

Introduction to SQLite and introduction to SQLite I. Why SQLite? SQLite is currently the most popular open-source embedded database. compared with many other embedded storage engines (NoSQL), such as BerkeleyDB and MemBASE, SQLite supports some

For details about how to use the count function in MySQL, mysqlcount The count function is a function used to count records in tables or arrays. Here we will introduce the usage and Performance Comparison of the count function in MySQL. Count (*)

SQLite tutorial (13): C language programming example code (1), sqlite programming example 1. Get the table Schema information: 1) dynamically create a table. 2) obtain the table field information, such as the number of fields and the type of each

This article will introduce several major steps for SQL Server Profiler to analyze deadlocks. This is also to help you better manage your databases. In two or more SQL Server processes, a deadlock occurs when each process locks the resources that