Multiserver table

[hackalive]

So as many of you might/probably knwo, search engines such as Google and Microsoft Bing, don't and can't possibly store the entire index database on one server, the database is stored on multiple servers. Now my question is how can I acomplish this, what server (or technologies in terms of hardware) do I need as well as what software do I use to make MySQL (or other open source free DB systems) store information across many server like Google and Bing.

 

Any responses and help would be much appreciated, and before anyone asks yes the table will be that big, that it will need to be sotred like Google or Bing.

 

Look foreward to your replies and suggestions

 

Thanks in advance

[jskywalker]

The answer is chapter 16 of the docs:

http://dev.mysql.com/doc/refman/5.1/en/replication.html

[hackalive]

This chapter while usefully, discusees Replication, so one master which duplicates data to a slave, that is not what I am after, sorry

 

If I have misread can you point out as a quote from the page what I am after and how to accomplish it

 

thanks anyway

[Mchl]

See MySQL Cluster

[jskywalker]

yes, indeed, i misread the question....

[hackalive]

and does anyone know a good open source non-rational database system that I can do this with as well

[Mchl]

You mean non-relational I suppose. Why would you want a non-relational db?

[hackalive]

yeah I mean non-relational, and becuase things like Facebook use it for walls etc.

[Mchl]

If your only argument for non-relational database is that someone else uses it, you might want to reconsider. Facebook is not very typical application.

 

As far as I know they use Cassandra

http://cassandra.apache.org/

 

[hackalive]

thanks there is a deeper reason that someone else uses it, but I am not prepared to divulge that info