Categories
Products
Technologies
Top Rated docs

November 27, 2020

How to Secure MySQL: Part Two

In the previous post about MySQL security, we have covered a range of options that can be used to make your MySQL instance(s) more secure. They included: General MySQL security measures; Controlling access in MySQL;...

November 24, 2020

How to Backup Google Cloud SQL for MySQL and Restore on Your Own Server

Google Cloud SQL is a managed database service for MySQL, PostgreSQL, and SQL Server. Even if you are new to managed database services, it just takes a few minutes to set up Google Cloud SQL...

November 20, 2020

How to Secure MySQL: Part One

Whenever application security is mentioned, people think of securing applications against some of the most frequent attacks such as injection, broken authentication, sensitive data exposure, and the like. However, while these attacks are prevalent, knowing...

November 17, 2020

Monitoring Percona Server for MySQL – Key Metrics

In this blog post, we are going to look into some key metrics and status when monitoring a Percona Server for MySQL to help us fine-tune the MySQL server configuration for a long run. Just...

November 13, 2020

Full-Text Searches in MySQL: The Good, the Bad and the Ugly

Sometimes when searching in a MySQL database you might want to run full-text search queries against character-based data. Today we’re discussing the advantages and disadvantages of such search methods. What are Full-Text Searches in MySQL?...

November 10, 2020

How to Deploy Percona Server for MySQL for High Availability

Percona Server for MySQL 8.0 offers a number of clustering solutions for high availability out-of-the-box: Single-master: Asynchronous replication Semi synchronous replication Multi-master: Group replication InnoDB Cluster (a combination of MySQL Router, MySQL Shell and Percona...

November 6, 2020

Asynchronous Replication Automatic Failover in MySQL 8.0.22

  Oracle recently released MySQL 8.0.22, and this new version came with a new asynchronous connection failover mechanism. It allows a replica to automatically establish an asynchronous replication connection to a new source, in case...

November 2, 2020

An Overview of the Percona XtraDB Cluster Kubernetes Operator

If you have been around in the container world, you would know that it is pretty challenging to adopt a full Kubernetes automation for a clustered database system, which commonly adds a level of complexity...

October 30, 2020

Using the Percona Audit Log Plugin for Database Security

Why Do You Need To Use an Audit Plugin For Your Database? Auditing in a database doesn't deviate from its meaning as it shares the same connotation i.e. to inspect, examine, and evaluate for such...

October 29, 2020

Migrating Azure Database for MySQL/MariaDB to an On-Prem Server

Database migrations can impose huge challenges when you consider how to start, what tools to use, and how to achieve a full database migration successfully. Earlier, we have listed the top open source you can...

October 29, 2020

How to Backup Your Amazon RDS for MySQL and Restore on Your Own Server

Amazon Relational Database Service (Amazon RDS) is a web service to create and operate relational databases online. With this service, you get to automate time-consuming tasks like hardware configuration, database setup, or patch deployment. Amazon...

October 28, 2020

Migrating Google Cloud SQL for MySQL to an On-Prem Server

Google Cloud SQL for MySQL is a fully-managed database service that helps you set up, maintain, manage, and administer your MySQL relational databases on Google Cloud Platform. However, there are differences between Cloud SQL and...

Subscribe below to be notified of fresh posts