(Image credit: Pixabay).
In my earlier post, I showed how MySQL, since version 8.0.14, has support for LATERAL derived tables. With LATERAL, a JOIN can have a second table – a subquery-based derived table – be defined based on values from columns of the first table, and thus be re-calculated for each row of the first table.…
Facebook Twitter LinkedIn
What is new with MySQL 8.0 Delayed Replication ?
Delayed Replication – You can deliberately execute transactions later than the master by a specific duration of time , Why you do that and for what ? Consider this, Accidentally someone did a wrong UPDATE / DELETE in the master and the transaction is committed, Now how can DBA rollback the database system to the last known good condition ? This is when we benefit from MySQL delayed slave replication investment. The default replication delay in MySQL is “0” seconds, To delay the slave by N seconds use the CHANGE MASTER TO MASTER_DELAY = N, The transactions received from the master is not executed until N seconds later than it’s commit on the immediate master. We have blogged here how to setup …
[Read more]In 5.6 and earlier, the format is 190711 18:44:52 (YYmmdd HH:MM:SS) and the time zone is always the system time zone. Hope that helps.
MySQL Roles are becoming more and more popular. Therefor, we receive more and more questions related to them.
First I encourage you to read this previous 2 posts:
In this post, I will share you some queries I find useful when using MySQL Roles.
Listing the Roles
The first query allows you to list the Roles created on your MySQL Server and if they are assigned to users, and how many:
SELECT any_value(User) 'Role Name',
IF(any_value(from_user) is NULL,'No', 'Yes') Active,
count(to_user) 'Assigned …[Read more]
Like I stated in my previous article - MySQL InnoDB Cluster -
Recovering and provisioning with mysqldump :
"As the administrator of a cluster, among others tasks, you
should be able to restore failed nodes and to add (or remove) new
nodes".
Well, I still agree with myself :)
MySQL customers using a Commercial Edition have access to MySQL
Enterprise Backup (MEB) which provide enterprise-grade physical
backup and recovery for MySQL.
MEB delivers hot, online, non-blocking backups on multiple
platforms including Linux, Windows, Mac & Solaris.
The post MySQL InnoDB Cluster - Recovering and provisioning with MySQL Enterprise Backup first appeared on dasini.net - Diary of a MySQL expert.
Percona is glad to announce the release of Percona XtraBackup 2.4.15 on July 10, 2019. You can download it from our download site and apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, it …
[Read more]This tutorial shows how to install an Apache web server on a CentOS 7 server with PHP (mod_php with PHP 5.4, 7.0, 7.1, 7.2 or 7.3) and MySQL support. This setup is often referred to as LAMP which stands for Linux - Apache - MySQL - PHP.
The MySQL Server High Availability landscape provides with a slew
of tools to help you ensure that your databases keep humming.
Such tools are Galera Cluster, however, it is worth looking at
semi-synchronous replication with failover tools, and also the
usual leader-follower asynchronous replication. Today more
workloads are moving to the cloud, and what failover options do
you get with Amazon RDS for MySQL or even Aurora? What about the
newfangled group replication and InnoDB Cluster? And let us not
forget that Galera Cluster has spawned branches too!
Join Codership, the developers and experts of Galera
Cluster, as we discuss where Galera Cluster fits in and how
to get best out of it.
EMEA webinar 9th April 10-11 AM CEST (Central European
Time)
JOIN THE EMEA WEBINAR
USA webinar 9th April …
Do you want to run Galera Cluster in the cloud? Why not learn to setup a 3-node Galera Cluster using Amazon Web Services (AWS) Elastic Compute Cloud (EC2), and run it yourself (3-node because this is the minimum preferred size; you can have a 5, 7, or 9 node cluster too — not in the demo though!). In this webinar, we will cover the steps to do this, with a demonstration of how easy it is for you to do. We will also cover how you may want to load balance traffic to your Galera Cluster using a proxy like ProxySQL.
In addition, we will cover why you may want to run a 3-node (or more) Galera Cluster (multi-master synchronous clusters) instead of (or in addition to) using Amazon Relational Database Service (RDS) MySQL, which has the ability to have asynchronous replication (Read Replicas), and High Availability provided by DRBD (Multi-AZ). We will also cover where Galera Cluster differs from Amazon Aurora RDS for MySQL.
Join us and …
[Read more]This tutorial explains MySQL DATE_SUB function which subtracts a slice of time (in days/hours, e.g., 1 day or 10 days) from the given date. We’ll describe the complete date arithmetic of this method with the help of simple examples. 1. DATE_SUB() Syntax 2. DATE_SUB() with -ve Interval 3. DATE_SUB() for Invalid Date 4. DATE_SUB() for Auto Adjustment Let’s now go through each of the section one by one. MySQL DATE_SUB() Function As stated initially, DATE_SUB() is a built-in MySQL function which subtracts the specified no. of days from a given date. So, let’s now see the details and check out
The post MySQL DATE_SUB Function with Simple Examples appeared first on Learn Programming and Software Testing.
