Exploring Aurora serverlessV2 for MySQL Part 2 – Migration

Greetings everyone!!!!! Let's begin the phase II of our blog on Aurora serverless-V2. Part 1 - https://mydbops.wordpress.com/2022/05/22/exploring-auAurora-serverless-v2-for-mysqlHere, I have focused primarily on the migration strategies, hence this blog will be helpful for those who are in a stance to migrate towards serverless V2. Before entering into the migration strategies, let's take a look at the …

Advertisement

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 …

Synopsis of Mydbops 19th edition of MyWebinar

Thank you to everyone who joined us for the 19th 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 in the coming days by presenting more LIVE events. Recently, Mydbops conducted a webinar on the top …

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 …

MongoDB Index type and Properties (Series 2)

I'm hoping that after reading the previous blog, you will have a better understanding of indexes and the guidelines for building one. In this blog, I am going to share index types and their characteristics. Index TypesSingle Field IndexCompound IndexSort OrderMultikey IndexLimitations of MultiKey IndexCompound Multikey IndexesGeospatial Index2dsphere2dLimitations of the Geospatial IndexText IndexesLimitations of Text …

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 …

Synopsis of Mydbops 18th edition of MyWebinar

We’re ecstatic and energized about the prospect of sowing seeds of knowledge in our open-source database community. Thank you to everyone who joined us for the 18th 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 …