PostegreSQL is a plain old SQL database, very powerful and very consistent. In some case, project needs an ACID database, but schemaless.. With JSON support, PostegreSQL is a very interesting tool to provide ACID and some very interesting function (time management, localisation function and data types…) and the schemaless NoSQL …
Troubleshooting MySQL problems doesn’t need to involve trial-and-error and it doesn’t need to take a long time. You need only two things: a good process and good tools. This session shows you an approach that the speaker has used to solve many frustrating problems quickly, and open source tools that …
Sphinx is an open-source search tool that can also do other magic. Blazing full-scans, easy multi-core and multi-box queries, and wicked fast math spring to mind. When the queries are right, 1-billion-pageview sites switch from MySQL to Sphinx for over 90% of the query impact. It also has 175 (and …
MySQL 5.6 was released in February 2013. It is the largest release of MySQL in history (measured by code size increase) and contains a number of very useful enhancements to replication, performance and security. What I want to talk about however is how it’s now much easier to run in …
This presentation discusses how to get great MySQL performance while being practical – spending time on what gives you the best return. It covers the main areas for improving MySQL performance, pointing out the most important things you need to get right for each of them.
As is the case for many websites and applications, when the size of its users reach a certain point, critical changes to the architecture must be made. This presentation discusses how Lanyrd addressed this problem, when they decided to move from MySQL to PostgreSQL, and from AWS to Softlayer.
