tag:blogger.com,1999:blog-31421954.post4709619962141971609..comments2023-10-30T08:23:12.960-07:00Comments on mySQL DBA, Architecture, Dev, Scale, HA, Code : Asynchronous Queries verses Synchronous QueriesDathan Pattishallhttp://www.blogger.com/profile/00356367514107959723noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-31421954.post-23596810742091559302009-11-10T12:47:58.903-08:002009-11-10T12:47:58.903-08:00Thats awesome Eric. I will give it a tryThats awesome Eric. I will give it a tryDathan Pattishallhttps://www.blogger.com/profile/00356367514107959723noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-40554286071969918532009-11-10T01:15:41.881-08:002009-11-10T01:15:41.881-08:00... the link http://blog.ulf-wendel.de/?p=201 poin...... the link http://blog.ulf-wendel.de/?p=201 points you "PHP: How mysqlnd async queries help you with sharding!" from about a year ago.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31421954.post-55930980902142425322009-11-10T00:04:50.292-08:002009-11-10T00:04:50.292-08:00http://blog.ulf-wendel.de/?p=201http://blog.ulf-wendel.de/?p=201Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31421954.post-46123820182269391922009-11-09T21:31:28.684-08:002009-11-09T21:31:28.684-08:00Nice post, the power of async queries is yet to be...Nice post, the power of async queries is yet to be realized by most, mostly due to the APIs not being there. Rather than introducing an entire new layer into the mix, I would suggest using non-blocking I/O directly on the first layer PHP machines. This is what I added into libdrizzle and the corresponding PHP extension. For example, you can queue N queries and have them run concurrently, possibly against multiple servers, all within PHP.<br /><br />http://cvs.php.net/viewvc.cgi/pecl/drizzle/drizzle.php?view=markup<br /><br />Towards the end of this is a "concurrent query interface" example.<br /><br />-EricUnknownhttps://www.blogger.com/profile/14369137017887122155noreply@blogger.com