Skip to main content

Home/ BoxMonkey/ Group items tagged database

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Alex Street

Using Amazon RDS with PHP - AWS Elastic Beanstalk - 0 views

docs.amazonwebservices.com/...create_deploy_PHP.rds.html

ancestry amazon

shared by Alex Street on 25 Aug 12 - No Cached
  • Create an Amazon RDS DB Instance
  • Configure your Amazon RDS DB Security Group
  • allow access from the Amazon EC2 security group
  • ...4 more annotations...
  • Establish a database connection in your PHP code using your Amazon RDS DB
  • ance's public DNS name
  • find the name of your EC2 security group
  • Configure your Amazon RDS DB Security Group to allow access from the Amazon EC2 security group
Alex Street

List of genealogy databases - Wikipedia, the free encyclopedia - 0 views

en.wikipedia.org/...List_of_genealogy_databases

ancestry gedcom gedview

shared by Alex Street on 20 Jul 12 - No Cached
  • Alex Street on 20 Jul 12
     
    GeneaNet
Alex Street

Configuration for big number of individuals - 0 views

webtrees.net/...-for-big-number-of-individuals

webtrees mysql

shared by Alex Street on 14 Aug 12 - No Cached
  • 50 concurrent/interactive users - frustratingly slow
  • 1GB of RAM to MySQL sounds about right for your size of database
  • configure webtrees and MySQL
  • ...8 more annotations...
  • RAM, RAM and more RAM
  • webtrees will take advantage of MySQL's query cache and PHP/APC if they are enabled.
  • article on the WIKI with some suggestions regarding MySQL tuning.
  • capabilities of your server: software, memory, hardware (drives) and bandwidth
  • mediocre server can never be made to perform well,
  • good experiences with Amazon's servers and heavily uses their CDN as well.
  • I too use a CDN service, Cloudflare,
  • has substantially lightened the load on my server
Alex Street

MySQL Configuration - webtreesWiki - 0 views

wiki.webtrees.net/MySQL_Configuration

webtrees mysql

shared by Alex Street on 14 Aug 12 - No Cached
  • default configuration supplied on many installations is very poor
  • Configuration File
  • configuration settings are stored in a plain text file
  • ...16 more annotations...
  • my.cnf on Linux and MacOS-X.
  • errors in my.ini, MySQL will refuse to start
  • MySQL daemon process, mysqld.
  • configuration lines take the format setting-name=value.
  • find out the version of your MySQL server (
  • max-allowed-packet=32M
  • wait-timeout=60
  • slow query log (as the name suggests)
  • MySQL for query processing.
  • Caching
  • saves the result of each query you run
  • Setting this too high can be counter-productive.
  • table-cache=1024
  • key-buffer-size=64M sort-buffer-size=16M
  • MySQL has a large number of configuration options. Adjusting these can make an enormous difference to the performance of your database
  • my.ini
1 - 12 of 12
Showing 20▼ items per page