In our last blog post about the Automatic Asynchronous Replication Connection Failover feature which was released in MySQL 8.0.22, we showed you its usage and benefits. We now present here additional changes we added in MySQL 8.0.23 to further enhance this feature by making the receiver aware of the source’s group membership changes.…
Tweet Share
This article provides a complete overview of how to create a new user account in MySQL and grant different types of privileges on a MySQL database. Learn the basics of user account management and find hints. Introduction First, let’s figure out why we need users and privileges. When you install MySQL Server on your system […]
The post How to Create a New User Account in MySQL and Grant Permissions on a Database appeared first on Devart Blog.
As introduced in a previous blog RonDB enables us to easily execute benchmarks on RonDB using the Sysbench benchmark.
In this blog I will present some results where the RonDB cluster had 2 data nodes, each using a r5.4xlarge VM in AWS that has 16 VCPUs and 128 GB memory. The Sysbench test uses SQL to access RonDB.
In this particular test case we wanted to test the Key-Lookup performance using SQL. Key-Lookup performance is essential in the RonDB use case as an online Feature Store in Hopsworks.
In this case we use the …
[Read more]
In the previous blog, we were able to setup a MySQL NDB Cluster
replication between one source and one replica cluster. In this
blog, we will discuss about replication between one source and
three replica clusters.
Note: With MySQL version (8.0.21), we have started
changing the term “master” to “source”, the term “slave” to
“replica”. So in this blog we will refer these terms ‘source’ and
‘replica’ wherever applicable.
The main advantage of this type of topology is good for giving
‘local’ reads in geographically distant areas as well as
increased redundancy in case of issues.
Let’s create four MySQL NDB Cluster with the following
environment, from which one will be termed as ‘source’ cluster
while the rest will be ‘replica’ clusters.
In this blog series, we will discuss various MySQL NDB Cluster
replication topologies possible with a demonstration. We will
start with a simple case i.e. one source (formerly called master)
and one replica (formerly called slave).
Note: With MySQL version (8.0.21), we have started changing the
term “master” to “source”, the term “slave” to “replica”. So in
this blog we will refer these terms ‘source’ and ‘replica’
wherever applicable.
Let’s create two MySQL NDB Cluster with the following
environment, from which one will be termed as ‘source’ cluster
while the other one will be ‘replica’ cluster. For now, let’s
stick to the identical environment from both the cluster. Later
in the following blog series, we will change the environments and
will run the replication.
The architecture of the world’s most popular open source database
system is very important for the Information Technology people.
There are many reasons for MySQL’s popularity around the world,
but one of the main reasons is its architecture, while there are
many big players such as Oracle, Microsoft SQL and DB2, MySQL’s
architecture makes it as unique and preferred choice for most of
the developers. In this article, we are going to discuss about of
the internal architecture of the MySQL relational database
management system. The article is for novice database
administrators, database developers, software developers and
those who are interested to work with MySQL database.
Major components: The MySQL architecture describes how the
different components of a MySQL system relate to one another. The
MySQL architecture is basically a client – server system. MySQL
database server is the server and the applications which …
Many of my students wanted to know how to write a simple PSM (Persistent Stored Module) for MySQL that saved the writes to all table as a group. So, to that end here’s simple example.
/* Drop and create four tables. */ DROP TABLE IF EXISTS one, two, three, four; CREATE TABLE one ( id int primary key auto_increment, msg varchar(10)); CREATE TABLE two ( id int primary key auto_increment, msg varchar(10)); CREATE TABLE three ( id int primary key auto_increment, msg varchar(10)); CREATE TABLE four ( id int primary key auto_increment, msg varchar(10));
/* Conditionally drop procedure. */
DROP PROCEDURE IF EXISTS locking;
/* Set delimiter to $$ to allow ; inside the procedure. */
DELIMITER $$
/* Create a transaction procedure. */
CREATE PROCEDURE locking(IN pv_one varchar(10)
,IN pv_two …The AWS ledger database (QLDB) is an auditors best friend and lives up to the stated description of “Amazon QLDB can be used to track each and every application data change and maintains a complete and verifiable history of changes over time.”
This presentation will go over what was done to take a MySQL application that provided auditing activity changes for key data, and how it is being migrated to QLDB.
While QLDB does use a SQL-format for DML (PartiQL), and you can perform the traditional INSERT/UPDATE/DELETE/SELECT, the ability to extend these statements to manipulate Amazon Ion data (a superset of JSON) gives you improved capabilities and statements.
Get a comparison of how to map a MySQL structure multiple tables and lots of columns into a …
[Read more]MySQL Server offers, among the different security features, encryption at rest (or Transparent Data Encryption, TDE) in the commercial release (find the differences with Community here).
While testing TDE with MySQL InnoDB Cluster, I was wondering what inner mechanism was implemented to deal with TDE, master keys and keyrings, and the clone plugin. If I need to clone an instance, how would everything work so to guarantee my InnoDB Cluster instances will still be encrypted, and the keyring chosen would still use a good master key to decrypt tablespace keys and finally tablespace pages?
The answer is obviously that this is fully managed. You can add instances to …
[Read more]
During many decision-making phases in programming code
(conditional logic), there are times execution depends on
several different factors. Multiple conditional tests
are powerful and constraining, oftentimes requiring more than one
test to be passed in order for program flow to proceed. For MySQL
(and standard SQL in general) the CASE expression is
used for IF/THEN/ELSE
conditional logic. The post, MySQL Simple CASE Expression – with
examples, covered Simple CASE queries which
are essentially equality tests. MySQL Simple CASE is
but one variant of 2, with the other being a MySQL
Searched CASE Expression. A MySQL Searched
CASE Expression can have multiple
conditional tests in each WHEN …