phpsycho Posted September 3, 2011 Share Posted September 3, 2011 I am using MySQL to scrape tons and tons of websites so thats about 10+ queries executing every 2 seconds. Then plus there is people executing queries when searching, updating profiles, posting in the forum, etc.. So it got real glitchy where data recently inserted to the db wouldn't load until 5 refreshes. Sooo I am looking for a alternative to MySQL that is much faster and has the ability to have a cluster. Oh and gotta be free. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 4, 2011 Share Posted September 4, 2011 Don't blame MySQL -- Facebook uses MySQL, and they're not looking for alternatives. Quote Link to comment Share on other sites More sharing options...
phpsycho Posted September 5, 2011 Author Share Posted September 5, 2011 They also use Cassandra. I wanna use Cassandra too, but I need a CQL driver for PHP. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 5, 2011 Share Posted September 5, 2011 You're missing the point -- MySQL isn't the problem. Quote Link to comment Share on other sites More sharing options...
phpsycho Posted September 5, 2011 Author Share Posted September 5, 2011 Then what could it be? Also.. is it possible to hold data in MySQL on more than one hard drive and or server? Quote Link to comment Share on other sites More sharing options...
Muddy_Funster Posted September 6, 2011 Share Posted September 6, 2011 Then what could it be? Also.. is it possible to hold data in MySQL on more than one hard drive and or server? Likely problems would be (in order of likelyhood): poor query structure bad/no normalisation network bandwidth restrictions server hardware not up to task As for running MySQL on multiple Disks and or server - hell yeah you can, google "MySQL replication and load balancing" Quote Link to comment 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.