NAV: SLTechnology News&Howtos > Database >

• 

  Use lamp architecture to build Discuz forums and achieve high availability to the database

  Lamp architecture = LAMP refers to the first letters of Linux (operating system), Apache (HTTP server), MySQL (database software), and PHP (sometimes Perl or Python), generally used to build web servers. #

  2022-06-01 18:31:04 Views: 247
• 

  Oracle job timing execution parameters

  Oracle job common execution time 1, trunc (sysdate,'mi') + 1 / (24060) 2 per minute, regular execution every day, such as: trunc (sysdate+1) at 0: 00 am every day, trun at 1: 00 am every day

  2022-06-01 18:31:04 Views: 258
• 

  MYSQL database basic operation command

  MySQL database system is a typical application of MySQL S (client / server) architecture. Special client software is needed to access the database. In Linux system, the simplest and most easy-to-use MySQL client software is its own mysql command tool.

  2022-06-01 18:30:48 Views: 269
• 

  Common operations of Oracle

  Some operations commonly used in Oracle, record: 1. Steps to establish tablespaces and users: user establishment: create user username identified by "password"; authorization: grant create session to

  2022-06-01 18:30:48 Views: 240
• 

  Linux-Mycat- installation configuration

  MyCat introduces that the "large database cluster" for enterprise application development supports transactions, ACID, and the enhanced database that can replace Mysql can be regarded as an enterprise database of "Mysql" cluster, which can be used to replace the expensive Oracle cluster fusion memory cache technology and Nosql.

  2022-06-01 18:30:47 Views: 256
• 

  Database operation and maintenance platform

  Database operation and maintenance platform Inception_web version installation preface Inception is an automated database operation and maintenance system environment that integrates audit SQL, execution SQL and rollback: system: centos 6.8Ip: 192.168.137.

  2022-06-01 18:30:47 Views: 219
• 

  What is the transaction of MySQL

  This article mainly tells you briefly what is the transaction processing of MySQL. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article on what is the transaction processing of MySQL can bring you some practice.

  2022-06-01 18:30:44 Views: 213
• 

  The usage of union in Oracle

  The purpose of the UNION instruction is to merge the results of the two SQL statements so that you can view the query results you want. For example: SELECT Date FROM Store_InformationUNIONSELECT Date FRO

  2022-06-01 18:30:43 Views: 206
• 

  Redis supports five data types

  Redis currently supports five data types, which are String (string) List (list) Hash (dictionary) Set (set) Sorted Set (ordered set) Redis data type 1. String type SET key value setting

  2022-06-01 18:30:43 Views: 234
• 

  What must be paid attention to when using MySQL

  The following mainly brings you what you must pay attention to when using MySQL. I hope these contents can bring you practical use, which is also the main purpose of this article. All right, don't talk too much nonsense, let's just read the following. 1. Root

  2022-06-01 18:30:43 Views: 225
• 

  Memory caching software memcached

  Chapter 1: memcached memory cache software (memory is faster than disk) is divided into server and client server memcached client memcache birth reasons. In 2003, enterprises before memcachedweb1.0 2005 were born.

  2022-06-01 18:30:40 Views: 236
• 

  Characteristics and functions of invisible index in MySQL8.0

  I don't know if you have any understanding of the similar articles on the characteristics and functions of invisible index in MySQL8.0. Today, I'm here to give you a brief introduction. If you are interested, let's take a look at the text. I believe that after reading the invisib in MySQL8.0

  2022-06-01 18:30:39 Views: 250
• 

  How to install MySQL5.7 under Windows system

  Below to bring you about the Windows system how to install MySQL5.7 content, I believe you must have read a similar article. What's the difference between what we bring to everyone? Let's take a look at the text. I believe that after reading MySQL5.7 under the Windows system, how to do it?

  2022-06-01 18:30:39 Views: 223
• 

  Use MySQL Installer to install MySQL services and components under Windows

  Let me tell you a little bit about installing MySQL services and components in MySQL Installer under Windows. Have you ever heard of similar topics before? If you are interested, let's take a look at using MySQL Inst under Windows.

  2022-06-01 18:30:08 Views: 278
• 

  How to set the location of slave to read binlog in MySQL

  This article is mainly about how to set slave to read the location of binlog in MySQL. If you are interested, let's take a look at this article. I believe that after reading how to set the location of slave to read binlog in MySQL.

  2022-06-01 18:30:08 Views: 236
• 

  How to synchronize mysql databases with different CVM

  The following is about how to synchronize mysql databases on different cloud servers. If you are interested, let's take a look at this article. I believe it will be of some help to you after reading how to synchronize mysql databases on different cloud servers. Goal: a self-built database on CVM is synchronized to

  2022-06-01 18:30:08 Views: 245
• 

  Centos6.6_X64 install oracle10G

  The centos6.6 system used in this experiment is oracle 10g. Centos version: CentOS-6.6_X64-bin-DVD1.isoOracleDatabase version: 10201_databas

  2022-06-01 18:29:39 Views: 291
• 

  An example of damage treatment of non-archived current redolog in Oracle 10.2.0.5

  Operating system: RHEL5.8 x64 database: Oracle 10.2.0.5.0 failure case: a stand-alone dawning PC server 4 300G SAS disks, RAID5 bad two disks (server panel no fault prompt, no one found), resulting in RA

  2022-06-01 18:29:38 Views: 208
• 

  Automatic initialization of SQL Server 2017 AlwaysOn AG (4)

  Check the progress of database synchronization if the database is in the availability group configured for automatic seed settings, you can query the sys.dm_hadr_automatic_seeding system view to monitor the progress of seed settings. For availability groups that are configured for automatic seed

  2022-06-01 18:29:38 Views: 258
• 

  Setting method of case sensitivity in MySQL

  This article mainly gives you a brief introduction to the case-sensitive setting method in MySQL. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on case-sensitive setting in MySQL can bring you

  2022-06-01 18:29:37 Views: 242