Following the announcement late last year that we’d made our flagship product Tungsten Cluster available on the Amazon Marketplace in an easy-to-access and deploy AMI format, we published some useful resources in the past few months to help users getting started with Tungsten Clustering in the AWS cloud.

Tags: amazon awstungsten cluster amiCloudcloudformation

We might have had one of our largest, most well attended webinars in recent times, for both EMEA and North American timezones, and we thank you for attending. We had many good questions, and we realise that this is a popular topic, so expect to get more blog posts around this. It also helps us drive the development of Galera Manager further, to know what you want (a new release, is just around the corner).

The video recording  of the webinar is available and we encourage you to take a gander.

We did demo a 9-node Galera Cluster running across San Francisco, London and Singapore, and also discussed latency for local nodes, a local Galera Cluster, as well as what penalty you …

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 …

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

in mysql-claim-jobs.py

.

Base Program

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 …

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 …