Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Ever spent your weekend debugging a MySQL production issue that could have been avoided with better configuration? I have, and it’s beyond frustrating. I have prepared my list of the…
The post What MySQL configuration you hate the most? first appeared on Change Is Inevitable.
MySQL Analysis: With an AI-Powered CLI Tool
As DBAs with MySQL we often live on a Linux terminal window. We also enjoy free options when available. This post shows an approach that allows us to stay on our terminal window and still use an AI-powered tool. You can update to use other direct AI providers but I set this example up to use aimlapi.com as it brings multiple AI models to your terminal for free with limited use or very low cost for more testing.
Note: I'm not a paid spokesperson for AIMLAPI or anything - this is just an easy example to highlight the idea.
The Problem
You're looking at a legacy database with hundreds of tables, each with complex relationships and questionable design decisions made years ago. The usual process involves:
You can connect to MySQL Server using MySQL Client (the command-line utility) and GUI tools. This article will review each method in detail.
The post How to Connect to a MySQL Database appeared first on Devart Blog.
The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance. In this blog post, I’m going to highlight the…
The post How to filter MySQL slow queries using pt-query-digest first appeared on Change Is Inevitable.
Error 'Table 'EMPLOYEES.POSITION' doesn't exist' on query.
Default database: 'employees'. Query: 'ALTER TABLE
EMPLOYEES.POSITION ADD COLUMN phone VARCHAR(15)' Interesting
, table exist on slave server . But we are getting above error
frequently and unable to broken the replication because database
size is too big
We are having environment as GTID replication setup with windows
server (Master) to Ubuntu Linux machine (Slave) . When we
dig into all the findings , concluded its may be with case
sensitivity issue . Lower_case_table_names variable value is same
on both servers . But as per MySQL documents Database
and table names are not case-sensitive in Windows , but are
case-sensitive in most varieties of Unix.Column,index,stored
routine, and event names are …
Problem :
We are running 5 node percona cluster on Ubuntu 16.04, and its
configured with master-slave replication. Suddenly we got an
alert for replica broken from slave server, which was earlier
configured with normal replication
We have tried to sync the data and configure the replication,
unable to fix that immediately due to huge transactions and GTID
enabled servers. So we have decided to follow with innobackupex
tool, and problem fixed in 2 hours
Followed all the steps from percona doc and shared the experience
in my environment
Steps involving to repair the broken Replication :
1.Backup master server 2.Prepare the backup 3.Restore
and Configure the Replication 4Check Replication Status
1.Backup …
Author: Robert Agar
The role of a corporate database administrator has evolved tremendously since the introduction of relational databases in the late 1970s. A DBA from the early 1980s would be totally unprepared for the complexities that face database professionals in 2019. It’s a completely different world and the skillset required has radically changed.
The heightened focus on the value of a company’s accumulated data has made DBAs more important to the business goals of an organization than ever before. Keeping this valuable resource safe and accessible is one of the modern DBA’s primary responsibilities. Many diverse methods are required to fulfill these duties, and a DBA must be comfortable using them all to address problems encountered in day-to-day activities.
Common Issues Faced by DBAs
The laundry list of issues that DBAs must deal with regularly is a long one. …
[Read more]This blog post explains benefits, features and limitations of the improved semi-sync replication in MySQL 5.7
The post Improved Semi-Sync Replication in MySQL 5.7 appeared first on Datavail.
Learn how to set up and use Percona's clustercheck script in a MySQL Galera Cluster.
The post Percona’s Clustercheck Script for MySQL Galera appeared first on Datavail.
This blog post focuses on MySQL 5.7's newly improved features of security validation and password expiration.
The post Security Validation and Password Expiration in MySQL 5.7 appeared first on Datavail.
