This video explains how to use the Tungsten replicator to move data in real-time between Oracle and MySQL. Continuent Tungsten is a commercial product that provides a production-grade solution to keep databases up, prevent data loss, provide database scaling, and improve resource utilization.
This presentation describes how attackers could take advantage of SQL Injection vulnerabilities using time-based blind SQL injection. The goal is to stress the importance of establishing secure development best practices for Web applications and not only to entrust the site security to the perimeter defenses. This article shows exploitation examples …
Do schema changes (“migrations”) require a lot of advance scheduling and impact your development and business progress? Is an ALTER TABLE on the critical path in your project planning chart? This common problem comes from the fact that most ALTER operations in MySQL cause the table to be locked and …
As MySQL powers business critical applications it is very important to be able to upgrade MySQL server with as low risk as possible. This presentation shows the best practices used by Percona to perform hundreds of MySQL upgrade projects as well as learn how to use Percona Toolkit to assist …
We have graphs for social networking and other complex structures, and some specialised tools to store and traverse them. But all our other data is in our SQL RDBMS with a convenient familiar API! And we all know that SQL databases are unsuitable for handling these types of structures! Or …
Every relational database has some machine scaling limits. This video presents the concept of Database Sharding – splitting the database to several independent databases, a solution proven highly effective for scaling MySQL. It discusss the steps required for building a sharding solution, the implications and limitations of such solution.
