[Freeswitch-users] Performance bottleneck

[Yossi Neiman]

Just to clarify about the license for MySQL. MPL is listed as a 
compatible license by MySQL for using the client code (-lmysqlclient or 
-lmysqlclient_r). See EXCEPTIONS-CLIENT in the MySQL source tree. 
However, if you want to embed the whole database directly into 
FreeSWITCH, I believe that would be incompatible without the purchase of 
a commercial license.

-- 
Yossi Neiman
President
Cartis Solutions, Inc.
P) 630-259-8100
http://www.cartissolutions.com



Ken Rice wrote:
> Actually having evaluated MySQL for large scale environments it works 
> well up to a point... Postgres on the other hand has much more mature 
> replication, store procedures, triggers, a query cacher that insane 
> and no need to use mysql’s so called ‘hash tables’ to get the data 
> loaded into ram (pg does this automagically via its caching mechanism)
>
> Mix that with table partitioning and you have some fairly crazy numbers
>
> Real world deployments doing some pretty complex LCR shows that a 
> small cluster (4 boxes) or old dell 2650s are able to sustain > 40K 
> queries/sec (~10% being inserts for CDRs)
>
> When you get into this scale the real enterprise work that has been 
> done on pgsql starts to show thru... Companies like Greenplum feed a 
> good bit of their core performance tuning back to PgSQL... (for those 
> that are wondering pgsql is bsd licensed so its actually license 
> compatible w/ FreeSwitch say some someone want to look at replacing 
> sqlite with a pgsql engine)
>