This article will show you how to create and manage views in MySQL. A view is a virtual table that does not store its own data but rather displays data that is stored in other tables. Essentially, a view is a result of SQL query execution, which returns the required rows of data from one […]
The post How to Create a View in MySQL appeared first on Devart Blog.
This latest post on MySQL replication follows the ones we did on Amazon Redshift & Amazon Aurora; naturally, we had to cover Amazon RDS as well and so we look here at how to easily and securely replicate from MySQL to Amazon RDS (and vice versa).
Tags: MySQL ReplicationMySQLreal-timetungsten replicatoramazon rds
Digital14 provides secure solutions, cybersecurity, and digital transformation services to public and commercial sector organizations in the United Arab Emirates. Digital14 supports intelligent and intrinsically secure digital transformations that create great experiences and unlock productivity for enterprise and government alike. The company's unique expertise in cybersecurity enable organizations to innovate with confidence and accelerate growth.
As a pioneer in smart cities and Internet of Things (IoT), the UAE is also increasingly vulnerable to the threat of cyber-attacks.
Digital14's KATIM platform is engineered to deliver ultra-secure communication and collaboration capabilities via secure network infrastructure, devices, applications, and services to protect its customers from the attacks. The company offers a wide range of customizable applications, including KATIM Messenger, KATIM Mail, and KATIM gateway. In addition, it …
[Read more]Digital14 provides secure solutions, cybersecurity, and digital transformation services to public and commercial sector organizations in the United Arab Emirates. Digital14 supports intelligent and intrinsically secure digital transformations that create great experiences and unlock productivity for...
Somebody needed a job queue in Python: Multiple writers insert
into it in random order, and the jobs are written into the MySQL
table jobs. From the jobs table,
multiple consumers claim jobs in batches of n or
smaller (n=100), and process them. After processing, the
consumers delete the jobs. We need concurrent job generation and
consumption, with proper and efficient locking.
The full source for this example can be seen in mysql-dev-examples
.
Using our usual includes and setup,
from time import sleep
from random import …
Somebody needed a job queue in Python: Multiple writers insert
into it in random order, and the jobs are written into the MySQL
table jobs. From the jobs table,
multiple consumers claim jobs in batches of n or
smaller (n=100), and process them. After processing, the
consumers delete the jobs. We need concurrent job generation and
consumption, with proper and efficient locking.
The full source for this example can be seen in mysql-dev-examples in mysql-claim-jobs.py.
Base Program
Using our usual includes and setup,
from time import sleep
from random import randint
from sys import exit
from multiprocessing import Process
import click
import MySQLdb
import MySQLdb.cursors …If you have not read MDS, PHP and authentication by my brilliant colleague LeFred please do so. The TL;DR is that most recent versions of the PHP support the MySQL 8.0 standard for authentication, Caching SHA 256, but with PHP 7.3 and earlier you will have to use the older MySQL Native Password authentication.
Someone reached out to me with a direct message to
ask me if they really needed to change from MySQL native
to Caching SHA 256.
Well, what versions of MySQL are you using?
The good news is that they are running 8.0.23 in production, '25
in test and development. But all the accounts are using MySQL
Native Authentication.
What versions of PHP? There was some …
[Read more]If like me you are using MySQL Shell on many different systems and new installations, there are some commands I often use to benefit from my environment.
What I really want to enable is the history of course, a nicer prompt and sometimes the default mode I want to use.
This blog post is just a little reminder with those commands I usually repeat in all my systems:
mysql-js> shell.options.setPersist('history.autoSave', 1) mysql-js> shell.options.setPersist('history.maxSize', 5000)
The option above is when using MySQL Shell in JS mode which is the default. To play with options using the same command in every mode (JS, Python, SQL), you can use /option like:
\option --persist history.autoSave 1
Then I set the prompt to have something like this:
$ cp /usr/share/mysqlsh/prompt/prompt_256pl+aw.json …
[Read more]If like me you are using MySQL Shell on many different systems and new installations, there are some commands I often use to benefit from my environment. What I really want to enable is the history of course, a nicer prompt and sometimes the default mode I want to use. This blog post is just a littl...
The Problem
State Snapshot Transfer can be a very long and expensive process, depending on the size of your Percona XtraDB Cluster (PXC)/Galera cluster, as well as network and disk bandwidth. There are situations where it is needed though, like after long enough node separation, where the gcache on other members was too small to keep all the needed transactions.
Let’s see how we can avoid SST, yet recover fast and without even the need for doing a full backup from another node.
Below, I will present a simple scenario, where one of the cluster nodes was having a broken network for long enough that it will make …
[Read more]