[TYPO3] 2 Questions on MySQL for Typo3
Corrado
support at eeos.biz
Thu May 10 11:54:38 CEST 2007
Georg Großberger wrote:
> Hi all,
>
> Yesterday I read Dmitrys presentation sheet on Typo3 perfomance tuning. He
> suggests a RAID 5 for MySQL, but MySQL themselves recommend a RAID 10.
> What are your experiences?
>
> Another thing is the partitioning feature in MySQL 5.1, which highly
> improves performance, when working with a huge mass of records. How could
> someone use this feature in Typo3? Partitioning via language, or PID or
> something else?
>
> I'm everything but a MySQL guru, so someone may share his/her experiences
> with us.
>
> Georg
Concerning hardware, it depends on your budget. RAID 5 is a good compromise
between costs and safety of data. Mirroring is more expensive but safer,
and should also be faster, if it is done at hardware level. Be careful
between software and hardware raid options, because hardware raid option
are effectively faster, whilst software raid option can put load o your
processing capability.
That is what I can remember by now about raid.
Concerning MySQL itself, why don't you drop a line on the mysql list? they
should know!
Hope this helps
Corrado
--
eeos communications (technical support)
http://www.eeos.biz
More information about the TYPO3-english
mailing list