Ideas for scaling out database architecture

Posted by andrew on Server Fault See other posts from Server Fault or by andrew
Published on 2010-04-01T15:40:08Z Indexed on 2010/04/01 15:43 UTC
Read the original article Hit count: 511

Filed under:

replication

|

scaling

|

high-availability

|

database

We're looking to scale out our existing database architecture and need some advice on which way to go.

We currently have 2 web servers behind a load balancer that both read & write to a single master database which replicates to a slave.

Ideally, I'd like each of the webservers to point to their own master DB and have the data between the 2 synchronised but from what I've read, using any kind of master-master or ring-replication is discouraged.

I'm looking for a general "what do other people do" kind of answer - database vendor isn't a concern at the moment but we'd like to stay with MySQL or convert to MSSQL.

Any ideas would be gratefully received.

Many thanks,

Andrew

© Server Fault or respective owner

Related posts about replication

Is there any replication standard or concept for application server data replication

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi friends, Say, I have a server that handles file based mass data and can process thousands of read requests and hundreds of provisioning requests(Add, modify, delete) per second. This is not SQL based database. Now i planned to implement replication. There should be master- master replication,… >>> More
MySQL Connect 8 Days Away - Replication Sessions

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Following on from my post about MySQL Cluster sessions at the forthcoming Connect conference, its now the turn of MySQL Replication - another technology at the heart of scaling and high availability for MySQL. Unless you've only just returned from a 6-month alien abduction, you will know… >>> More
re-enabling a table for mysql replication

as seen on Server Fault - Search for 'Server Fault'
We were able to setup mysql master-slave replication with the following version on both master/slave: mysqld Ver 5.5.28-29.1-log for Linux on x86_64 (Percona Server (GPL), Release 29.1) One day, we noticed that replication has stopped, we tried skipping over the entries that caused the replication… >>> More
Replication Services in a BI environment

as seen on SQL Blog - Search for 'SQL Blog'
In this blog post I will explain the principles of SQL Server Replication Services without too much detail and I will take a look on the BI capabilities that Replication Services could offer in my opinion. SQL Server Replication Services provides tools to copy and distribute database objects from… >>> More
Fixing MySQL Replication

as seen on Internet.com - Search for 'Internet.com'
Continuing last months article on "MySQL Replication Pitfalls," Sean Hull discusses what to do to make your replication setup more resilient. >>> More

Related posts about scaling

Scaling background without scaling foreground in platformer?

as seen on Game Development - Search for 'Game Development'
I'm currently developing a platform game and I've run into a problem with scaling resolutions. I want a different resolution of the game to still display the foreground unscaled (characters, tiles, etc) but I want the background to be scaled to fit into the window. To explain this better, my viewport… >>> More
The new Auto Scaling Service in Windows Azure

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
One of the key features of the Cloud is the on-demand scalability, which lets the cloud application developers to scale up or scale down the number of compute resources hosted on the Cloud. Auto Scaling provides the capability to dynamically scale up and scale down your compute resources based on… >>> More
WPF performance on scaling a large scene

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a full screen app that I want to be able to zoom in on certain areas. I have the code working fine, but I notice that when I get closer in, the zoom in animation (which animates the ScaleTransform.ScaleX and ScaleTransform.ScaleY properties on a Parent canvas) starts to jerk down a little… >>> More
AWS: setting up auto-scale for EC2 instances

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Originally posted on: http://geekswithblogs.net/EltonStoneman/archive/2013/10/16/aws-setting-up-auto-scale-for-ec2-instances.aspxWith Amazon Web Services, there’s no direct equivalent to Azure Worker Roles – no Elastic Beanstalk-style application for .NET background workers. But you can get the auto-scale… >>> More
java slick2D - problem using ScalableGame class

as seen on Game Development - Search for 'Game Development'
I have problem adjusting the size of the screen, using the ScalableGame class from Slick2D library. So, what I want to achieve, whenever I change display size, background should adjust to screen size, and objects (images, grahpic shapes) should fit (scale). Alright, so this is how state looks by… >>> More