Database Administrator

Step 2. Install mysql in yum[Root @ stonex ~] # Yum-y install mysql-serverInstallation result:Installed:Mysql-server.x86_64. 1.73-3. el6_5Dependency Installed:Mysql. x86_64. 1.73-3. el6_5 perl-DBD-MySQL.x86_64. 013-3.el6 perl-DBI.x86_64.

When I first set up a message push server for my company before the Spring Festival, I installed MongoDB 2.4.9 and MongoDB2.6.0 on February 8,. I have made a lot of improvements. Now I am going to upgrade it to the latest version 2.6.0, the upgrade

1. Concepts Trigger is a special event-driven process defined by the user in the relational table. Once defined The server automatically activates corresponding triggers for table addition, deletion, and modification, and implements centralized

What is bitmap index?Bitmap indexes use a single-digit chart to store the visible structure of records.What are the features of Bitmap indexes?Bitmap index implementation method: Use a BIT to indicate whether the value corresponding to this

Our previous queries are all based on one table. How can we query data from two or more tables? This note is used to learn multi-table queries. Basic syntax: Select * | (specific column name, column name 1, column name 2) From table 1 alias 1,

I started O & M recently. I had an accident for two days. Although I was surprised, I think I was lucky! The fault records are as follows: 1. The new project was launched on November 1,. When executing the DDL command, I forgot to confirm the

The implementation of a function is simple, but it is not easy to implement a function that meets the user experience. For example, in the evaluation system, in the examination system, in the Course Selection System, or even from the first grade to

Overview:===============An archive gap is a range of missing archived redo logs created whenever the standby system is unable to receive the next archived redo log generated by the primary database. For example, an archive gap occurs when the

I. Start the listener and database 1. Start the listener: [root@JTWF oracle]# su oraclebash-4.1$ lsnrctl start If the result is as follows, the startup is successful: LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014

Preface: SQLServer replication technology has emerged at least in the SQLServer2000 era. It was originally for distributed computing, not for high availability. However, replication has become a highly available technology and is widely used. Many

There are three sources for Database Design: (1) You can design databases from existing data, such as excel tables. In this mode, you need to consider the normalization of data, (2) design a new database, which needs to build a complete database

This is MySQL SQL optimization Article 2nd. we all advocate Percona, a powerful branch of MySQL. Should this be the case? In some cases, the original configuration is reliable, and weisan is not necessarily powerful. Let's take a look at the sar

There is a project that need collecting periodically (2 months) data into one table and then exporting it as excel file. The table is a temporary table, the app do that Delete from tb_name; insert into tb_name values ..... With that method, it

Non-relational databases have developed rapidly a few years ago, and have never been engaged in similar development before. Therefore, they have started learning non-relational databases. As I chose mongodb for development, I will share my learning

  3. Oracle_Loader External Tables 3.1 In the scripts directory, you will find prod_master.dat and prod_master.ctl. Using the information found in these files, create an external table names PROD_MASTER in the SH schema of the PROD database. In

Zookeeper oracle 10g CRS voting disk management ----------------- Voting disk backup recovery: -- Back up voting disk: Dd if = voting_disk_name of = backup_file_name -- Restore voting disk: If your voting disk is stored on a raw device, use

1. simple aggregation tools 1. count Count is the simplest aggregation tool used to return the number of documents in the collection. 2. distinct The semantics of distinct is the same as that of other databases. It is used to find all the

Fault description:A new RAC experiment was installed, and it was found that ora. rac2.LISTENER _ RAC2.lsnr could not be started. Check listner. ora for no exception. After manual startup, the status is UNKNOW. Crs_stop-f ora. rac2.LISTENER _

Anyone familiar with Jobtracker knows that during Job initialization, EagerTaskInitializationListener locks JobInProgress and then performs InitTask. For details, please refer to the code. One step here is to write initial data to hdfs and flush it,

The tool named Big Data Lite is bundled with Oracle Linux, Cloudera software, Hadoop, and a large number of Oracle cloud connectors to replicate available environments on Oracle's Big Data all-in-one machine. This bundling tool is provided to