Backup and Recovery is one of the most essential jobs for every database administrator. We all know the importance of the backups for the databases. Here I am not going to write its importance, rather about the different types of backup tools available for … Continue reading Exploring Logical Backup in PostgreSQL.
Human geography examines the dynamics of cultures, societies and economies, and physical geography examines the dynamics of physical landscapes and the environment. In this blog i am going to explain what are the new Geography features available in MySQL 8.0 Major Difference in MySQL 5.7 & 8.0 Geography : There is a big change from … Continue reading GeoSpatial data handling made easy with MySQL 8.0
The world is in a pandemic situation and I believe everyone doing good. Please Stay Home! Stay Safe! In this situation, most of the people are doing WFH, and I believe its the right time to talk about how to enable the Developer, OPS Team, and DBA can initiate secure encrypted TCP connection instead of … Continue reading Securing MongoDB Cluster with TLS/SSL
COVID-19 is creating a perfect storm of instability, confusion and threats for private and public sector organisations. Every organization is almost certainly negatively affected by the current pandemic, though a few may be able to draw some optimistic conclusions from those difficult days. Here are four different ways COVID-19 is impacting Organizations who are trusting … Continue reading How Mydbops Managed Database Services could prove helpful during this Pandemic ?
This presentation covers about the basics of Group replication in MySQL 8.0. Group replication world on the basis of Multi Paxos ( a variant of it ). The author covers the leader election algorithm , switching the primary node and replication modes in this presentation. https://www.slideshare.net/MyDBOPS/group-replication-in-mysql-80-a-walk-through Like to have this high availability MySQL solution configured … Continue reading Presentation : Group Replication in MySQL 8.0
We are aware of ProxySQL as an SQL load balancing tool with a lot of features bundled in it.Now it has added firewall rules integrated too. Below are a few interesting features explained and explored by our Mydbops team. MySQL replication Read-Write Split up Replication Switchover using ProxySQL And MHA HA for Proxysql with keepalived … Continue reading Building a MySQL Firewall with ProxySQL
MySQL has come up with window function in latest GA MySQL 8.0 . It is a major leap in SQL for MySQL. This presentation provides an overview to window function in MySQL 8.0. https://www.slideshare.net/MyDBOPS/window-functions-in-my-sql-8 Window Function in MySQL 8.0
Data security plays a major role in current age. Privacy matters a lot. Data masking is one of the Key Features when comes to security. In MySQL community versions if you want to mask your data, You can go with a Maxscale load balancer. They introduced a new masking filter on the Maxscale 2.1 version. … Continue reading Security: Data Masking in MySQL 8.0 server
Firstly, let’s start with the Universal Truth: STAY HOME, STAY SAFE, WORK FROM HOME. Said that, we are already aware that database is the schema for any business operations. Procrastination in optimizing the database will lead to a disaster. Hiring a resource considering the present situation is even more tedious. Mydbops can help in your … Continue reading Present Pandemic Situation is Daunting!!! Mitigate your Worries on Database to Mydbops.
Resource management is one of the key thing in all RDBMS. DB Connections is one of them. In PostgreSQL, Allocating more connections without proper analysis of resources causes an overhead in Memory usage and the creation of an OS process for each connection will lead to a scheduling overhead in the time-sharing operating system. These … Continue reading Getting started with PGBouncer in PostgreSQL