IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Theory and Practice of Programming Forum / You can do that with PEAR
Post #274,158
by drewk
Picture of drewk
11/28/06 12:06:04 AM
Reply
New You can do that with PEAR
And still keep it away from the programmers. Create a class that extends DB.php. Wrap the connection method with your own, which checks if you're reading or updating. If you're reading, do it from one of the slaves. Best way is to put a load balancer in front of the slaves so you can dynamically add/remove slaves without interrupting the app. Next best is round-robin or random select within your class.




Wait, you said ADODB. I used DB, not DB_ado, but I assume the above still applies.
===

Kip Hawley is still an idiot.

===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
Post #274,159
by static
Picture of static
11/28/06 12:11:50 AM
Reply
New ADODB has a reputation.
Mainly that it's a heavy layer for what it does.

You're right: derive a new class and use that instead makes sense. That's probably what I'll do for that other project.

Wade.
"Don't give up!"
     Programming and design experiment - (admin) - (27) - Nov. 27, 2006, 10:12:32 PM EST
         Yes, or Icon, Wade... ;-) -NT - (admin) - (1) - Nov. 27, 2006, 10:18:35 PM EST
             I do most of my programming in PHP these days. - (static) - Nov. 27, 2006, 10:34:44 PM EST
         This sounds familiar. - (static) - (5) - Nov. 27, 2006, 10:33:27 PM EST
             Re: This sounds familiar. - (admin) - (4) - Nov. 27, 2006, 10:56:02 PM EST
                 We're back to a scalability layer. - (static) - (3) - Nov. 27, 2006, 11:56:01 PM EST
                     You can do that with PEAR - (drewk) - (1) - Nov. 28, 2006, 12:06:04 AM EST
                         ADODB has a reputation. - (static) - Nov. 28, 2006, 12:11:50 AM EST
                     Re: We're back to a scalability layer. - (admin) - Nov. 28, 2006, 12:40:02 PM EST
         A few ideas - (admin) - (6) - Nov. 27, 2006, 10:39:30 PM EST
             How critical is update ordering? - (drewk) - (5) - Nov. 27, 2006, 11:39:34 PM EST
                 Critical. - (admin) - (4) - Nov. 27, 2006, 11:39:52 PM EST
                     That's could be really hard. - (static) - (3) - Nov. 28, 2006, 12:02:19 AM EST
                         One reason why I lean towards all-in-memory - (admin) - (2) - Nov. 28, 2006, 12:22:31 AM EST
                             Doable from a database as well... - (ChrisR) - (1) - Nov. 28, 2006, 10:31:08 AM EST
                                 I didn't say it wasn't doable. - (admin) - Nov. 28, 2006, 10:58:05 AM EST
         Consistency, Availability, Reliability - (tuberculosis) - (4) - Nov. 27, 2006, 11:21:47 PM EST
             Define your terms. - (admin) - (3) - Nov. 27, 2006, 11:34:27 PM EST
                 mmm kay - (tuberculosis) - (2) - Nov. 28, 2006, 12:29:13 AM EST
                     That's what I thought, for the most part. - (admin) - Nov. 28, 2006, 12:09:15 PM EST
                     Or how about we do this: - (admin) - Nov. 28, 2006, 12:12:41 PM EST
         Have you looked at the O'Reilly database war stories? - (tonytib) - (4) - Nov. 28, 2006, 02:16:07 AM EST
             Yes, I've seen those before. - (admin) - (3) - Nov. 28, 2006, 12:10:03 PM EST
                 I'm really starting to think there's something to my idea - (drewk) - (2) - Nov. 28, 2006, 09:31:52 PM EST
                     Isn't that what SQLite is sorta trying to solve? - (static) - (1) - Nov. 28, 2006, 11:10:41 PM EST
                         It's a solution to a specific problem - (drewk) - Nov. 28, 2006, 11:21:11 PM EST
         XBase, of course. - (pwhysall) - (1) - Nov. 28, 2006, 09:15:25 AM EST
             I heard that -NT - (tablizer) - Nov. 28, 2006, 05:28:39 PM EST

I made it through almost 20 minutes of this before coming out of my skin and destroying the TV with my mad shrieking.
51 ms