Thanks for all the information.
>
>> I'm also curious how a single instance of Laconica would scale. Say
>> identica became very popular and was getting overloaded, how would
>> one
>> scale that particular instance of laconica? My guess is that the
>> bottleneck would be the database access and that going some master/
>> slave architecture would be a first step.
> Yes, it's already doing that.
>>
>> Is the underlying code
>> written to support this kind of scaling?
> Yes.
Can you tell me where to config the master and slave databases for
this kind of configuration. I didn't see anything regarding a master/
slave configuration in config.php.sample. Does the code simply do
all writes to the master and all reads from the slaves? When setting
up the MySQL replication, is there anything special that needs to be
done? For example, some systems require master only tables.
>> Is anyone running an
>> instance of laconica with more than an single database server?
> Yes, identi.ca does this.
>> I notice that the table types are MyISAM. This is probably so MySQL
>> full text search can be used. Of course this won't work very well
>> once the notice table gets large (millions) and/or the update rate
>> increases.
> Agreed. I'm looking into optionally using Sphinx, a full-text search
> engine, as an alternative to MyISAM + FTS.
Switching to innodb and Sphinx can make a huge difference. Is there
anyone actively working on this?
Regards,
Adam
_______________________________________________
Laconica-dev mailing list
[email protected]
http://mail.laconi.ca/mailman/listinfo/laconica-dev
