Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.…
Tweet Share
There may come a time you need to rename one or more columns in
an existing MySQL table for a variety of reasons. Using
ALTER TABLE, to rename a column is an easy enough
command. But, suppose there are multiple tables in the same
database/schema that have the same-named column and all of those
columns need to be renamed. That could be a lot of ALTER
TABLE statements to type out. Save your energy and time,
avoiding all of those ALTER TABLE commands
all-together. If you are lucky enough to be working with a MySQL
version > 8.0 then the Shell is your salvation. With just a
few lines of Python code in \py mode, all of your
trouble(s) and headache(s) are no more…
Photo by Ibrahim Rifath on …
[Read more]These are my notes for creating a small Node.js application that queries a MySQL database. The post will show you how to:
This blog post assumes you’ve performed a global install of Node.js on a Linux server. If you’re unfamiliar with how to perform a global Node.js installation, I cover how to do it in this earlier blog post.
Before you write the Node.js applicaiton, you need to setup a
db developer directory. Then, create a
node_modules symbolic link to the
/usr/local/lib/node_modules directory in the
db directory. You can use the following command …
On July 21, 2020, Percona delivered an updated version of our Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) focused on easing deployment and operations management of a clustered MySQL environment. Included in the Percona Distribution for MySQL, our Operator is based on the best practices for MySQL cluster configuration and setup in Kubernetes. This update adds a variety of important new features including:
Smart Update to Safely and Reliably Upgrade your PXC
Environment Automatically
We implemented a new update strategy called Smart Update. Smart Update is aware of the
context of your environment and minimizes the number of failover
events that need to occur to fully upgrade a …
On Monday, July 13, 2020, Oracle released MySQL 8.0.21. This release contained a few new changes that cause issues with Percona XtraBackup.
First, this release introduced the ability to temporarily disable InnoDB redo logging (see the work log and documentation). If you love your data, this feature should ONLY be used to speed up an initial logical data import and should never be used under a production workload.
When used, this new feature creates some interesting complications for Percona XtraBackup that you need to be aware of. The core requirement for XtraBackup to be able to make consistent hot backups is to have some form of redo or write ahead log to copy and read from. Disabling the InnoDB redo log will prevent XtraBackup from making a …
[Read more]The Percona Kubernetes Operator for Percona XtraDB Cluster can send backups to Amazon S3 or S3-compatible storage. And every now and then at Support, we are asked how to send backups to Google Cloud Storage.
Google Cloud Storage offers an “interoperability mode” which is S3-compatible. However, there are a few details to take care of when using it.
Google Cloud Storage Configuration
First, select “Settings” under “Storage” in the Navigation Menu. Under Settings, select the Interoperability tab. If Interoperability is not yet enabled, click Enable Interoperability Access. This turns on the S3-compatible interface to Google Cloud Storage.
After enabling S3-compatible storage, an access key needs to be generated. There are two options: Access keys can be tied to Service accounts or User accounts. For …
[Read more]MySQL 8.0 finally allows you to use roles to grant privileges. Most companies are now required to fulfill stricter security requirements, one of those requirements is each user must login using their own username. Roles allow you to grant individual … Continue reading →
Yesterday (17/Jul/2020) I’ve added a separate feed for MySQL topics. It can be accessed at the address https://saveriomiroddi.github.io/feed/mysql.xml (also represented by the dolphin icon in the navigation bar of the blog).
In this tutorial, we will show you how to create a backup of MySQL databases on an Ubuntu 20.04 VPS, ...
The post How to Create a Backup of MySQL Databases Using mysqldump on Ubuntu 20.04 appeared first on RoseHosting.
The MySQL team is proud to announce the general availability of version 8.0.21 of the MySQL Shell.
MySQL Shell Logical Dump and Load Utilities
A new suite of logical dump utilities was introduced in MySQL
Shell 8.0.21.
util.dumpInstance(),
util.dumpSchemas() and
util.loadDump()…
Facebook Twitter LinkedIn