PHP

MySQL master-slave replication requires at least two Mysql services. Of course, MySQL services can be distributed on different servers or multiple services can be started on one server. MySQL master-slave replication requires at least two Mysql

As the basic unit of logical processing, database operations are composed of one or more SQL statements. Of course, there are also non-database operations, such as restoration set in the computer As the basic unit of logical processing, database

OracleDG-build PhysicalStandby system environment: Operating System: RedHatEL4Oracle: Oracle10.2.0.1.0 .. OracleDG-build PhysicalStandby system environment: Operating System: RedHatEL4Oracle: Oracle10.2.0.1.0 .. Oracle DG -- building Physical

I recently tried PostgreSQL9.04 to share my experience on pg_hba.conf configuration. Pg_cmd.conf is the configuration file for client authentication, which defines how to authenticate the client. I recently tried PostgreSQL 9.04 and shared my

One time the developer directly runs the deletetable operating system on the database server, and runs at the peak of work, resulting in no response for a long period of execution, and then closes the SQLPLUS Client One time a developer directly

In dba's work, backup is the basis of all work In dba's work, backup is the basis of all work In dba's work, backup is the foundation of all work. If there is no backup, it would be difficult to recover the data easily. If the business data

After upgrading from Oracle10g to Oracle11g, you need to understand the new features of Oracle11g. These features may affect the application and performance and need to be adjusted. After upgrading from Oracle 10g to Oracle 11g, you need to

There is a new feature in Oracle11g. When the table has no data, no segment is allocated to save space. Oracle 11g has a new feature. When the table has no data, no segment is allocated to save space. Oracle 11g has a new feature. When the

Practice: migrate Oracle10.2.0.4 to Oracle11.2.0.4 Practice: migrate data from Oracle 10.2.0.4 to Oracle 11.2.0.4 Environment:Source database: 192.168.8.132 Oracle10.2.0.4Target Database: 192.168.8.20.oracle11.2.0.4OS: linux 5.4-64-bitMigrate

This article analyzes the mysqld process and how to safely and easily shut down MySQL instances. If you are not clear about this process, refer to it. Shutdown: 1. initiate shutdown and send a SIGTERM signal. 2. If necessary, create a shutdownthread.

Prerequisites for creating standbydatabase Based on the backup rmanduplicate command: Ensure the backup of the original database, archive is completely visible to the standby end, here false Prerequisites for using the backup rman duplicate command

Some query statements in Oracle and their execution sequence query conditions: 1) LIKE: fuzzy query, two Wildcards are required, %: represents 0 to multiple characters; _: identifies a single character. Some query statements in Oracle and their

A variety of problems occurred when I upgraded the MySQL version from 5.1 to 5.7 On CentOS today. However, after a step-by-step investigation, the problem is solved. The following is a record of the process. A variety of problems occurred when I

1. Why is it recommended that ioppiotop have certain requirements on the kernel and python version, and sometimes it cannot be used? In this case, iopp can be used as an alternative solution. In some cases, you may not be able to use iotop smoothly.

Today to help colleagues deal with a tricky thing, the problem is this: no matter which version of mysql client the client uses to connect to the server, found that as long as the server side after the character-set-serverutf8, character_set_client,

When we deploy the MySQLReplication slave database, we usually do a slave database from the beginning, and then gradually replicate the data to the slave server as the business changes. However, if we want to deploy and copy slave databases for a

Currently, the Community version of infobright is used. DML is not supported and data can only be imported using LOADDATA. If the metadata contains special control characters, errors are often reported during the import process, which is annoying.

Yesterday, an exception occurred when GTID mode replication was enabled in MySQL. No operations on the MASTER node can be applied on the SLAVE. The RELAYLOG of the SLAVE contains records, however, the BINLOG of SLAVE cannot be found. Since GTID is

Previously, I tested MySQL5.6.17Percona5.6.16MariaDB10.0.11OneSQL5.6.16 against the benchmark TPCC. From the test results, we can see the relative advantages of MariaDB in high concurrency (1920 concurrent threads) mode, we can also see that MariaDB

Test environment: net. ipv4.tcp _ cores for explanations of these kernel parameters, refer to: 2.12.ReduceTCPperformancespikes test solution: Test Results: Conclusion and Suggestion: from the test results alone, HttpMemcMC is worth Test environment: