NAV: SLTechnology News&Howtos > Database >

• 

  Resolve:. / check_oracle_health-- connect orcl-- mode connection-time error report

  Error message. / check_oracle_health-- connect orcl-- mode connection-timeCRITICAL-cannot connect to orcl. In

  2022-06-01 17:29:59 Views: 215
• 

  Master-Slave deployment of mysql5.7.13 based on centos6 (2)

  Master-slave deployment of mysql5.7.13 based on centos6 (2). Deployment master mysql description: mysql1 is the host and mysql2 is the standby. Create the library [root@mysql1 ~] # mysql-uroot-p1234

  2022-06-01 17:29:32 Views: 283
• 

  Mongodb delayed replication node configuration

  Background: when we generally configure Mongodb master-slave, or Mongodb replication sets, data synchronization is real-time. However, if the wrong data operation is carried out on the primary node, it will cause the data of the whole cluster to go wrong. So, we can pick a mo in a cluster.

  2022-06-01 17:29:32 Views: 218
• 

  Seven compressed packages of oracle database

  Oracle11g has several installation CDs: file name description p102025301120--Linux-x86-64_1of7.zip database installation media p102025301120--Linux-x86-64

  2022-06-01 17:29:14 Views: 219
• 

  OEM12C installation documentation

  OEM12C installation documentation environment: OEM12.1.0.5 operating system: CENTOS6.7ORACLE:11.2.0.31, hardware requirements 2, software package requirements-RHEL6.X OEL6.X version for omsmake-3

  2022-06-01 17:29:14 Views: 267
• 

  The crsctl start crs instance cannot be started automatically because AUTO_START=restore causes

  After crsctl start crs, the instance cannot be started automatically. Check the startup property of resource, 1:crsctl status resource ora.orcl.db-pauto_start, whose value is resto

  2022-06-01 17:29:13 Views: 275
• 

  Backup script in Linux RAC environment

  Run {crosscheck archivelog all; allocate channel c1 device type disk connect sys/oracl

  2022-06-01 17:29:13 Views: 240
• 

  [foam gold] SQL sub-query Not In no result reason

  Background source code select * from ITEM where item_id not in (select parent_item_id from ITEM) query effect does not have any matching value. Cause not in

  2022-06-01 17:29:07 Views: 269
• 

  MySQL Cluster Manager 1.4 user's Manual-A5

  Table A.9 MySQL server options and variables for NDB clusters: MySQL clusters NDB 7.5-7.6

  2022-06-01 17:29:03 Views: 245
• 

  Linux builds mysql master-slave service

  Found more than N information on the Internet, none of them can succeed smoothly, depressed, maybe the level is limited. After continuous research and testing, I complete the realization of starting two Mysql under linux, and have a more in-depth understanding of mysql. No more nonsense, let's go! Steps such as

  2022-06-01 17:28:57 Views: 293
• 

  Mongodb installation

  one。 Prepare a machine with Centos system installed (I use Centos 7), and guarantee that you can connect to 2. 2 through X-shell. Go to the official website to download mongodb software II. Start installing mongodb1. Connect through X-shell

  2022-06-01 17:28:41 Views: 235
• 

  The solution of data Export from MySQL Database in Drocker

  In practical application, we must encounter the need to export the data in the database. Below, I will summarize my own experience accordingly. I am afraid that I will forget for a long time. I hope I can record it so that I can make a follow-up inquiry. At the same time, I also hope to help those in need. When needed for M

  2022-06-01 17:28:40 Views: 221
• 

  Deferred replication delayed replication

  Mysql5.6 starts to support deferred replication. The default master_delay is 0 seconds, CHANGE MASTER TO MASTER_DELAY = N, indicating the principle of delayed Nseconds: the essence of deferred replication is that sql_thread needs to wait.

  2022-06-01 17:28:40 Views: 215
• 

  RedisView- open source cross-platform Redis visualization tool

  There are many kinds of existing redis graphics chemical industry, but generally there are some shortcomings, such as large amount of data jamming, not supporting clusters, charging, not boasting platform and so on. In order to have an independent and controllable excellent Redis graphics tool, business time development RedisView, the functions are as follows: 1. Redis database view

  2022-06-01 17:28:32 Views: 249
• 

  Enable auto_position=1 to keep reporting errors

  Enable auto_position=1 to keep reporting errors Got fatal error 1236 from master when reading data from binary log: 'The slave

  2022-06-01 17:28:31 Views: 230
• 

  Error occurred in oracle new user executing sql query ORA-00942: table or view does not exist

  After oracle creates a new user, an error occurs after the client executes the SQL query as follows: execute the query statement as follows: select * from sm_sales_order;ORA-00942: create a new user without a table or view and specify the tablespace and the

  2022-06-01 17:28:31 Views: 221
• 

  PostgreSQL-- kills dead connections

  First, the principle in the database PostgreSQL, a client to server connection is actually a tcp socket connection, tcp connection is a virtual connection, one side abnormal exit (such as power outage), the other side will continue to maintain the connection. For example: a client computer is normal.

  2022-06-01 17:28:30 Views: 297
• 

  Server1_nobinlog, Error: Too many connections

  The operation and maintenance staff rebooted the tested machine directly, the / usr directory does not exist, reinstall the new mysql, and then the test library restarts myshard, some ports can be up, some can not get up root@ubuntu:/data/rds/myshard/bin

  2022-06-01 17:28:21 Views: 241
• 

  Yum installs mysql5.7 and 5.6

  Usually when yum installs mysql-server, the mysql version is relatively low. If you want to install a higher version, you can import the official yum source to install mysql5.71, download the official yum source, and import the download address: http://dev.mys.

  2022-06-01 17:28:21 Views: 242
• 

  The main cluster of Atlas+mysql implements read-write separation.

  Preface: at present, the database of online system adopts the main main architecture. Among them, one master only switches to use in the event of a failure (only a single server provides services, and when there is a problem, switch to the other), it is difficult for this structure to support large concurrency, and the other of the two hosts is not effectively used when there is no failure.

  2022-06-01 17:28:21 Views: 221