Keyword conflict between MySQL data cannot be written Problem description: a new table is created using MySQL today. A syntax error is reported during data insertion. Because the mabits Automatic code generation tool is used, and the SQL statements
MySQL dual-master Configuration MySQL dual-master Configuration Prepare the environment: the server operating system is RHEL6.4 x86_64, to minimize installation. Both host A and host B disable the firewall and SELINUX. The IP addresses are 192.168.13
Two MySQL services run on one server Two MySQL services run on one server 1. Add a group, add a user to the group, and decompress the package. Groupadd mysql Useradd mysql-g mysql-M-s/sbin/nologin Tar-zxvf
Compare the date difference between MySQL and Oracle by using a create statement Today, a developer submitted an SQL change and found a problem during deployment.A statement is a simple create statement.Create table 'test _ user '('Openid' varchar (6
MySQL revokes an authorization Create test tableCreate table t1 (id int );Create table t2 (id int );Create table t3 (id int );Create table t4 (msg varchar (100 )); If the wildcard is used for authorization.Grant select, insert, update, delete on
Postgres-X2 deployment steps Sort 2015 elephant will, everyone is very concerned about PostgreSQL cluster, at present, developers have turned to Postgres-X2, recently according to their own and colleagues deploy xl process to deploy a Postgres-X2.
PostgreSQL uses C to complete Stored Procedure instances I recently wrote an example of a stored procedure written by PostgreSQL in C, which is recorded here. Objective: To use C to complete a stored procedure example. A stored procedure can update
Oracle multi-Table query optimization Oracle has a high-speed buffer concept. This high-speed buffer is used to store the executed SQL statements. Therefore, oracle has to do a lot of work when executing SQL statements, such as parsing SQL
DataGuard bug in adding temporary data files One environment is Oracle 10gR2, with one master node and two slave nodes. Because the 10 Gb slave database is not active, we will open the corresponding window time when there are some query requirements.
Impact of MongoDB planned Cache After creating an index for Primary in the MongoDB 2.6 replica set, it is found that the Secondary query does not follow the latest index. It is normal after the plan cache of the set is cleared temporarily. I have
Analysis of Oracle 12c PDB In any case, Oracle 12c has been out for so long and has never started learning for various reasons. It seems a little late now. I have always heard that PDB is a brand new architecture model in 12c. In various technical
Oracle 12c R2 new feature dbca command can create standby Database Since version 12c R2, the dbca command provides the syntax for creating the standby slave database: Syntax: Dbca-silent-plain-gdbName BOS.domain.com-sid BOS1-sysPassword
Error Caused by Oracle 11g import to 10g Environment Introduction Old Environment New Environment Operating System: RedHat5.8 64-bit Redhat6.4 64-bit Database Version: Oracle 10.2.0.4 64-
Hbase VS Oracle 1. Hbase is suitable for a large number of inserts and reads at the same time. Enter a Key to get a value or enter some key to get some value. 2. the bottleneck of Hbase is the hard disk transmission speed. Hbase operations, which
MySQL multi-master and One-slave Synchronization Test preparation: host A and host B are the primary IP addresses 192.168.131.129 and 192.168.131.130, and host C is the slave server. Configure MySQL multi-instance on the slave server with the IP
Use the AWK tool in Cygwin to view mysql binlog logs Linux tools are really powerful. However, as a person who does not have the right to use Linux machines or who does not use Linux for development, it is really inconvenient to use some commands, a
Install Oracle 11gR2 in CentOS 6.6 Install Oracle 11gR2 in CentOS 6.6 I. Hardware requirements 1) The minimum memory size is 1 GB, preferably 2 GB or more. The memory here is 10 GB. 2) The official suggestions for swap partition size are as follows.
Oracle online redefinition Before online redefinition of [@ more @] Oracle9i, table data is organized by alter table XXX move [tablespace XX. If the table is very large and IO is not fast, the process of moving may be quite long and cannot be
PostgreSQL export data dictionary documentation You need to sort out the data dictionary documents of the current database on the project. The project is not standardized. Such documents should be supplemented later. Each field in these tables is
Use undo in Oracle to restore Data [Note] when I accidentally saw a colleague's QQ message saying "really tired", I got a call from this colleague in less than 30 minutes, as shown below: When I was just doing data deletion, I found that the