Sogou Spread knowledge, share the happy --MySQL database development and optimization of video

Today is September 11th, is a memorable day, to pray for the lives of innocent lives! This year since Bo has been opened for six years, in the support and assistance of the majority of users, the blog wrote 500 articles.........
Read(1612) comment(1)

Sogou My three all"

To write this article for a long time, there has been no time to write. Time do not have a moment to stay, remember, set foot on this piece of land in the southern part of the country for nearly ten years, even pronto. In this there is no culture and multicultural city of immigrants, deeply felt the words of wisdom, time is life, efficiency is money. Similarly, reform is the soul of Shenzhen, innovation culture is everywhere, also confirms the that the everlasting truth, the only constant is change. From the special zone to the free trade area, more than 30 years of time to go through the West nearly a hundred years of history, it can be described in real time with each passing day, advancing with the times. Think about yourself.........
Read(2197) comment(3)

Sogou Master how to make

Master, also called the master, is close to degree master's. Usually refers to in a certain field, an industry and corresponding circle has a higher visibility and very popular, well aware of in tenant, high degree of professional proficiency, has already reached the acme of position, can be described as almost Dao Yi! Before this paper continues, the following statement described the master mainly is database, and Oracle as the center spread. Secondly, I am not a master, but a little earlier than we have entered the field only. As a result, this article is dedicated to you,...
Read(5024) comment(19)

Sogou DBA those things

Speaking of DBA, full name of the database administrator, not the doctor of business administration, do not misunderstand, but it's a world of difference! In spite of this, many people still believe that there is a mysterious veil, surrounded by a wreath, too profound to be understood, people paid. As a matter of fact, it is a mechanic DBA. Repair what is it, not a lathe machine tool, it is not a precision instrument repair, repair is the database, only this. DBA industry has also experienced the process from the beginning, development to the peak of the process...
Read(4721) comment(6)

Linux under the configuration of Apache and Tomcat connection

HTTP server Tomcat and Apache belong to the Apache foundation, both of which can provide Web services, but the emphasis is different between the two. Server HTTP focuses on the web server, while Tomcat focuses on the application server as a lightweight. At the same time, both can be combined to use, that is, the dynamic request can be forwarded through the server Tomcat to the back end of the HTTP to complete, Server HTTP only handle static requests. This paper describes how to configure Apache and tomca...
Read(607) comment(0)

Linux 6 under the installation of Tomcat 8

The Tomcat server is a free and open source web application server, is a lightweight application server, commonly used in small systems and concurrent access is not a lot of occasions is the preferred choice for developing and debugging JSP program. Tomcat and IIS, such as Web server, with the function of processing the HTML page, in addition it is a Servlet and JSP containers, independent of the Servlet container is the default mode of Tomcat. Through the appropriate configuration, Apache for the HTML page service, Tomcat run JS...
Read(922) comment(0)

Linux compile and install httpd Apache 2.4

Apache is the world's first use of the Web server software. It can be run on almost all widely used computer platforms, because of its cross platform and security is widely used, is one of the most popular Web server software. The current Apache version is 2.4, the main description of this paper is based on the CentOS 6.5 source code to install httpd Apache. ...
Read(992) comment(0)

Linux under the configuration of httpd Apache

Httpd is the main program of the Apache Hypertext Transfer Protocol (HTTP) server. It is designed to be an independent run of the background process, it will build a processing request of the child process or thread of the pool to provide services. Httpd support based on the virtual host, as well as based on HOST, PORT, IP to achieve the virtual host, reverse proxy, load balancing, path alias, user authentication, basic, support third party modules, and many other features. This paper mainly describes the basic configuration of httpd (2.2 version) under Linux. ...
Read(1232) comment(0)

Linux under the installation of httpd Apache

Httpd is the main program of the Apache Hypertext Transfer Protocol (HTTP) server. It is designed to be an independent run of the background process, it will build a processing request of the child process or thread of the pool to provide services. Httpd support based on the virtual host, as well as based on HOST, PORT, IP to achieve the virtual host, reverse proxy, load balancing, path alias, user authentication, basic, support third party modules, and many other features. This paper describes the httpd under the Linux installation and related basic usage. ...
Read(1163) comment(0)

HTTP concise basic knowledge

HTTP Hypertext Transfer Protocol (Transfer Protocol HyperText) is the most widely used network protocol on the Internet. All WWW files must comply with this standard. It is a standard for client and server side requests and responses (TCP). The client is the end user, the server is a web site. By using a Web browser, web crawler, or other tools, the client initiates a HTTP request to the server that specifies the port (the default port is 80), and the server side responds to the message. This paper briefly describes the HTTP as well as...
Read(1337) comment(1)

Using CRM to manage heartbeat

Heartbeat is a Linux based open source, widely used high availability cluster system. Including heart rate services and resources to take over the two components of the cluster can be used. Its resource management mode can be managed based on haresource file mode, and can be managed by CIB mode. Based on CIB, the cluster resource uses the XML format to save the resource configuration information. Haresouce based file management can be converted to CIB based management.........
Read(1047) comment(0)

Linux based heartbeat configuration httpd High Availability Services

Heartbeat is a Linux based open source, widely used high availability cluster system. We can build web high availability service environment based on Heartbeat. In this paper, CentOS 6.5 under a simple example, and its log for a preliminary analysis, for your reference. ...
Read(1116) comment(0)

Linux under the installation and configuration heartbeat

Heartbeat is a Linux based open source, widely used high availability cluster system. Including heart rate services and resources to take over the two components of the cluster can be used. This paper briefly describes the installation of 2.1.4 Linux in the heartbeat environment, and describes the configuration of the 3 important profiles of heartbeat. ...
Read(1120) comment(0)

Daily management of DRBD

DRBD is a software used to achieve, without sharing, the server between the contents of the image block of storage and replication solutions. DRBD is made up of kernel modules and related scripts to build high availability clusters. For the environment of high availability cluster, although DRBD disk resources are taken over by cluster management components as a cluster service, it is very necessary to master the command of DRBD. This paper describes some of the commonly used DRBD daily management commands, for your reference. ...
Read(1044) comment(0)

Overview of HeartBeat cluster components

Heartbeat is a high availability cluster system based on Linux open source. Including heart rate services and resources to take over the two components of the cluster can be used. Heartbeat monitoring service can be carried out through the network link and serial, and support link redundancy, sending messages between them to tell each other their current state, if the other side to send the message is not received within a specified time, then it is assumed that each failure, then start the resource module for taking over to take over running on each host resources or services. ...
Read(1004) comment(0)

Windows platform to install MongoDB

MongoDB with its simple operation, completely free, open source, at any time to download and other features, is widely used in a variety of large portal and professional websites, greatly reducing the operating costs. This paper describes the installation steps and procedures in the Widows platform, for your reference. ...
Read(1181) comment(0)

Quick install and deploy DRBD

DRBD with its open source, simple, efficient, good performance for the majority of operation and maintenance of the favor of the people. The main function is to synchronize the data between two devices of the same size at different nodes. DRBD is made up of kernel modules and related scripts to build high availability clusters. This paper describes the installation method, for your reference. ...
Read(1186) comment(2)

DRBD principle and its characteristics

Replicated Block Device Distributed (DRBD) is a software used to achieve, without sharing, between the server and the storage of the contents of the image block of storage solutions. Its core functions through the Linux kernel implementation, more close to the operating system and the file system IO stack. DRBD is made up of kernel modules and related scripts to build high availability clusters. In fact, the way is to mirror the entire device through the network. You can regard it as a kind of network RAID. It allows the user to create a local block on the remote machine...
Read(1227) comment(2)

Execute to Parse Oracle analysis of the implementation of the analysis

To Parse% AWR is an important part of the Efficiency Percentages Instance Execute part of the performance indicators, the response to the database SQL analysis and implementation of the ratio. This ratio also involves parameters associated with cursor and hard soft parsing, parsing, parsing and so soft. This paper is focused on the development and description of this ratio. ...
Read(1187) comment(0)

Linux quick install MongoDB

DB Mongo is currently in the IT industry is very popular in a non relational database (NoSql), its flexible data storage method has been favored by the current IT practitioners. DB Mongo is very good to achieve the object-oriented idea (OO), in the DB Mongo every record is a Document object. DB Mongo's biggest advantage is that all of the data persistence operations are not required to develop manual SQL statements, the direct call method can easily achieve CRUD operation. This article describes how to quickly install mongodb for your reference. ...
Read(1646) comment(1)

Explain type MySQL connection type sample

For the acquisition of MySQL execution plan, we can view through the explain way, explain way seems to be simple, actually contains a lot of content, especially the output results in the type type column. Understanding of these different types, for our SQL optimization, this paper only describes the explian output results in the type column, while giving its demonstration. ...
Read(1072) comment(0)

Oracle big table to clean up truncate.. storage reuse

Recently need to clean up a large table, the requirements can not affect the performance. In MySQL inside we can through the use of coreutils as well as hard link to minimize the I/O, Oracle also can be divided into batches to minimize the space to minimize I/O, in the end, we will wait and see. ...
Read(1445) comment(1)

Manually clean up Oracle audit records

Oracle database audit function is very powerful, usually including the standard audit (including user level audit and system level audit) and fine-grained audit. In spite of this, it is easy to cause performance problems. At the same time, the system will be the system to support a burst of space. The following description of how to audit the audit from the system table space and clean up the Oracle audit records, for your reference. ...
Read(1186) comment(0)

EXPLAIN SQL MySQL output information description

Explain statement can be used to gain some information about SQL execution, such as the join order of the tables, the table access mode and so on. Through further analysis of the relevant information, we can add the appropriate index of the table, and to optimize the connection order, use the tips, and other means to achieve the purpose of efficient SQL operation. This paper describes the usage of EXPLIAN and gives some examples. ...
Read(1015) comment(0)
531 data a total of 27 pagesOne Two Three Four Five ... Next page Shadowe
    personal data
    • Visit3155777 times
    • Integral:Thirty-four thousand three hundred and ninety-seven
    • Grade
    • Rank:Sixty-eighth name
    • Original523
    • Reproduced:0
    • Translation:7
    • Comments:631
    ---- me Announce---- and Contact

    QQ: 645746311
    DBA group 1: 170233858
    DBA group 2: 324029615
    Database forum:DBSupport 
    Database service:Www.ycdata.net
    Blog reproduced please link to indicate the source

    Latest comments