http://netvouz.com/falko/tag/mysql?feed=rss&pg=1 falko's bookmarks tagged "mysql" on Netvouz http://www.howtoforge.com/groupware-server-with-group-office-postfix-dovecot-spamassassin-on-debian-lenny In this howto I will explain how you can set up a groupware server using the Debian Linux operating system, Group-Office for managing the mailboxes and groupware functions like e-mail, shared calendars, file sharing etc., Postfix with virtual accounts in MySQL, Dovecot IMAP, SpamAssassin spam filter, and a vacation perl script that will handle out-of-office replies. falko Thu, 26 Feb 2009 13:11:37 GMT http://www.howtoforge.com/how-to-back-up-mysql-databases-with-mylvmbackup-on-ubuntu-12.10 mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on an Ubuntu 12.10 server. falko Tue, 15 Jan 2013 11:19:30 GMT http://www.howtoforge.com/back_up_mysql_dbs_without_interruptions 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 do not 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. falko Mon, 14 May 2007 09:54:57 GMT http://www.howtoforge.com/how-to-benchmark-your-system-cpu-file-io-mysql-with-sysbench sysbench is a benchmark suite which allows you to quickly get an impression about system performance which is important if you plan to run a database under intensive load. This article explains how to benchmark your CPU, file IO, and MySQL performance with sysbench. falko Sun, 22 Jul 2012 10:20:14 GMT http://www.howtoforge.com/lemp_nginx_mysql_php_ubuntu_debian This HowTo will describe the setup of an efficient http server and mail server for small or medium configurations (as low as 96 mb). Why LEMP instead of LAMP? NGINX is a great replacement for Apache with very low memory footprint and great stability. falko Fri, 19 Oct 2007 09:39:57 GMT http://www.howtoforge.com/how-to-install-mysql-5.6-on-ubuntu-12.10-including-memcached-plugin According to What's New in MySQL 5.6, MySQL 5.6 will bring some performance improvements over MySQL 5.5. If you want to test out MySQL 5.6, you have to install one of the development releases from the MySQL downloads page because there is no stable release yet. This tutorial explains how to install the MySQL 5.6.8rc1 (Linux Generic) development release on an Ubuntu 12.10 server. falko Tue, 20 Nov 2012 11:09:10 GMT http://www.howtoforge.com/how-to-install-percona-server-5.5-on-ubuntu-12.10 Percona Server is a drop-in replacement for MySQL. It offers more performance and scalability than the default MySQL server coming with your Linux distribution, while it uses the same init scripts and command line tools which makes it easy to use. This tutorial explains how to install Percona Server 5.5 on Ubuntu 12.10. falko Thu, 10 Jan 2013 12:39:46 GMT http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-mysql5.1 This tutorial 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). falko Tue, 17 Jun 2008 09:52:40 GMT http://www.howtoforge.com/how-to-set-up-database-replication-in-mysql-on-ubuntu-9.10 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. falko Tue, 12 Jan 2010 13:00:23 GMT http://www.howtoforge.com/how-to-set-up-mysql-database-replication-with-ssl-encryption-on-centos-5.4 This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). 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. falko Thu, 18 Feb 2010 13:41:56 GMT