Very quickly, another thing that I typically like to do on my server boxes is allow root access to my Mysql database from remote computers. I don’t forward the port through my router and I use a very secure password (doesn’t everyone?).

Mysql multi-table query Left Join and Right Join to Use

There are, however, some special circumstances that do require a little more complex tactics.For example, when handling sensitive data, putting the files into a database gives you a little more control over how the data is handled and who has access to it.This article shows a simple way of putting files into a MySQL table, using PHP.

Tungsten is a family of open source technologies for database clustering and replication. Tungsten includes replication, management, SQL routing, and proxying that improve database availability, protect data, and raise application throughput.

Have developed a video sharing site, users upload videos, using FFmpeg convert. Flv and .3 gp format. web site is very simple procedure, the main task is to configure the video server.Now the video server configuration steps, share out.

Mysql automatic backup script,This script only once a day, and only the most recent five-day backup on the server.

Mysql bin log files to remove the shell script, share to everybody

Recently developed a Web site, it is estimated that the maximum online 30000, up to 100 concurrent. Development site can stand the pressure, how to ensure that there is no problem loading the site, after decisions are as follows…

Mysql slow log to record the execution time is longer (more than long_query_time seconds) a log of the sql tools.

Replication can be suspended for an hour after the restart Replication, Slave to observe how long the data can be consistent with the Master. Replication restart from the Master data and agreed to spend the time and the suspension of time Replication is the ratio of the capacity of Replication.