NAV: SLTechnology News&Howtos > Database >

• 

  Practical Operation of MySQL Database Cluster

  1. Database cluster usage scenario 1. With the continuous increase of access volume, the pressure of a single MySQL database server continues to increase, which requires optimization and architecture transformation of MySQL. If MySQL optimization can not significantly improve the pressure, high availability, master-slave replication, read-write separation can be used.

  2022-06-01 22:05:14 Views: 254
• 

  The most complete installation process of Oracle database 12C in CentOS7 (full

  Before installation, you can download 12 from the second version of the installation package from the Oracle official website. Step 1: you need to add a 20g hard disk to install Oracle, and format the disk as XFS# to enter the server. First turn off the firewall systemctl stop firew.

  2022-06-01 22:05:06 Views: 211
• 

  Interpretation of mongodb Source Code for java connection

  Mongdb has been used for more than half a year, and it has always been the business logic to achieve ok. However, this will not make progress. Therefore, today I checked the source code of the java connection mongodb driver and integrated all kinds of information found to facilitate in-depth use in the future. Paste the connection database code Li first

  2022-06-01 22:05:00 Views: 205
• 

  Use of MySQL stress testing tool

  1. Mysqlslapmysqlslap, the stress testing tool of MySQL, is the benchmark tool of mysql. The tool queries data, which is simple in syntax, flexible and easy to use. This tool can simulate multiple clients to send query updates to the server concurrently.

  2022-06-01 22:05:00 Views: 233
• 

  SQL Server 2017 AlwaysOn on Linux configuration and maintenance (5)

  2.2.1 three synchronous replicas this configuration contains three synchronous replicas. By default, it provides high availability and data protection. It can also provide read scaling. An availability group with three synchronous copies can provide read scaling, high availability, and data protection. The following table describes the available sexual behavior.

  2022-06-01 22:04:57 Views: 245
• 

  Omni-directional comparison of PostgreSQL and MySQL

  360 °omni-directional comparison between PostgreSQL and MySQL I. original https://www.enterprisedb.com/blog/postgresql-vs-mysql-360-degree-compar

  2022-06-01 22:04:56 Views: 292
• 

  Brief introduction of Postgres Database

  PG usage tutorial: https://www.yiibai.com/postgresql

  2022-06-01 22:04:53 Views: 251
• 

  Mongodb3.2 configuration file yaml format

  After the mongodb3.x version, you need a configuration file in yaml syntax format. The following is the yaml configuration file format as follows: official yaml configuration file options reference: https://docs.mongodb.org/manual/referen

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

  Mongodb single installation

  1. Download mongdbcurl-O https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-3.2.1.tgz2, environment preparation: 1 mkdir / hom

  2022-06-01 22:04:53 Views: 262
• 

  The usage of oracle lpad

  Select length ('abc'), lpad (' abc',4,'$'), lpad ('abc',5,' ^'), lpad ('abc',5,'gf'), lpad (' abc',10,'gf') from

  2022-06-01 22:04:44 Views: 255
• 

  Microsoft Announces SQL Server 2019 Preview

  Today is the first day of Microsoft's Ignite 2018 conference in Orlando, and it announced SQL Server

  2022-06-01 22:04:44 Views: 204
• 

  Oracle virtual column subpartition virtual column partition

  Oracle 11g Virtual column Sub-Partition experiment the following two create statements are created successfully; requirements description: the project requires three fields to be partitioned, such as time, hour, and a region ID, then associate with the virtual column. Drop table test_par

  2022-06-01 22:04:44 Views: 268
• 

  Mysql scheduled backup

  1. Write a timing script for 1.1 linux system vi dbback.shroud home/backecho You You

  2022-06-01 22:04:35 Views: 240
• 

  MYSQL behavior

  MySQL behavior in MySQL, there are two variables that can control the behavior, they are the AUTOCOMMIT variable and the TRANSACTION ISOLACTION LEVEL variable. Autocommit in MySQL, if you do not change its autocommit

  2022-06-01 22:04:35 Views: 286
• 

  The exception in the example of kafka-storm-hbase

  This exception occurred when submitting the cluster on the storm task today: storm.kafka.UpdateOffsetExceptionjava.lang.RuntimeException: storm.kafka.Up

  2022-06-01 22:04:35 Views: 279
• 

  SQL Server 2017 AlwaysOn on Linux configuration and maintenance (2)

  two。 AlwaysOn availability groups created for high availability AlwaysOn availability groups on the Linux platform, SQL Server instances store configuration metadata in the master database. AlwaysOn availability group configuration on a Linux cluster

  2022-06-01 22:04:34 Views: 291
• 

  Oracle plsql utl_file

  Set SERVEROUT onDECLAREtab_sql varchar2 (4000); tab_lob clob;TYPE ddl_type IS REF CURSOR;ddl_cur ddl_t

  2022-06-01 22:04:11 Views: 299
• 

  The solution of importing Times 2013 Code into Mycat 1.6.5 fragments

  1. Basic information, mysql 5.7.22 nodes: datanode1, datanode2, datanode3mycat 1.6.5.2. Failure phenomenon: report 2013j2006 when importing tens of millions of level test data, or

  2022-06-01 22:04:11 Views: 233
• 

  XtraBackup usage

  I am a tool for backing up MySQL data. I was born in Percona's home. Download my home address: http://www.percona.com/ to enter: Software-- > Percona XtraBackup-

  2022-06-01 22:03:54 Views: 301
• 

  Windows installs the MongoDB PHP extension

  1. Download expansion pack download address: https://pecl.php.net/package/mongodb/1.5.3/windows author download: 7.1 Thread Safe (TS) x642. Unpack the downloaded package

  2022-06-01 22:03:54 Views: 293