If you are a developer that deals with MySQL or a MySQL database administrator, you probably know what MySQL database engines are. One of the most popular database engines as far as MySQL or MariaDB is concerned is InnoDB. – This storage engine is very widely regarded as a high-performance storage engine that also balances high performance with high reliability. ———————————————————————————————————- …

Continue reading "InnoDB: High Performance vs. Reliability with dbWatch"

About the Author: Lukas Vileikis is an ethical hacker and a frequent conference speaker. Since 2014, Lukas has found and responsibly disclosed security flaws in some of the most visited websites in Lithuania. He runs one of the biggest & fastest data breach search engines in the world – BreachDirectory.com, frequently speaks at conferences and …

Continue reading "Challenges of Scaling MySQL: dbWatch to the Rescue"

About the Author:  Chad Pabalan is a Pre-Sales Engineer for dbWatch and a DBA specializing in SQLServer high availability setups and disaster recovery planning and configurations. He is an AWS Certified Solutions Architect Professional, a cloud enthusiast specializing in architecture and designing scalable, high available, and fault-tolerant systems on AWS Cloud.  As a DBA, infrastructure admin, or manager, you may have encountered a scenario where you are tasked to lead, plan and execute a server migration project for reasons such as: …

Continue reading "The 5 R’s in Server Migration Planning"

About the Author: Lukas Vileikis is an ethical hacker and a frequent conference speaker. Since 2014, Lukas has found and responsibly disclosed security flaws in some of the most visited websites in Lithuania. He runs one of the biggest & fastest data breach search engines in the world – BreachDirectory.com, frequently speaks at conferences and …

Continue reading "Monitoring The Performance Of Database Indexes With Dbwatch"

About the Author: Lukas Vileikis is an ethical hacker and a frequent conference speaker. Since 2014, Lukas has found and responsibly disclosed security flaws in some of the most visited websites in Lithuania. He runs one of the biggest & fastest data breach search engines in the world – BreachDirectory.com, frequently speaks at conferences and …

Continue reading "Managing Your Database Instances With Dbwatch"

About the Author: Chad is a Pre-sales Engineer for dbWatch and a DBA who specializes in SQLServer high availability setups and disaster recovery planning and configurations. He is an AWS Certified Solutions Architect Associate, a cloud enthusiast who specializes in architecture and designing scalable, high available, and fault-tolerant systems on AWS. As a database administrator managing many different database instances on various platforms, it can be difficult for you to track various aspects of your performance within your database farm. You …

Continue reading "Create A Customized Database Performance View In Dbwatch"

About the Author: Chad Pabalan is a Pre-sales Engineer for dbWatch and a DBA who specializes in SQLServer high availability setups and disaster recovery planning and configurations. He is an AWS Certified Solutions Architect Associate, a cloud enthusiast who specializes in architecture and designing scalable, high available, and fault-tolerant systems on AWS Introduction to Database Farms  Companies use different database management systems to store large amounts of data for processing and analysis; some companies have massive data warehouses (OLAP) for analytics …

Continue reading "dbWatch Control Center for managing Database Farms"

About the Author: Lukas Vileikis is an ethical hacker and a frequent conference speaker. Since 2014, Lukas has found and responsibly disclosed security flaws in some of the most visited websites in Lithuania. He runs one of the biggest & fastest data breach search engines in the world – BreachDirectory.com, frequently speaks at conferences and …

Continue reading "Monitoring MyIsam Performance With Dbwatch – a Guide"

About the Author: Lukas Vileikis is an ethical hacker and a frequent conference speaker. Since 2014, Lukas has found and responsibly disclosed security flaws in some of the most visited websites in Lithuania.He runs one of the biggest & fastest data breach search engines in the world – BreachDirectory.com, frequently speaks at conferences and blogs …

Continue reading "Monitoring InnoDB Performance with dbwatch – a Guide"

How is database farm management different from instance management? Why do you need it and when? That is what I will try to shed some light on in this blog. If you are responsible for a database farm, read on. Managing instances – watching and tuning performance, handling incidents, and generally maintaining them has always been the DBA domain. …

Continue reading "From SQL Instance Management to Database Farm Management"