Enabling TokuDB in Percona server 5.7

The TokuDB engine must be separately downloaded and then enabled as a plug-in component in previous versions. This package can be installed alongside with standard Percona Server 5.6 releases starting with 5.6.19-67.0 and does not require any specially adapted version of Percona Server. After acquisition Percona has integrated the TokuDB with their standard Percona Server distribution. … Continue reading Enabling TokuDB in Percona server 5.7

Storing JSON Data Type In MySQL

What is JSON ? Json (Java script object notation ) is a lightweight data-interchange format. It’s easy for humans to read and write.It’s easy for machines to parse and generate. It is used primarily to transmit data between a server and web application, as an alternative to XML. If you want more details click here JSON … Continue reading Storing JSON Data Type In MySQL

Percona Tool kit for Effective MySQL Administration

At MyDBOPS we focus on faster database operations. So we have build our own set of our tools and also we use standard open source tools. Percona tool kit and Xtrabackup are some of the prominent tools we use. This is presentation about a few percona tool that every DBA should consider using it.