MySQL

  • |

    Setup MySQL Replication

    ByConan

    This tutorial describes how to setup MySQL replication. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync….

  • Some MySQL performance tips

    ByConan

    This article discusses about some MySQL performance tips which are collected over Internet and based on the experience of the author (me ^__^). Specific Query Performance Tips (see also database design tips for tips on indexes):  Use EXPLAIN to profile the query execution plan  Use Slow Query Log (always have it on!)  Don’t use DISTINCT when you…