- Web Server
- Control Panels
- Site Map/RSS Feeds
How To Back Up MySQL Databases Without Interrupting MySQL
This article describes how you can back up MySQL databases without interrupting the MySQL service. Normally, when you want to create a MySQL backup, you either have to stop MySQL or issue a read lock on your MySQL tables in order to get a correct backup; if you don't do it this way, you can end up with an inconsistent backup. To get consistent backups without interrupting MySQL, I use a little trick: I replicate my MySQL database to a second MySQL server, and on the second MySQL server I use a cron job that creates regular backups of the replicated database.
How To Install KnowledgebasePublisher On Your Site
This is a step-by-step tutorial on installation of KnowledgebasePublisher, an opensource knowledge base, FAQ script that you can install on your web site.
Custom Monitoring MySQL and SNMP with BixData
With BixData you can monitor your servers as well as VMware and Xen. BixData includes pre-built plugins for things like CPU, Memory, Disk, etc. but any good monitoring tool needs to be customizable. BixData includes the basic ability to run scripts and record their exit values, similar to Nagios Plugins. BixData 2.7 adds support for importing data in more complex formats. This allows you to monitor almost anything. I'll go through the steps showing you how to monitor MySQL locally where an agent is installed and then the steps to monitor a device remotely through SNMP. The advantage of BixData is that any data available through a BixAgent works with the standard tools such as the situation room, scoreboards, notifications and the reporting system. All data are stored in standard SQL tables and are easily accessible.
How To Set Up A Ubuntu/Debian LAMP Server
This tutorial shows a quick way to set up your own LAMP server (Linux + Apache + MySQL + PHP/Perl) on a Ubuntu or Debian system.
Securing the connection between MySQL and MySQL Administrator using an SSH tunnel
This is a description of how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty. By creating a secure tunnel to your MySQL server using Putty, you can grant localhost access to powerful applications like MySQL Administrator while at the same time, make your server appear as if it isn't even there. In effect, make your MySQL server disappear from the outside world.
How to perform a point in time restoration using ZRM for MySQL
ZRM for MySQL is a powerful, flexible and robust backup and recovery solution for MySQL databases for all storage engines. With ZRM for MySQL a Database Administrator can automate logical or raw backup to a local or remote disk. In this How To, we attempt to explain how to recover from an user error at any given point in time.
MySQL Backup And Recovery With mysql-zrm On Debian Sarge
This guide describes how to back up and recover your MySQL databases with mysql-zrm on a Debian Sarge system. mysql-zrm is short for Zmanda Recovery Manager for MySQL, it is a new tool that lets you create full logical or raw backups of your databases (regardless of your storage engine and MySQL configuration), generate reports about the backups, verify the integrity of the backups, and recover your databases. It can also send email notifcations about the backup status, and you can implement multiple backup policies (based on your applications and based on time (e.g. daily, weekly, etc.)).
MySQL Master Master Repliction Tutorial
This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the first one goes up again, it will still be used as slave for the live one.
This How To explain the replication in MySQL on the same machine.
You have large hits, with database driven site and performance, redundancy, security now comes in mind. DBA is now input by many fingers to seek some good solution to make happy faces. So here comes words like Cluster, Replication, Backup, Fail Over and others. So what these are? We currently discuss Replication in terms of a web based database driven site for large hits.
How To Set Up A Load-Balanced MySQL Cluster
This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node. This cluster is load-balanced by a high-availability load balancer that in fact has two nodes that use the 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).