db mysql

1. Be sure to close the Selinx before moving, this is very deceptive; (You must restart it after closing, this shutdown does not affect MySQL security) Vim/etc/selinux/config Open this file modificationselinux=enforcing-------To change this line to

One master and one slave: MASTER: OS: centos release 5.6 DB: MySQL 5.5.8 IP: 192.168.1.2 SLAVE: OS: centos release 5.6 DB: MySQL 5.5.8 IP: 192.168.1.3 Modify the host master configuration file (/etc/My. CNF) [Mysqld] // At least two

Today learned to do the background page, very failure will not show. PHP: The following code can block PHP attention level error, that is, throw any non-attention errors [PHP] Error_reporting (e_all&~e_notice); Error_reporting

Simple to use Seaslog, but understand that he is not very suitable for distributed, so come here to recommend a Environmental conditions: Two servers.Allocation down is 2*nginx load balancing, Db-mysql,cache-redis master-slave, language PHP, the

I learned how to create a background page today. if it fails, it will not be displayed. Php: The following code shields php attention-level errors, that is, it throws any non-attention errors [php] error_reporting (E_ALL & amp ;~ E_NOTICE);

Mysql5.6 dual-master configuration automatic synchronization script bitsCN.com # Recently, a project has been applied to the mysql dual-master structure and is shared. # Mysql version: 5.6.11 # Operating system version: rhel 6.2 # My. cnf

Mysql5.5master-slave (Replication) configuration method bitsCN.com one master one slave: Master: OS: centos release 5.6 DB: mysql 5.5.8 IP: 192.168.1.2 Slave: OS: centos release 5.6 DB: mysql 5.5.8 IP: 192.168.1.3 Modify the host Master

Mysql5.5master-slave (Replication) master-slave configuration bitsCN.com one master one slave: Master: OS: centos release 5.6 DB: mysql 5.5.8 IP: 192.168.1.2 Slave: OS: centos release 5.6 DB: mysql 5.5.8 IP: 192.168.1.3 Modify the host Master

function Cook_cooloff () { Global $PHP _self, $aid, $pgno; Setcookie ("Open_list", 0,time () + 31536000); Header ("Location: $PHP _self?aid= $aid &pgno= $pgno"); Exit } //=============================================================== function

Mysql database read/write splitting Data Synchronization I used two xp (one master, one slave) systems to test successfully, and I also did a test on linux systems, however, I think the problem I encountered is the same. In xp, the problem can be

Controller attribute: admin_address => $ controller_node_address, public_address => $ controller_node_public, public_interface =>$: public_int, private_interface =>$: use_quantum? {True => false, default = >$: fuel_settings ['fixed _ interface']},

Idoutils is an addon of icinga used to save data to the database. In this article, I try to use MySQL server, and MySQL server has been installed on another machine. The sever of icinga has been installed before. 1. First install the program

The MySQL master-slave structure is based on mysql incremental logs, which is different from the master-slave replication structure. In the master-master replication structure, any changes to the data inventory on one of the two servers will be

Mysql master-slave backup and SQL statement backup, mysql master-slave SQL statement The master-slave configuration of the MySQL server is a very simple task. Instead of starting from scratch, it is always on the mysql server that has been installed

Mysql 5.5.40 implements One-Master-multiple-slave muil-slave and 5.5.40one-master We know that the overhead of Mysql Reading and Writing Performance is quite different. Generally, the server is under 20% write pressure, and the other 80% pressure

How to Set Up MySQL synchronization (replication) MySQL provides the Database Synchronization function, which is of great help to achieve database redundancy, backup, recovery, and load balancing. This document describes common synchronization

MySQL database Optimization How should we optimize the MySQL database? Next I will explain this problem from MySQL's hardware selection, MySQL installation, my. cnf optimization, MySQL architecture design, and data splitting. Optimization of server

Mysql5.5 master-slave synchronous replication configuration, mysql5.5 master-slave Synchronization In the previous article "mud: learning the principles of mysql database master-slave synchronous replication", we introduced the basic principles of

MySQL installation (Binary installation mode) MySQL installation (RPM installation mode) and directory structure MySQL installation (Binary installation mode) MySQL installation (source code installation mode) This article uses the binary mode for

MySQL installation (Binary installation mode), mysql binary MySQL installation (RPM installation mode) and directory structure MySQL installation (Binary installation mode) MySQL installation (source code installation mode) This article uses the