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. Link to comment https://forums.phpfreaks.com/topic/246360-mysql-alternatives/ 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. Link to comment https://forums.phpfreaks.com/topic/246360-mysql-alternatives/#findComment-1265466 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. Link to comment https://forums.phpfreaks.com/topic/246360-mysql-alternatives/#findComment-1265721 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. Link to comment https://forums.phpfreaks.com/topic/246360-mysql-alternatives/#findComment-1265730 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? Link to comment https://forums.phpfreaks.com/topic/246360-mysql-alternatives/#findComment-1265767 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" Link to comment https://forums.phpfreaks.com/topic/246360-mysql-alternatives/#findComment-1265889 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.