[HyperDB] setup question

[J M]

btw,

i had the same config.. but "SELECT" statements still goes to the Master..

On Tue, Mar 2, 2010 at 2:11 PM, J M <jerome.m at gmail.com> wrote:

> since you using Mysql you can do logging from there..
>
>
> On Mon, Mar 1, 2010 at 1:54 PM, Beck, Joe <Joe_Beck at comcast.com> wrote:
>
>> thanks. yes, this did it.
>> add_db_server('global', 0, '', 1,
>> 0,'172.18.0.52:3306','172.18.0.52:3306
>> ','blogs_sprint','blogs_sprint','blogs
>> _sprint');  //wp1 main read svr
>> add_db_server('global', 0, '', 0,
>> 1,'172.18.0.55:3306','172.18.0.55:3306
>> ','blogs_sprint','blogs_sprint','blogs
>> _sprint');  //wp2 write svr
>>
>> I heard that hyperdb is good for logging/keeping track of queries & where
>> they¹re being sent.
>> anyone have any details on that?
>> if I¹m mistaken, can anyone recommend a way to validate & track reads &
>> writes to verify hyperdb is doing what you expect?
>>
>> thanks,
>> Joe
>>
>>
>>
>> On 3/1/10 9:58 AM, "Andy Skelton" <skeltoac at gmail.com> wrote:
>>
>> > Your config is telling HyperDB that there is no place to send reads. Try
>> a 1
>> > in the R arg of the read server.
>> >
>> > Andy
>> >
>> > On Feb 28, 2010 11:51 PM, "Beck, Joe" <Joe_Beck at comcast.com> wrote:
>> >
>> > I¹m new to hyperdb & need some help getting a dev env configured for a
>> POC.
>> > we have mysql in a master-slave config and would like to leverage
>> hyperdb
>> > for 2 things--> split reads/writes and support multiple data center.
>> >
>> > For now, the focus is on splitting the reads & writes.
>> > after going thru the install steps it seemed like a pretty simple
>> process,
>> > but I¹m getting hung up on the add_db_server line in db-settings.php
>> > originally I had:
>> >
>> > add_db_server('global', 0, '', 0,
>> > 0,'172.18.0.52:3306','172.18.0.52:3306
>> ','blogs_sprint','blogs_sprint','blogs
>> > _sprint');  //wp1 as read svr
>> > add_db_server('global', 0, '', 1,
>> > 0,'172.18.0.55:3306','172.18.0.55:3306
>> ','blogs_sprint','blogs_sprint','blogs
>> > _sprint');  //wp2 as write svr
>> >
>> > but was getting the following error:
>> > Unable to connect to : while querying table 'wp_1_options' (global_w)
>> >
>> > then I was questioning the horizontal partitioning part of this.
>> > so I commented out the first add_db_server line but still getting the
>> same.
>> > then, I started going thru the code & tried changing my add_db_server
>> line
>> > to
>> > add_db_server('global_w', 0, '', 1,
>> > 0,'172.18.0.55:3306','172.18.0.55:3306
>> ','blogs_sprint','blogs_sprint','blogs
>> > _sprint');  //wp2
>> >
>> > I stopped getting the orig error but got the std can¹t find your blog
>> msg:
>> > No WPMU site defined on this host. If you are the owner of this site,
>> please
>> > check <a href='http://codex.wordpress.org/Debugging_WPMU'>Debugging
>> WPMU</a>
>> > for further assistance.
>> >
>> > Any suggestions or guidance on this is greatly appreciated.
>> > we¹re using wpmu 2.8.6 & I downloaded the latest hyperdb, don¹t see a
>> > version on this.
>> >
>> > thanks,
>> > Joe
>> > _______________________________________________
>> > HyperDB mailing list
>> > HyperDB at lists.automattic.com
>> > http://lists.automattic.com/mailman/listinfo/hyperdb
>> > _______________________________________________
>> > HyperDB mailing list
>> > HyperDB at lists.automattic.com
>> > http://lists.automattic.com/mailman/listinfo/hyperdb
>> >
>>
>> _______________________________________________
>> HyperDB mailing list
>> HyperDB at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/hyperdb
>>
>
>