Database Administrator

MariaDB single-host dual-instance master-slave Replication MariaDB single-host dual-instance master-slave Replication MariaDB is actually the same as MySQL, but its name is different. Start ~ In the previous experiment, we installed MariaDB on a

Use local indexes to improve PostgreSQL Performance You may not know that PostgreSQL supports partial indexing of table data? Its advantage is that it can accelerate the reading speed of the indexed data without additional overhead. the best way is

Install MariaDB and MySQL MariaDB can be used to replace enhanced MySQL versions, but MariaDB can also be installed when MySQL is installed. (This makes sense. For example, you want to migrate data from one database/application to another

Oracle GoldenGate Quick Start Tutorial: Basic Concepts and configurations 1. Introduction to GoldenGate Oracle Golden Gate is a log-based copy and backup software for structured data. It parses online logs of the source database or archive logs to

PostgreSql Procedure copy split string to table, postgresqlsplit In my scenario, there is a table with a field storing data using split string. Although Hibernate provides org. hibernate. annotations. Type annotations, You can implement org.

RAC a node database cannot be started: ORA-00600: internal error code, arguments: [4: kg1_lditomicrots], [1], [], [], [], [], [, internalerror The hardware of a customer's RAC node has changed. After the host is restarted, the database instance

Configure Eclipse Xdebug debugging tool in Ubuntu 13.04 + Firefox's easy Xdebug component, 13.04 xdebug Step 1: Install the php_xdebug extension and check whether the installation is successful. [Html]View plaincopyprint? Sudo apt-get install php5

Pl SQL Developer client connects to the server, pldeveloper After installing Oracle and PLSQL, open the listener on the server. Right-click a computer, choose management> services and applications> services> open services starting with Oracle,

Data room charging system-use of stored procedures and charging system storage process In the "checkout" section of the data center billing system, You must select an operator and click the "checkout" button to change the registration, recharge, and

My. cnf already exists, affecting installation -- mysql, my. cnf -- mysql Found existing config file./my. cnf on the system. Because this file might be in use, it was not replaced, But was used in bootstrap (unless you used -- defaults-file) And

SQL commands for regularly deleting historical data from databases and SQL commands for historical data Create a job,Used to regularly clear historical database data Delete the data of the first quarter of the table before gps_comm, as

Restore table accidentally deleted records, and delete table records by mistakeRestore table accidentally deleted records  I recently handled a user's accidental deletion of the delete table. Here I made a simple summary. The content of this article

Java implements Oracle database backup and oracle Database Backup Today, we will paste an Oracle database backup feature that has been implemented very early. This feature was designed at the university stage: Import java. io. file; import java. io.

Mysql-views, stored procedures, triggers, and mysql-Views I. VIEW A view is a virtual table and does not store any data. Only the running time contains the dynamically retrieved data. Eg: SELECT sid, name, sex, s_num FROM student, school WHERE sid =

Locate the INT $ DBA_CONSTRAINTS definition under $ ORACLE_HOME/rdbms/admin in 12c, dbaconstraints [oracle@rhel59 admin]$ pwd/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin[oracle@rhel59 admin]$ grep -rn 'INT$DBA_CONSTRAINTS' ././e1201000.sql:138

Parallel Computing of relational algebra and parallel computing of relational algebra The parallel execution of SQL queries has been extended from the learning of Dremel and Impala, so I took this opportunity to learn more about the parallel

[MongoDB] mongodb sharded cluster (5) on windows platform, mongodb Cluster In this article, the above four articles continue to describe how to build a mongodb sharding cluster on the window platform. You can also create indexes in a sharded cluster.

Cannot Debug SQL: Unable to start T-SQL Debugging. cocould not attach to SQL Server process on, t-sqldebuggingWhen SSMS debug SQL script is used today, an error is reported: Unable to start T-SQL Debugging. cocould not attach to SQL Server process

Conventional-path insert (traditional path insert), sys. path. insert We have already mentioned Direct-path.INSERTNow let's talk about Conventional.INSERT. Source: "Oracle Database Administrator's Guide11GRelease 2 (11.2 )" Conventional and

Mysql SQL Statement Review 2 -- Regular Expressions and mysql Regular Expressions Here, we will briefly review the usage of Regular Expressions in mysql when filtering data. This mainly refers to an example for each usage or a brief description. The