ELASTRA is the world's first infinitely scalable solution for running standard relational databases in an on-demand computing cloud. ELASTRA's exclusive, high-performance S3DFS storage technologies enable a standard RDBMS to be deployed on Amazon's Elasti
Your WordPress database contains every post, every comment and every link you have on your blog. If your database gets erased or corrupted, you stand to lose everything you have written
Here are some of the best free MySQL tools out there. The description is not my review of the product, it is just what the developers say about their tools. If you know some other good ones, you can drop a comment.
WizzyWeb is a Web-based rapid application development (RAD) tool for creating PHP Web database applications for all popular databases, (e.g., MySQL, Oracle, SQL Server, Sybase, IBM, etc.)
MySQLPHPGrid puts data from a MySQL table in a configurable grid on a webpage. The grid supports sorting of columns, editing of cells, adding rows, deleting rows and pagination. You can display a full MySQL table, or just a subset of a table. MySQLPHPG
My own contribution is innotop, a MySQL and InnoDB monitor. As MySQL has become increasingly popular, InnoDB has become the most widely used transactional MySQL storage engine. InnoDB has many differences from other MySQL storage engines, so it requires d
You MUST have a third server as a managment node but this can be shut down after the cluster starts. Also note that I do not recommend shutting down the managment server (see the extra notes at the bottom of this document for more information). You can no
You may know about the MySQL Cluster, which is a complex architecture to achieve high availability and performance. One of the advantages of MySQL Cluster is that each node is a peer to the others, whereas in a normal replicating system you have a master
Replication FAQ. Q: How do I configure a slave if the master is running and I do not want to stop it? A: There are several possibilities. If you have taken a snapshot backup of the master at some point and recorded the binary log filename and offset (fr
Below are instructions on installing Confluence and supporting software (MySQL 5, Resin) on a Fedora or RHEL/Centos Linux system. Some seemingly little things here took many hours to figure out. Some of the information may not apply to you (e.g. my refere
MySQL Workbench is a database modeling tool for MySQL. You can use it to design and create new database schemas, document existing databases and even perform complex migrations to MySQL.
A collection of 10 FAQs on MySQL command-line interface mysql. Clear answers are provided with tutorial exercises on mysql command option; running SQL and mysql commands; running mysql command files in batch mode; returning query output in HTML and XML fo
For a faster "mysqldump" innodb tables 1. mysqldump --opt --user=username --password database > filetosaveto.sql 2. open the dump file put this statement at the beginning of the sql dump text file: SET FOREIGN_KEY_CHECKS=0; 3. mysql --user=usern
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 repl
Let's be honest, when most people start thinking about developing in PHP (or even ASP) their aim is to produce dynamic content drawn from a database, or provide a web interface to a database. There are of course other uses for PHP, but this would seem to
ActiveGrid's Application Server software, set for release in July, is designed to combine several individual servers running LAMP software to tackle demanding computing jobs. The company will give away a low-end product and charge for a more functional se
Freetag is an easy tagging and folksonomy-enabled plugin for use with MySQL-PHP applications. It allows you to create tags on existing database schemas, and access and manage your tags through a robust API.
LAMP has become a defacto-standard around the web community in the recent years, here is a guide to help you set it up. LAMP is the combination of Linux + Apache + MySQL + PHP. You probably already have Linux up if you have come this far, if not you can g
This page walks through the setup of Apache, PHP and MySQL on a Redhat (Fedora) Linux system. The installation is very similar on other Linux distributions. Also, since each package is open source they run almost every OS including Mac OS X and even Windo
This tutorial is designed to guide you through the initial steps of setting up Apache, MySQL, and PHP on Linux. The Linux distribution being utilized for this tutorial is Fedora Core 1, however the steps should be very similar across most distributions. T
Setting up a PHP 5 with Apache 2 and MySQL 4.1.3 PHP 5.0 has finally arrived. Here's a step-by-step guide to setting up a cutting-edge Web development environment with PHP 5.0, Apache 2.0, and MySQL 4.1.3.
This document will walk you through the installation of what is known as a "LAMP" system: Linux, Apache, MySQL and PHP. Depending on who you talk to, the P also stands for Perl or Python, but in general, it is assumed to be PHP. I run CentOS on my servers
This is a detailed description how to set up a CentOS 4.3 based server that offers all services needed by ISPs and hosters (web server (SSL-capable), mail server (with SMTP-AUTH and TLS!), DNS server, FTP server, MySQL server, POP3/IMAP, Quota, Firewall,
This document will walk you through the installation of what is known as a "LAMP" system: Linux, Apache, MySQL and PHP. Depending on who you talk to, the P also stands for Perl or Python, but in general, it is assumed to be PHP. I run CentOS on my servers
This page walks through the setup of Apache, PHP and MySQL on a Redhat (Fedora) Linux system. The installation is very similar on other Linux distributions. Also, since each package is open source they run almost every OS including Mac OS X and even Windo
Simply exploding the acronym on a letter by letter basis gives us the following elements: * Linux * Apache Web server * MySQL database * Perl, Python, or PHP
This document will walk you through the installation of what is known as a "LAMP" system: Linux, Apache, MySQL and PHP. Depending on who you talk to, the P also stands for Perl or Python, but in general, it is assumed to be PHP. I run CentOS on my servers
# Simple upload-and-use design ( No need for setup on most servers! ) # Config file or session based login # Multiple server support # View multiple databases # View table status # CREATE, DROP, EMPTY, and OPTIMIZE multiple tables # VIEW, EDIT, and
Simple Machines Forum - SMF in short - is a free, professional grade software package that allows you to set up your own online community within minutes. Its powerful custom made template engine puts you in full control of the lay-out of your message boar
If you're lucky, your current Web host may already have installed MySQL and PHP on your Web server. If that's the case, much of this chapter will not apply to you, and you can skip straight to the section called "If Your Web Host Provides PHP and MySQL" t
Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own cms [1]: there will be a moment that you’ll want to store hierarchical data in a database. And, unless you’re using a XML [2]-like da
What makes Flickr interesting as an online application is it’s use of RSS, among other things, and how that in turn enables social networking. Although the term “social networking” is currently a buzzword, what Flickr and del.icio.us have achieved,
?> The first thing that I like to do is move all of my connection information out of the main script and into a small include file. This way when I change the password for the database I don't have to go and edit every script that connects to that databas
10 Tips That Every PHP Newbie Should Know Jeffery Vaska I wish I had known these 10 tips the day I started working with PHP. Instead of learning them through painstaking process, I could have been on my way to becoming a PHP programmer even sooner! This a
phpMyEdit generates PHP code for displaying/editing MySQL tables in HTML. All you need to do is to write a simple calling program (a utility to do this is included). It includes a huge set of table manipulation functions (record addition, change, view, co
PHP has always been ahead of the curve when it comes to supporting new technologies - and XML is no exception. Early versions of PHP came with basic XML support built in; newer versions improved on this by adding support for new XML protocols and technolo