Database Administrator

MHA online switching process In addition to automatic monitoring and switching, MySQL MHA provides online failover, which is mostly used for hardware upgrades and MySQL database migration. This mode provides fast switching and elegant blocking of

Monitor multiple database loads simultaneously using Shell scripts In normal work, there are still a lot of databases to be managed. Because of the relationship between remote access and permissions, some graphic tools cannot be accessed. Sometimes

Updated materialized views of PostgreSQL 9.4 PostgreSQL version 9.4 has been released for a while and has updated a lot of content. One of them is the update of materialized views that are of interest. Compared with the original materialized view

MySQL error: Unknown character set: 'utf8mb4' Com. mysql. jdbc. exceptions. jdbc4.MySQLSyntaxErrorException: Unknown character set: 'utf8mb4'At sun. reflect. NativeConstructorAccessorImpl. newInstance0 (Native Method)At sun. reflect. nativeconstruct%

Oracle Database time and system time There is a huge gap between Oracle Database time and server system time, resulting in data confusion and report errors. The difference between database time and system time is about 16 hours. The details are

Mysql Study Notes sixteen (database maintenance), mysql Study Notes Data backup data loss cause: storage media applaud, user operation error (accidental deletion of the entire database), server paralysis 1. File Replication needs to stop the server

About Oracle Cluster Registry, oracleclusterAbout Oracle Cluster RegistryOracle Cluster Registry (OCR) is a file that contains information about the cluster node list and instance-to-node mapping information. OCR also contains information about

Data structure, data structure and AlgorithmHash search In the previous search algorithm, the time complexity is O (n) or O (2n). The efficiency depends on the number of "comparisons. Even if the search results of a table using the sort tree

Oracle Memorandum 1, oracle Memorandum Database Administrator: Install and upgrade the Oracle database to create a database, tablespace, table, view, and index... Develop and implement backup and repair plans database permission management, tuning,

Report data source-Hadoop, report hadoop In addition to traditional relational databases, the data source types supported by computing reports include TXT text, Excel, JSON, HTTP, Hadoop, and mongodb. For Hadoop, you can directly access Hive or read

Mysql Study Notes 4 (view), mysql Study Notes ViewView Operations on views can simplify queries and improve security. View: Essentially, a virtual table is similar to a real table and contains a series of columns and row data with names.

MySQL changes the storage engine of database tables. MySQL changes the storage engine of database tables 1. view the original storage engine of the table show create table user; 'user', 'CREATE TABLE `user` (\n `id` int(11) NOT NULL DEFAULT \'0\'

Error code: 1064, error code 1064 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: create table example3 (id Primary key, stu_id int, constraint c_fk foreign key (stu_id, course_id) references example2 (stu_id, cour...

Alert output when alter database open resetlogs, alterresetlogs SQL> alter database open resetlogs; Database altered.Prompt: ORA-279 signalled during: alter database recover datafile 5...ALTER DATABASE RECOVER CANCELMedia Recovery CanceledCompleted:

Oracle inspection script and oracle Inspection   #! /Bin/sh # Get HostnameHOSTNAME = 'hostname' Logfile = xunjian _ 'date + % y % m % D'. logHostinfodir =/home/oracle/xunjian If [[! -D $ hostinfodir]ThenMkdir-p $ hostinfodirFi Date> $ hostinfodir/$

C # using DataTable to access data, DataTable Introduction: http://www.dotnetperls.com/datatable Retrieve Data Example of saving SQL results to DataTable: http://stackoverflow.com/questions/6073382/read-sql-table-into-c-sharp-datatable Example code:

MySql Installation Error A problem occurred recently during mysql installation: 1. Unlike operating systems, deletion and cleanup are also different during installation: Window 7, the following describes how to fully uninstall an ECS instance: 1)

Php implementation method for memcache consistent hash, memcachehashI recently read some distributed articles, so I used php to implement consistent hash to train my hands. In the past, I used the most primitive hash Modulo for distribution, when a

Oracle Database Import and Export, oracle Import and ExportI. PreparationsCreate a tablespace:Create temporary tablespace yangwen_tempTempfile 'd: \ oracle \ oradata \ orcl \ yangwen_temp.dbf'Size 50 mAutoextend onNext 50 m maxsize 20480 mExtent

The hbase shell script is written on the SecureCRT terminal and cannot be used to delete keys. securecrthbase I. Description Remote connection to Linux on SecureCRT terminal, and use hbase shell script for Distributed Database Operations, but