Go back to fronty page View most popular entries View latest additions Submit tutorials to UnixTutorials.info
UnixTutorials logo

Search results for How To Back Up MySQL Databases Without Interrupting MySQL

Debian

Setting Up Master-Master Replication With MySQL 5 On Debian Etch

Post date: October 25, 2007, 11:10 Category: Miscellaneous Views: 3194 Comments
Tutorial quote: 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 do not 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.
Linux

Clone/Back Up/Restore OpenVZ VMs With vzdump

Post date: November 25, 2008, 11:11 Category: Miscellaneous Views: 3842 Comments
Tutorial quote: vzdump is a backup and restore utility for OpenVZ VMs. This tutorial shows how you can use it to clone/back up/restore virtual machines with vzdump.
Debian

Installing PowerDNS (With MySQL Backend) And Poweradmin On Debian Lenny

Post date: July 11, 2010, 22:07 Category: Installing Views: 3280 Comments
Tutorial quote: This article shows how you can install the PowerDNS nameserver (with MySQL backend) and the Poweradmin control panel for PowerDNS on a Debian Lenny system. PowerDNS is a high-performance, authoritative-only nameserver - in the setup described here it will read the DNS records from a MySQL database (similar to MyDNS), although other backends such as PostgreSQL are supported as well. Poweradmin is a web-based control panel for PowerDNS.
Debian

Installing PowerDNS (With MySQL Backend) And Poweradmin On Debian Etch

Post date: January 20, 2009, 11:01 Category: Installing Views: 3448 Comments
Tutorial quote: This article shows how you can install the PowerDNS nameserver (with MySQL backend) and the Poweradmin control panel for PowerDNS on a Debian Etch system. PowerDNS is a high-performance, authoritative-only nameserver - in the setup described here it will read the DNS records from a MySQL database (similar to MyDNS), although other backends such as PostgreSQL are supported as well. Poweradmin is a web-based control panel for PowerDNS.
Ubuntu

Intrusion Detection: Snort, Base, MySQL, and Apache2 On Ubuntu 7.10 (Gutsy Gibbon)

Post date: November 21, 2007, 10:11 Category: Security Views: 4910 Comments
Tutorial quote: In this tutorial I will describe how to install and configure Snort (an intrusion detection system (IDS)) from source, BASE (Basic Analysis and Security Engine), MySQL, and Apache2 on Ubuntu 7.10 (Gutsy Gibbon). Snort will assist you in monitoring your network and alert you about possible threats. Snort will output its log files to a MySQL database which BASE will use to display a graphical interface in a web browser.
Linux

MySQLTuner - Performance Tunning MySQL on Linux

Post date: January 24, 2010, 06:01 Category: Optimizing Views: 4372 Comments
Tutorial quote: MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.
CloneZilla

Back Up/Restore Hard Drives And Partitions With CloneZilla Live

Post date: November 30, 2008, 13:11 Category: Miscellaneous Views: 10126 Comments
Tutorial quote: This tutorial shows how you can back up and restore hard drives and partitions with CloneZilla Live. CloneZilla Live is a Linux Live-CD that you insert into your computer; it contains hard disk and partition imaging and cloning tools similar to Norton Ghost. The created images are compressed and can be transferred to a Samba-, SSH-, or NFS server or to a local hard drive or USB drive.
Unix+clones

Resetting a forgotten MySQL root password

Post date: October 2, 2006, 09:10 Category: Security Views: 4657 Comments
Tutorial quote: Resetting the root password of a MySQL database is trivial if you know the current password if you don't it is a little tricker. Thankfully it isn't too difficult to fix, and here we'll show one possible way of doing so.
Debian

Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Debian Etch)

Post date: August 19, 2008, 10:08 Category: Software Views: 3184 Comments
Tutorial quote: This guide explains how you can create advanced virtual hosts on a lighttpd web server on Debian Etch that are stored in a MySQL database. The method described here does not use the lighttpd mod_mysql_vhost module, and unlike mod_mysql_vhost (which allows you to store only the hostname and document root of a vhost in a database), this method allows to store individual configuration directives for each vhost in the MySQL database.
Unix+clones

High Performance MySQL

Post date: December 1, 2006, 04:12 Category: Optimizing Views: 5860 Comments
Tutorial quote: The operating system your MySQL server runs on and the server's configuration can be just as important to your server's performance as the indexes, schema, or queries themselves. In this chapter, we will help you understand how to tune your server to improve performance, as opposed to tuning schema or queries. We'll be looking at changes to your hardware, operating system, and MySQL configuration to see what effects they have on overall performance.

We assume that you've already made efforts to boost the performance of your queries. If you haven't done that already, stop now and read Chapter 4 and Chapter 5 to get a handle on optimizing your queries and your application code. Only then should you worry about server settings. Hardware is often not the solution to MySQL performance problems. Poorly optimized queries can slow you down far more than not having the latest CPU or SCSI disk. To put this in perspective, one of the MySQL AB trainers even says that changing hardware might, in the best cases, give you a 10-fold performance increase. But tuning queries (and schemas) can often give you 1000-fold performance increase. Seriously.

Some topics covered in this chapter are platform-specific. The authors' knowledge of the various platforms on which MySQL runs is limited. In many cases, you'll need to consult your local documentation for various operating system tools and specifics.

We start with an overview of the factors that limit performance and then look more in depth at RAID, hardware, and operating system issues. The chapter finishes with a discussion of techniques you can use to locate, identify, and fix bottlenecks.
Web-based applications and online marketing solutions - LumoLink