Prevent ProxySQL from directing traffic to broken MySQL replica

ProxySQL is an open-source MySQL proxy server, meaning it serves as an intermediary between a MySQL server and the applications that access its databases. ProxySQL can improve performance by distributing traffic among a pool of multiple database servers. Consider 2 slaves are routed under Proxysql , In any one of the slave, if the replication …

View And Materialized View In MongoDB

MongoDB supports view and materialized view. This blog will give an overview of the views in MongoDB. DB ViewCreate Viewdb.createCollection() Syntaxdb.createView() SyntaxExampleQuery the ViewOutputAdvantagesIndexesRestrictionsSupported Mongosh MethodsUnsupported OperationsResource LockingRemove a ViewOn-Demand Materialized ViewsOn-Demand Materialized Views CreationComparison Views And Materialized Views DB View MongoDB 3.4 views are non-materialised views, and behind the scenes, the engine runs an …

Overview of Predefined Roles in PostgreSQL

The PostgreSQL community always adds new features in its release every year. One of the prominent features is the Predefined Role which was introduced in PostgreSQL 9.6 with a single role available. Now it is having more than 10 predefined roles. A predefined role is a built-in role that provided access to commonly needed information. …

pt-online-schema-change resulted in missing MySQL triggers ?

Recently, while doing a test process to examine resource usage and the time required to alter the table using pt-osc, it leads to a loss of triggers even though the --preserve-triggers option is specified. I made the decision to recreate the identical circumstance so that everyone could see it. Test environment :  OS: Amazon Linux …

Terminate In-Progress Index Builds in MongoDB (series 3)

MongoDB uses B-Tree internally. We will understand about Terminating In-progress index builds, and the index build process, commit quorum, and dropping an index in this blog. I have added flow charts to make the information interactive. let's start! Terminate In-Progress Index Builds Before 4.4From 4.4Abort In-Progress Index BuildsCommit QuorumRequires featureCompatibilityVersion 4.4+Index Build ProcessSet Index Commit QuorumsetIndexCommitQuorumResource …

Generate Invisible Primary Key (GIPK) MySQL 8.0

The Primary key is like the hero of a row, which has more beneficial features in the table while performing any task on the table. The DBA knows the importance of the primary key in the table and how to handle it. Notable features of having a primary key:Requirements:Enabling GIPK:Handling GIPK:BenchmarkingData loading :Limitations:Conclusion: Notable features …

MongoDB Rule for Indexing (Series: 1)

Any database must have an index, thus MongoDB is not exceptional in this regard. MongoDB features a tonne of interesting index types with fantastic properties based on the use cases it was created for. It has been a very long time since I considered writing a series of blogs about the MongoDB index at all …

Synopsis of Mydbops 17th edition of MyWebinar

We’re ecstatic and energised about the prospect of sowing seeds of knowledge in our opensource database community. Thank you to everyone who joined us for the 17th edition of MyWebinar. We hope that our time together helped to elevate and seam your work to perfection. We’re committed to giving back to the opensource database community …

Stream MySQL data with mydumper

Mydumper supports streaming of backups right from version 0.11.3 and the latest version Mydumper 0.12.3 it enabled its support for compressed streaming backup. This was the most awaited feature added to Mydumper, making it a more powerful tool for data migration to RDS or Cloud. If you are hearing mydumper for the first time, then …

Synopsis of Mydbops 15th edition of MyWebinar

We’re ecstatic and energised about the prospect of sowing seeds of knowledge in our opensource database community. Thank you to everyone who joined us for the 15th edition of MyWebinar. We hope that our time together helped to elevate and seam your work to perfection. We’re committed to giving back to the opensource database community …