Setup Mail Server on Two Ubuntu Servers with MySQL Replication

This project is fairly straight forward: we are setting up redundancy for an eCommerce site. The site itself is a PHP / MySQL based site and currently hosted on a VPS. The secondary server will also be a VPS at a geographically different location (and on a different class C network). Here are the tasks required for the job:

1. Setup an email server on BOTH systems according to this document: ([url removed, login to view]). Integrate spam assassin to reduce / eliminate spam. Setup the SPF records for the domain associated with this project.

2. Setup the MX records so that mail will roll over from the primary server to the secondary server in case the primary server goes down.

3. Setup DNS records using DNSMadeEasy's Failover service ([url removed, login to view]) so that if the primary server goes offline, traffic is redirected to the secondary server. (This is a 30 minute task at the most).

4. Setup fetchmail on the secondary server to deliver mail to the primary server in the event that it receives mail instead of the primary box. (Secondary server should have an MX of 20, and Primary server should have an MX of 10. If MX 20 receives mail for any reason, MX 10 should retreive it with fetchmail and store it appropriately).

5. Setup MySQL replication so that:

a) the mailboxes are replicated between the servers.

b) the database for the eCommerce site is replicated.

6. Setup a cron job and rsync to replicate files between sites.

All setup should be done in the most "standard" way possible. Use the software from the repos. Code compiling is not necessary unless we (together) decide there is a feature that is required for this setup that is not available via the repos.

I have done this myself in the past, and - on average - it takes about 12 hours, including testing, to setup. I am willing to allot up to 16 hours of your time for the project to account for "surprises."

You will need to provide your SSH public key to access the system. We will not be using usernames / passwords to access these systems. Replication (like rsync) will also need to be done using keys).

You may have to work with our developers to ensure that certain functions (like the shopping cart) work from both systems. While there should be no problem (the code uses an API that is origin agnostic), it is possible there will be bugs to work out.

Your price quote and timeline must be fixed and accurate.

We have several of these projects coming up, so I am looking for someone who can do this multiple times and create a consistently good result.

This bid is for a SINGLE job. If you do well with this one, we'll bring you on board for the others.

Skills: Database Administration, DNS, Linux, MySQL

See more: vps price, vps linux price, ubuntu service, ubuntu for linux price, software developers network, shopping cart 6.0.14, setup ecommerce site, setting up an ecommerce site, problem setup, on-board services, network testing services, location services api, location based services api, linux developers, job board api, how to bring traffic to your site, how can i create a job board site, forward domain dns, ecommerce site setup, board bring up, spam assassin, setting up ubuntu, public domain database, vps setup, ubuntu

About the Employer:
( 80 reviews ) Marietta, United States

Project ID: #5285769

23 freelancers are bidding on average $473 for this job


Hi there, I have over 7 years experience working on HTML, Wordpress, Magento, Database administration, OpenCart, Website Design, Logo / Banner Design Joomla, CSS and Linux Administration. I have read the project descri More

$412 USD in 10 days
(281 Reviews)

Hello, I have been working as a Linux system administrator over 12 years and i have honestly extensive practical and technical knowledge with Linux servers (setup/management/configuration/troubleshooting/securing an More

$349 USD in 3 days
(218 Reviews)

Hi. I am an experienced Linux system administrator with extensive mail servers setup experience . I will perform the setup, tuning and provide further support of the project for you. I'm available online in Yahoo!/J More

$378 USD in 10 days
(176 Reviews)

A proposal has not yet been provided

$331 USD in 3 days
(105 Reviews)

Hello. I have vast experience in cluster technologies, and I can configure MariaDB multi-master cluster, so in future it will be possible to add new servers in master-master replication scheme, or just create 2 serv More

$277 USD in 2 days
(60 Reviews)

Hello, I have 10+ years of experience in progamming and Linux and database administration. Also I have worked with email applications such as QMail, Postfix, Zimbra, RoundCube, ... Thanks, Helmot

$300 USD in 5 days
(7 Reviews)

Good morning, my name is Luca, I'm a system administrator since 2001. I currently own an hosting service and internet provider in Italy. I'm based in Rome. I also work for many private companies and public bureaus by More

$500 USD in 3 days
(32 Reviews)

Hi ! I am senior systems admin with more than 15 years of experience , i can setup both of your servers in 1-2 days , please consider me for this project. Best Regards, Konstantin

$500 USD in 3 days
(15 Reviews)

Can help you in your project. Can review my profile - you will see there many linux projects i done.

$315 USD in 3 days
(36 Reviews)

Hello Sir, I am Working with 3 tier Data Center Organization as a Linux Expert, I have more than 5 years experience in Mail server Administration, Web security, Web hosting, Database Administration and Migration, worki More

$300 USD in 2 days
(34 Reviews)

Hello, I work as a Linux/Unix system administrator for the past 10 years and have all the necessary skills and hands-on experience to complete the task. Hope to hear from you soon.

$444 USD in 7 days
(8 Reviews)

Hey there. The only item on the list that I don't really have any experience with is #4 - fetchmail used for sync, the rest I have done in the past and are straight-forward.

$500 USD in 3 days
(4 Reviews)

Hi, I can start working on your project immediately. I am an experienced web developer and software engineer. This kind of setup always has surprises. So, if you need somebody to do it successfully I am the right perso More

$750 USD in 2 days
(2 Reviews)

Good morning, I've already implemented this work in the past, same software but different SO (Fedora 11) I make a replication during the update of the SO from Fedora 11 to Fedora 14 to a different server, so I repli More

$450 USD in 7 days
(2 Reviews)

Hello there, We are a group of technical expertise professionals exploring server technology from more than 7 years. After having a go through on the job description we found the task is achievable. We already More

$600 USD in 3 days
(1 Review)

I'm communications and electronics engineer graduated from faculty of engineering Alexandria university. Diploma in software engineering from information technology institute in Egypt. Red Hat Certified System Admi More

$255 USD in 3 days
(1 Review)

I work for HP in the area of security systems. Highlighted Tasks: Hardening / Pentesting OS: Linux, Wintel (2003-2012) DB (Oracle, SQL Server)

$666 USD in 5 days
(1 Review)

Hello, I have 5 years experienced Server and Network Administrator . I am specialize in Mail Server Administration & Configuration. Recently I have Configured : [url removed, login to view] http://webmail.go-gulf.c More

$455 USD in 10 days
(1 Review)

I like to write in sh, Perl, to administer the server, find and eliminate the cause of a fault in the programs (Exim, DbMail, Apache, Nginx, PgSQL, MySQL) as well as edit the HTML code or the correct code in Perl or PH More

$777 USD in 3 days
(0 Reviews)

A proposal has not yet been provided

$255 USD in 3 days
(0 Reviews)