Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

horizontal scale out

hi,

I heard about that SQL server table partitioning is horizontal scare out but how about in terms of the whole SQL server topology side?

how to horizontally scare out ?

I heard that Amazon cloud provide this kid of database service, right?
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Partitioning is just keep the data from a single table in many physical partitions (file groups) so it reduces the quantity of data that a query may work with.
What are you really looking for?
Avatar of marrowyung
marrowyung

ASKER

hi very good victor,

it seems "Partitioning is just keep the data from a single table in many physical partitions (file groups)" and this one" so it reduces the quantity of data that a query may work with." has no relationship.

I have friend ask me how to do horizontal scaling using SQL server and I said SQL server can't do this except PDW edition, which do the oracle RAC thing in SQL server but MS move that topology in DB tier.

I said tempdb is some kind of it as it scale horizontally but he said it is not what he want.

he want to use/find out a method and replace SQL server replication as it is too slow and also no conflict on data once replicated to other country.

someone use Amazon cloud because of this ,any horizontal scale out solution for SQL server?
it seems (...) has no relationship.
Why not?

I said SQL server can't do this except PDW edition
Why not?

I said tempdb is some kind of it as it scale horizontally but he said it is not what he want.
Of course not.

he want to use/find out a method and replace SQL server replication as it is too slow and also no conflict on data once replicated to other country.
We need to know better is actual solution to provide any input. Did he see the AlwaysOn solution?
"I said tempdb is some kind of it as it scale horizontally but he said it is not what he want.
Of course not.
"
that one is load balancing or round robin, right?

"Did he see the AlwaysOn solution?"

yes, they are using SQL 2012, my credit is telling him the always on in SQL 2012 has problem and should have a project to upgrade to SQL 2014.

but that one is not horizontal scaling man. they want data existing in all server around the world without delay.
that one is load balancing or round robin, right?
TempDB is only about the performance. Forget it since it's not related about what you want here.

but that one is not horizontal scaling man. they want data existing in all server around the world without delay.
You can't expect no delays when replicating data around the world. Not even Oracle can do that.
Actually, AlwaysOn is the only reliable solution from SQL Server and still need improvements.
"TempDB is only about the performance. Forget it since it's not related about what you want here."

yes, as I said to him SQL server don't have it if PDW is not what you need.

"You can't expect no delays when replicating data around the world. "

yes I understand. I answer him too. he keep saying amazon cloud as he found sth.

"Not even Oracle can do that.
Actually, "

I answered him either. the RAC can only work good in 100Km. over that, oracle do not guarantee.

"AlwaysOn is the only reliable solution from SQL Server and still need improvements.


it is not horizontal scaling again, it is a multi function failover design.  again I still suggset to them the PDW of SQL server, which MS AI cloud service also use this .

this is the only solution.

as it is built on mirror technology, it should be good for worldwide deployment as mirroring is based on that design.
any good amazon cloud service you can suggest based on that?
he keep saying amazon cloud as he found sth.
Amazon offer is service in a Cloud, meaning that can be accessed from any part of the world. You don't know which server are you connecting when working with Cloud. The server can be in HK, UK, USA, Australia or any other country. How this can be used as horizontal scale out? Can you ask that to your friend?

any good amazon cloud service you can suggest based on that?
Amazon only offers a cloud service. There's no good or bad. Is the only one they offers. As Microsoft offers they and Oracle's they.
"Amazon offer is service in a Cloud, meaning that can be accessed from any part of the world. You don't know which server are you connecting when working with Cloud. The server can be in HK, UK, USA, Australia or any other country. "

is good. they have one primary site and one secondary site, and one cloud if both of them down.

but the amazon cloud already make the site virtually unbreakable /un downable.

so do you agree that other than AOG, not other option to replace replication ? even it is not going to replace replication as AOG is diff.
they have one primary site and one secondary site, and one cloud if both of them down.
but the amazon cloud already make the site virtually unbreakable /un downable.
They have many secondary sites around the world. The same for any company that's offering Cloud service. Microsoft has it, Oracle has it. That's nothing special on that.

so do you agree that other than AOG, not other option to replace replication ? even it is not going to replace replication as AOG is diff.
Agree.
from your point of view, how to improve replication's speed if replicate across the whole world ?

do you know if SQL PDW can help on that across diff country by adding SQL server nodes on diff data center in diff country? the mirroring technology designed for long distance data transfer, right ?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"Having an high performance network."

HAAHA, any latency requirement of network for replication ?

"I don't know why are you keeping insist in PDW. That's the SQL Server solution for Datawarehouse and it will have the same issues if you want to replicate it around the world."

as my friend need horizontal scale out, replication is the one they don't want to use.

"No. Any solution should be used for short or long distance. "

ok, as when I hear the seminar of MS in teched, they said mirror technology is designed for that.
No. Any solution should be used for short or long distance.
any latency requirement of network for replication ?
That depends on the business requirements but I would say that everything higher than 5ms is bad and the ideal should be less than 2ms.
but from india and US, how large is that ?

usually from diff country , it will be larger than 2 ms, right? so we have to consider IPLC or MPLS

one thing, any doc from MS talk about the best replication network requirement ?
but from india and US, how large is that ?
I don't know. I live and work in Europe and have no experience outside Europe.
ok, then has to tracert that.. must be IPLC or MPLC, closed network man !
I am funny to see that this port only few people to answer!
I am funny to see that this port only few people to answer!
I don't think there are many solutions like the one you presented. People are more used to regional solutions rather than worldwide.
"People are more used to regional solutions rather than worldwide.

sorry what is that mean ?
Means that maybe only few people with experience on what you're asking for.
I can tell you more and more people using Amazon AWS.

do you know anyone use it ? how to start learning that in an easy way ?
by this :

https://aws.amazon.com/rds/?ft=n

it seems AMAZON RDS already solve this problem by not using replication at all.

any objection "?
Sorry, can't help with Amazon's cloud. I never used it.
one thing, what is the definition of a SQL server farm ? anything like that in SQL server?
I'm not sure if that term can be used for SQL Server. If so, then it should be a collection of SQL Server machines in the domain/network.
yes, I never heard about that too.
tks.
check the Amazon RDS, I think this is the one about SQL server farm as well as SQL server horizontal scale out.