We depend on MySQL replication to scale out easily. However, MySQL replication does not guarantee data consistency between the master and slave. Luckily there are free third-party tools to check and fix data consistency. This session will explain how to use those tools, and lead folks through the theory and practice of setting up continual…

We depend on MySQL replication to scale out easily. However, MySQL replication does not guarantee data consistency between the master and slave. Luckily there are free third-party tools to check and fix data consistency. This session will explain how to use those tools, and lead folks through the theory and practice of setting up continual…

We depend on MySQL replication to scale out easily. However, MySQL replication does not guarantee data consistency between the master and slave. Luckily there are free third-party tools to check and fix data consistency. This session will explain how to use those tools, and lead folks through the theory and practice of setting up continual…

Effective performance management and diagnosis necessitates collection of sufficient database statistics and timely analysis. Oracle provides AWR to collect statistics over desired period of time. It also provides ADDM to perform analysis of AWR. However, often AWR data is so huge that finding a sub-optimal SQL and bottleneck is like finding a needle in the…

Oracle Streams is a data replication and integration feature of the Oracle database. Streams enables the propagation of data, transactions, and events it is used for data replication and integration either within the database or between two different databases. This presentation will provide an overview of the streams Architecture, will discuss the basic configuration of…

Oracle Streams is a data replication and integration feature of the Oracle database. Streams enables the propagation of data, transactions, and events it is used for data replication and integration either within the database or between two different databases. This presentation will provide an overview of the streams Architecture, will discuss the basic configuration of…

Oracle Streams is a data replication and integration feature of the Oracle database. Streams enables the propagation of data, transactions, and events it is used for data replication and integration either within the database or between two different databases. This presentation will provide an overview of the streams Architecture, will discuss the basic configuration of…

Galera is a generic replication service, providing synchronous multi-master replication. We have used Galera to implement MySQL/InnoDB cluster with features like :* high availability* client transparency* high performance, write scalabilityThe presentation will give an overview of the unique Galera replication method showing the benefits of synchronous operation. Multi-master topology can give considerable performance boost, which…

Galera is a generic replication service, providing synchronous multi-master replication. We have used Galera to implement MySQL/InnoDB cluster with features like :* high availability* client transparency* high performance, write scalabilityThe presentation will give an overview of the unique Galera replication method showing the benefits of synchronous operation. Multi-master topology can give considerable performance boost, which…