Data types are the basic rules that define what data can be stored in a column and how the data is stored
When designing a table, you should pay special attention to the data type used. Using the
Tag: mysql
MySQL master from mount
1. Modify the my.cnf file
vim /etc/my.cnf 1.1 Main Library< /p> #The current mysql service number is 1, which is the first mysql server
server-id=1
#Binary log file
log-bin=mysql-bin
1
Big big architecture better MySQL query performance
There is a very strange problem between the query on my server and the MySql InnoDB architecture.
The query has a high query time (about 1, 6 – 2 seconds), and my database is almost empty.
PT-HeartBeat Monitor Mysql Synchronization Delay
pt-heartbeat monitors mysql master-slave synchronization delay:
Install percona toolkit (pt-heartbeat is a subcommand of the software):
http://repo .percona.com/release/6/RPMS/x86_64/pe
Full-text search Django: MySQL is not so bad? (vs Sphinx, Xapian)
I am studying django’s full-text search engine.
It must be easy to install, fast indexing, fast index update, no blocking during indexing, fast search.
After reading a lot of web pages, I in
HeartBeat V2 CRM implements NFS-based mysql high availability cluster
Foreword
Because the built-in resource manager haresource function of heartbeat v1 is relatively simple and does not support graphical management, Therefore, heartbeat v2 no longer supports h
How to use HeartBeat to form a high availability mysql cluster
I have reposted many posts, in fact, to build a mysql cluster using heartbeat. Many online uses make to generate RPM for installation. I also found a lot of information. The cluster users that come
HeartBeat + DRBD + MySQL High Available Scheme
www.521voip.com Focus on cloud computing
Heartbeat+DRBD+mysql high-availability solution
1.1 Introduction to the plan
This plan The Heartbeat dual-system hot backup software is us
HeartBeat + DRBD + MYSQL + LVS Cluster
Four hosts
Host name IPAddress Purpose
dbm129 172.16.0.129 heart+ mysql beat+ mysql secondary node
dbs130 172.16.0.130 6.0 slave(mater_host=172.16.0.233)
dbs131 2.1 131 131
heartbeat+DRBD+mysql+haproxy
heartbeat+DRBD+mysql+haproxy
heartbeat+DRBD+mysql mainly realizes the single point of failure of mysql master
haproxy implements load balancing from mysql
Specific architecture di