Database Administrator

Detailed steps for creating the ipvs-XL Cluster Recently, the company's business needs to use ipvs-XL clusters. There is not much network information about this part of knowledge. After a period of query and various detours, the installation was

Install the Visual Database Browser SQLite Browser 16.04 on Ubuntu 3.8 SQLite Browser 3.8 was released at the end of last year. SQLite Browser is a visual database Browser that can be installed through PPA. SQLite Browser is a visualization tool

Oracle 11G R2 replicuard construction in CentOS 5.11 Datagard is a disaster tolerance solution for Oracle Enterprise Edition. It is widely used in enterprises and I will record the setup process for backup.Host Name database version Instance name

WAS _ initiate mbind: Invalid argument, mbindargument **************************************** ******************************** *************************************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost

Summary of Oracle database architecture, oracle Architecture   Oracle DB Architecture An Oracle DB server consists of one Oracle DB and one or more database instances. An instance consists of a memory structure and background processes. Whenever an

Recently, I need to write a data migration script to migrate data from a single Oracle database to a MySQL Sharding cluster. I just recently learned python and used it to practice it.I quickly completed MySQL and only needed to install a python

Sqlite Study Notes 10: Using sqlite to query and update data in C language, sqlite Study Notes The third parameter in sqlite_exec () mentioned above, SQLite will call this callback function for each record processed in each SELECT statement executed

[PLSQL Developer] PLSQL Developer SQL Editor garbled, plsqldeveloper[Problem] We often write various statements in the SQL window of PLSQL Developer. To save these statements, you can save them as a text file or copy them and paste them into a Word

Second, understanding database three paradigm, understanding database paradigm Understanding the database paradigm is of great help to design a rational database. Based on my understanding of the database paradigm and specific examples, this article

Multiple Oracle databases physically stored in the network can be logically considered as a single large database. Users can access the data in the remote database through the network, while the collaborative processing between servers It is

Oracele Timesten connects to DSN to create a user, oraceletimesten 1. Enable startup [Tt @ host2 info] $ ttDaemonAdmin-start-force /Home/tt/TimesTen/tt1122/info/timestend. pid file exists, attempt start due to-force option. TimesTen Daemon startup

SQL statement optimization: optimization of JOIN, LEFT JOIN and RIGHT JOIN statements; sqljoin In database applications, we often need to perform multi-table queries on the database. However, when the data volume is large, multi-table queries have a

Seven Tips for improving MySQL performance: mysql Performance Original article: 7 keys to better MySQL performanceAuthor: Peter ZaitsevTranslator: Peter Note: As the size and load increase, MySQL performance tends to decline. Remember these

When you build a Postgresql test environment and encounter a problem during installation, execute configure The following error is reported during the process: configure: error: readline library not found. The colleague said that the system has been

Java from entry to entry-database Mongo DB Export, Import, backup, from entry to entry-level mongo I. Overview This blog tells you how Mongo DB imports and exports data and backs up data. In the following operations, you must open the

ORACLE 11G manual database creation, oracle11g manual database creation  Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held

What is MDS In the OAF framework? What is OAPageContext & OAWebBean ?, Oafoapagecontext Address: http://oracle.anilpassi.com/mds-in-oa-framework-what-exactly-it-is-2.html We know that "MDS" is the abbreviation of "MetaData Service". We also know

Install the 32-bit oracle software in 64-bit linuxIn some cases, sometimes we need to install 32 oracle software on a 64-bit system (for example, the customer's abnormal requirements ). Although theoretically, this method is feasible, but in the

Compile and install PostgreSQL and osxpostgresql in Mac OSX Originally, the official installation package was used. However, the installation package will create postgre, which is a bit uncomfortable on the login interface. After searching for a

Data Import from oracle to mysql (applicable to the mutual import between any data sources), oraclemysql To release some resources in the production database, you need to migrate the API module to mysql and export data. When I tried the oracle to