MHA Routine Management MHA is the best choice for many enterprises that use MySQL databases for high availability. It is easy to use and powerful, and implements automatic master-slave failover Based on the MySQL replication architecture. This
Asm disk Group loading ORA-15183 error example In Oracle 11gR2, ASM (Automatic Storage Management) is removed from the Database Component, and as an independent Component, it enters the scope of Grid Management. This article mainly introduces a
Cleaning temporary tablespace in Oracle Oracle temporary tablespace is mainly used to query and store some buffer data. Temporary tablespace consumption is mainly caused by sorting the intermediate query results. The main functions of temporary
View the version of the remote Redis Server How can I view the version of a remote Redis server? What should I do if I have no SSH access permission for the remote Redis server and want to know which version of the Redis server is used? It's easy to
MD5 encryption in Oracle Because MD5 encryption is used, I searched the internet for relevant information and studied it carefully. Its core is the MD5-encoded data packet function: DBMS_OBFUSCATION_TOOLKIT.MD5, which involves the RAW type, which is
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
Node. js remotely connects to the MongoDB database server on another host My MongoDB is installed in linux. First, add a user 1. First, run the terminal command line on the MongoDB server host and enter Mongo 2. Enter use admin to access the user
Oracle 11g TNS connection error ORA-12532 troubleshooting TNS connection errors are common problems for Oracle users. In practice, due to the complexity of the user terminal environment, various TNS connection problems often plague daily users.
MySQL Performance Optimization-Block Nested-Loop Join (BNL) 1. IntroductionI believe that many developers/DBAs are still not satisfied with the way MySQL processes multi-Table associations or the performance when using MySQL. Join queries submitted
How to do the truncate operation for a primary table associated with a foreign key The primary and Foreign keys are mandatory associations between two tables provided by the database. They can also be implemented at the application layer.
Use Hive's regular parser RegexSerDe to analyze Nginx logs 1. Environment: Hadoop-2.6.0 & apache-hive-1.2.0-bin 2. Use Hive to analyze nginx logs. The website access logs are as follows: Cat/home/hadoop/hivetestdata/nginx.txt192.168.1.128--[09/Jan/20
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.
Dynamic Registration listening and dynamic listeningSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release
Data Table field attribute query, data table field attribute --- Query all database table namesSelect id, name from sysobjects where xtype = 'U' order by name--- Query all the field attributes of a tableSelect * from syscolumns where id = object_id
Oracle dblink causes too many remote database sessions. oracledblink The database of the on-site reporting network company could not be connected. I checked the database processes = 1500 and session = 2200 first. I think it is very big. Few people
Dell shareplex and HVR data replication software, shareplexhvr Today I have a general understanding of Dell shareplex data replication software, web site: http://software.dell.com/products/shareplex/ You can see from this URL,Shareplex is the
PreparedStatement and Statement, preparedstatement PreparedStatement is one of the APIs used to execute SQL query statements. Java provides Statement, PreparedStatement, and CallableStatement to execute query statements. Statement is used for
Install and use mongodb 1. Install and start MongoDB Widndows and linux are basically the same 1. Download the database, Mongodb-linux-x86_64-ubuntu1404-3.0.3.tgz: linux 2. decompress the file and place it in a proper location. Tar-vxf mongodb-linux-
Extended map and extended map of associated queries select one.*,tw.id sid,tw.catlevel slevel,tw.name sname,tw.code scode,thr.id tid,thr.catlevel tlevel,thr.name as tname, thr.code as tcode from tb_sort one join tb_sort tw on
JDBC connection pool with the best performance: HikariCP, jdbchikaricp HikariCP claims to be the best-performing JDBC connection pool component. I have not carefully tested the specific performance, but from the perspective of its development, it