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.
This short tutorial explains how to replace your MySQL database with a MariaDB database.
Learn the differences and similarities among Oracle’s MySQL, MariaDB, Drizzle and the Percona patchset. You will learn the coding philosophies of the organizations behind the MSQL forks and how they interact with the community, so you can choose which fork is right for you.
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.
This presentation presents the history of MySQL and discusses its relationship with the MariaDB fork and their possible future.
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 …
