Mysql: Recently Popular Faves

Fighting MySQL Replication Lag | MySQL Performance Blog

mohit — Wed, 24 Sep 2008 13:54:46 GMT

There are some helpful tips in here, whether or not you use replication. In my experience, the most important thing with database performance is to minimize the time and row range over which you hold write locks -- and that's what this post is essentially about.

Quoted: Piping data through application is the best solution in many cases and is quite easy - it is trivial to write the function which will take SELECT query and the table to which store its result set and use in your application in all cases when you need this functionality.

Comment at Faves | View original page

MySQL :: MySQL 5.1 Downloads — Generally Available (GA) release for production use

mike — Fri, 15 May 2009 05:09:19 GMT

5.1 is the current production release of MySQL

Comment at Faves | View original page

Querious - MySQL Database Tool

guido — Sun, 22 Feb 2009 19:07:10 GMT

Comment at Faves | View original page

Virtual Hosting With vsftpd And MySQL On Debian Etch | HowtoForge - Linux Howtos and Tutorials

falko — Tue, 26 Jun 2007 09:54:22 GMT

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.

Comment at Faves | View original page

Full Mail Server Solution w/ Virtual Domains & Users (Debian Etch, Postfix, Mysql, Dovecot, DSpam, ClamAV, Postgrey, RBL) | HowtoForge - Linux Howtos and Tutorials

falko — Wed, 31 Oct 2007 09:57:27 GMT

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.

Comment at Faves | View original page

Virtual Users And Domains With Postfix, Courier And MySQL (Fedora 8) | HowtoForge - Linux Howtos and Tutorials

falko — Tue, 20 Nov 2007 10:53:35 GMT

This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I will also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses. The resulting Postfix server is capable of SMTP-AUTH and TLS and quota (quota is not built into Postfix by default, I will show how to patch your Postfix appropriately). Passwords are stored in encrypted form in the database (most documents I found were dealing with plain text passwords which is a security risk). In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV so that emails will be scanned for spam and viruses.

Comment at Faves | View original page

Ge-DALe：ジェダール　～名刺/チラシ/カタログ制作を自動組版で効率化！InDesign/Illustrator/QuarkXPress対応～

ketchup — Mon, 28 Jul 2008 15:14:01 GMT

Quoted: ジェダールは、CSV／TSV（タブテキスト）／FileMaker Pro／Microsoft Excel／MySQL／PostgreSQLなどの幅広いデータソースから、Adobe InDesign／Adobe Illustrator／QuarkXPressなどの各種DTPソフトやHTMLファイルへの自動組版を実現するソフトウェアです。

Comment at Faves | View original page

The Perfect Server - Mandriva 2008 Free (Mandriva 2008.0) | HowtoForge - Linux Howtos and Tutorials

falko — Wed, 10 Oct 2007 15:43:19 GMT

This is a detailed description about how to set up a Mandriva 2008 Free (Mandriva 2008.0) server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Courier POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 32-bit version of Mandriva 2008, but should apply to the 64-bit version with very little modifications as well.

Comment at Faves | View original page

How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1 | HowtoForge - Linux Howtos and Tutorials

falko — Tue, 17 Jun 2008 09:53:41 GMT

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).

Comment at Faves | View original page

Facebook | Engineering @ Facebook's Notes

derek — Thu, 21 Aug 2008 16:43:44 GMT

Interesting writeup of hacking MySQL to dirty memcached entries after replication sync.

Quoted: REPLACE INTO profile (`first_name`) VALUES ('Monkey') WHERE `user_id`='jsobel' MEMCACHE_DIRTY 'jsobel:first_name'

Faves Comments: 2 | View original page

Mysql: Recently Popular Faves

Fighting MySQL Replication Lag | MySQL Performance Blog

MySQL :: MySQL 5.1 Downloads — Generally Available (GA) release for production use

Querious - MySQL Database Tool

Virtual Hosting With vsftpd And MySQL On Debian Etch | HowtoForge - Linux Howtos and Tutorials

Full Mail Server Solution w/ Virtual Domains & Users (Debian Etch, Postfix, Mysql, Dovecot, DSpam, ClamAV, Postgrey, RBL) | HowtoForge - Linux Howtos and Tutorials

Virtual Users And Domains With Postfix, Courier And MySQL (Fedora 8) | HowtoForge - Linux Howtos and Tutorials

Ge-DALe：ジェダール ～名刺/チラシ/カタログ制作を自動組版で効率化！InDesign/Illustrator/QuarkXPress対応～

The Perfect Server - Mandriva 2008 Free (Mandriva 2008.0) | HowtoForge - Linux Howtos and Tutorials

How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1 | HowtoForge - Linux Howtos and Tutorials

Facebook | Engineering @ Facebook's Notes

Ge-DALe：ジェダール　～名刺/チラシ/カタログ制作を自動組版で効率化！InDesign/Illustrator/QuarkXPress対応～