Database Administrator

C # data interaction between mobile terminals and PCs Note: For smartphones with more and more powerful features, applications supporting mobile phone user data synchronization, backup, recovery, and other protection measures are in urgent need. In

Compile and install Redis and master-slave replication configuration in Linux The installation and configuration of Redis is very simple, and Redis has been installed a long time ago. But I forgot some details when I installed it again these days.

Quick Reference for installation and deployment of Oracle 11G Single Instance + ASM storage on Linux Operating Environment: Apply for a Linux6.4 host (Template) in the Citrix virtualization environment)Objective: to create a single-host 11 GB + ASM

About Oracle cvu and cvuqdisk, oraclecvucvuqdisk About Oracle cvu and cvuqdisk Download link of cvu:Http://www.oracle.com/technetwork/products/clustering/downloads/cvu-download-homepage-099973.html Cvuqdisk is the installation package on linux.

MongoDB3.0.1 is deployed in multiple parts. There are not many domestic deployment documents (HE zhixiong )., Mongodb3.0.1 he zhixiong1) The parts include:1. There are at least three config servers: The data block-to-shard ing is stored to determine

SQL Sever connection failure -- SQL Sever remote process call failed, sqlsever Today, I started three layers of learning with great enthusiasm. I watched the video and knocked on the code. I felt like I hadn't knocked on the code for a long time,

You are not authorized to create a view in Oracle. You are authorized to create a view in oracle. Q: After using scott to log on to Oracle, the system creates a view and prompts "insufficient Permissions". How can this problem be solved?Answer:This

CRS-0184: Cannot communicate with the CRS daemon. node out of cluster troubleshooting, crs-0184crs 1. system environment: OEL6.5 Enterprise Edition Oracle11.2.0.2 RAC + ASM 2. error message: $ Crs_stat-tCRS-0184: Cannot communicate with the CRS

Ora-28001: the password has expired. (password invalid), ora-28001expired. Ora-28001: the password has expired. (password expired) This new oracle11g feature, the default user password is only valid for 180 days. 1. plsql logs in as an

MySQL Study Notes _ 8_ SQL BASIC Language review, Study Notes _ 8_ SQL SQL language basic review I. Overview SQL statement comments 1) All contents starting with "#" until the end of the line are comments 2) All content starting with "--" (-- and

Error code: 1248 Every derived table must have its own alias, 1248 derived 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT stu_id, (SELECT stu_name FROM t_student_info t WHERE t. stu_id = t. stu_id)

The DS sequence table reverts input data and ds sequence data. There are two very similar processes to achieve the inverse of input data and the ordering of order tables. Therefore, the basic operations of order tables are the same: preparations

Database locks and databasesPreface Some time ago, I encountered a lot of problems online and in the project about using the GET_LOCK () function of mysql to obtain the lock. There are two main problems: 1. Two locks cannot be obtained at the same

Mysql backup data migration, error handling, mysql backup dataAll data files in/usr/lib/mysql are left behind in the project history. Previously, MyISAM engine of mysql5.1 In Debian was used. The current machine is ubuntu, and only mysql5.5 is used.

08-SQLite in, between, alias, 08-sqlitealiasI. in operator Overview The IN operator allows us to specify multiple values IN the WHERE clause. Syntax: select column_name from table_name where column_name in (value1, value2 ,...); Example 1:

Install MongoDB in Linux and set auto-start.1. Download mongodb linux version (note the difference between 32-bit and 64-bit),: http://www.mongodb.org/downloads2.place the downloaded mongodbinstallation file mongodb-linux-x86_64-2.6.7.gz

Difference between mysql-authorized localhost & % and persistent authorization error solution (install openstack), mysqllocalhostFirst, we will attach the openstack document to illustrate why permission errors are reported when % is granted!Mysql-u

Similarities and differences between a set computing report and a rundry report when processing a dynamic report. The centralized report inherits the macro mechanism of the rundry report to process dynamic reports. It is very convenient to use the

SQL Application and Development: (4) view applications and SQL Application Development View A view is a table created based on a predefined query. Its definition exists as a schema object. Like a base table, a view contains a series of columns and

How can we improve the query efficiency in a ten-million-level database query ?, Search Efficiency How to improve query efficiency in a ten-million database query? 1) Database Design:A. to optimize the query, try to avoid full table scanning. First,