Linux Tutorials on the topic “mysql”
-
How To Install MySQL 4.1 And PHP4 On Debian Etch
Author: Falko Timme • Tags: php, mysql, debian • Comments: 0How To Install MySQL 4.1 And PHP4 On Debian Etch MySQL 4 and PHP 4 are quite old, but you might have PHP applications on your server that require PHP4 and MySQL 4. The problem is that Debian Etch comes with MySQL 5 only, and its PHP4 packages depend on MySQL 5 and don't work with MySQL 4. This guide shows how you can install MySQL 4.1 on Debian Etch along with PHP4 packages that work with MySQL 4.1.
-
Getting MySQL Status Values With mysqlreport
Author: Falko Timme • Tags: mysql • Comments: 0Getting MySQL Status Values With mysqlreport mysqlreport is a Perl script that displays a well-formatted report of important MySQL status variables (taken from MySQL's SHOW STATUS; output) that can help you gain an understanding of what is happening under MySQL's hood. It can help diagnose problems.
-
How To Set Up Database Replication In MySQL
Author: Falko Timme • Tags: mysql, high-availability • Comments: 61How To Set Up Database Replication In MySQL This tutorial describes how to set up database replication in MySQL. 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. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.
-
-
How To Set Up A Load-Balanced MySQL Cluster
Author: Falko Timme • Tags: mysql, high-availability • Comments: 23How 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).
-
How To Back Up MySQL Databases Without Interrupting MySQL
Author: Falko Timme • Tags: mysql, backup, high-availability • Comments: 10How 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.
-
Setting Up Master-Master Replication With MySQL 5 On Debian Etch
Author: Falko Timme •
Tags: debian, high-availability, mysql •
Comments: 6 Setting Up Master-Master Replication With MySQL 5 On Debian Etch Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you don't have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master.
-
Full Mail Server Solution w/ Virtual Domains & Users (Debian Etch, Postfix, Mysql, Dovecot, DSpam, ClamAV, Postgrey, RBL)
Author: Vecter • Tags: antivirus, debian, mysql, postfix, security • Comments: 5Full Mail Server Solution w/ Virtual Domains & Users (Debian Etch, Postfix, MySQL, DoveCot, DSpam, ClamAV, Postgrey, RBL) This guide describes how to set up a full email solution in Debian Linux (all code is from Debian Etch). I was asked to design a secure, scalable, portable solution for a small company. While the guide references many 'servers', the company only had 4 physical machines, Xen was used to virtualize the entire solution. That particular aspect of the system is not discussed in this guide, although I will try to get it into the next revision.
-
Have Your Own (Chrooted) Debian LAMP Server While Running The Perfect Ubuntu Desktop
Author: the_g_bomb • Tags: apache, debian, mysql, php, ubuntu • Comments: 0Have Your Own (Chrooted) Debian LAMP Server While Running The Perfect Ubuntu Desktop This is a brief description about the steps to be taken to setup a Debian based Webserver (Debian Sarge alias Debian 3.1) that will run chrooted under Ubuntu 7.04.
-
MySQL Master Master Replication
Author: sheikhsa • Tags: mysql • Comments: 45MySQL 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.
-
How To Install KnowledgebasePublisher On Your Site
Author: sridhar • Tags: mysql, php • Comments: 1How 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.
