Installing MySQL on FreeBSD

In This article I’ll describes how to install very famous and popular relational database, especially using as a back-end database for most web servers.

This article will not teach you how to use SQL. Our consideration go trough only for Installation.

FreeBSD: Apache + MySQL + PHP

"Setting up a LAMP server is a common task for systems administrators, and FreeBSD is one of the most reliable and stable operating systems available. You can swap out the L in LAMP with F for FreeBSD to build a fast and reliable Web server..."

(more...)

Setting up FAMP on FreeBSD

Setting up a LAMP server is a common task for systems administrators, and FreeBSD is one of the most reliable and stable operating systems available. You can swap out the L in LAMP with F for FreeBSD to build a fast and reliable Web server.

(more...)

Tips for MySQL to PostgreSQL Switch

If you’ve decided to move a few tables from MySQL to PostgreSQL, these few tips might help.

Unable to Use mysqldump on a Shared Host? Here’s an Alternative

I have used many shared hosts throughout my years as a webmaster. Shared hosts have many great points, namely, price, and then they have their major drawbacks. For me, one of the major drawbacks is the limited use of the machine on which your site is hosted.

For instance, I love phpMyAdmin for maintaining and managing my databases, but I am not a fan of the need to log in to backup the databases. The easiest way around that of course would be to execute the mysqldump command that comes bundled with MySQL. Unfortunately, most shared hosts, all that I have dealt with, disable the ability to use exec() or system() with PHP to execute the MySQL native command.

(more...)

How to import csv file to mysql using PhpMyAdmin

Here's one way to get your Excel file into MySQL via phpMyAdmin.

InnoDB vs MyISAM

Most people who use MySQL know that MyISAM and InnoDB are the two most-common database engines available with the popular open-source database provider. I would bet that most of those people don't even take the time to select a storage-engine and just accept the database default. Those of you who are left probably heard from a friend who saw something online that said one of the two is better than the other. Those of you who are left will still probably learn a thing or two here.

How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1

This tutorial is based on Falko Timme's tutorial for MySQL Cluster 5.0. It shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer nodes. This cluster is load-balanced by an Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).

10 great articles for optimizing MySQL queries

Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. Although it may be possible to perform some local optimizations with little knowledge of your system or application, the more optimal you want your system to become, the more you must know about it.

The following 10 articles explain and give some examples of different ways to optimize MySQL.

How To Repair MySQL Replication

If you have set up MySQL replication, you probably know this problem: sometimes there are invalid MySQL queries which cause the replication to not work anymore. In this short guide I explain how you can repair the replication on the MySQL slave without the need to set it up from scratch again.

How To Set Up A Load Balanced MySQL 5 Cluster With Two Server Machines

This document is a how to for installing mysql 5 cluster with only two server machines. Our cluster combines two data nodes:two management nodes and two mysql nodes.
Every machine has 1 data node,1 management node, and 1 mysql server.

To avoid network problems between our internet connection, switches,etc, we networked the two machines with dual switch connection and one crossover cable between them.
The mysql cluster will communicate using the crossover cable, just to be sure that there will be no network problems (except from the crossover cable link).

To communicate with the mysql we will use a shared ip, which will be available with linux ha , so the mysql clients will connect to that ip. and have 99.999999% uptime.

This is an expirimental guide, that i used on my own, and didn't find any workaround like this on the web. So, before use it, test it for yourself and if it works good for you then use it.

Testing PHP/MySQL Applications with PHPUnit/DbUnit

In the last decade, PHP has developed from a niche language for adding dynamic functionality to small websites to a powerful tool making strong inroads into large-scale Web systems. Critical business logic like this needs to work correctly. But how do you ensure that it does? You test it, of course.

MySQL 6 will be fully open source

MySQL AB, property of Sun Microsystems, reversed its decision about releasing advanced MySQL 6 features under a closed source license. Last month it was announced that the upcoming version of the widely used database server would not contain certain closed source encryption and compression backup extensions. Reportedly, those would be included only in a paid enterprise version. Now, according to a blog post at mysql.com, the decision has been reversed and MySQL will remain fully open source.

How to move your MySQL database directory to a second Hard Drive

If you have a dedicated server with a second Hard Drive then you can often achieve better performance (reduce io wait issues) if you move your MySQL databases to the second Hard Drive.

(more...)

How to make multiple updates using a single query in MySQL

Nice tutorial.

MySQL Backups Using ZRM For MySQL 2.0

Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. Significant features are:

• Schedule full and incremental logical or raw backups of your MySQL database

• Centralized backup management

• Perform backup that is the best match for your storage engine and your MySQL configuration

• Get e-mail notification about status of your backups

• Monitor and obtain reports about your backups (including RSS feeds)

• Verify your backup images

• Compress and encrypt your backup images

• Implement Site or Application specific backup policies

• Recover database easily to any point in time or to any particular database event

• Custom plugins to tailor MySQL backups to your environment

• MySQL backup using Linux LVM and Solaris ZFS snapshots

(more...)

Back Up and Restore Your MySQL Database

Do you need to change your web host or switch your database server? This is probably the only time when you really think of backing up your MySQL data. If you’ve got a website with a database or your custom database running for your applications, it is imperative that you make regular backups of the database. In this article, I will outline two easy ways of backing up and restoring databases in MySQL.

Searching With Php And Mysql Beyond Like

Ever wanted to add a search feature to your php & MySQL driven web site? Then your in luck this tutorial shows you how!

Automatically backup your mysql databases daily

This script will not only backup all the databases on your server once a day, but it will also optimize/repair them -- and to keep things clean, it gzips the backups and automatically deletes any backups that are more than 3 days old. You must have the root mysql password in order to use this particular script, though.

Lighttpd Webserver setup with php5 and Mysql support

Security, speed, compliance, and flexibility — all of these describe lighttpd (pron. lighty) which is rapidly redefining efficiency of a webserver; as it is designed and optimized for high performance environments. With a small memory footprint compared to other web-servers, effective management of the cpu-load, and advanced feature set (FastCGI, SCGI, Auth, Output-Compression, URL-Rewriting and many more) lighttpd is the perfect solution for every server that is suffering load problems. And best of all it’s Open Source licensed under the revised BSD license.

(more....)