Database Administrator

MySQL settings for master-slave synchronization are also noted online. I have nothing to say. Record the requirements of our company. MySQL cross-database and cross-Table synchronization:Replicate-wild-do-table = test %. % (both % are very

After one day of trial, MySQL backup tools in Linux cannot be used for backup. Now we will record the backup steps in detail. Using SQLyogEnt to back up data may cause problems due to a large amount of data, which has caused me many times and is

Default Value: transaction level is repeatable read for mysql. In this case, the data READ every time in a mysql session remains unchanged, regardless of the updates made to other transactions. in this way, the performance is relatively high, but it

1. Enable services in Linux[Xxx @ localhost ~] $ SuPassword:[Xxx @ localhost xxxxx] #/etc/init. d/mysqld startStart MySQL: [OK] 2. log on[Xxx @ localhost xxxxx # mysqlWelcome to the MySQL monitor. Commands end with; or \ g.Your MySQL connection id

If you want to write Perl scripts that can access the MySQL database, you need to install the DBI module. You need to install two groups of DBI modules, one of which is the DBI module that provides various basic DBI drivers, another group is the DBD:

You can directly modify the sqlnet. ora file under $ OREACLE_HOME/network/admin and add the following content: Tcp. validnode_checking = yes # Ip addresses allowed for access Tcp. invited_nodes = (ip1, ip2 ,......) # Ip addresses not allowed for

Oracle Version: Oracle10.2.0.1 Author: Cocis When creating a user in a database, it is best to create an independent tablespace for different users based on application performance and management considerations. 1. Create a tablespace In both the

Installing the MySQL database in Ubuntu 8.10 is very simple. The following is the MySQL installed in Ubuntu 8.10. the MySQL server should be started automatically. You can run the following command at the terminal prompt to check whether the MySQL

In Oracle databases, the database administrator not only takes a certain amount of effort in selecting indexes. In addition, you should pay attention to the storage of indexes. Because indexes are the same as tables, you not only need to save the

A friend asked about XMLDOM's inability to correctly set the character set, that is, xmldom. setCharset is invalid. For more information about Metalink, see Note: 251011.1. This is a Bug in Oracle. You can use dbms_output to bypass this issue. Test

MySQL synchronization in the slave database has been stopped, Use show slave status \ G to view Slave_IO_Running: No. The server Load balancer instance fails to be started, and no error code is displayed. The following error is reported in the

In fact, for a small DBA, sometimes these problems cannot be avoided. Therefore, we need a tool to check whether the master-slave replication is normal and whether an error has occurred. Pt-table-checksum. MySQL 5.6 master-slave replication Part 1

New project accepted, master-slave database replication synchronization Error, Error Code 1292 (invalid datatype) Error SQL: update wave set IS_WAVED = 0, LEVEL = 1, SOURCE_TB_NAME = null, SOURCE_ID = null, UPDATE_TIME = '2017-03-10 02:13:36. 0

The wave of big data is surging, and a new information technology revolution is about to begin. "Spring River plumbing duck Xianzhi", as a database practitioner, is particularly profound to me. However, whether it is Oracle's EXADATA or MySQL's

Creating databases, tables, and query statements in MySQL will be of great help to our application databases in the future. This article summarizes these basic statements, I hope to help you. 1. Create and delete databases. Create a database

Hive users can use alter statements to change table attributes. Alter PartitionsAdd partitions: Alter table table_nameADD [if not exists]PARTITION partition_spec [LOCATION 'location1']Partition_spec [LOCATION 'location2']...Partition_spec:(Partition_

Create or replace procedure tj_data is-- Variables used in the current Stored ProcedureV_tableName VARCHAR2 (100 );V_ SQL varchar2 (200 );V_count integer;-- Obtain all tables in the current databaseCURSOR TABLE_LOOP is select Table_name FROM

A replica set is a master-slave cluster with automatic fault recovery. The most obvious difference between a master-slave cluster and a replica set is that the replica set does not have a fixed master node. You can use a replica set as a cluster.

Oracle 10 Gb later optimizer supports two modes: normal Mode and tuning mode. In most cases, the optimizer is in normal mode. The CBO-based normal Mode only takes into account a small part of the Execution Plan set to select which execution plan,

Collection of Oracle 11g statistics 1. Do not use the compute and estimate options for ANALYZE. They have been deprecated. In addition, the statistical information collected by analyze cannot be used by the cost-based optimizer and can only be