mysql

The page provides an index to the how-to videos provided for your review.

1) Master-Master Replication with MySQL

This video conveys just how easy it is to establish Master-Master Replication with MySQL on Microsoft Windows.

2) Secure FTP Server over SSL using FileZilla

This video demonstrates the simplicity with which a Secure FTP Server over SSL can be established using the FREE FileZilla FTP Server.

The following are demo versions or proofs of concept of the ideas outlined in a number of my scripts and projects contained within this site.

All of these web applications will be made Open Source during 2010 and the source code will be made available on this site, in addition to which a forum will be established for the exchange of ideas in support of future enhancements to these projects either by myself or the Open Source community at large.

Stay tuned for this release!

1). Multi or Two Factor Authentication Demo
This solution provides a web-based two-factor or multi-factor (something you know plus something you have) proof of concept using a very low-tech solution much stronger than the traditional token-based variants. Further details are available on the demo site.

2). Dinofile - Secure File Server
This solution provides a web-based secure file transfer and storage system where files are transmitted over SSL and stored in an encrypted (256-bit AES) format on a non web accessible partition.

3). Ad Serving Solution
This solution provides for an Advertisement Serving solution similar in operation to that provided by the largest online agencies.

The script that follows provides for an example way to use PHP to connect to a MySQL database through the use of a PHP Function.

The code that follows I will call db.php


<?php
function connect($sql)
{
// The following values should all be adjusted to suit your MySQL install.
$host="localhost";
$user="root";
$pass="password";
$db="users";
if(!($connect=mysql_connect($host,$user,$pass))){
printf("Error connecting to the database");
email_error("Server Connection Error", mysql_error());
}
if(!($dbselect = mysql_select_db($db, $connect))){
printf("<p>Error connecting to the database</p>");
email_error("Database Connection Error", mysql_error());
}
$result=mysql_query($sql);
if (mysql_errno() == 0){
return $result;
}
else {

In establishing a high-availability web application you need to consider multiple levels of availability and redundancy.

In this first installment discussing MySQL replication I am referring to omni-directional replication. In my follow-up on the subject, next week, we will be covering bi-directional replication or creating what is otherwise known as multi-master replication, and yes I am doing this on Microsoft Windows.