NAV: SLTechnology News&Howtos > Database >

• 

  The usage of SQL Server stuff function

  1. Delete characters of the specified length and insert another set of characters at the specified starting point. 2. Syntax STUFF (character_expression, start, length, character_expressio)

  2022-06-01 09:53:13 Views: 202
• 

  Zabbix3.0.4 source code installation (server side and agent side)

  This blog post as your own record of Zabbix3.0 installation process is similar to 2.x Zabbix3.0.4 source code installation Server installation: first, basic environment: Centos6.7Nginx:1.9Mysql:5.5PHP:5.5.30 (za

  2022-06-01 09:53:13 Views: 245
• 

  Solve the problem that conflict problem appears in centos7 yum installation MySQL rpm package

  [root@localhost mysqlrmp] # rpm-ivh MySQL-server-5.6.37-1.el7.x86_64.rpm has the following error: Preparing... #

  2022-06-01 09:53:13 Views: 263
• 

  Using the new API in Hbase 098.4 to get the column values of multiple rows through the Get list

  In Hbase0.98.4, the column values of multiple rows in Hbase are obtained by the way of Get list. I originally intended to use the KeyValue class to deal with it, but it was found that the two methods of getRow () and getValue () of this class had been abandoned and finally used the new AP.

  2022-06-01 09:53:12 Views: 266
• 

  Amoeba: about the read-write separation of mysql

  Today, read-write separation is done with amoeba. The following steps are summarized: three linux:1, 192.168.1.213 for amoeba server 2, 192.168.1.184 for mysql database 3, 192.168.1.1

  2022-06-01 09:53:00 Views: 277
• 

  [NoSQL] the place of equalizer information in mongo_detail.py

  The idea of processing equalizer information in [ToolsForMongo] mongo_detail.py first look at the db.settings.find ({'_ id':'balancer'}) output under several typical conditions: 1. Create mongo

  2022-06-01 09:53:00 Views: 214
• 

  Holer implements external network access to intranet database

  The external network accesses the intranet database. The database is installed locally and can only be accessed in the local area network. How can the local database be accessed from the external network? This article describes the specific steps to implement using holer. 1. Prepare to install and start the database 1.1 the default installed database port is 3306. two。

  2022-06-01 09:52:43 Views: 282
• 

  Compile and install zabbix3.2,LAMP

  Compile and install zabbix 1.1 environment prepare system environment: close iptables and SELINUX before redhat 6.6 64-bit mysql-5.6.34php-5.6.28zabbix-3.2.1 configuration to avoid installation

  2022-06-01 09:52:43 Views: 205
• 

  MySQL Learning Notes-installation and basic Operation

  MySQL Learning Notes-installation and basic Operations 1. Install MySQL1 # yum-y install mysql mysql-server mysql-devel add / etc/my.conf configuration: 1 vi / et

  2022-06-01 09:52:43 Views: 241
• 

  Simple implementation of AB replication in Mysql Database

  Mysql master-slave replication in the actual enterprise application environment, a single mysql database is not enough to meet the future business needs. For example, if the server fails, if there is no backup server to provide services, the business will have to stop. In this case, we can analyze the mysql data

  2022-06-01 09:52:40 Views: 263
• 

  Oracle controlfile path modification

  SQL > startup;ORACLE instance started.Total System Global Area 835104768 bytesFixed Size 2232960 byte

  2022-06-01 09:52:39 Views: 259
• 

  MyCat read-write separation configuration

  Read-write separation is an inevitable point to consider when we configure the database cluster, because it can effectively reduce the load of the master database, and in the case of read redundant writes, the vast majority of read requests can be distributed to different slave libraries. Even if the load of the slave library is not enough, it can be extracted by adding the slave library.

  2022-06-01 09:52:39 Views: 226
• 

  Get started with MongoDB in a short time

  What is MongoDBMongoDB is written by C++ language, is an open source database system based on distributed file storage. In the case of high load, adding more nodes can ensure server performance. MongoDB is designed to provide scalable high performance for web applications

  2022-06-01 09:52:39 Views: 290
• 

  Set up MySQL servers that are master and slave to each other

  IP address of node1: IP address of 192.168.1.254node2: 192.168.1.253 operating system is RHEL7.3,MySQL version 5.7.181, modify MySQL configuration file of node1 # Note ser

  2022-06-01 09:52:38 Views: 251
• 

  Mongodb frequently used command date, grouped

  Date grouping db.msds_acce***ecord.group ({keyf: function (doc) {var date = new Date (doc.addtime); var dateK

  2022-06-01 09:52:38 Views: 278
• 

  Stages of MongoDB pipeline aggregation

  The names of the stages of pipeline aggregation describe the documents in the $project transformation flow, such as by adding new fields or removing existing fields. For each input document, output one document. Match filters the document stream, allowing only matching documents to move on to the next pipeline phase without modification. $m

  2022-06-01 09:52:38 Views: 214
• 

  OGG-01163 Bad column table structure consistent, trail file meta inconsistent processing

  After changing the table structure of the source side, the destination side ogg alarms. 2019-04-15 12:48:47 ERROR OGG-01163 Bad column length (21) specified for column CH

  2022-06-01 09:52:38 Views: 242
• 

  Build WordPress personal site under Linux

  WordPress is based on the LAMP environment. What is used here is CentOS 7 wordpress, which has version requirements for php and mysql. Wordpress version 4.7.4 database mariadb-5.5.

  2022-06-01 09:52:28 Views: 266
• 

  The solution to oracle error ora-01658-expanding tablespace

  1. View all tablespace sizes SQL > select tablespace_name,sum (bytes) / 1024 move 1024 from dba_data_files group by tablespace

  2022-06-01 09:52:28 Views: 252
• 

  Introduction to two parameters of oracle sequence: nextval and currval

  Two parameters of oracle sequence: nextval and currval. I will use the following example to reflect the difference between the two parameters: note: before calling the value of currval, you must call the value of nextval, otherwise an error will be reported, as shown in the following figure:

  2022-06-01 09:52:27 Views: 281