NAV: SLTechnology News&Howtos > Database >

• 

  Mongodb Security and Optimization

  Improve the security of mongodb: MongoDB has no password by default and only allows local access. If you open access to the public network, you must set a password and configure a firewall to specify which ip ports are only allowed to access mongodb ports, otherwise there will be security risks. Configure permission management

  2022-06-01 11:33:53 Views: 203
• 

  ORA-00845: MEMORY_TARGET not supported

  1. Environment description system: rhel 7.3.Database: Oracle 12.2.0.1 II. Use AMM$export ORACLE_SID=orcl$sqlplus / as sysdbaSQL*Plus: Rele

  2022-06-01 11:33:53 Views: 234
• 

  Hbase failed to start properly

  In a fully distributed environment, hbase cannot start normally when it starts. The problem of throwing abnormal information org.apache.hadoop.hbase.ClockOutOfSyncException in logs log is due to master and Re.

  2022-06-01 11:33:53 Views: 296
• 

  Oracle startup phase

  Startup is divided into three steps: 1.nomount stage, this stage is the instance startup, the system allocates memory according to the parameter file, and starts the background process. In the 2.mount phase, check the name and location of the data file and log file according to the control file, and connect the instance to the database.

  2022-06-01 11:33:49 Views: 290
• 

  The method of rebuilding scott by oracle

  Reminder: this method has only been practiced on oracle 10g 11g 12c. First find SQL > ho pwd/home/oracle/product/11.2.0/rdbms/admin2 under this path. Then perform the following

  2022-06-01 11:33:49 Views: 248
• 

  Oracle backup and recovery-rman

  (1) create recovery catalog 1, create recovery catalog database # mkdir-p / u01/app/oracle/oradata/rmandb#chown-R oracle/ u01/app/oracle/oradat

  2022-06-01 11:33:49 Views: 211
• 

  Pt-table-sync of percona-toolkit

  Through the above pt-table-checksums to find these inconsistent data tables (https://blog.51cto.com/li02yu/2340403), how to synchronize the data? That is, how to repair the inconsistent data of MySQL masters.

  2022-06-01 11:33:49 Views: 289
• 

  Oracle materialized View Log

  1. What is the materialized view log? the fast refresh of the materialized view of oracle requires that the materialized view log must be established, and the incremental refresh function can be realized through the materialized view log. The official document gives an interpretation of the materialized view log: A materialized view lo

  2022-06-01 11:33:48 Views: 245
• 

  Can't connect to local MySQL server through socket

  # mysqlERROR 2002 (HY000): Can't connect to local MySQL server through socket' / tmp/mysql.socket'# ln

  2022-06-01 11:33:48 Views: 231
• 

  Discussion on the applicability of Hadoop, Spark, HBase and Redis (2): HBase

  Let's talk about HBase. In this regard, it is often heard that HBase is only suitable for supporting offline analytical applications, especially as a background data source for MapReduce tasks. There are many people who hold this view, even among one of the most famous telecom equipment providers in China, HBase

  2022-06-01 11:33:48 Views: 264
• 

  Ecosystem of Hadoop

  Hadoop ecosystem 1. Abstract after several years of rapid development, Hadoop has now developed into a software ecosystem containing many related projects. In a narrow sense, the Hadoop core only includes Hadoop Common, Hadoop HDFS and Hadoop.

  2022-06-01 11:33:48 Views: 235
• 

  MySQL5.7 reported an error

  Mysql profile directory: the following sentence in the configuration file when the / etc/my.cnfroot password is empty: skip-grant-tablesGRANT ALL PRIVILEGES ON *. * TO IDENTI

  2022-06-01 11:33:47 Views: 251
• 

  Oracle gets the current date and date format

  Oracle get current date and date format get system date: SYSDATE () format date: TO_CHAR (SYSDATE (), 'YY/MM/DD HH24:MI:SS) or TO_DATE (SYSDATE ()

  2022-06-01 11:33:20 Views: 202
• 

  Tbs_P2: changing tablespace properties

  SQL > conn system/oracle-- create manual segment managed tablespaces SQL > altersystem set db_create_file_dest ='/ oradata';SQL > createtab

  2022-06-01 11:33:20 Views: 274
• 

  2: replication based on binary log file location

  Server 192.168.1.2 (master), server 192.168.1.3 (slave) to configure master to use replication based on binary log file location, binary logging must be enabled and a unique server must be established

  2022-06-01 11:33:20 Views: 205
• 

  Mongodb competes with mysql for full table scanning capability

  The data of nosql is in memory, while the traditional rdbms, when a select executes for the first time, if it finds that there is no needed data in memory (such as mysql's innodb buffer pool), it will read it from disk and then start calculating.

  2022-06-01 11:33:19 Views: 270
• 

  Mongodb install for windows7 64-bit

  Configure Mongo server 1. On the official website: http://www.mongodb.org/ downloads the latest mongodb according to the operating system. Download version: mongodb-win32-x86_64-2008plus-ssl-3

  2022-06-01 11:33:19 Views: 246
• 

  SQLserver2008, you can't install it after uninstalling it once? Solve = =

  I installed it successfully before, and then it inexplicably failed to connect to the database engine, and then I deleted its related files, but I didn't clean the registry, and then I reinstalled it, and then I couldn't connect it, and now the installation was successful but failed. I also cleaned the registry and solved it.

  2022-06-01 11:33:19 Views: 260
• 

  Install MySQL-5.6.37 with general binary installation package under Linux

  Record the process of installing MySQL 5.6.37 in CentOS 6.9 environment for your reference. If the system above centos7: need to uninstall rpm-e mariadb-libs-5.5.52-1.el7.x86_64

  2022-06-01 11:33:19 Views: 292
• 

  SQL Server dual-computer Hot standby Technology

  SQL Server dual hot backup technology SQL Server dual hot backup can be achieved by publishing and subscribing, log delivery, and database mirroring. Publish subscribe publish and subscribe is to use SQL Server database replication technology to convert data or database objects from a number

  2022-06-01 11:33:19 Views: 285