Everyone knows that big data is here to stay, and one of the best NoSQL solutions out there is Hadoop. MySQL DBAs will need to know when to adjust and leverage Hadoop within their environment and even start using and administering Hadoop clusters.
Imagine a MySQL query that barely fits your monitor screen such as a 7 table join. This video discusses filling the gap between reading explain output and optimizing really large queries. Practical techniques used to address real-world situations are hared, while pointing out common mistakes organizations often make.
Using MySQL replication gives you an opportunity to scale out read queries. However, MySQL replication is asynchronous so the slave may fall behind. This MySQL webinar shows the correct ways to check when the slave is safe to query and how to architect your PHP application to adapt dynamically when the slave is out of …