hackalive Posted May 24, 2010 Share Posted May 24, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/202705-multiserver-table/ Share on other sites More sharing options...
jskywalker Posted May 24, 2010 Share Posted May 24, 2010 The answer is chapter 16 of the docs: http://dev.mysql.com/doc/refman/5.1/en/replication.html Quote Link to comment https://forums.phpfreaks.com/topic/202705-multiserver-table/#findComment-1062473 Share on other sites More sharing options...
hackalive Posted May 24, 2010 Author Share Posted May 24, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/202705-multiserver-table/#findComment-1062476 Share on other sites More sharing options...
Mchl Posted May 24, 2010 Share Posted May 24, 2010 See MySQL Cluster Quote Link to comment https://forums.phpfreaks.com/topic/202705-multiserver-table/#findComment-1062479 Share on other sites More sharing options...
jskywalker Posted May 24, 2010 Share Posted May 24, 2010 yes, indeed, i misread the question.... Quote Link to comment https://forums.phpfreaks.com/topic/202705-multiserver-table/#findComment-1062484 Share on other sites More sharing options...
hackalive Posted May 24, 2010 Author Share Posted May 24, 2010 and does anyone know a good open source non-rational database system that I can do this with as well Quote Link to comment https://forums.phpfreaks.com/topic/202705-multiserver-table/#findComment-1062485 Share on other sites More sharing options...
Mchl Posted May 24, 2010 Share Posted May 24, 2010 You mean non-relational I suppose. Why would you want a non-relational db? Quote Link to comment https://forums.phpfreaks.com/topic/202705-multiserver-table/#findComment-1062521 Share on other sites More sharing options...
hackalive Posted May 24, 2010 Author Share Posted May 24, 2010 yeah I mean non-relational, and becuase things like Facebook use it for walls etc. Quote Link to comment https://forums.phpfreaks.com/topic/202705-multiserver-table/#findComment-1062534 Share on other sites More sharing options...
Mchl Posted May 24, 2010 Share Posted May 24, 2010 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/ Quote Link to comment https://forums.phpfreaks.com/topic/202705-multiserver-table/#findComment-1062539 Share on other sites More sharing options...
hackalive Posted May 24, 2010 Author Share Posted May 24, 2010 thanks there is a deeper reason that someone else uses it, but I am not prepared to divulge that info Quote Link to comment https://forums.phpfreaks.com/topic/202705-multiserver-table/#findComment-1062540 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.