PlanetMysql.ru — информация о СУБД MySQL

There are 2 kind of upgrade is possible in MySQL. Major version upgrade (i.e MySQL 4.1 to MySQL 5.0) Minor version upgrade (i.e MySQL 5.0.45 to MySQL 5.0.47) In the Major version upgrade, people are generally using very common technique which is, taking backup by mysqldump from MySQL 4.1 and reload into MySQL 5.0. This
PlanetMySQL Voting: Vote UP / Vote DOWN

There are 2 kind of upgrade is possible in MySQL. Major version upgrade (i.e MySQL 4.1 to MySQL 5.0) Minor version upgrade (i.e MySQL 5.0.45 to MySQL 5.0.47) In the Major version upgrade, people are generally using very common technique which is, taking backup by mysqldump from MySQL 4.1 and reload into MySQL 5.0. This
PlanetMySQL Voting: Vote UP / Vote DOWN

There are several types of indexes are available in MySQL: B-Tree Indexes: Normal Indexes – Normal indexes are the most basic indexes, and have no restraints such as uniqueness. It can contain duplicate value. Unique Indexes – Unique indexes are the same as “Normal” indexes with one difference: all values of the indexed column(s) must
PlanetMySQL Voting: Vote UP / Vote DOWN

Heartbeat is a project from Linux-HA. http://www.linux-ha.org/wiki/Heartbeat. Heartbeat will be helpful when we would have pair and/or more servers which are configured to replicate in circular fashion. I.e  In MySQL Replication, if master will be fail we have to do manually failover or we have to make script which will manage this thing. But if
PlanetMySQL Voting: Vote UP / Vote DOWN

Its easy to install MySQL on ubuntu but you must have updated your repository for apt-get utility. If you haven’t than run below command to update it. shell> apt-get update After that, to install MySQL 5.1 on ubuntu run below command. shell>sudo apt-get install mysql-server-5.1 you’ll have to give your password so it will start
PlanetMySQL Voting: Vote UP / Vote DOWN