NAV: SLTechnology News&Howtos > Database >

• 

  [MySQL] [backup] details of installation and use of mydumper

  Introduction to mydumper: jointly maintained and developed by Max Bubenick of percona and Domas Mituzas of facebook, it is also a 10-year-old tool, compared with the mysqldump tool, which is also a logical backup.

  2022-06-01 11:38:01 Views: 257
• 

  Migrate PDB between different CDB

  Test environment source environment target environment host operating system Oracle Linux 7.2hostname zhankysOracle version 11.2.0.1 x64IP:172.16.171.214CDB=orcl cloned PDB=or

  2022-06-01 11:38:01 Views: 299
• 

  Settings after mysql/mariadb database installation is complete

  Specify the innodb_file_per_table=1 parameter, which mainly prevents the ibdata file from being too large, in which all databases are stored. The above problem does not occur after you specify this parameter. Specify default character set: add parameters in the [mysqld] section

  2022-06-01 11:38:00 Views: 271
• 

  Mysql to view the current database and table | remote access can be configured | View status

  Select database () view the current database: show tables view the table configuration of the current database remote mysql server can be accessed at / etc/mysql/mysql.conf.d/mys

  2022-06-01 11:37:55 Views: 240
• 

  Sybase change password

  Initial empty password sa1 > sp_password null,hu_1234562 > go change password 1 > sp_password "hu_123456", "2nihao_3X64", sa2 > go

  2022-06-01 11:37:55 Views: 241
• 

  Reading the return value of oracle function with python

  Create a function in oracle that was intended to return an index table, but failed. Thinking that text can also transmit information, I was suddenly inspired to format the return value. Considering that the amount of data returned may be large, the length of the varchar2 type is tight

  2022-06-01 11:37:55 Views: 206
• 

  General Operation and Management of postgresql Database

  Database connection: method 1: psql-U test_huishishuju-d test_huishishuju parameter description:-U database user name-d database name mode 2: su-postgres-bash

  2022-06-01 11:37:55 Views: 232
• 

  11g rac grid users to manage listeners

  By default, Oracle 11g RAC database listeners are managed by grid users through clustering tools, but sometimes we find that database listeners are started by oracle users, so there are some problems here. For example, the emergence of redundant monitoring processes, we can

  2022-06-01 11:37:55 Views: 263
• 

  Considerations for centos6.6 installation of weblogic12c

  Environment, because my centos6.6 does not have a graphical interface installed, I reported an error [weblogic@localhost ~] $java-jar wls_121200.jarExtracting files.. during installation.

  2022-06-01 11:37:54 Views: 272
• 

  MongoDB modifies the data in the collection

  1. View the collection show collections2. View the data in the collection db.runoob.find () 3. Modify the data db.runoob.update ({'title':'test'}, {$set: {' ti) in the collection

  2022-06-01 11:37:43 Views: 276
• 

  PHPstudy modifies default upload size database upload size limit modification

  Today, when I was importing database data to customers, I found that the default upload size of phpstudy is 2m, which is too small. Charm Network came into contact with this software a long time ago, and today I still think it is easy to use. it is a common modification to modify the parameters of this upload size limit. Today, I will tell you again.

  2022-06-01 11:37:40 Views: 292
• 

  Single-host deployment of LAMP

  Single-host LAMP deployment requirements: one virtual host provides phpMyAdmin on one host, another virtual host provides wordpress, and provides https services for phpMyAdmim: I. install the required rpm package yuminstall-

  2022-06-01 11:37:27 Views: 214
• 

  Oracle OCA J2SE7 Cetificate-Rules for Primitive Types

  Any bigger than an int can NEVER be assigned to an int or anything smaller than int (byte, char, or

  2022-06-01 11:37:27 Views: 226
• 

  Deploy an atlas-mysql basic architecture from scratch

  The purpose of the experiment is to build the basic environment of atlas-mysql and realize the separation of reading and writing. And create a user table, split horizontally with the 'id' field as a condition, and split into three child tables. The experimental steps are as follows: 1. Deploy two mysql-master nodes for two-way synchronization. Parallel

  2022-06-01 11:36:57 Views: 254
• 

  Myql 5.7.21 GTID group replication

  HostnameIP role node131.1.1.13master1node141.1.14master2node151.1.15master3 [MySQL] prompt=\\ u@\\ h:\\ d

  2022-06-01 11:36:57 Views: 221
• 

  Record once under Windows2012 R2, Sqlserver2

  Sqlserver remote backup practice project background: customers offline IDC has a set of business system running in the physical environment, winodws 2012 is running Tomcat8+Sqlserver2014 's internal process system, due to various reasons

  2022-06-01 11:36:27 Views: 282
• 

  Percona Xtrabackup 8.0 backup MySQL8

  With the introduction of Percona XtraBackup 8.0, Percona XtraBackup 2.4 will continue to support MySQL and Percona Server 5.6 and 5.7 databases. Because MySQL 8.0 is counting

  2022-06-01 11:36:26 Views: 224
• 

  How to speed up xtrabackup recovery by 20 times?

     Xtrabackup is a free database hot backup software open source by percona. It can back up InnoDB database and XtraDB storage engine database without blocking. It has the following advantages: fast backup speed and reliable    physical backup.

  2022-06-01 11:36:08 Views: 260
• 

  Mysql show index interpretation

  View the index status on the table: SHOW INDEX returns table index information.SHOW KEYS and SHOW INDEXES are synonyms for SHO

  2022-06-01 11:36:07 Views: 261
• 

  Chapter II Authentication-- learn springmvc shiro mybatis from me

  Authentication, that is, who can prove that he is himself in the application. Generally provide some identification information such as their identity ID to show that he is himself, such as provide × ×, user name / password to prove. In shiro, users need to provide principals (identity) and cred

  2022-06-01 11:36:03 Views: 244