Up to MySQL 8.0.16, to perform these tasks you could:
- Use MySQL Enterprise Backup :
- Use mysqldump
Starting with MySQL 8.0.17, the easiest and recommended method is to use the CLONE feature.
The post MySQL InnoDB Cluster - Easy Recovering and provisioning first appeared on dasini.net - Diary of a MySQL expert.
Oracle Code One starts September 16th and the MySQL Track is
packed with interesting presentations. The session coded that
start with 'DEV' are general talks. Hands on Labs start with
'HOL' and you will have a pre imaged laptop to use to do the lab
work. And 'TUT' is for tutorials. Use the mobile
OOW/CodeOne app to reserve your space as space is limited and
there is limited stand by space.
I highly recommend the State of the Dolphin talk on Monday as
that will provide the richest overview of what is going on within
the MySQL Community.
And Tuesday night is the traditional MySQL Community Reception
from 7-9:00 PM at the Samovar Wine Bar which is open to
all.
Monday, September 16 Foreign Key Support in MySQL 8.0: Change,
Opportunities, and …
On October 3rd ProxySQL will have it’s very first technology day. They have chosen the lovely city of Ghent, Belgium, my home town, as the place to be. For those attending Percona Live Europe in Amsterdam, this is a great opportunity to extend your stay for a bit and take a two-hour train ride from the Percona Live venue at Amsterdam airport to Ghent where you can get some additional ProxySQL-specific content.
The ProxySQL team has selected a few experienced speakers to come and talk about their product. Vlad Fedorkov from ProxySQL LLC will have two sessions. The first one will be about High Performance MySQL and the second one will be about traffic management and performance troubleshooting. Oracle’s MySQL Community Manager, Frederic Descamps, will talk about using ProxySQL with InnoDB Cluster (Group Replication) and Percona’s Marco Tusa …
[Read more]One of the great things about working at Percona is the constant innovation that occurs as a result of a deep level of technical expertise. A more recent conversation about the Information Schema table: innodb_cached_indexes led to the desire to produce this information in an easy to digest and useful format. Enter PMM.
Our goal with creating this dashboard was to help bring further insight into how your MySQL database cache is being used. Why is this important? Data is accessed significantly faster when it is cached, so indexes that are cached will allow for an increase in query performance. Until now there has not been an easy way to see which indexes are cached and which are not. We want to take the …
[Read more]The MySQL Router is evolving quickly, seemingly following fast in areas that matter for InnoDB Cluster. For instance, this blog post from Jan Kneschke in MySQL-Router 8.0.16 an http webserver was added to support monitoring and management of the router instance. The webserver stages the way for those things at least, which is great next… Read More »
The MySQL Router is evolving quickly, seemingly following fast in areas that matter for InnoDB Cluster. Updated May 20, 2020: added MySQL account for router, added list-router output at the end For instance, this blog post from Jan Kneschke in MySQL-Router 8.0.16 an http webserver was added to support monitoring and management of the router… Read More »
Author: Robert Agar
MySQL is one of the most popular relational database platforms in the world. As such, it is used as the backend of many mission-critical applications across all sectors of business and industry. If you are a DBA or database developer there is a high probability that you are working with MySQL now or will be in the near future.
One of the primary responsibilities of a DBA is to optimize the performance of their databases. There are many ways to accomplish this feat, and all of them have an important point in common. You need knowledge concerning the operation of your systems before you can expect to make intelligent modifications to them. All of the methods used to tune and optimize your databases are identified by studying metrics regarding their current performance and using this data to plan appropriate action.
The right tools are required to gather the information needed to …
[Read more]Hope everyone aware about known about LVM(Logical Volume Manager) an extremely useful tool for handling the storage at various levels. LVM basically functions by layering abstractions on top of physical storage devices as mentioned below in the illustration.
Below is a simple diagrammatic expression of LVM
sda1 sdb1 (PV:s on partitions or whole disks)
\ /
\ /
Vgmysql (VG)
/ | \
/ | \
data log tmp (LV:s)
| | |
xfs ext4 xfs (filesystems)
IOPS is an extremely important resource, when it comes to storage it defines the performance of disk. Let’s not forget PIOPS(Provisioned IOPS) one of the major selling points for AWS and other cloud vendors for production machines such …
[Read more]
Somebody asked me how to expand a prior example with the static variables so
that it took arguments at the command line for the variables.
This example uses Python 3 new features in the
datetime package.
There’s a small trick converting the string
arguments to date data types. Here’s a quick example
that shows you how to convert the argument list into individual
date data type variables:
#!/usr/bin/python3
# include standard modules
import sys
from datetime import datetime
# Capture argument list.
fullCmdArguments = sys.argv
# Assignable variables.
beginDate = ""
endDate = ""
# Assign argument list to variable.
argumentList = fullCmdArguments[1:]
# Enumerate through the argument list where beginDate precedes endDate as strings.
try:
for i, s in enumerate(argumentList):
if (i == …[Read more]
Please find below the shows & conferences where you can find MySQL Community team or MySQL experts during the week of Sep 9, 2019:
SwanseaCon, Swansea, UK, September 9, 2019