NAV: SLTechnology News&Howtos > Database >

• 

  Detailed explanation of C3P0 connection pool configuration + database master-slave configuration

  The detailed explanation of C3P0 connection pool configuration in the data layer spring-dao.xml configuration file first puts the related code of the two configuration files bean. The following article will explain the detailed configuration properties. You can add configuration and modify configuration ordinary single database connection pool configuration spri.

  2022-06-01 21:51:25 Views: 215
• 

  SQL Server 2017 AlwaysOn on Linux configuration and maintenance (13)

  2.4.2 forced failover is strictly restricted for disaster recovery. If the cluster fails to respond due to a disaster in the primary data center, you cannot use cluster management tools to interact with the cluster, and you may need to force a failover to bypass the external cluster administrator. Verify that the AG resource is no longer

  2022-06-01 21:51:25 Views: 288
• 

  Mysql master-slave replication and maintenance-single master and double master

  This paper describes the configuration method, matters needing attention and maintenance of single master mode and double master mode of MySQL. 1. Single master configuration instance 1.1 overall process: master and slave time synchronization master enables binary recording function and authorizes a specific user to binary

  2022-06-01 21:51:24 Views: 243
• 

  Recovery method of Sql Server Database lost due to unknown reasons

  Fault description: 5 pieces of 2T hard disk set up RAID5, divide LUN for windows server use. The Sql Server2008 database is installed in the windows server. There are three logical partitions in the storage space, with sizes of 500G, 800G and 2, respectively.

  2022-06-01 21:51:10 Views: 279
• 

  Initial Oracle database 11g express

  The initial Oracle database 11g express edition installation process is relatively simple. I installed it on t400+win7 and made it into ppt.

  2022-06-01 21:51:10 Views: 272
• 

  MongoDB Hot Backup test and pain point

  Preface to Percona MongoDB Hot Backup testing and pain points Part1: written in the front Percona MongoDB supports Hot Backup, solving the problem that the official version of MongoDB can only use mongodump

  2022-06-01 21:51:07 Views: 227
• 

  Oracle 11g New Partition

  Oracle 11g added interval partitions, virtual column partitions, and reference partitions. For more information, please see the official document: Creating Partitions1. Interval partition is an extension of range partition. Before introducing interval partitions, DBA needs to show

  2022-06-01 21:51:06 Views: 298
• 

  MHA of MySQL high availability cluster

  Introduction to MHA 1 and MHA of MySQL High availability Cluster MHA (Master High Availability) is currently a relatively mature solution in terms of MySQL high availability, which is developed by youshimaton of DeNA Company of Japan.

  2022-06-01 21:50:36 Views: 258
• 

  RMAN backup filesperset usage

  RMAN backup filesperset usage uses filesperset to control the size of backup sets when the filesperset parameter is specified, rman compares filesperset with the automatically calculated value (number of files per assigned channel) and takes

  2022-06-01 21:50:36 Views: 256
• 

  Redis installation notes

  Cp / usr/local/src/wget http://download.redis.io/releases/redis-3.0.1.tar.gztar zxf redis-3.0.1.tar.g

  2022-06-01 21:50:36 Views: 288
• 

  MySQL 8.0.18 rebuilding MG with clone plugin

  Suppose a node in the three-node MGR is abnormal, and the node needs to be re-added to the MGR cluster. The specific operation process is as follows: the contributor executes (192.168.1.11) DROP USER 'donor_clone_user'@'192.168

  2022-06-01 21:50:36 Views: 284
• 

  Multi-table query of MYSQL

  1. Cartesian product select * from emp,dep; select * from emp,dep where emp.dep_id = dep.id;select * from emp,dep w

  2022-06-01 21:50:35 Views: 273
• 

  Monitoring SQL Server transactional replication

  Monitoring SQL Server transactional replication usually, we can use SSMS's replication monitor to monitor replication. But we can't stare 24 hours a day, we have to monitor it in an automated way. Microsoft provides system stored procedure dbo.s in distribution database.

  2022-06-01 21:50:35 Views: 272
• 

  The use of couchbase in the summary of operation and maintenance work in the regiment.

  I haven't written a blog for a long time. Today I brought the installation of couchbase using rpm-ivh couchbase....rpm to visit http://ip:8091 to start setting up couchbase cluster and other machines to join the cluster to create bukket configuration.

  2022-06-01 21:50:05 Views: 206
• 

  Jaas jca jsse

  Java Security Architecture: http://download.oracle.com/javase/6/docs/technotes/guides/security/spec/security-spec.doc

  2022-06-01 21:50:05 Views: 275
• 

  Mysql_config_editor

  Mysql_config_editor is a tool for storing mysql login information. After setting the login information through mysql_config_editor, you can use only one-- login-p when logging in to the database with the mysql command

  2022-06-01 21:49:38 Views: 285
• 

  Mysql Learning Notes (6-DML command)

  DML:INSERT, DELETE, UPDATE, SELECTINSERT INTO:INSERT [INTO] tbl_name [(col1,...)] {VALUES | VALUE} (va

  2022-06-01 21:49:37 Views: 232
• 

  EBS 11i ojspCompile.pl compiles jsp garbled encoding

  11i environment, generally speaking, jsp is compiled automatically after restarting apache, but because of some environment settings, you need to compile jsp manually. 11i compilation path: $JTF_TOP/admin/scripts/ojspCompile.pl compilation command

  2022-06-01 21:49:37 Views: 280
• 

  Introduction to MongoDB (1)-- Overview of Database

  1. Database Overview 1.1. What is the above picture in the introduction? Answer: what is the garage for? Answer: parking the car, in other words: storing the car. What is the database used for? Answer: store data. Thinking 1: the teacher asked you to summarize the number of people who were late this week. How do you record it? The amount of data is relatively small

  2022-06-01 21:49:25 Views: 300
• 

  Wcp knowledge Management system deployment document

  Wcp knowledge management system deploys document environment CentOS-6.5-x86_64-bin-DVD1.isojdk-7u79-linux-x64.tar.gzapache-tomcat-7.0.72.tar.gzMyS

  2022-06-01 21:49:08 Views: 214