Introduction: MySQL 5.7 introduces a new feature called virtual/generated column. It is called generated column because the data of this column is computed based on a predefined expression or from other columns. What is Virtual Column ? In general virtual columns appear to be normal table columns, but their values are derived rather than being … More Virtual Columns in MySQL and Use cases.
In this blog we are going to view about a new feature in latest release MySQL 8.0.1 for MySQL Replication . It is binlog_expire_logs_seconds. Previously we can set the expire logs for binlogs in number of days. By using the new feature (binlog_expire_logs_seconds) we can see set the expire time into number of seconds. The … More Binlog expiry now in seconds (MySQL 8.0)
In this blog we are going to explore about innodb tablespace encryption technique, which will be useful for securing data. In MySQL 5.7, a new feature “Innodb Tablespace Encryption“has been added to protect the data at rest. This is a most awaited feature in security. This encryption supports all file per table tablespaces and it … More MySQL Tablespace Encryption ( TDE )
Optimiser is the brain of the RDBMS. Optimiser decides the right access method , algorithms , join order and right index to be used for better execution of the query. This blog is made to shed some lights on Cost based optimiser in MySQL 5.7. The cost or statistics are stored in the data dictionary … More Cost-based Optimization in MySQL 5.7
Introduction: Password is be like the words, numbers and string of characters. On database and server side, the username and password were should needed for certain access. The password should be structured and security based. In this section we are going to take a elaborate view on validate_password plugin in MySQL. We have seen about … More Security: MySQL Password Validation Plugin
Introduction: Basically, Auditing is the process of monitoring and recording the activity happens inside the Server. MariaDB Audit Plugin is works with MariaDB, MySQL and Percona Servers. It is used to log the database Operations like, SQL Statements, User informations, Connections. The informations are stored in a user defined log file or in Syslog. Available audit … More Integrating MariaDB Audit plugin in MySQL 5.7
Presentation on MySQL Sys Schema in MySQL 5.7. Sys Schema views can help in better monitoring and understanding the MySQL resource consumption at various levels.
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 … More Storing JSON Data Type In MySQL
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.
One of the prime feature that makes MySQL popular as an open source database from early days was Replication. MySQL Replication has under gone various improvements in MySQL 5.7. The prominent replication features in MySQL 5.7 are True Multi Threaded Replication ( MTS ) , Multi-source replication and Group Replication ( in lab) . Multi … More Multi-Source Replication in MySQL 5.7