It all depends on what you're doing. - About php.ini best practices As always, don't load things you don't need :) Check your apache config for keepalives and tweak your prefork/worker settings for example
- MySQL best configuration values Depends on your setup/database size, concurrent connections One of my configs: [mysqld] skip-innodb datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=1000 table_cache=1024 key_buffer = 256M query_cache_size = 256MB query_cache_limit = 64MB sort_buffer_size = 64M myisam_sort_buffer_size = 64M tmp_table_size = 256MB wait_timeout = 30 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid - What about Cache and performance? Use gzip compression, opcode cacher, set correct headers for caching images/css/javascript files cache large sets of generated data in memory(apc/memcache) - Is it really a good idea to setup a MySQL Cluster (to boost performance), the app is intended to have 100,000 registered users, maybe 50 to 100 users at the same time. 50 to 100 users at the same time isn't that much, depending on what queries your doing. Make sure you database structure and indexes are optimized. Best to freshen up database normalization etc :) Read http://blog.crazytje.be/tag/gzip/ , first of 4 blog posts(links are on the page) dealing around simple optimalizations. On Sep 21, 11:07 pm, bowikaxu <[email protected]> wrote: > How does Amazon EC2 works? > Ive been checking the webpage and looks a great alternative, but i > dont know what service to choose, will i have full server management, > or how does it works? > If you have any experience on this would be glad on any feedback. > > .. aad > > On Sep 21, 3:10 pm, dtemes <[email protected]> wrote: > > > Have you evaluated putting your app on the cloud? amazon EC2 would be > > a good option if you want to start small and scale as needed > > > On 21 sep, 20:03, andres amaya diaz <[email protected]> wrote: > > > > I am going to setup a dedicated server for a cakephp app, and i want > > > to know any good tips about the configuration. > > > - About php.ini best practices > > > - MySQL best configuration values > > > - What about Cache and performance? > > > - Is it really a good idea to setup a MySQL Cluster (to boost > > > performance), the app is intended to have 100,000 registered users, > > > maybe 50 to 100 users at the same time. > > > > Thanks for any good advice? > > > aad Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
