NAV: SLTechnology News&Howtos > Database >

• 

  Configure deployment Oracle Goldengate Version 11.2.1.0.1

  Configure deployment Oracle Goldengate Version 11.2.1.0.1 configure user environment variable vi .bash _ profile add: export OGG_HOME=/data0/temp/oggLD

  2022-06-01 15:08:34 Views: 300
• 

  Configure the self-built MySQL on ECS as a pit stepped on by RDS from the library

  Environment: RDS version: Aliyun's self-built MySQL5.6.34 (official version) downloads the full automatic backup of Aliyun's rds to ECS, and decompresses it according to the official steps-- > aploy-log-- > mv to mysql.

  2022-06-01 15:08:34 Views: 245
• 

  GTID for new features of mysql5.6 (can be replicated in parallel)

  GTID is the global transaction ID (global transaction identifier), and GTID is actually made up of UUID+TID. Where UUID is the unique identity of an MySQL instance. TID represents that the instance has been submitted

  2022-06-01 15:08:21 Views: 279
• 

  How to delete database partition correctly

  Deleting a database partition from DPF is by no means as simple as editing db2nodes.cfg directly. The right thing to do is to use the command "db2stop drop partitionnum". If you edit the db2nodes.cfg directly and delete the corresponding points

  2022-06-01 15:08:20 Views: 282
• 

  MySQL view of 7Python all-station road series

  The MySQL view of the Python full stack path series is a virtual table (not real). Its essence is to obtain a dynamic dataset according to the SQL statement and name it. Users only need to use the name to get the result set, and can use it as a table. Create a view to create a

  2022-06-01 15:08:20 Views: 285
• 

  Change the default encoding of Mysql5.7 to utf8 under Mac

  After the official installation of Mysql5.7 on Mac, some character sets default to latin1 rather than utf8. To avoid garbled, this article introduces setting all character sets to utf8 to view the current character set coding show variables like.

  2022-06-01 15:08:20 Views: 283
• 

  Installation and basic commands of MySQL for LAMP

  Earlier we introduced apache httpd server, and in the enterprise website platform, in order to provide richer. Powerful web application functions, but also need the background database and web programming language and other roles to support, here we will install the MySQL database.

  2022-06-01 15:08:12 Views: 267
• 

  MySQL- realizes the best flashback actual combat based on binlog

  1. Background * Master and slave are built for data security. Real-time master-slave backups can only prevent hardware problems, such as damage to the hard drive of the master library. But for misoperation, there is nothing we can do. For example, a table is mistakenly deleted in the main database, or a update statement does not specify a where condition, resulting in the whole table being updated.

  2022-06-01 15:08:09 Views: 297
• 

  Java Code access Hbase Test

  Import java.io.IOException;import java.util.Iterator;import java.util.List;import org.apache.hadoop.

  2022-06-01 15:08:09 Views: 282
• 

  HBase stop node error "pid does not exist"

  HBase stop Node error, pid does not exist problem stop HBase Node Times error is as follows: [root@hregion92 bin] # / opt/hbase-0.98.7/bin/hbase-daemon.sh stop

  2022-06-01 15:08:09 Views: 287
• 

  Online DDL gh-ost tool testing

  OS:centos 6.5DB:percona server 5.6.32gh-ost:1.0.21DB-M:192.168.128.128DB-S: 192.168.128.129 introduction: gh-os

  2022-06-01 15:08:08 Views: 296
• 

  The theoretical basis of SQL

  First, an overview of the definition and history of 1.SQL SQL:Structured Query Language, structured query language. Is the standard language for relational databases; the SQL function is not just a query. Almost all relational database management system software supports SQL. Many

  2022-06-01 15:08:08 Views: 246
• 

  Percona-toolkit kills slow SQL statements

  1. Download percona-toolkit-2.2.16.tar.gz# wget https://www.percona.com/downloads/percona-toolkit/2.2.16/tarb

  2022-06-01 15:08:08 Views: 290
• 

  The first article on the use of MyCat

  The basic concept is too boring to introduce the concept directly, so let's take an example similar to the background to introduce the business scenario: the customer completes the order, the courier accepts and updates the waybill status, and the customer can check the waybill status at any time. One courier may have more than one master. At the same time, we need to mark the status of each waybill

  2022-06-01 15:07:51 Views: 208
• 

  Oracle from getting started to proficient in questions about simple queries

  Video course: Li Xinghua Oracle from introduction to proficient Video course Learner: sunshine Rono Video Source: 51CTO College if you want to query, be sure to use the query part of the DML. Compared with the simple query, the popular understanding is to query all the records, but you can

  2022-06-01 15:07:31 Views: 270
• 

  Database backup and restore series-full backup + two incremental backup and restore

  Scenario: full backup on Sunday, incremental backup on Monday and Tuesday, problem occurred on Wednesday, found a few minutes later; database installation: yum install mariadb-server-ysystemctl start mariadbyum inst

  2022-06-01 15:07:30 Views: 259
• 

  Perfect solution to oracle11gR2 installation grid check ASM error PRVG-10122

  First of all, the main reason for reporting errors in PRVG-10122rac1,rac2: the version of the kmod-oracleasm package is relatively old. In order to install my own kernel version, first of all, I uninstalled the kmod-oracleasmyum I downloaded on rac1.

  2022-06-01 15:07:30 Views: 226
• 

  SuSE11 installation MySQL5.7.22:RPM installation method

  Summary: SuSE11sp3 64-bit operating system, MySQL5.7.22 rpm installation package version 5.7 is different from the previous version installation, it should be noted that: kingtry is my hostname 1, environment preparation operating system: SuSE version 11sp3Magi 6

  2022-06-01 15:07:27 Views: 202
• 

  SQL Server database configuration improvement

  For the configuration of the SQL Server database, follow the best practices and see if you can modify the instance configuration of the production environment. The following is the adjustment method and basis: start the account memory lock to ensure that the SQL Server committed memory will not be swapped or the space will not be shrank by the operating system. The

  2022-06-01 15:07:27 Views: 257
• 

  Build a mongodb replica (one master and two backups)

  Mongodb replica Construction (one Master and two Slave) Master: 192.168.0.237 standby 1RV 192.168.0.122 Slave 2RV 192.168.0.123 three machines also operate tar zxf mongodb-linux-i686-

  2022-06-01 15:07:26 Views: 212