Database Administrator

I. Introduction==========This document describes how to install and configure a MySQL cluster based on two servers under RHEL. MySQL can continue to run when any server encounters a problem or goes down. Note!Although this is a MySQL cluster based

Most of these problems occur in the Federo version. a friend on the previous Forum used this version of Linux but was unable to deploy MySQL in the LAMP environment. Later, the installation of MySQL had many problems. Today, I replaced the system

1. on Linux, after logging on with an Oracle user, run:[Oracle @ h16 oracle] $ sqlplus/nologSQL * Plus: Release 9.2.0.4.0-Production on Tue Feb 19 16:42:38 2008Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.SQL> connect

After more than n days of installation, I finally successfully installed Oracle on the Linux system of my computer. The efforts made over the past few days have a little return, so the mood at this time is still very good! In fact, installing

All Integer types can have an optional (non-standard) attribute UNSIGNED. You can use an unsigned value when you want to allow only non-negative numbers in a column and the column requires a large upper limit value range. Mysql4:Mysql> create table

It is said that MySQL performance is very good. Prepare to test it. If the effect is good, replace the database with MySQL. But I didn't expect it to take two hours! But now we have solved the problem. Well, now we can record the things we learned

Oracle SQL Developer is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements.

1. KeywordsAuto_increment 2. Auto-increment usageExample:Create table animals (id mediumint not null auto_increment,Name char (30) not null,Primary key (id )); 3. Auto-Increment Q: How to obtain the current maximum auto-increment value?A: select @

I. Compilation and Installation ./Configure -- prefix = installation pathMakeMake install Run the mysql Script: installation directory/bin/./mysql_install_db -- user = XX (xx is the Freebsd user name) 2. modify the configuration file: Copy my.

When installing mysql-connector-odbc in Linux AS5.0, the following message is displayed: # Rpm-ivh mysql-connector-odbc-3.51.12-2.2.i386.rpmWarning: mysql-connector-odbc-3.51.12-2.2.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186Error:

Q: The following error occurs when I log on to MySQL on another machine: ERROR 2003 (HY000): Can't connect to MySQL server on 'x. x. x. x' (111) A: The reason is that, considering the security factors of MySQL, the default configuration only allows

1. Configuration:./Configure \-- Prefix =/home/zengyf/local/mysql-5.1.30 \-- Enable-local-infile \-- With-unix-socket-path =/home/zengyf/local/mysql-5.1.30/var/mysql. sock \-- With-tcp-port = 5506 \-- Enable-thread-safe-client \-- With-mysqld-user =

Abstract: This article is divided into three parts, mainly from the perspective of Oracle case library, respectively introduce the background of Oracle case library, Implementation ideas and methods, and finally give a conclusion. 1. Background In

It provides several time points for merging Oracle continuous time points.For example:Am-Am, and the output is Am-Am.Am-Am, Am-AmAm-Am, Am-AmUse the lag and lead functions as follows:Lag (column, N, defValue): takes the previous recordParameter:

I have not fully studied Oracle sqldev, but it is not convenient to use it in a few places. I found that I can modify the shortcut key to correct it. 1. Code intelligent completion prompt All the shoes that have used eclipse are used to using

Often encounter problems where Client-dependent tools such as PL/SQL Developer cannot connect to the Oracle Database Server. So far, it has not been fully clarified. I will first post a summary of the current method, which will be improved in the

Weekend June 9, 2013 Dbms: Oracle11.1.0.7 4 nodes RAC Reporting extremely slow System Operation Check the system wait event. The following statements are added to the backlog: View Insert into counterloadmessage (emsid, period, period, moentityid,

1. Install a Linux Virtual Machine I use VM, RedHat AS 6.2 and CentOS 6.3. When installing the Linux system, we can select all packages because we do not know how many packages need to be installed. (This is a stupid but feasible method, when the

1. Environment Description OS: AIX6.1 Oracle: 11.2.0.3.0 RAC 2. Accidents The host of NODE 2 in the database has a down accident and should have been switched to NODE 1 normally. However, the switchover failed and the system was restarted to solve

My colleague called me and said that the MySQL group buying database master is never synchronized. Nima, why is it so hard? Well, we can solve the problem by setting up a computer to set up a VPN.1. log on to the slave database and check whether the