NAV: SLTechnology News&Howtos > Database >

• 

  Shell scripts and scheduled tasks

  This article will introduce the perfect collaboration between Shell scripts and scheduled tasks with the goal of achieving regular automatic backups of MySQL databases. The Shell script is responsible for the specific backup operation, and the Crond server is responsible for controlling the backup cycle. [confirm backup scheme] backup host: I

  2022-06-01 07:25:01 Views: 241
• 

  PostgreSQL pg_rewind principle

  1. In the high-availability architecture that is common in the background, if the master fails and some data is not synchronized to the backup, the high-availability system will promote the slave as the main external service. When it is possible for the owner to join the cluster as a backup, it may fail to build a stream replication relationship. You can use the pg_rewind tool to make the active and standby

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

  Oracle sets boot self-startup under Linux

  1. Change oratab#cat / etc/oratabsdzy:/u01/oracle/product/11.2.0/dbhome_1:YN to Y2 and dbstart$ cd $ORACLE_HOME

  2022-06-01 07:24:57 Views: 364
• 

  Disk: the most easily overlooked performance depression

  Introduction: in terms of the performance of the whole software, resource performance is like the ice below the tip of the iceberg. This part is made up of traditional parts of the disk, CPU, memory and network, as well as batteries (power consumption) that are particularly important because of the mobile network. In this article, we will focus on the disk section. Ben

  2022-06-01 07:24:54 Views: 258
• 

  How to add 0 in front of Day less than 10 for SQL_Server

  Select RIGHT ('00 + Datename (DD,GETDATE ()), 2)

  2022-06-01 07:24:53 Views: 276
• 

  Disaster backup and recovery of MySQL Database

  Http://xiaorenwutest.blog.51cto.comMySQL database disaster recovery and backup database is a top priority for the company; record the company's huge data, related to the company's property, as well as customer information, if lost

  2022-06-01 07:24:42 Views: 268
• 

  Goldengate configuration ddl support

  Switch to the login database sqlplus / as sysdba:a.@marker_setup.sqlb.@ddl_setup.sql # under the goldengate software directory and enter the goldengate administrative user here

  2022-06-01 07:24:38 Views: 217
• 

  Database installation process and basic SQL statements under Linux

  Mysql installation starts 1. Centos installation mysql, network input commands (there are other installation methods, such as source code and rpm package) after successful installation: note: in root users under 2. Start mysqld (server) and you can see that mysql ser

  2022-06-01 07:24:38 Views: 242
• 

  Building High availability Rack of MySQL Replication Cluster based on MMM

  MMM introduces that MMM is an abbreviation for Multi-Master Replication Manager for MySQL, a multi-master replication manager provided by MySQL, whose core is a set of scripts written in the Perl language. Actually, MM

  2022-06-01 07:24:37 Views: 215
• 

  The problem of reference variables in PHP strings

  The string reference variable in php is mainly the different 1 of the database operation string, and the ordinary string reference variable a. The outer layer must quote double quotation marks b. Variables in a string can be written as: $s or {$s} 2. Database operation string (database operation instruction) a. The outer layer of the string must use double

  2022-06-01 07:24:30 Views: 225
• 

  The solution of oracle64 bit, pl/ SQL 32 bit

  When you install PL/SQL on 64-bit win7, you often encounter "Could not load". \ bin\ oci.dll "" this error, I checked the information, because PL/SQL only supports 32-bit OS, the solution is to load an extra o

  2022-06-01 07:24:21 Views: 217
• 

  About the problem that MySQL5.6 and later versions cannot be started after installation

  Mysql 5.6 and later are released for security reasons, and the root password is not empty. So during the installation of MySQL, a random password is generated, execute # / etc/init.d/mysql stop and then # mysqld_safe

  2022-06-01 07:24:12 Views: 267
• 

  SQL Server 2012 is fully installed

  1. Open the installation file to install cdn.com/mpr/mpr/AAMAAwDGAAgAAQAAAAAAAA9hAAAAJDZlMjQ4YmIxLTAxNDItNDQ1Zi04ZjhiLTI3Mzk4MmY4

  2022-06-01 07:24:03 Views: 249
• 

  Basic calculation method of internal offset of data block

  The BASE is calculated as follows: for ASSM:76+ (itc-1) * 24 = 52 + itc * 24 for MSSM:68+ (itc-1) * 24 = 44 + itc * 24 Click (here) to collapse or open gyj@

  2022-06-01 07:24:03 Views: 293
• 

  Oracle data file moving method

  Summary of the method of moving data files in oracle database

  2022-06-01 07:23:59 Views: 260
• 

  Mysql multi-instance installation

  Multi-instance installation, while opening multiple different server ports 3306 3307 large company installation database is generally compiled and installed, and will be made into a rpm package after optimization, in order to uniformly use and install mysql, if the previous single instance mysql has been enabled to execute pkill my

  2022-06-01 07:23:59 Views: 210
• 

  An example of non-interrupted Business Database Migration

  The following is the migration process of a business library from Source Master/Slave cluster to Target MHA cluster. In preparation, configuration data is copied from Source Master to Target Master, that is, Targe

  2022-06-01 07:23:59 Views: 298
• 

  Essential for SQLserver operation and maintenance: T-SQL statement exercise

  Xiaosheng blog: http://xsboke.blog.51cto.com------- thank you for your reference, if in doubt, welcome to exchange case 1: table as shown below Experimental requirements: 1. Query the products table for the factory date later than April 2014.

  2022-06-01 07:23:37 Views: 293
• 

  MYSQL MONGODB REDIS synchronization principle and High availability comparison

  MySQL1, asynchronous replication: 2. Semi-synchronous replication: when synchronization times out, it automatically changes back to asynchronous replication; the replica set of MongoDBMongoDB is a set of mongod processes that provide redundancy and high availability. The smallest replica set contains (1 primary,

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

  The execution result of saltstack is returned to mysql

  System: ubuntu 17.04 official documentation https://docs.saltstack.com/en/latest/ref/returners/all/salt.returners.mysql.htmlm

  2022-06-01 07:23:31 Views: 295