AW: [Dbix-class] Data partitioning and DBIC

[Hartmaier Alexander]

Why not buy stronger hardware?
In times of 4 core cpus for no money I can't imagine that you have
performance problems, at least at the database side.
If so try postgresql, db2 or oracle and not mysql.

The object inflation of dbic slows down thing much more than the db access
for me.

-Alex


> -----Urspr=FCngliche Nachricht-----
> Von: Evaldas Imbrasas [mailto:evaldas at imbrasas.com]
> Gesendet: Mittwoch, 04. April 2007 20:00
> An: dbix-class at lists.rawmode.org
> Betreff: Re: [Dbix-class] Data partitioning and DBIC
> =

> > It would help to know what you're trying to accomplish with the
> > partitioning.  Are you trying to overcome performance limitations
> with
> > the number of rows in a single table or index with your database
> > vendor (and which vendor is it?)?.
> =

> It would be to improve the scalability of the database layer in the
> application. Basically, I see several ways to scale with MySQL:
> =

> 1) Use Master-Slave(s) replication, and do all reads from the slaves.
> The problem is that there is no way to be sure that the slaves have
> the most recent data at any given time. So it's better to use the
> slave as a reporting database (data warehouse), and/or for backups.
> =

> 2) MySQL Cluster. The current production version has a nasty database
> size limit, though, where the entire database x the number of nodes
> has to fit into memory of each node...
> =

> 3) Data partitioning. It could be done either at the table level
> (i.e., by choosing 'clusters' of tables and putting them on different
> database servers), or/and at the data level, when you split the table
> across database servers based on some value (i.e., the last digit of
> the primary key).
> =

> I'm trying to investigate whether DBIx::Class has any tricks up the
> sleeve to work with the data partitioned either at the table level or
> at the data level. If not, is there a clean way to override certain
> DBIC methods to deal with this situation?
> =

> --
> -----------------------------------------------------
> Evaldas Imbrasas
> http://www.imbrasas.com
> =

> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive: http://www.mail-archive.com/dbix-
> class at lists.rawmode.org/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5611 bytes
Desc: not available
Url : http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20070405/e4=
9a813f/smime.bin