NAV: SLTechnology News&Howtos > Database >

• 

  MongoDB backup recovery notes

  1. Full logical backup / recovery Mongodump/Mongorestore for scenarios with a small amount of data, using the official mongodump/mongorestore tool for full backup and recovery is sufficient. Mongodump can

  2022-06-01 07:58:24 Views: 274
• 

  CentOS6.x/CentOS7.x one click to install mysql5.

  First, the system environment and description system: CentOS6.x_x64 mysql: community version 5.6.21, open source database used the most mysql, compilation and installation is relatively cumbersome, yum installation version is relatively low and the default installation location is / var/, this time under the official

  2022-06-01 07:58:24 Views: 247
• 

  Error occurred while hbase shell was performing table creation

  Hbase (main): 003 test','cf'ERROR 0 > create 'test','cf'ERROR: org.apache.hadoop.hbase.ipc.ServerNotRunningYetException

  2022-06-01 07:58:24 Views: 298
• 

  Mysql master-slave synchronization

  What is Mysql master-slave synchronization? Synchronize the data on the master database from the slave database (let other database servers automatically synchronize the data on the data server currently being accessed) the structure type of master-slave synchronization 1 master-> 1 slave (commonly used) one master server (responsible for business updates)

  2022-06-01 07:58:23 Views: 244
• 

  The solution of root password forgetting in MySQL version 5.7and 8.0 Database

  Note: MySQL5.7 cracked the root password, skipped password authentication to log in to the database, and directly changed the password in the table. However, MySQL 8.0 cannot change the root password in this way. It is necessary to skip password authentication and log in to the database, then set the root password to empty first.

  2022-06-01 07:58:16 Views: 264
• 

  Deployment of MySQL database on CentOS6.5 platform

  CentOS6.5 platform deployment MySQL database deployment MySQL-5.5.22 requires plug-in ncurses-*,cmake-2.8.6 experimental steps: first, compile and install Mysql database system 1. Check to see if the system has been secured through RPM

  2022-06-01 07:58:16 Views: 263
• 

  Small-scale installation of Oracle GoldenGate--OGG (1)

  Download GolenGate installation package to log in to the official address of http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

  2022-06-01 07:58:14 Views: 249
• 

  End of mysql database base command

  27 use mysqladmin to close the database mysqladmin-uroot-poldboy123 shutdownps-ef | grep mysql28 mysql forgot the password and re-changed the password process: my

  2022-06-01 07:58:14 Views: 239
• 

  Crsctl common commands

  [oracle@rac01 ~] $crsctlUsage: crsctl check crs-checks the viability of the CRS stack

  2022-06-01 07:58:13 Views: 258
• 

  Mongodb user Management

  Use db_order created user: db.createUser ({user: "u_db_order", pwd: "password", roles: [{role: "dbOwner", db: "

  2022-06-01 07:58:13 Views: 245
• 

  Mysql5.7.26 temporary table exception record

  No1: once the temporary table in the stored procedure is created successfully, if the field name is subsequently changed without restarting the mysql server, inserting data into the temporary table will prompt that there is no error prompt for the modified field name: Unknown col

  2022-06-01 07:58:13 Views: 292
• 

  Software package managed rpm

  Before there is no software package manager, users install the software through the source code. However, it is easy to find that the operating system environment and compiled parameters must be compiled every time the software is installed, and the operation process is very complicated, which is for those who are not familiar with the operating system.

  2022-06-01 07:58:10 Views: 264
• 

  Command to change the table structure: add, delete, modify fields, adjust field order

  ALTER TABLE `user_movement_ log` CHANGE `GatewayId` `GatewayId` int not null default 0 AFTER RegionID

  2022-06-01 07:58:10 Views: 248
• 

  Sequence, view, index (GO for interview)

  Oracle built-in object sequence, view, index sequence create sequence aaa start with 1; after using the view to create and then directly use the OK, with the view can replace the subquery, so that the sql concise view is not really stored

  2022-06-01 07:58:06 Views: 280
• 

  MySQL master-slave replication status monitoring and Wechat alarm

  MySQL master-slave replication status monitoring and Wechat alarm shell script implementation when the MySQL master-slave status is abnormal, trigger Wechat alarm 1. Set the master / slave monitoring script vi / opt/scripts/mysql/check_repl_status.sh

  2022-06-01 07:58:05 Views: 287
• 

  Redshift modifies varchar (60) to varchar (90) by rebuilding the table

  The first thing to know is that redshift does not support SQL syntax to directly modify varchar (60) to varchar (90), but both PostgreSQL and MySQL do. How 1.PostgreSQL modifies varchar (60

  2022-06-01 07:58:05 Views: 264
• 

  Abnormal shutdown of mongodb failed to start

  Just contacted mongodb, encountered a small problem, the information found on the Internet seems to be not very complete, summary and record, I hope it will be helpful to everyone. 1. Problem description: when reconfiguring the master and slave of mongodb, the database [kill mongod process] was shut down abnormally, resulting in

  2022-06-01 07:58:05 Views: 219
• 

  Backup and recovery of Redis database

  Redis all data is kept in memory. Here are three backup methods: 1. Periodically save to disk asynchronously, which is called semi-persistent mode. 1) semi-persistent RDB mode is also the default method for Redis backup, which is done through snapshots, when redi is satisfied.

  2022-06-01 07:58:02 Views: 231
• 

  Centos7-mysql- partition

  Partitioning is similar to subtables, the purpose is to divide a table into impassable storage, which can reduce the IO footprint of a single disk and improve database efficiency. There are two main forms of partitioning: horizontal partitioning to partition the rows of the table, and vertical partitioning to reduce the width of the table. If you want to use partitioning, you need to check whether show is currently supported.

  2022-06-01 07:58:02 Views: 305
• 

  MySQL reset password

  System version: Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 2Server ver

  2022-06-01 07:58:01 Views: 253