public marks

PUBLIC MARKS from camel with tags mysql & application

December 2008

Server2Go - Self configurable WAMPP Stack

Server2Go is a Webserver that runs out of the box without any installation and on write protected media. This means that web applications based on Server2Go can be used directly from cdrom, a usb stick or from any folder on a hard disk without the hassle of configuring Apache, PHP or MySQL. Server2Go allows you to create a standalone working web site or PHP application on a CD-ROM. There are many examples of its possible useses such as catalogue software, calculation programmes, image campaigns (CMS-based), computer based training lessons or other applicatons. Most PHP-Software such as the content management system Joomla or the computer based training software Moodle can be used from CD-ROM with the help of Server2Go. Server2Go was developed in the first instance for use on CD-ROM but there is no problem in using it from other drives too. Using a web browser, a user can run php programs as well as view html files on the CD-ROM. He only needs to insert a CD with Server2Go. The server software starts automatically and a browser is opened with the Website of the CD-ROM. Server2Go was built in the first place to replace other CD-ROM webservers such as WampOnCD or Microweb that lacked some important features or are not being actively developed. Main Features * Free! No royalties * Complete WAMPP Server-Stack * Runs directly from CD-ROM, USB Stick or Hard disk without installation * Full featured webserver (based on apache) * PHP 5.x support with many extensions installed (e.g. gd) * Supports SQLite databases * Runs on all versions of Windows from Win 98 and above, MAC OSX support is coming * Support for MySQL 5 Databases * Supports many PHP extensions (GD-Lib, PDO...) by default * Support for Perl 5.8

November 2008

Check Your Mysql Server Performance with MySQLTuner -- Debian Admin

by 1 other
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.

September 2008

Installing Zivios Server On Ubuntu | HowtoForge - Linux Howtos and Tutorials

This howto explains installing Zivios Master Service version 0.5.0. Zivios is an n-tiered PHP-5 application, providing identity management, single sign-on, user, group and computer provisioning, as well as remote management of services. It uses MySQL and OpenLDAP as it's data store, with OpenLdap being the primary back end for identity management and application integration and MySQL being used for panel specific data.

April 2008

scalr - Google Code

by 3 others
Scalr is a fully redundant, self-curing and self-scaling hosting environment utilizing Amazon's EC2. It allows you to create server farms through a web-based interface using prebuilt AMI's for load balancers (pound or nginx), app servers (apache, others), databases (mysql master-slave, others), and a generic AMI to build on top of. The health of the farm is continuously monitored and maintained. When the Load Average on a type of node goes above a configurable threshold a new node is inserted into the farm to spread the load and the cluster is reconfigured. When a node crashes a new machine of that type is inserted into the farm to replace it. 4 AMI's are provided for load balancers, mysql databases, application servers, and a generic base image to customize. Scalr allows you to further customize each image, bundle the image and use that for future nodes that are inserted into the farm. You can make changes to one machine and use that for a specific type of node. New machines of this type will be brought online to meet current levels and the old machines are terminated one by one. The project is still very young, but we're hoping that by open sourcing it the AWS development community can turn this into a robust hosting platform and give users an alternative to the current fee based services available.

December 2006

Nexen.net : portail PHP et MySQL - Générateur de profils de tests

Fake Name Generator génère des fiches d'identitée complètes et crédibles, du point de vue des bases de données. Nom, prénom, carte visa, adresse, téléphone, code postal, en fonction de la langue, du pays (format) et du pays (identité). Ces informations, totalement inventées, sont très utiles pour réaliser des tests d'interface, avec des valeurs crédibles, mais inventée.