Linux Tutorials on the topic “mysql”

• Script To Check If MySQL Master Master Replication Is Working Correctly

  Author: marchost • Tags: mysql • Comments: 5

  Script To Check If MySQL Master Master Replication Is Working Correctly This short article explains how you can use a short script to check whether your MySQL master master replication is working as expected or not.

  read more... | view as pdf

• Tuning MySQL Performance with MySQLTuner

  Author: Falko Timme • Tags: mysql • Comments: 13

  Tuning MySQL Performance with MySQLTuner MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers, gives recommendations which variables you should adjust in order to increase performance. That way, you can tune your my.cnf file to tease out the last bit of performance from your MySQL server and make it work more efficiently.

  read more... | view as pdf

• Installing Lighttpd With PHP5 And MySQL Support On Debian Etch

  Author: Falko Timme • Tags: debian, lighttpd, mysql, php • Comments: 15

  Installing Lighttpd With PHP5 And MySQL Support On Debian Etch Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Debian Etch server with PHP5 support (through FastCGI) and MySQL support.

  read more... | view as pdf

• Apache2: Logging To A MySQL Database With mod_log_sql (Debian Etch)

  Author: Falko Timme • Tags: apache, mysql, debian • Comments: 5

  Apache2: Logging To A MySQL Database With mod_log_sql (Debian Etch) This guide shows how you can write the Apache2 access log to a MySQL database instead of a file. To achieve this, I use the Apache2 module mod_log_sql. I'm using a Debian Etch server in this tutorial.

  read more... | view as pdf

• Installing MySQL Proxy On CentOS 5 (FINAL) x86_64

  Author: [email protected] • Tags: centos, mysql • Comments: 0

  Installing MySQL Proxy On CentOS 5 (FINAL) x86_64 This tutorial explains how you can install MySQL Proxy on a CentOS 5 (x86_64) system. MySQL Proxy is a simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication. Its flexibility allows for unlimited uses; common ones include: load balancing; failover; query analysis; query filtering and modification; and many more.

  read more... | view as pdf

• How To Set Up WebDAV With MySQL Authentication On Apache2 (Debian Etch)

  Author: Falko Timme • Tags: apache, debian, mysql • Comments: 2

  How To Set Up WebDAV With MySQL Authentication On Apache2 (Debian Etch) This guide explains how to set up WebDAV with MySQL authentication (using mod_auth_mysql) on Apache2 on a Debian Etch server. WebDAV stands for Web-based Distributed Authoring and Versioning and is a set of extensions to the HTTP protocol that allow users to directly edit files on the Apache server so that they do not need to be downloaded/uploaded via FTP. Of course, WebDAV can also be used to upload and download files.

  read more... | view as pdf

• Quick 'n' Easy LAMP Server For CentOS/RHEL

  Author: olddocks • Tags: apache, centos, mysql, php • Comments: 27

  Quick 'n' Easy LAMP Server For CentOS/RHEL This tutorial shows a quick way of installing a LAMP server (Linux + Apache + MySQL + PHP/Perl together commonly known as LAMP Server.) on CentOS and RHEL server systems.

  read more... | view as pdf

• Running MySQL 4 And MySQL 5 Concurrently

  Author: diademsa • Tags: mysql • Comments: 0

  Running MySQL 4 And MySQL 5 Concurrently This tutorial shows how to install MySQL 5 on a system where MySQL 4 is already running. It also shows how to configure phpMyAdmin to use both databases.

  read more... | view as pdf

• MySQL Backups Using ZRM For MySQL 2.0

  Author: paddy • Tags: backup, debian, mysql • Comments: 0

  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.

  read more... | view as pdf

• Master-Master Replication With MySQL 5 On Fedora 8

  Author: o.meyer • Tags: fedora, high-availability, mysql • Comments: 3

  Master-Master Replication With MySQL 5 On Fedora 8 This document describes how to set up master-master replication with MySQL 5 on Fedora 8. 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.

  read more... | view as pdf