Database Administrator

Implement PostgreSQL failover in CentOS 6.5 Pgpool-II is an intermediate component that works between the PostgreSQL multi-server and the PostgreSQL Data Warehouse client. It provides the following functions: Connection Pool: pgpool-II is used to

Write DMP files to aws rds Oracle using Python scripts RDS (Oracle) does not directly support SSH or FTP (based on security factors). Therefore, the dmp files from the original system expdp or exp cannot be directly imported into RDS. In the

MySQL 5.7 new feature: Generated Column (function index) MySQL 5.7 introduces Generated Column. This article briefly introduces the usage and precautions of Generated Column, and provides a quick and complete tutorial for readers to understand MySQL

Time Processing in javascript and javascript Time ProcessingVar myDate = new Date ();MyDate. getYear (); // obtain the current year (2 digits)MyDate. getFullYear (); // obtain the complete year (4 bits, 1970 -????)MyDate. getMonth (); // obtain the

Full-text search engine Elasticsearch getting started tutorial, Full-text search is the most common requirement. Open-source Elasticsearch (hereinafter referred to as Elastic) is the first choice for full-text search engines. It can quickly store,

Mongodb advanced 2: mongodb aggregation and mongodb advanced AggregationIn the previous article we talked about mongodb's advanced query: http://blog.csdn.net/stronglyh/article/details/46817789 This article introduces mongodb aggregation. I. mongodb

Redis configuration file redis. conf detailed description, redisredis. conf Redis. conf1. daemonize # By default Redis does not run as a daemon. use 'yes' if you need it. # Note that Redis will write a pid file in/var/run/redis. pid when daemonized.

Redis document translation _ LRU cache, redis document _ lruUsing Redis as an LRU cache uses Redis as the LRU cacheSource: http://blog.csdn.net/column/details/redisbanli.htmlWhen Redis is used as a cache, sometimes it is handy to let it

MySQL Optimization-Delete Insert update and mysql optimization insert update Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46581769 Insert Insert multi-row query results into the table Syntax INSERT INTO

How to restore deleted files from the recycle bin I have a boyfriend who has been in love for three years. I am willful and often get angry or yell at him. We had another quarrel yesterday because he didn't wash my jeans, and I didn't have to wear

Previous Article: getting started with MongoDB Http://blog.csdn.net/rjfxd/article/details/12108909 I. Preparations 1. Create a maven project and add the required Dependencies junit junit 4.10 test org. mongodb mongo-java-driver 2.11.3 Of

Currently, popular database software include DB2, Access, Sybase, SQL server, ORACLE, and Foxpro. Among them, IBM's DB2 database is the leader in large databases, and DB2 is an important product of IBM, providing services on different operating

Perhaps the most common error found in application code is a query request that uses a non-parameter special query to request data from the database instead of a prepared query or program. If you do not prepare your query or do not use the stored

By slimming the database through the file system, it is to serialize the big data in the database and the data not involved in the search to a certain location on the hard disk through the file stream. The storage location uses the hash path, that

To output data files in the correct format, you only need to use character links during select to standardize the format. For example, see the following table. SQL>; select id, username, password from myuser; // test table1. John 12342

As we all know, Oracle time can be directly used for addition and subtraction operations, such Select sysdate, sysdate-2 from dual"SYSDATE" "SYSDATE-2"-----------------------------------"19-5-09" "17-5-09" Obviously, sysdate-2

SQL Server database query tips: Problem type: When the ACCESS database field contains a Japanese Katakana or other unknown characters, the query will prompt a memory overflow. Solution: Modify the query statement. SQL ="Select * from ada where

1 Preface In the recent project development process, I encountered Database Design Problems and referred to multiple databases, summary of some of the relevant database entities and relationships. During the month, I also wrote a MySQL database

As I recently conducted a cross-database operation test, I started IBatisNet IBatis. dataMapper.1.6.2/IBatis. dataAccess.1.9.2) + SQL Server2005 was used smoothly, but some problems occurred when IBatisNet + MySQL5.1 was used. After hard work and

Data is an important asset of an enterprise's data center. obtaining and maintaining high-quality data is critical to efficient IT and business operations. In the face of increasing complexity of business data, how can we fully ensure data quality?