Linux Tutorials on the topic “mysql”
-
Sphinx As MySQL Storage Engine (SphinxSE)
Author: grungy •
Tags: centos, debian, mysql •
Comments: 9 Sphinx As MySQL Storage Engine (SphinxSE) SphinX is a great full-text search engine for MySQL. Installing the Sphinx daemon was straightforward as you can compile it from the source or use a .DEB/.RPM package but SphinxSE was a little bit tricky since it needed to be installed as a plugin on a running MySQL server. So if you use Debian or Centos and install your MySQL from a .deb or .rpm package this is how you do it.
-
Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Fedora 18
Author: Falko Timme •
Tags: fedora, mysql, nginx, php, web server •
Comments: 1 Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Fedora 18 Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Fedora 18 server with PHP5 support (through PHP-FPM) and MySQL support.
-
How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10
Author: Falko Timme •
Tags: backup, mysql, ubuntu •
Comments: 0 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.
-
-
How To Install Percona Server 5.5 On Ubuntu 12.10
Author: Falko Timme •
Tags: mysql, ubuntu •
Comments: 4 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.
-
How To Install MySQL 5.6 On Ubuntu 12.10 (Including memcached Plugin)
Author: Falko Timme •
Tags: mysql, ubuntu •
Comments: 9 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.
-
Remote MySQL Performance And Query Monitoring
Author: gbi •
Tags: linux, mysql •
Comments: 0 Remote MySQL Performance and Query Monitoring There may be the situation that you have to monitor a MySQL server remotely. There are some linux tools to do performance and query monitoring locally, and these tools can also used to monitor remotely - but only unencrypted ! Also often MySQL is only listening on the loopback interface, so it is even not reachable remotely over the net (which is very good seen from the security viewpoint). But there is an easy solution in the Linux world.
-
Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 12.10
Author: Falko Timme •
Tags: mysql, nginx, php, ubuntu, web server •
Comments: 5 Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 12.10 Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 12.10 server with PHP5 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP).
-
Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.10 (LAMP)
Author: Falko Timme •
Tags: apache, mysql, php, ubuntu, web server •
Comments: 2 Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.10 (LAMP) LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 12.10 server with PHP5 support (mod_php) and MySQL support.
-
Virtual Hosting With vsftpd And MySQL On Ubuntu 12.04
Author: Falko Timme •
Tags: ftp, mysql, ubuntu •
Comments: 5 Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine.
-
Configuring Your LEMP System (Linux, nginx, MySQL, PHP-FPM) For Maximum Performance
Author: Falko Timme •
Tags: mysql, nginx, php, web server •
Comments: 12 Configuring Your LEMP System (Linux, nginx, MySQL, PHP-FPM) For Maximum Performance If you are using nginx as your webserver, you are looking for a performance boost and better speed. nginx is fast by default, but you can optimize its performance and the performance of all parts (like PHP and MySQL) that work together with nginx. Here is a small, incomprehensive list of tips and tricks to configure your LEMP system (Linux, nginx, MySQL, PHP-FPM) for maximum performance. These tricks work for me, but your mileage may vary. Do not implement them all at once, but one by one and check what effect the modification has on your system's performance.
