NAV: SLTechnology News&Howtos > Database >

• 

  Using mybatis-generator combined with Ant script in Mybatis to generate Model, Mapper and other files quickly and automatically

  Students who have used Mybatis know that for the database tables used in each project, it is necessary to establish their corresponding database additions, deletions, modifications, xxxMapper.xml files, entity class xxx.java files, and other classes to call xxxMa for database operations.

  2022-06-01 08:22:48 Views: 252
• 

  Redo failed to archive fault handling

  Errors in file c:\ app\ administrator\ diag\ rdbms\ orcl\ orcl\ trace\ orcl_arc0_13756.trc:ORA-00354: corrup

  2022-06-01 08:22:48 Views: 280
• 

  How to calculate the days of XX week in XX year in SQL Server

  SQL Server has a very powerful function: DATEPART () it can calculate the day of 2017-10-17 which belongs to this year: the week of select datepart (dy,'2017-10-17): select da

  2022-06-01 08:22:40 Views: 213
• 

  Redis stand-alone installation

  Redis stand-alone installation 0. Install the dependency package yum-y install lrzsz gcc unzip autoconf docbook-style-xsl1. Download redis source code redis.io2. Upload to service

  2022-06-01 08:22:40 Views: 254
• 

  The solution of forgetting Oracle login password under Windows platform

  Usually we forget a lot of passwords, for example, today I forgot the login password of Oracle. Let's share the solution. Press Win+R at the same time, enter: cmd and then enter: sqlplus / nolog input: connect / as sysdba

  2022-06-01 08:22:18 Views: 301
• 

  Three difficult problems in microservice business development-split, transaction, query (part two)

  In the last episode, we explained that the key obstacles to the use of micro-service architecture are domain model, transaction and query, which seem to be in natural opposition to functional split. As long as the functions are split, these three problems are involved. And then we showed you that one solution is to implement the business logic of each service as

  2022-06-01 08:22:18 Views: 279
• 

  Mysql5.5.42 specifies the database synchronization operation

  Environment description: the requirement is to create a master-slave replication environment. Master is required to synchronize only the drsj library in the master library to slave-side master-side IP:192.168.1.100 slave-side IP:192.168.1.200 master-slave replication conditions: 1

  2022-06-01 08:22:05 Views: 263
• 

  MySQL5.7 installation

  1. Download the installation package wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz2, solution

  2022-06-01 08:22:05 Views: 202
• 

  Xiaobai can also easily access the artifact NAS partner on the intranet.

  When it comes to the Internet, does everyone feel like the air now, basically no one can leave? With the increase of Internet users day by day, more and more operators begin to give individual customers some virtual Internet IP, that is, there is no public network IP. Then it cannot be accessed directly in intranet mode, and

  2022-06-01 08:22:05 Views: 285
• 

  The problem that the initial root password cannot be found after the initial installation of Mysql5.7 above version

  One of the main new features of mysql5.7 is the great enhancement of security. After installing Mysql, a random password is created by default for root@localhost users. This random password needs to be found in different ways on different systems, otherwise you cannot log in to mys.

  2022-06-01 08:22:04 Views: 264
• 

  Introduction to GTID mode!

  MySQL GTID Replication: a powerful GTID (Global Transaction ID, global transaction ID) feature has been added from MySQL5.6, which is used to strengthen the consistency between the master and backup of the database and fault recovery

  2022-06-01 08:22:00 Views: 294
• 

  Backup check is correct, MySQL automatic backup restore check design details

  The author introduces Pang Kuo, the manager of the basic department of operation and maintenance of Youpengpule Media. Responsible for database operation management and platform design and development, monitoring design improvement, problem tracking, computer room network maintenance and management. At present, four patents have been applied for by the Patent Office. Good at database operation and maintenance management and Shell, Perl, PHP

  2022-06-01 08:22:00 Views: 298
• 

  SQL detach database

  Detach data after starting SSMS and connecting to the database server, expand the server node in object Explorer. Find the database name that needs to be separated under the database object. Here, take the student_Mis database as an example. Right-click the student_Mis database, and in the

  2022-06-01 08:21:42 Views: 205
• 

  SQL Server queries backup date and backup device name

  Query the backup date and backup device name to check whether the backup was performed on a given day. SELECT b.backup_finish_date,a.physical_device_nameFROM dbo.backupmediafam

  2022-06-01 08:21:40 Views: 262
• 

  A complete solution for Apache ShardingSphere data desensitization

  Apache ShardingSphere data desensitization complete solution detailed introduction to Pan Juan, JD.com senior DBA of mathematics, mainly responsible for JD.com database middleware development, database operation and maintenance automation platform development, production database operation and maintenance work. Participated in JD.com 6.18,

  2022-06-01 08:21:16 Views: 295
• 

  HaProxy+Keepalived+Mycat highly available cluster configuration

  Overview this section focuses on configuring HaProxy+Keepalived high-availability clusters, so the configuration of Mycat will not be introduced here. You can refer to the previous articles I wrote about Mycat. Deployment diagram: configure HaProxy installation 181,179 services

  2022-06-01 08:21:14 Views: 250
• 

  Use of percona-xtrabackup (2)

  The previous article briefly introduced the installation of percona-xtrabackup, percona-xtrabackup installation (1), this article mainly introduces the work of innobackupex and the implementation principle and specific use and so on. Xtrabackup package

  2022-06-01 08:21:13 Views: 288
• 

  Mysql 5.7 Master and Slave

  Install ignore, refer to my previous blog. Clone the master database from the slave library. After cloning the master database, you need to modify the UUID in server-id and / data/mysql/auto.cnf, modify the pid file name and modify my.cnfmaster:

  2022-06-01 08:21:10 Views: 270
• 

  MySQL database design specification

  Directory specification background and purpose 2.1database design 2.1.1 database name 2.1.2 table structure 2.1.3 column data type optimization 2.1.4 index design 2.1.5 sub-database sub-table, partition table 2.1.6 character set 2.1.7 program DAO layer design

  2022-06-01 08:21:10 Views: 260
• 

  Oracle series: (24) sequence

  What is a sequence [Sequence] (1) is similar to the auto_increment automatic growth mechanism in MySQL, but there is no auto_increment mechanism in Oracle (2) is a mechanism provided by oracle to generate unique numerical values.

  2022-06-01 08:20:52 Views: 298