development wrote:
> Dear All,
>
> I m setting up single master and single slave
> replication for our system. Our database size is
> 30 GB. Our master server is dual processor 2.8GHz,
> 4GB RAM etc.
>
> I wanted to ask; wheather for slave server we
> require the same configuration machine or we can
> setup of single cpu 2.8GHz, 1 GB RAM machine? Our
> appliation is bit heavy application.
>
> Thanks
> Rushik.
While this setup would work, remember that the replication thread is single-threaded, and will process only 1 SQL statement at a time. You may want a faster machine for the slave to keep up with the master.
Partha Dutta
Senior Consultant, MySQL Inc.
http://www.mysql.com