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

Oracle reconstruction control file-Rebuild controlfile The DBA needs to know when recreating the control file, but it may not be able to reproduce the system throughout his career. First of all, it is emphasized that backup is the safest, quickest,

OGG synchronizes Oracle Data to Kafka Environment:Source: Oracle12.2 ogg for Oracle 12.3Target: Kafka ogg for bigdata 12.3Synchronize Oracle Data to Kafka through OGG Source Configuration:1. Add additional logs to the table to be synchronizedDblogin

Redis Master/Slave + KeepAlived for High Availability Redis is a popular non-relational database that supports a wide range of data types, multi-thread high concurrency support, redis runs in memory with faster read/write. Because redis is doing so

Python clears database error logs and python database logs # Coding = gbkFrom encodings import gbkImport reImport sysImport OSImport pyodbcImport tracebackImport decimal   # Connecting to a databaseConn = pyodbc. connect ('driver = {SQL Server};

Oracle goldengate bi-directional active-active configure 1. Install the golden gate software. After creating the installation directory, decompress it under the directory. (Both the source and target are executed)Note: We recommend that you use

In one sentence, convert a Linq statement to an SQL statement.Zookeeper Public IEnumerable ReportView_List (VMB_ReportConditions requiredModel){IEnumerable resultModel = new List ();IQueryable merchantList;MerchantList = Report_List (); # Region

Comparison and Analysis of eight common NoSQL Database Systems Krist óf kolács is a software architect and consultant who recently published an article comparing various NoSQL databases. Although SQL database is a very useful tool, after 15 years of

Detailed description of distributed algorithms and NoSQL algorithms in nosql Databases Today, we will study some distributed strategies, such as replication in fault detection. These strategies are marked in italics and divided into three parts:

Speaking of mysql, we immediately think of its small size, fast speed, and open source features, so it is widely used. Today, we will summarize the two most frequent mysql operations: insert and query, and the optimization methods. Insert: I. Text

1. All non-numeric characters for replacing a field are blankUpdate mobileNo_batchreg_black set mobile_no =Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace (Replace

PostgreSQL tutorial (8): Index details, postgresql Index I. Index type: PostgreSQL provides multiple index types: B-Tree, Hash, GiST, and GIN. Because they use different algorithms, each index type has a suitable Query type, the create index Command

In addition to using the APIS provided by office to search for Word documents, this article briefly summarizes three solutions for searching Word files based on SQL Server's full-text retrieval technology. 1. Full-text search with the Windows Index

Many friends think that in simple mode, the heap table cannot retrieve a record because there is no log record. In fact, in a sense, it can be recovered, because the heap table only changes the row offset when deleting records, and the actual data

In "How to Design Database 2)", Jack London Chen raised some questions, which are roughly as follows: "Man/woman should be designed in the same table. Most user tables are designed as one table. Neither administrator nor user can be connected ." I

Use the transparent data encryption (TDE) of the Oracle database introduced as part of Oracle Advanced Security Option Version 10.2 and later ), you can selectively Encrypt sensitive database data stored in the underlying database data files and all

When the data volume of a database is frequently read/written, we need to consider separating the read/write of the database to improve the efficiency of database use (of course there are other uses such as backing up data ), at this time, we need

What is Database Links? First, we will explain its role: to allow users to access another remote database through one database. The Database Link stores the connection information of the remote Database. As shown in: Scott can query the emp table

It is easy to have problems when managing databases, but how to solve problems when database pages are damaged or verification errors occur is also important for everyone to understand. I have been learning more about database Fault Handling

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