Remove auditing-by-reading-the-sql-server-transaction-log
article thumbnail

Deep Dive into MySQL’s Performance Schema

Percona

Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. Instruments are a combination of different sets of components like wait, io, sql, binlog, file, etc. Instruments are being read from left and then components will be added with delimiter “/”.

article thumbnail

An Introduction to MySQL Replication: Exploring Different Types of MySQL Replication Solutions

Percona

In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works , its benefits and challenges, as well as reviewing some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). Set the server-id to a unique value.

Servers 52
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. Contact us to learn more!

article thumbnail

MongoDB Security: Top Security Concerns and Best Practices

Percona

Because of its NoSQL origin and document architecture design, MongoDB is much more flexible and scalable than SQL databases such as MySQL. Because of its NoSQL origin and document architecture design, MongoDB is much more flexible and scalable than SQL databases such as MySQL. MongoDB databases commonly exceed a terabyte of data.

article thumbnail

Backup and Recovery for Databases: What You Should Know

Percona

For a more detailed description, read Full vs. Incremental vs. Differential Backups: Comparing Backup Types.) So staying with our analogy, and learning from historical lessons, organizations must be responsible stewards of data — for the sake of customers, stakeholders, and the business itself. Solid backup procedures must be in place.

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40
article thumbnail

CDN Web Application Firewall (WAF): Your Shield Against Online Threats

IO River

For instance, let's say you operate an e-commerce site and you've noticed a pattern of fraudulent transactions originating from a particular IP range. But not all of these are meant for you; some could be scams, spam, or even dangerous items. ‍This is where WAF comes in! Think of WAF as the security guard for your special mailbox.

Traffic 52