…
Additional Resources
Screencast: Introducing Regions
Dev Center: Configure SSL for Europe Region Apps
Dev Center: Production Tier Postgres Database Migration
Dev Center: Starter Tier Postgres Database Migration
Domas Mituzas , Database Engineer
Harrison Fisk , MySQL Performance Engineer
Yoshinori Matsunobu , Database Engineer
Their breakout session is entitled " MySQL at Facebook: lots and lots of small data ". They will explain how MySQL remained relevant at Facebook through a combination of good product ( MySQL), good people, and good process. The Q&A session following their presentation promises to be engaging and thought provoking. …
Database
Optimizing your database is another easy, but effective, way to ramp up performance. The first step is regularly deleting spam comments and post revisions. WordPress saves each change as a separate revision in your database. This is great if you need to revert to a previous version, but it can also really slow you down. This is another area where plugins are helpful. Try installing Revision Control , or if you need more comprehensive database optimization, try the WP-DBManager …
Over the last few months as well as working on the day job developing Neo4j , Ian Robinson , Emil Eifrem and I have been working on writing a new book for O'Reilly that showcases the expressive power and technical capabilities of graph databases. I'm really happy to announce that the fruits of that labour has now been released as a full , free early-access eBook, aptly named Graph Databases .
Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
Following Roel's post, Percona Server on the Raspberry Pi: Your own MySQL Database Server , I thought what other crazy gadget can I run Percona Server on? And having an Asus Nexus 7 Android tablet I decided to give it a try.
Anything below contains a risk that you break your tablet if you do not know what you are doing, so be advised.
First, we need rooted …
Database
Once you've ensured that MySQL your data store isn't a bottleneck, you need to analyze your queries generated by your theme and plugins to either optimize them (reduce their response times), reduce their number through refactoring code or various caching techniques. Remember that by default, using transients in WordPress ‘moves the problem' of caching something like a time consuming API request ( API requests become expensive because they …
…basis for chapters for our next book project (since our current book project Graph Databases (O'Reilly) is nearing completion). However all the teaching materials (and in particular that big, slow-to-clone PowerPoint deck) are going away since the teaching materials will be focussed in the book itself rather than as slides. The deck will - of course - remain in version control history but over time it will become inconsistent with the koans so be careful if you use historical materials …
Starting to feel like we might actually have a winter this year.
Git Gutter - ST2 plugin that shows git line status in the gutter.
Labrador 0.2 - Database client focused specifically on Rails development databases.
TraceKit - JavaScript library for uniform stack traces across all the major browsers.
box2d-jQuery - Amusing code that turns your DOM into "physical" objects that fall down and can be kicked around.
…
Database redundancy
Diversified geographic locations
The best thing to do is figure out your individual requirements and do your homework. If your application is on Engine Yard, then go ahead and reach out to our [ Professional Services](http://www.engineyard.com/services) team. They offer free High Availability consultations and will custom-tailor a solution that fits your business needs.
I hope you've enjoyed this blog post! Feel free to leave comments below and visit the following …
Database Community EOL Maintenance End of Life Postgres 8.3 February 2013 December 2012 January 2013 MySQL 5.0 December, 2009 March 2013 December 2013
Due to the high number of customers using MySQL 5.0, we will focus on providing additional upgrade paths and documentation. We'll keep you informed on our progress; we are planning a series of blogposts to help you migrate off 5.0 starting next year.
Keep in mind that there are many benefits to upgrading …