|
Thanks, man. Very much appreciate you sharing your perspective.
|
|
|
|
|
Replicated Databases is a very costly option. I would use multiple databases as a very last option. You could always beef-up the database server, plan your indexes, implement indexed views for repeating queries, improve the queries and stored procedures, implement caching in your application or improve performance of the application itself.
And if you have done all of the above and it is still not solving the problem, then I would suggest you to implement some custom caching services, using Redis[^] or MongoDB[^]. Windows Azure offers geo-redundant storage locations, you could use these NoSQL files to act as an intermediate database. It will give you more flexibility and control.
And if you want to implement replication or mirroring in Windows Azure. There are two options because Windows Azure offers two types of SQL Server solutions. SQL Azure (PaaS) and SQL Server inside a VM (IaaS). SQL Azure means zero administration and maintenance at the cost of control and flexibility (We are using this as Production database). And traditional SQL Server inside a Virtual Machine means more control, better performance and complete administration (We are using this as Development database). There are 6 locations available for Azure that you may use.
To sync multiple database using SQL Azure you can use Data-Sync service. This is out-of-the-box solution and you could setup multiple synced databases in just few clicks/minutes. but the biggest problem with this option is the minimum sync time is 5 min. so you will have 5 min delay between the sync and this can cause huge problems.
Which left you with the last option, to do everything by yourself, by setting up multiple Azure VMs in different regions, and then install and configure database mirroring/replication, and setup network load balancer (in Azure this is easy to do). You will also have to change your Application to use 'correct' connection string. I have done this headache in my previous job (with on-premise servers) and it's costly and time consuming, and your DBA will hate you for rest of his life .
I still prefer to setup Web Application at multiple locations, load balance them, use single but powerful server for Database, and implement some intelligent caching service using NoSQL database.
|
|
|
|
|
Multiple web apps and a bit of intellegence certainly sounds better than incurring the wrath of the DBAs.
|
|
|
|
|
Most people have more than the average number of legs.
The only instant messaging I do involves my middle finger.
English doesn't borrow from other languages.
English follows other languages down dark alleys, knocks them over and goes through their pockets for loose grammar.
|
|
|
|
|
|
|
I've been told I have 3.
Windows 8 is the resurrected version of Microsoft Bob. The only thing missing is the Fisher-Price logo.
- Harvey
|
|
|
|
|
|
Very slightly less than two...
The only instant messaging I do involves my middle finger.
English doesn't borrow from other languages.
English follows other languages down dark alleys, knocks them over and goes through their pockets for loose grammar.
|
|
|
|
|
Please quit your Integer mentality.
|
|
|
|
|
Somewhere up near 4 where Griff lives
“I believe that there is an equality to all humanity. We all suck.” Bill Hicks
|
|
|
|
|
Bloody cheek!
The only instant messaging I do involves my middle finger.
English doesn't borrow from other languages.
English follows other languages down dark alleys, knocks them over and goes through their pockets for loose grammar.
|
|
|
|
|
It's why median is a more meaningful number!!
|
|
|
|
|
|
"...the trouble is, neither have you."
The only instant messaging I do involves my middle finger.
English doesn't borrow from other languages.
English follows other languages down dark alleys, knocks them over and goes through their pockets for loose grammar.
|
|
|
|
|
I bring the average down, cos most of the time I'm legless.
|
|
|
|
|
|
I'd never heard of him before your link. I'll see if I can find time to watch it later.
The only instant messaging I do involves my middle finger.
English doesn't borrow from other languages.
English follows other languages down dark alleys, knocks them over and goes through their pockets for loose grammar.
|
|
|
|
|
He has been frequently on TED talks[^] too, quite interesting though. Most is about the actual state of the world, healt issues and poverty etc. I think Bill GAtes has this on his favourite talks as well...
|
|
|
|
|
XKCD[^]
A classic. We're outnumbered (soon). Terminators eat your heart out!
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
link not working as expected..
Welcome to AOL
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
Wrong link maybe ?
P.S we can always step on some of the "people" to lower their numbers
Microsoft ... the only place where VARIANT_TRUE != true
|
|
|
|
|
I don't need a computer or any bloatware to read AOL.
A... O... L
See? It's easy.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
|
Thanks for that. I guess that's the problem with posting just before a meeting.
For everyone wondering about the AOL link - that was to AOL Reader which is the best alternative to Google Reader I've discovered so far.
(I was amazed - always avoided them until then)
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|