Database Administrator

MariaDB Galera Cluster deployment (how to quickly deploy MariaDB Cluster) MariaDB, as a branch of Mysql, is widely used in open-source projects, such as the Popular openstack. To ensure the high availability of services and improve the load capacity

How to install and deploy Cassandra distributed NoSQL Database Apache Cassandra is an open-source Distributed Key-Value storage system. It was initially developed by Facebook to store particularly large data. Cassandra is suitable for real-time

Oracle function (converts the first letter of each word to uppercase) NLS_INITCAP (x [, y]) [Function] returns a string and converts the first letter of the string to uppercase, And the other letters to lowercase; [Parameter] x struct expression

MySQL advanced technology-storage engine, mysql storage engine The MySQL function is divided into two parts. The outer part is mainly used to connect to the client and investigate SQL statements beforehand. The inner part is the so-called storage

[Database Study Notes] (3) ing between SQL data types and Java data types, learning notes Data Types Comparison of Data Types Between SQL database and access Database Text nvarchar (n)Note ntextNumber (long integer) intInteger smallintNumber

Database Link of IT Ninja Turtles: database of Ninja Turtles -CREATE public database link test_link connect to scott identified by tiger using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521) (CONNECT_DATA

Oracle client download, oracle client downloadOracle refers to a user with a level of capacity. The following describes how to install and assemble a column (using instantclient-win32-10.2.0.3-.zip ).Oracle provides six compressed packages to be

CentOS installation mysql *. rpm prompt conflicts with file from package solution, centos. rpm Install MySql 6.5 in CentOS 5.6 Decompress file: tar xvf MySQL-5.6.19-1.linux_glibc2.5.x86_64.rpm-bundle.tar Release the following files: MySQL-embedded-5.

Install MySql in Ubuntu and connect to the Internet, while tumysql is on the Internet. Pure beginner tutorial. 1. Install mysql apt-get install mysql-server mysql-client libmysqlclient15-dev During the installation process, you will be

Introduction to ETL technology: Introduction to ETL, data warehouse, and etl Data WarehouseETL is the abbreviation of Extract-Transform-Load. It is used to describe the process of extracting, transforming, and loading data from the source to the

Knowledge about SQL Injection bypass and SQL Injection Bypass I. Concept of bypassing waf Start from step 1, analyze at, and then bypass. 1. Filter and, or preg_match('/(and|or)/i', $id)Filtered injection: 1 or 1 = 1 1 and 1 = 1Bypassed injection: 1

In-depth analysis of NoSQL database distributed algorithms (graphic details), nosql text Although the NoSQL movement has not brought about fundamental technological changes to distributed data processing, it still triggers overwhelming research and

This article describes how to install Oracle 11gR2 (11.2.0.3) in Oracle Linux 6.3 ). Since Oracle 11g, the official Oracle website does not provide a download link for its Patch. You need to use the Meatlink account to download the Patch. Do not

Mongodb advanced 3: mongodb management and mongodb advanced management Http://blog.csdn.net/stronglyh/article/details/46827141 Usually, there are many win development environments, but the production environment should be put on unix. I.

1. connect to your own database to create tablespaces, users, import, export, and exportA) Session-new session enter the user name and password (for example, sys, sys) as the dbaB) Database-open scheme browserC) on the tab, select

Link: http://www.vpsee.com/2009/08/use-shell-script-to-access-mysql/ In the afternoon, I wrote a simple bash script to test the program and input a test case file, Output the test cases and results that fail the test and save the results to the

Java from entry to entry-database Mongo DB Export, Import, backup, from entry to entry-level mongo I. Overview This blog tells you how Mongo DB imports and exports data and backs up data. In the following operations, you must open the

Environment Introduction: Dual-host operating system: solaris 10 database version: oracle 11g R1 64bit current host name and IP: fly-db2 192.168.20.21 current slave host name and IP: fly-db1 192.168.20.20 Background: The physical memory of the

1. Prepared hostNode1: 172.16.133.11Node2: 172.16.133.12MySQL has been installed.MySQL installation see: http://5142926.blog.51cto.com/5132926/9356522. mysql master-slave ReplicationNode1: master serverNode2: slave server(1) node1:Enable binary log (

Newlisp tracks jobtracker status, newlispjobtracker The basic idea is to use newlisp to regularly download the jobtracker page, use regular expressions to parse the table elements in html, and then obtain the latest mapreduce status. Each time the