Drupal 7 Job -- Seattle-Everett, WA.
I hope it is okay to post job offers here. If not then I apologize.
We're a small, Renewable Energy company based out of Washington State looking for some Drupal 7 help. Women and women-led teams are strongly encouraged to apply for this role. We'd prefer someone in the Seattle-Everett area but remote may be fine too.
Fine-grained MySQL tables privileges
Regarding Drupal site security, I am really surprised to see that MySQL settings do not keep an important place in Securing your site discussion.
Yet a very simple MySQL policy would have prevented Drupageddon to your site.
According to INSTALL.mysql.txt, MySQL user used by Drupal, must have the following minimal privileges on Drupal database:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES.
Read moreDrupal Database Development
The percona-query-digest tool is excellent at tracking down queries that kill performance. The queries can be re-written on modified schemas with better indexes and you're golden. Once that's done you need to institure some healthy happy ways to avoid the problem continuing to recur through a little education and some development routines.
Read moreSeeking part-time developer to help finish site
You are a talented and dedicated software developer proficient with Drupal (not a firm), and competent with mySQL databases, and willing to learn a bit about Ubercart. You are also available to work on a part-time basis.
We are a small company about to roll out a website with over 19 million business listings that allows homeowners to search for local businesses and service providers.
Read moreMySQL table_cache: Is lower better?
In the past, using MySQL tuning scripts like mysqltuner.pl and tuning-primer.sh have always suggested increasing table_cache to fairly high levels. I've now been reading a few articles about benchmarks that have suggested a lower table_cache can often result in better performance (one such blog post at http://www.mysqlperformanceblog.com/2009/11/16/table_cache-negative-scal...).
So I was wondering what experiences people have had running Drupal sites in terms of tweaking table_cache.
Read moreMySQL Tuning: tmp_table_size and max_heap_table_size
I'm switching over to a new server for my Drupal sites and am starting to tweak MySQL using tuning-primer and mysqltuner. I'm hosting on a VE server at Media Temple with (currently) 1GB of dedicated RAM. The database is currently MyISAM with no INNODB.
Read more