First we will talk about some of the other internal users of the technology that underpins the InnoDB Clone. MySQL Enterprise Backup (MEB) is an enterprise offering that provides backup and recovery for MySQL. Among various types of backups available, the following two types are of interest to us:
Full Backup – A backup that backs
up the entire MySQL instance – all the tables in each MySQL
database.
… Facebook Twitter LinkedIn
MySQL 5.7, alongside other many improvements, brought bulk load for creating an index (WL#7277 to be specific), which made ADD INDEX operations much faster by disabling redo logging and making the changes directly to tablespace files. This change requires extra care for backup tools. To block DDL statements on an instance, Percona Server for MySQL implemented LOCK TABLES FOR BACKUP. Percona XtraBackup (PXB) uses this lock for the duration of the backup. This lock does not affect DML statements.
MySQL 5.7 doesn’t have an option to block an instance against DDL and to allow all MDL’s. Thus, Percona XtraBackup has also implemented –lock-ddl-per-table. Before we go into other details, let’s understand how –lock-ddl-per-table works up to now:
As mentioned in the AWS discussion forum back in October, Amazon has started the end of life (EOL) process for RDS MySQL version 5.5. What this means is:
As any seasoned administrator knows, upgrades can be painful and things might go wrong.
Risks
I think we can safely assume that the upgrade will be performed in-place, as it would be too complex and time-consuming otherwise. Since a direct upgrade from 5.5 to 5.7 is not supported, we need to go through 5.6 first. This means instances need to be restarted twice; first to go from …
[Read more]
In this post we will see the unique features of MySQL Cluster
i.e. Self healing and no single point of failure.
MySQL Cluster No Single Point Of Failure:
As we know that in MySQL Cluster, data nodes are logically
grouped into nodegroups. All data nodes in a nodegroup contain
the same data, kept in sync at all times. Different nodegroups
contain different data. So in a single nodegroup, MySQL Cluster
can sustain multiple node shutdown at the same time but at least
one node must live in that nodegroup. Lets demonstrate this
feature with a 4 replicas cluster where each nodegroup have 4
data nodes.
Lets create a MySQL Cluster with below environment.
…
[Read more]
In this post, we will see how easily we can install MySQL Cluster
on different physical hosts. One can install MySQL Cluster on a
single host too. If you are wondering what MySQL Cluster is then
please look into my previous post.
MySQL
Cluster Installation:
Lets create a MySQL Cluster with the following environment:
MySQL Cluster 8.0.22 version
2 Management servers
4 Data nodes servers
2 Mysqld servers
4 API nodes
OS: Ubuntu 20.04 LTS
Hostname and IP address of all the nodes in the
MySQL Cluster:
Management Node1
(mgmt1): Hostname: …
In one of our previous articles - Setting up Replication with
various methods for MySQL 8 - we reviewed how to create a replica
with multiple tools.
Now, it is time to perform the same action but with MySQL Shell.
The post MySQL SHELL – The new era first appeared on dasini.net - Diary of a MySQL experts.
Mysqldump is a client utility that is used to perform logical backups of the MySQL database. This popular migration tool is useful for various use cases of MySQL such as: Backup and restore of databases. Migrating data from one server to another. Migrating data across different managed MySQL service providers. Migrating data between different versions […]
MySQL Shell is an advanced client tool that has many features and is easy to use. The recent MySQL release (MySQL 8.0.22) has the utility “exportTable()”, which supports exporting the data into a file from a table using MySQL shell. The exported data file can be imported using the utility “importTable()”, which was released in MySQL 8.0.17.
With “exportTable()”, you can export the data into a local server or in any S3-compliant object storage provider. In this blog, I am going to explain how those exportTable() & importTable() utilities are working in local servers and I also did some tests with MySQL 5.7 and MySQL 5.6.
Overview of exportTable() & importTable() exportTable():
Introduction In this article, we are going to see how we can enable the MySQL JDBC Driver Statement Caching mechanism, which, unfortunately, is not enabled by default. No matter what data access framework you are using, you still need to configure the JDBC Driver if you want to get the most out of the MySQL database engine. MySQL JDBC client-side PreparedStatement As I explained in this article, by default, the MySQL JDBC Driver emulates prepared statements. So, no matter if you are executing a plain Statement or a PreparedStatement, the SQL statement... Read More
The post MySQL JDBC Statement Caching appeared first on Vlad Mihalcea.
If you plan to deploy a Drupal site to OCI using MySQL Database Service, there is a very easy way to perform that deployment: using OCI’s Resource Manager !
As you know, security is something very important for Oracle in OCI, therefor, exposing the database on the Internet is not allowed.
Even if you are not using OCI, I really recommend you to follow that principle and never expose your database to Internet !
I already cover this in many previous posts. But I also understand that for people not being a sysadmin, this can be complicated the first time.
That’s why, all this can be automated using a stack to deploy in Resource Manager.
The first thing to do when you have your OCI account, it’s to download the stack from GitHub: https://github.com/lefred/oci-drupal-mds
Then in OCI’s dashboard, just …
[Read more]