Managing RDS MySQL logs – RDS needs DBA -1
RDS is popularly known as AWS managed service but we would like to call it as CloudDBA managed service . We are starting this series “RDS – Managed by CloudDBA” to focus on the need for DBA in......
Create your two “free forever” PostgreSQL/MySQL servers today
Oracle cloud gives you two always-free vms which can be used as sandbox servers. So next time when you want to test a new database feature , research on a problem, remember this and use them to save...
Innodb Cluster Open Book (Github Wiki) Launched
“We just launched Innodb cluster open guide on our github page. Please hit below URL to access it . We will be adding more pages soon . Please send your valuable feedback” Click here to go to our...
Cut 50% of your backup storage costs using blockchain storage
Table of Contents What is Tardigrade ? It is the world’s first S3-compatible decentralized cloud storage solution (Powered by Storj Labs) . Each file uploaded will be encrypted and split into 80 chunks and distributed across the satellite...
Vitess and Workbench – Compatible pair ?
Workbench is the most popular mysql client GUI tool . Does it work well with Vitess ? We are using sample cluster given in the docs. Ensure that you have 3 mysql instances, 3 vttablets , vtgate ,etcd...
Understanding Innodb History Length – Part 3
NOTE : This is PART 3 of series. Please go to our blog section and read PART 1 and 2 (If you have not done that already) Working Example: Let’s understand this with an example through sysbench. Example...
Innodb Cluster 5.7 Vs 8 – 10 Things to know
If you want to read details on below topics click here for detailed article.
MySQL 5.7 and Innodb cluster : Must read series – Part 2
You are reading Part 2. Please read Part 1 of this article here 6. Consistency levels Default behaviour is EVENTUAL consistency for innodb cluster. What does this mean ? Eventual Consistency : The transaction does not wait for...
Understanding Innodb History Length – Part 2
NOTE : Please read Part 1 before proceeding further . Part 1 discusses isolation levels , roll ptr and other basic concepts . This article has advanced content and is hard to understand unless you grasp the concepts...
MySQL 5.7 and Innodb cluster : Must read series – Part 1
1. Cluster status – Extended information In version 5.7 cluster.status() does not include replication lag or the recovery status of nodes in a cluster. Lets say you are noticing intermittent lag , you need to use commands like...