Posted by Crell on August 24, 2008 at 8:17am
Jump to:
| Project: | Drupal core |
| Version: | 8.x-dev |
| Component: | database system |
| Category: | task |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
The new database API supports flagging queries as safe to run against a slave server if the site is using Master/slave replication. We should go through core and flag all queries that are "slave safe" while converting those queries to the new API. That should have no effect on most sites but on those using Master/slave replication (like Drupal.org) it should be a performance boost.
A query is slave-safe if it is OK if the data it retrieves is out of date by up to several minutes. Mostly that is true for reporting and statistical data, like the tracker module.
The current list of queries modified on Drupal.org to use a slave server would be a really good place to start. :-)
Comments
#1
We added a few, but I don't think Dries will let us add any more. :-( If you're running a big site with master/slave replication in Drupal 7, please give us feedback on what is and is not slave-safe! We can fold that data into Drupal 8 by just flagging more queries.
#2
subscribe
#3
Oh q0rban always a couple of days ahead of me :)
sub.
#4
subscribe (running with the cool kids).