Database Administrator

Install, configure, and test the MySQL source code package in Linux (this test is feasible) Write down this MySQL note, which will be useful in the future! RedHat Linux 6 uses the CentOS yum source to describe how to install and configure mysql

Key New Features of MySQL 8 MySQL's eighth version is coming soon and is expected to be released in 2018. Within 28 months after MySQL 5.7.9's first general-purpose version was launched, MySQL 8 released five candidate versions from 8.0.0 to 8.0.4.

Bind a variable of DATE type in SQL * Plus SQL * Plus is an essential tool for DBAs. According to TK, "DBAs that do not use SQL * Plus are not qualified DBAs ." Of course, this is not the case, but it is similar to this. We can see the importance of

Obtain the value of a specific position in the field in MySQL Obtain the value of a specific position in the query field in MySQL For example, there are two types of data: mysql>  select  *  from  t; + --------------------------+ |  name | + --------

Connect to Sybase through Oracle transparent gateway The transparent gateway technology proposed by Oracle can be used to interconnect with other types of databases to establish connections between different types of data, which is convenient for

Implementation of the REVERSE function in DB2 Some guys asked DB2 if there were any built-in reverse functions in the group. I tested that DB2 does have built-in functions, but Oracle and SQL server both have built-in functions. Let's take a

Cross-platform database migration using Oracle Data Guard The customer was originally a single-host Oracle 11.2.0.3.0 Database for Windows Database system. The customer's requirement is to migrate the single-host Oracle Database to the three-node

Transaction design strategies for MongoDB, Cassandra, and HBase NoSQL databases (such as MongoDB, Cassandra, Hbase, DynamoDB, and Riak) make application development easier. They provide quite flexible data models and rich data types, and are easier

InnoDB RR isolation level insert select two deadlock case analysis, innodb Case Analysis Author:Gao Peng (Eight monsters in Chongqing) School draft:Master Ye (some content is fine-tuned) Original article: http://blog.itpub.net/7728585/viewspace-

Database selection of different business logic constraints and database business logic Constraints I think the constraints on data tables are still very useful. At least there are many database optimizations, which can greatly improve the retrieval

Tomcat _ configure jdbc (small example) and tomcat configure jdbc  Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/47043975   Example of jdbc configuration under tomcat When you use

Redis expiration key deletion policy and redis expiration key policy We have learned that Redis is a memory database, and data in Redis is stored in the memory in the form of key-value, which is maintained and managed by the Redis server, memory is

A small example of redirecting data files under asm (using the toad tool), asmtoad Original works, from the blog of "Deep Blue,Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/46863991   Scenario: in the production environment, you

Oracle Solaris, pci dss, and solarisdss   Today on the Oracle official website to search for pci dss, unintentional search for Oracle Solaris information about pci dss (see the following url:

Payment Card Industry Data Security Standard pci dss and oracle database, dssoracle Payment Card Industry Data Security Standard pci dss and oracle database Recently I checked several Oracle database Security options, so I came into use with the

MySQL Optimization-triggers and mysql triggers Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46763665 A trigger is a special stored procedure. The difference is that the stored procedure must be called by

  Click Tools ---> Preferences ---> Profiler. The configuration description is as follows (the current demo version is 9.0.0.1601)Available Columns -- Available Columns (can be moved to the right)Selected Columns -- Selected ColumnsTime units --

Recently encountered problems are quite interesting. First, I haven't started the test database for a long time. Today I opened the database and encountered the following error during the test using the service program:

In the previous article "differences between read in the current mode and consistent read", I used two special examples to describe the differences between read in the current mode and consistent read, it also mentions that "if the corresponding

A butterfly in the South American jungle flags wings and may cause heavy snow in Moscow, indicating the complexity of the atmospheric system. However, DBAs often face similar problems in their daily work. We analyze the symptoms of faults to solve