NAV: SLTechnology News&Howtos > Database >

• 

  [Mongo] user authentication of mongodb

  1. Create a super account > use admin; > db. CreateUser ({user: "admin", pwd: "123456", roles: [{role: "roo

  2022-06-01 06:37:13 Views: 284
• 

  New Features of Oracle12C-- cdb and pdb

  Oracle 12C introduces new features of CDB and PDB. In the multi-rent user environment (Multitenant Environment) introduced by ORACLE 12C database, one database container (CDB) is allowed to host multiple pluggable databases (

  2022-06-01 06:37:10 Views: 251
• 

  Ubuntu Linux:MySQL installation Guide (transfer)

  Ubuntu Linux:MySQL installation Guide (transfer) [@ more@] install MySQLsudo apt-get install mysql-server this should be very simple, and I don't think everyone is too big in installation.

  2022-06-01 06:37:10 Views: 206
• 

  Bao Fu oracle configuration

  After Oracle 11g has installed and built the library, some adjustments are needed to make the database run stably and efficiently. It took a while to sort out the following parameter setting specifications for reference only. 1. Set database parameters 1, processes and sessions (default 150)-view processes and sessions

  2022-06-01 06:37:10 Views: 242
• 

  Oracle+Ogg Archive lost redirect data steps to establish ogg synchronization

  1031 ogg restore operation 1. Stop the replication process on the destination side and delete the replication process of the destination side OGG ggsci > dblogin userid ggtarget,password ggtargetggsci > stop r

  2022-06-01 06:37:00 Views: 267
• 

  Oracle12c Migration-upgrade and Migration of a risk reporting system to 12c-3

  In this article, we introduce other technologies of upgrade and migration: the main steps of rman upgrade: 1. In the source database 11.2, check the concurrent collection setting SQL > select dbms_stats.get_prefs ('CONCURRENT') for obtaining statistical objects.

  2022-06-01 06:37:00 Views: 251
• 

  Oracle 12C modify database character set method + modify client character set method:

  Oracle 12C can modify the character set of PDB separately, which will be described later. This time, it adopts the method of modifying all the CDB: first, query the database character set: select * from nls_database_parameters

  2022-06-01 06:36:49 Views: 201
• 

  New feature of 11G-enhanced recovery performance of Block Media (block media recovery)

  11G new feature-Block Media recovery performance Enhancement (block media recovery) Block Media recovery performance Enhancement (block media recovery): only recover damaged blocks. There is no need to offlin corrupted data files

  2022-06-01 06:36:49 Views: 202
• 

  Introduction to MySQL High availability solution

  This article briefly describes the PPT of a high availability scheme of MySQL that I sorted out when I was a beginner of MySQL. Although it is not very comprehensive and not necessarily accurate, I still want to share it with you, discuss it together, and make progress together. In addition, this partial article is made into PPT, bluffing leaders or superiors.

  2022-06-01 06:36:49 Views: 266
• 

  Infrastructure moving to the Cloud (3)

  Of course, the preparatory stage of cloud relocation work is not without a survey of the existing environment, this is a very important stage, how to move, but also need this as a basis, so this stage can not be careless. 1, on the whole, we need to draw a new topology diagram according to the old database topology diagram and our own understanding. This is

  2022-06-01 06:36:49 Views: 248
• 

  Row-level lock and table-level intention lock of Mysql lock

  The Innodb storage engine implements two kinds of row-level locks: l shared lock l exclusive lock compatibility relationship between these two locks as shown in the following figure shared lock exclusive lock compatibility incompatible exclusive lock incompatible row-level lock is easier to understand. Let's introduce table-level intention locks. Innodb storage

  2022-06-01 06:36:48 Views: 255
• 

  MySQL hint: The server quit without updating PID file(... & # 41; failed

  Cause of error restarting MySQL database [root@guoqing mysql] # service mysql restartMySQL server PID file could not be found

  2022-06-01 06:36:48 Views: 204
• 

  Installation and use of pt-table-checksum,?pt-table-sync and percona-toolkit toolkits

  For details of a useful tool for percona-toolkit MySQL, please refer to http://www.cnblogs.com/zping/p/5678652.html to check data consistency (provided that the slave library must be active)

  2022-06-01 06:36:48 Views: 266
• 

  Why Amazon Aurora when migrating from local MySQL to cloud database?

  In the past two years, with the maturity of the cloud environment, the business of many enterprises are moving to the cloud. As a result, "cloud database" has become one of the most fashionable words, respected by AWS, Microsoft, Ali, Huawei and other big companies. So, for users, how do they view the development of cloud database? what are the factors?

  2022-06-01 06:36:43 Views: 245
• 

  Simple practice of MySQL misoperation data recovery (R11 note day 67)

  A few days ago, a colleague encountered a problem with MySQL data recovery. He ran a update statement and forgot to add the where condition. As a result, it was too late. I simply confirmed whether there is a backup, no, whether the log is turned on, no. So this concession

  2022-06-01 06:36:37 Views: 245
• 

  Mysql 8.0.17 Partition characteristic Test

  1. All the tests below are based on mysql version 8.0.17. Elcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connect

  2022-06-01 06:36:37 Views: 228
• 

  Instructions for the use of mydumper and myloader parameters

  MydumperUsage:mydumper [OPTION...] Multi-threaded MySQL dumpingHelp Options:-?,-help Show help opt

  2022-06-01 06:36:37 Views: 288
• 

  [AlwaysOn] create SQL Server high availability group T-SQL syntax: security

  Security Security permissions Permissions requires membership in the sysadmin fixed server role, and you can create availability group server permissions, change any availability group permissions, or control server permissions. Requires membersh

  2022-06-01 06:36:37 Views: 228
• 

  Several methods of sqlplus connecting to Database

  1. Sqlplus / as sysdba operating system authentication does not require the database server to start listener or the database server to be available. For example, if we want to start the database, we can enter sqlplus in this way, and then use s

  2022-06-01 06:36:33 Views: 254
• 

  Index scans may not be as good as full table scans in terms of the understanding of the pure amount of data, CLUSTERING_FACTOR is not involved

  Multi-block read scenario Full Table Scan-full table scan Index Fast Full Scans-index fast full scan single block read scenario Rowid Scans-obtain Index Uniq directly through Rowid

  2022-06-01 06:36:33 Views: 240