Database Administrator

1. Download the mysql database Official Website: www.mysql.com to register a mysql user MySQL For Windows V5.2 Alpha http://www.skycn.com/soft/1262.html updated on: 2. Download the mysql database driver.

Operating System: RedHat linux 5 (Enterprise Edition) Software: Oracle 10g R1 Preparations: Download the official oracle 10g install for linux documentation Software to be installed in Linux: GNOME Desktop Environment/KDE X Window

MySQL uses the default Character Set of latin1. That is to say, the Chinese character fields are stored directly using the GBK internal code encoding, if you want to sort the fields with Chinese characters in pinyin (especially those with names),

1. installation environment: Fedora 10 (kernel version: 2.6.27.5-117. fc10.i686) Oracle Database 11g Release 2 (11.2.0.1.0) (Register and download the corresponding Linux x86 version on the Oracle website) 2. References: Oracle Database 11g Release 2

In the past two days, a QA asked, "it is difficult to check the Database console because the database storage time is BigInt. I really don't know what it is! There is related function conversion in the impression, as follows: The storage time of the

Detailed installation and testing of pgwatch An error occurred during installation, but no documentation was found online. I decided to write a detailed installation document myself. 1. Download pgwatch. Here I use Version 1.0, as shown below: Wget

1. Configure Advanced Security Options and network services for Oracle databases through OUI 2. Configure kerberos Authentication 1. Execute the command netmgr and click the authentication label. In Available Methods, select KERBEROS5 and move it to

The stored procedure is used in many places when the data center is reconstructed. Here is a brief summary. Stored Procedure is a set of SQL statements for specific functions. It is compiled and Stored in the database. You can run a stored procedure

The second part was intended to test whether the master server was suspended and the slave server was upgraded. However, an accident occurred. Instead, it was used to test how to recover a slave server when it was suspended. Put the failure of the

1. Price MySql: Cheap (partially free): currently, MySQL uses DualLicensed, a commercial license agreement developed by GPL and MySQLAB. If you use MySQL in a free (Open Source) project that complies with GPL, you can follow the GPL protocol to use

The MariaDB database management system is a branch of MySQL. It is mainly maintained by the open-source community and licensed by GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of

I was planning to conduct an in-depth study on Oracle Data dictionary this evening, but when I was about to finish the research, I received a message from a friend in Beijing saying that their database generation had a problem, let me take a look at

Introduction Mixer is a mysql proxy implemented by go and supports basic mysql proxy functions. Mysql has a lot of middleware. For the existing powerful proxies on the market, I mainly examine the following: Mysql-proxy, an official mysql proxy,

I used VB6 Enterprise Edition to encapsulate a DLL, which has four VB forms: form1, form2, form3, form4, in VBE of excel 2003, class modules and standard modules in DLL are successfully called with VBA code, but VB forms cannot be called or

In the actual operating environment, we often encounter such requirements. For example, if you want to avoid affecting the running time of the DB patch in the current network environment, or, you want to connect to Standby DB for testing of actual

Generally, we can see that the terms "Index" and "key" are used for exchange, but they are actually different. An index is a physical structure stored in a database. A key is purely a logical concept. The key represents the integrity constraints

Image-level backup (image copies) is equivalent to copying copies of data files and archive logs. It is exactly the same as the original file in the storage space. If you need to perform partial recovery (such as a data file) when using image backup,

Oracle constraints on database integrity: Three methods to maintain data integrity: ORACLE integrity constraints, database triggers, and application code. ORACLE integrity constraints should be used whenever possible, with high reliability and

When multiple tables are joined in Hive, the Hive SQL Optimization engine is not powerful enough, and the Association Sequence of tables is different, which leads to different quantities of MapReduce jobs. In this case, you need to adjust the SQL

Application Context is a group of name-value pairs in the memory. application context belongs to a namespace ). You can only use one custom procedure to call dbms_session.set_context to set the value of application context. You can use sys_context (,