Ideas, releases, practical guides, and perspectives from the people building with MySQL.
If you use replication with MySQL, if you need a backup, if you need a spare copy of a system for testing and for many other reasons you need a way to make a copy of your MySQL system. In the past you could make a copy in various ways: using a cold file system … Continue reading MySQL 8.0.17+: Cloning is now much easier
The post MySQL 8.0.17+: Cloning is now much easier first appeared on Simon J Mudd's Blog.
In MySQL 8.0.17 there have been a lot of updates to the MySQL set of offerings. We’ve introduced Cloning into InnoDB Cluster 8.0.17, advances with the MySQL-Router in 8.0.17 and MySQL continues to expand its collection of automation managed features. When Group Replication was first introduced in MySQL 5.7.17, there was considerably less to manage… Read More »
In MySQL 8.0.17 there have been a lot of updates to the MySQL set of offerings. We’ve introduced Cloning into InnoDB Cluster 8.0.17, advances with the MySQL-Router in 8.0.17 and MySQL continues to expand its collection of automation managed features. When Group Replication was first introduced in MySQL 5.7.17, there was considerably less to manage right away compared… Read More »
Overview The Skinny
In this blog post, we explore the correct way to implement bi-directional Tungsten Replication between AWS Aurora and Tungsten Clustering for MySQL databases.
Background The Story
When we are approached by a prospect interested in using our solutions, we are proud of our pre-sales process by which that we engage at a very deep technical level to ensure the we provide the best possible solution to meet with the prospect’s requirements. This involves an in-depth hands-on POC, in addition to the significant time and effort we spend building and testing the solution architectures in our lab environment as part of the proposal process.
From time to time, we are presented with requirements that are not always quite so straight forward. Just recently we faced such a situation. A …
[Read more]
Last week I posted a blog on how to setup multi-source for MySQL
5.7 using GTID based replication, in this blog we will do the
same using MySQL 8.0.
Most of the procedure are the same, there are only two things
that we need to change are;
1) Procedure for creating the replication user.
2) Fetching the GTID value from the MySQL dumpfile.
1) Create replication user for MySQL 8
MySQL 8 uses a new authentication plugin so to create the
replication user will differ from MySQL 5.7. The procedure for
5.7 was with:
mysql> CREATE USER 'repl_user'@'slave-host' IDENTIFIED BY 'repl_pass';
mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl_user'@'slave-host';
With MySQL 8 you need to create the user like:
mysql> CREATE USER …[Read more]
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 »
