PUBLIC MARKS from camel with tag database

CMON is a daemon that aggregates information from MySQL Cluster that earlier was only accessible from the cluster log or the management client, such as: * cluster state * node state * backup statistics * statistics * cluster events (cluster log basically) .. and let's you access the information using SQL, because CMON logs the information into ordinary MYISAM tables! So, it is really easy to use! In the package you also get get php scripts that you can put on your webserver to generate graphs and get a www interface to CMON. CMON can also start ndbd nodes and make decisions on how they should be started (with or without --initial). CMON starts as a daemon and will automatically create cmon database and install the necessary tables automatically.

Open source OpenInviter (Open Inviter) is an free import contacts (addressbook) script from email providers like Lycos, GMX.net, Rediff, IndiaTimes, KataMail, AOL, OperaMail, Yandex, Terra, Rambler, Mail.com, Mynet.com, Yahoo!, Inbox.com, GMail, Libero, Mail.ru, Live/Hotmail, FastMail or social portals like Flickr, LinkedIn, Twitter, Bebo, Friendster, Facebook, Last.fm, Hi5, MySpace, Flixster, Perfspot, Orkut, Skyrock. This contacts importer script is integrating with content management systems (aka CMS) like Joomla, JamRoom, Drupal, SimpleMachines Forum (SMF), Wordpress, Social Engine, PunBB, Joomla1.0, PhpBB. Open Inviter is written in PHP 5 (no database required but cURL or wget required) and running on any webserver (tested on Apache) offering advanced tell a friend features. OpenInviter is a free self hosted solution that does not use a third party gateway (or API) to import contacts. Sounds cool! How much? OpenInviter is totally free and open-source solution. You can download it, change it, write plugins for it. Everything for free. What are you waiting for? Grab your OpenInviter today! Go to the Download section now! Features at a glance * Easy access to your visitors address book in all major email providers and social networks around the world. * Completely painless and easy way of integrating in your website. It takes virtually not more than 5 minutes to have your own OpenInviter up and running on your site. * Constant updates so that you can sit back and relax and always have access to the latest ways to get your visitor's address book. * WGET-ready! Yes, you read right! OpenInviter is the only contacts importer supporting both WGET and cURL as methods of handling requests (since version 1.2) so now you can use it on ANY server you want without the hassle of installing libcurl! * Real time access to the service statuses so you can know if there is an email provider that is not working right with OpenInviter.

Would you like to create RSS feeds without ANY programming or technical knowledge at all? FeedFire will take virtually any web page and convert it into a fully formed and fully coded RSS feed. FeedFire is a sophisticated solution that is really simple to use. It is powerful, automated and customisable. You can easily turn ANY page into a RSS feed, without ANY programming. You can also search our large database of channels, which are conveniently categorised for you.

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. It’s key to remember that MySQLTuner is a script which can assist you with your server, but it is not the solution to a badly performing MySQL server. The best performance gains come from a thorough review of the queries sent to the server, and an evaluation of the MySQL server itself. A qualified developer in your application’s programming or scripting language should be able to work with a MySQL database administrator to find improvements for your server. Once the server and application are optimized well, you may need to consider hardware upgrades to the physical server itself. This is a really useful tool for helping to optimize MySQL performance.Understanding the various my.cnf variables and how they affect performance can seem really complicated but this tool takes some of the pain away and makes it easier to understand the effects of each variable.It is especially useful to be able to see the global memory usage, memory usage per thread and the maximum possible memory usage - that is really valuable information that is otherwise complex to calculate.

I'm pleased to present you with part one of a two part series on creating a photo site using PHP, jQuery, and AJAX. Originally, I intended to fit the entire tutorial into one screencast, but that quickly became a pipe dream as I realized that there was simply too much to cover. Nevertheless, even if you only watch this first video, you should learn a great deal. We'll be retrieving images from a database, creating a simple login form with authentication, and will then allow for our database to be asynchronously updated. Sounds good? If so, let's get into it.

GreenSQL (or greensql-fw) is a firewall for MySQL databases that filters SQL injection attacks. It works as a reverse proxy, i.e., it takes the SQL queries, checks them, passes them on to the MySQL database and delivers back the result from the MySQL database. It comes with a web interface (called greensql-console) so that you can manage GreenSQL through a web browser. This guide shows how you can install GreenSQL and its web interface on a Debian Etch server.

MAGIC-SMTPD is a drop in replacement for Dan Bernsteins qmail-smtpd, and was originally designed to be part of the LinuxMagic Magic Mail Server. This OpenSource version has been released to allow others to benefit from it's anti-spam components, and valid user checking to reduce server loads and spam volumes. It is designed to support stock qmail installations, qmail/vpopmail installations, as well as having database support. Designed for ISP service, this will work for all mail servers large and small. Comments are welcome. Support for other mailers is expected in the future. Complete support packages are also available.

After my last post on limiting bandwidth usage on a Xen node I thought I would follow up with how to monitor the bandwidth usage of a Xen node. I chose to use netacct-mysql to monitor bandwidth and store the results into a mysql database. This isn't the only way of monitoring the bandwidth but it was easy to set up and stores the information directly into mysql without needing any extra scripts. On the Xen setup I'm using for an example there are 3 nodes and a bucket for each node will be created in the mysql database by netacct. Setting up netacct can be tricky so you will want to check to make sure traffic for each node is going into the correct bucket.

You are not a Linux expert, Artica for Postfix allows you to install a full solution by one single command line: * Postfix: Main MTA * Kaspersky Anti-spam: powerfull Anti-spam provided by Kaspersky Inc * Kaspersky Anti-Virus * Bogofilter : Bayesian anti-spam * OpenLDAP: Database for main configuration and user management * emailrelay: little SMTP server (used as a content-filter) * SQLite library: zeroconf sql database engine with high perfomances. * Cyrus-imap: powerfull MDA System * Procmail: MDA Filter * Fetchmail: Email retreival * DnsMasq:DNS forwarder and DHCP server * Mailman:Mailing List manager * Sieve: End-user mail filters * Yorel script: Statistics of yorel * QueueGraph: Statistics for postfix * MailGraph: Statistics for postfix * AWSTats and geoip plugin: Statistics set for postfix * renattach: attachments filter

In this article, Prabhakar Chaganti will show us to create virtual appliances that perform one specific function. These appliances can be web servers, database servers or anything else that you can think of which is useful for your business. The key advantage with these appliances is the fact that they are mostly maintenance free, and can be started up and then used without going through any lengthy installation process. You can use these as needed for your testing and then dispose them off. You can also use them for staging environments or production environments, and you can even share them across the enterprise.

Spotlight® on MySQL diagnoses MySQL problems in real time by graphically displaying all database activity in an intuitive user interface, enabling you to respond quickly to issues that need attention. With Spotlight on MySQL, DBAs or developers running Windows can drill down to locate in-depth information on the source of a performance issue. And because the run-time nature of your MySQL databases is unique, Spotlight calibrates itself to a baseline of normal database activity. This allows Spotlight to automatically establish the speed of the internal flows and other activity indicators. When a threshold is met, Spotlight notifies you using a visual or audible alert. Spotlight on MySQL supports MySQL versions 5.0 or later that employ the InnoDB storage engine.

Apache Synapse offers a wide range of connectivity, including HTTP/S, JMS, (S)FTP, SOAP, WS-ReliableMessaging and WS-Security. The project has been designed to allow administrators to support advanced functionality such as load-balancing, throttling, and failover without writing code. The new Apache Synapse 1.1 release includes many enhancements based on feedback from users, including * Apache VFS based file transport - supports File System, FTP, SFTP, JAR, ZIP, TAR, GZIP, Mime * Scheduled Task support makes it simple to run repetitive tasks * XQuery mediator - simplifies XML transformation with the XQuery standard * POJO Command mediator - allows the creation of message-independent mediation logic * DB Report and DB Lookup mediators - support message augmentation and database logging * Cache and Throttle mediators/enhancements - improve performance and manage load on existing services * Split/Clone/Aggregate mediators - support batch processing of large messages * Improved logging and tracing support With asynchronous support for HTTP and HTTPS, Apache Synapse has very high scalability under load, supporting thousands of concurrent connections even with limited threads. Combined with streaming XML support, Apache Synapse has class-leading performance results. The Apache Synapse code and binaries are available from the website at http://ws.apache.org/synapse

GeoNames Data Access

ZRM for MySQL Community Edition is a freely downloadable version of ZRM for MySQL - the leading MySQL backup solution. It has been developed by Zmanda engineers with input from many Database and System Administrators who were looking for an easy-to-use yet enterprise-strength backup and recovery solution for MySQL. We expect to provide frequent updates to ZRM for MySQL, so please check back often.

capttofu: MySQL Multi-Master Replication

Domain Technologie Control (DTC) is a GPL control panel for hosting. Using a web GUI for admin and accounting all hosting services, DTC can delegate the task of creating subdomains, email, and FTP accounts to users for the domain names they own. DTC manages a MySQL database containing all the hosting information. It has support for many programs (bind 8 and 9 and compatibles, MySQL, Apache 1.3, php4, qmail, postfix 2, courier, dovecot, proftpd, webalizer, mod-log-sql, etc.) through config files and/or MySQL plugins (when the service is non-critical). It can also generate backup scripts, calculation scripts, and config files using a single system UID/GID and monitor all traffic accounting per user and per service. Since version 0.12, DTC is fully skinable and translated into several languages (Chinese, English, Spanish, French, Dutch, German, Italian, Russian, Hungarian, Romanian and Polish).

PhpDig is a web spider and search engine written in PHP, using a MySQL database and flat file support. PhpDig builds a glossary with words found in indexed pages. On a search query, it displays a result page containing the search keys, ranked by occurrence.

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

Collection of Perl scripts to aid in managing groups of Linux MySQL servers through the following means: - monitor replication - automate backups - ease upgrades - create single point of configurability for all servers

This document describes how to install a mail server based on Postfix that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses.

Database reporting tool from PostgreSQL, MySQL, SQLite, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase, or Frontbase.