Post reply

Problem please help me ?

  • May 15, 2011 at 7:08 am

    #250896

    Hello

    Thanks for your website.

    I have a question about distributed system.

    we have a project about distributed systems but the problems that we have is about how we can design this architecture,we want to design duplicate version of Distributed System.

    we want to design this architecture with this way .

    we have a 2 servers that we installed our database on them and these server are controlled with the another Computer (third computer) and the third computer routines the request from clients to servers .

    and my question is :

    is it possible?

    thanks

    bye

    ---------------------------------------------------
    baaaaaaaaaaaaaleh!!! (Ehs_Akb)

  • May 15, 2011 at 9:00 am

    #1324701

    I'm not really clear on what you are trying to do and why you need 3 Servers?

    Could you be a little more specific?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • May 15, 2011 at 11:48 am

    #1324733

    Sounds like mirroring with a dedicated witness server (see BOL, section "Overview of Database Mirroring").


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • May 15, 2011 at 12:18 pm

    #1324744

    Is this a Distributed System question or a Mirroring question?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • May 16, 2011 at 7:17 am

    #1325014

    bijarcity (5/15/2011)

    Hello

    Thanks for your website.

    I have a question about distributed system.

    we have a project about distributed systems but the problems that we have is about how we can design this architecture,we want to design duplicate version of Distributed System.

    we want to design this architecture with this way .

    we have a 2 servers that we installed our database on them and these server are controlled with the another Computer (third computer) and the third computer routines the request from clients to servers .

    and my question is :

    is it possible?

    thanks

    bye

    I think there is a language barrier here getting in the way, but I think "the third computer routines . . ." should be "the third computer ROUTES . . .". This make the system not only distributed but load balancing. This is certainly doable using a web farm and web call balancing hardware/software. Unless you have a scale-out database design though you are still going to be stuck with a single database server that could be a bottle-neck. It is VERY difficult to design a scale-out database application unless the data is easily 'partitionable' such as based on a clientid or some such. The good news is that you can buy VERY powerful SQL Server hardware these days that can scale to incredible load.

    Let me add that the type of design you are doing is VERY VERY COMPLEX and you simply MUST hire an application/database architect that knows how to do this type of work. You have a very low probability of success if you don't do this.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • May 16, 2011 at 2:47 pm

    #1325481

    Hi

    Thanks a lot for answering .

    -----

    i think my comment isn't very clear so :

    I want to design a distributed database for my project .so i want to implement the duplication version of distributed system ,I mean i want to have a same database on two servers (Server A,Server B) ,the two server's databases are same .

    for example you send a request to ServerA if this server be inaccessible the request sends to ServerB and the request is done .and after some minutes when the ServerA is connected ,the ServerB copies all its changed table to ServerB and with this way the records of two databases are same. i think these Servers Should be controlled by another Server(ServerC) to divide the request between these servers(A,B) and the serverC decides to which Servers is Conected to send the request .

    thank you very much

    ---------------------------------------------------
    baaaaaaaaaaaaaleh!!! (Ehs_Akb)

  • May 16, 2011 at 2:54 pm

    #1325486

    Hi

    thanks a lot,but it isn't mirroring .

    ---------------------------------------------------
    baaaaaaaaaaaaaleh!!! (Ehs_Akb)

  • May 16, 2011 at 3:05 pm

    #1325489

    bijarcity (5/15/2011)

    Hello

    Thanks for your website.

    I have a question about distributed system.

    we have a project about distributed systems but the problems that we have is about how we can design this architecture,we want to design duplicate version of Distributed System.

    we want to design this architecture with this way .

    we have a 2 servers that we installed our database on them and these server are controlled with the another Computer (third computer) and the third computer routines the request from clients to servers .

    and my question is :

    is it possible?

    thanks

    bye

    What Business requirements are driving this initiative?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • May 16, 2011 at 3:24 pm

    #1325500

    not dividing ,(server C) just check the Servers A,B ,to know which one is connected

    ---------------------------------------------------
    baaaaaaaaaaaaaleh!!! (Ehs_Akb)

  • May 16, 2011 at 3:37 pm

    #1325507

    bijarcity (5/16/2011)

    not dividing ,(server C) just check the Servers A,B ,to know which one is connected

    I should have been more clear.

    Why do you need to create a distributed database environment?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • May 17, 2011 at 10:54 am

    #1325960

    my project is that,and i have to implement that ,so do you have any idea about that ?

    ---------------------------------------------------
    baaaaaaaaaaaaaleh!!! (Ehs_Akb)

  • May 17, 2011 at 11:08 am

    #1325972

    bijarcity (5/17/2011)

    my project is that,and i have to implement that ,so do you have any idea about that ?

    Your project is not a cake walk.

    You want to start out by performing some research, gathering requirements, determining the feasibility and go from there. As was stated by another member "MVP" you need some help and you need someone that is very familiar with your current environment, SME, the objectives of this initiative and a Analyisis & Design document.

    If you have to go this alone I would start by reading up on Distributive Systems.

    I would also ask the question "Why is this necessary?"

    Why is this needed and what business requirement justify this initiative?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • May 17, 2011 at 3:17 pm

    #1326146

    Your project is not a cake walk.

    You want to start out by performing some research, gathering requirements, determining the feasibility and go from there. As was stated by another member "MVP" you need some help and you need someone that is very familiar with your current environment, SME, the objectives of this initiative and a Analyisis & Design document.

    If you have to go this alone I would start by reading up on Distributive Systems.

    I would also ask the question "Why is this necessary?"

    Why is this needed and what business requirement justify this initiative?

    -------------------------

    Thanks for your moral support. I really would be happy if you help me ,this is the project of my DB in university ,and i like to design that because i think Distributed database is very useful in the future ,and i think this subject is very amazing and it doesn't have any requirement justify.

    thanks a lot my dear friend.

    Ehsan

    ---------------------------------------------------
    baaaaaaaaaaaaaleh!!! (Ehs_Akb)

  • May 17, 2011 at 3:30 pm

    #1326155

    bijarcity (5/17/2011)[hr I really would be happy if you help me ,this is the project of my DB in university ,and i like to design that because i think Distributed database is very useful in the future ,and i think this subject is very amazing and it doesn't have any requirement justify.

    If there is not a business requirement that is driving the need for a distributive system then how can you justify it?

    How did you come up with 3 Servers?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • May 18, 2011 at 2:45 am

    #1326271

    I have 2 servers(A,B) that i install my database on them,and the other server(c) sends the request to the server that is accessible,

    let me give an example ,suppose you are client that send me a request the Server c gets your request and check the others servers and finds which servers is accessible and after that sends your request to that servers ,in this example we suppose that one of the servers(A,B) is not in our network and it has have a problem ,so after fixing the servers when it comes to the network ,it updates its information and gets its information from another servers .

    Thanks .

    ---------------------------------------------------
    baaaaaaaaaaaaaleh!!! (Ehs_Akb)

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply