Web Host Chat - The UK hosting forum
Home QLinks Members Your Profile Register FAQ's Hosts Only Area SMS Alerts Game Servers
Go Back   Web Host Chat > News, Reviews and useful guides > Web Hosting Articles and Guides
Reply
 
LinkBack Thread Tools
Old 13th June 2008   #1 (permalink)
Excited Newbie
 
Join Date: Apr 2006
Posts: 4
splinter is on a distinguished road
High Availability across DCs

I'm looking at putting MySQL on two servers in two separate datacentres, using either Master-Slave Replication if the latency is low enough because it's more reliable, otherwise Master-Master Replication. I'd rather each server be from a different provider too with separate upstreams. The traffic between then will go through an OpenVPN tunnel.

Obviously with this, latency is an issue. What do I really need to look for when choosing the providers?

Should I look to have a VLAN setup between the two?
Will peering between the two be sufficient? Should I ask for traceroutes between the two providers? What sort of latency should I look for?

I've run MySQL Replication for a long time, just not between multiple datacentres.

Thank you for any advice you can give me,
splinter
splinter is offline   Reply With Quote
Old 14th June 2008   #2 (permalink)
 
Join Date: Mar 2002
Location: London, United Kingdom
Age: 39
Posts: 4,855
othellotech is on a distinguished road
>Should I look to have a VLAN setup between the two?

No, you're vpn'ing between the machines

>Will peering between the two be sufficient?

Sufficient - no, but it will improve the performance.

>Should I ask for traceroutes between the two providers?

Of course

> What sort of latency should I look for?

What do you need ? For master/master ~100ms is fine
__________________
Rob Golding Othello Technology Systems Ltd AS29527 Company#03894981 VAT#GB-782561410 Tel:0871 277 6875
consultancy domains email forwarding resellers ecommerce colo rackspace ip transit secondary mx/dns dedicated servers backup/DR
* OthelloHosts.net Linux and Windows Clustered High-Availability Professional Email / Web / Secure Hosting
* OthelloVPS.net Managed Xen Enterprise Virtual Private Servers and Dedicated Servers
# Currently buying web hosts and domain resellers - www.hostacquisitions.co.uk
othellotech is offline   Reply With Quote
Old 16th June 2008   #3 (permalink)
 
Join Date: Apr 2005
Location: Manchester
Posts: 269
samb is on a distinguished road
Setting up the replication is the easy bit - much harder is how to handle automated failover and avoid a split-brain condition when the link between the two DCs fails.
samb is offline   Reply With Quote
Old 21st June 2008   #4 (permalink)
 
Dhosting's Avatar
 
Join Date: Jan 2006
Location: Blackpool
Age: 21
Posts: 1,510
Dhosting is on a distinguished road
We had two w2k3 boxes doing master to master MySQL 5 replication between two data centers never an issue, always helps if you set the auto increment offset properly etc.

Also did a MySQL 4.1 master to slave in the event of the master failing we could handle transactions on the slave and essentially switch the roles so the slave became the master etc.

It can generate some super large files though log wise so watch out for it, you can usually clean them out if you set MySQl up right.

Naturally your App needs to look for the backup mysql box if the primary times out etc.
__________________
Chris Daley
Dwebs Ltd :: Company No. 05603664 :: 08000 141 942
2008hosting.net - Windows 2008 Server Hosting Solutions
Dhosting.co.uk - Web Hosting, Managed Servers
Dwebs.ltd.uk - Web Design & Other Services

My views are my own and not those of my company.
Dhosting is offline   Reply With Quote
Old 18th August 2008   #5 (permalink)
 
Join Date: Jan 2008
Location: Ireland
Posts: 90
shortword is on a distinguished road
We've done several solutions like that this and in several different configurations. Master - Master works best between DC's but it helps to be able to DO HA on the same subnet. if you can, then programatically set the app to use IP1 all the time and if IP1 isn't available to use IP2. Or round robin them in code and make sure to exclude 1 if it's down.

The other option is to use drbd for /var/lib/mysql/ - drbd works flawlessly over the internet or over the lan which means you can have a live mirrored copy of the DB on an offsite server. Again programatically you can connect to the box that isn't giving errors/is available.

Be carefull of both solutions. If you drop a table, it's gone no matter what solution you go for. So in addition to the above always keep regular backups.
__________________
Paul Kelly, Technical Director & Parallels Specialist
Blacknight offer IE and EU Domains, Shared hosting, Reseller Hosting, VPS, DDS, Dedicated, Managed, Colocation out of Dublin from two Tier IV Data Centres.

Services: Plesk / Plesk Expand / Parallels Containers / HSPComplete / Acronis True Image Server/ Plesk Sitebuilder | RIR consultancy, BGP Transit, Wholesale Hosting, Wholesale Domain registration services
shortword is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UK Managed Windows Servers - Limited Availability fusion Web Hosting and Related Offers 1 17th April 2006 12:06 AM
[SC] Limited availability Dell servers from £75! Ricky Web Hosting and Related Offers 0 2nd June 2005 02:59 PM
London 47U rack & 10mbit offer **limited availability, free setup** edb49 Web Hosting and Related Offers 0 8th December 2004 11:44 AM
Fully-managed high-availability Dell 2650 dedicated server edb49 Web Hosting and Related Offers 0 24th February 2004 11:06 AM
DRBD / High Availability illusion Business and Technical Advice 0 11th January 2004 06:46 PM

User Information
»REGISTER NOW!
Web Hosting Articles and Guides Featuring articles and guides written by Web Hosts to help you


Quick forum search
 

Special Hosting Offers

Hot Stuff


Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0