In this post I will list a few options to migrate a table from MySQL to Redis logically. I will run examples using the classical world database. The world database can be downloaded here, so if you would like to try the examples, just import it in your MySQL instance. mysql> use world; Database changed mysql> show tables; +-----------------+ | Tables_in_world | +-----------------+ | city | | country | | countrylanguage | +-----------------+ 3 rows in set (0.01 sec) There are several ways to go ahead and import a table into Redis, let’s go through some of them. In the ..read more

Python clients you can use to connect to a Redis Server are listed in the documentation. I personally use redis-py, but Redis the company has just released Redis OM for Python, so I think it is worth to have a look. I will share here basic instructions to connect to a Redis Server and test a couple of commands. Connect using redis-py In the first place, when working with Python, I would recommend to setup a virtual environment (venv), so to isolate the Python environment under testing from the global environment. You can create the venv as follows. python3 -m venv redisvenv source redisvenv/b ..read more

You already know how to setup a Redis Server in a few seconds following my advices in this post, now it’s time to think big and learn how to scale a Redis Server. Let’s start with a quote from the documentation. Redis is, mostly, a single-threaded server from the POV of commands execution (actually modern versions of Redis use threads for different things). It is not designed to benefit from multiple CPU cores. People are supposed to launch several Redis instances to scale out on several cores if needed. So in a Redis Server, all the data is stored in the memory space of the process itself a ..read more

I have been away for some time from this blog, but that was for a reason, I got a new job at Redis (and I can’t hide I am truly enthusiastic about my new position as Technical Enablement Architect!), and taking some time to onboard and extend my knowledge of the awesome Redis server, the popular in-memory key-value storage. So my future posts will likely be about Redis and the infinite chances to “getting things done” using this very nice solution. Maybe you know Redis as an efficient caching layer, but once you get to know it a bit more, you realize that Redis has all the qualities to be your ..read more

In this post I will show how to program a C++ client for MySQL NDB Cluster. I have already presented MySQL Cluster, the distributed database using the in-memory storage engine, in several occasions. You may have learnt how to configure and start MySQL Cluster, so I will assume that a cluster is up and running. If you want to develop a simple C++ client, just run the cluster in a single host, which may be your very laptop. In order to compile an NDB API client, you will need. MySQL NDB Cluster installed. Community distributions are here (I like to work with the self contained TAR). The cluster ..read more

Here’s a cheat sheet to run MySQL in a Docker container in your Windows or Mac laptop in a few minutes. In this brief how-to you will: Install Docker Desktop in your laptop Download official Oracle MySQL image or Docker Inc. image Start the container Administer it Start a MySQL session and start a Linux session Download and install Docker You can download Docker Desktop for Windows or Mac from https://docs.docker.com/desktop/. Install like any other application and you’re ready to move to the next step. As you can read from the docs, Docker Desktop will install several things like Docker Com ..read more

MySQL Server can rely on OCI services to: Secure sensitive information in the OCI Vault Store backups safely and conveniently in OCI Object Storage Migrate data from OCI Object Storage to a MySQL Database Service DB System Let’s explore how to administer MySQL the easy way using OCI services. Secure encryption keys in the OCI vault It is possible to encrypt virtually anything in MySQL 8: redo logs, undo logs, binary logs, backups (…) and, obviously, data. See the list of features to make your data safer than ever. MySQL Server relies on a set of keyring plugins to store encryption master key ..read more

Just a quick how-to, to download, compile and use Sysbench on your RHEL/OL Linux box to test MySQL Server (note: compiling and using Sysbench is no mistery, the README file has all the instructions clearly explained, but I write this little guide to setup and use this tool in minutes). Download and compile The repository is hosted at: https://github.com/akopytov/sysbench. You can choose to download the latest master branch as usual or the latest stable. I have picked the latest stable. In order to compile and use certain MySQL library version, make sure mysql_config (used by sysbench auto conf ..read more

Time zone handling can sometimes generate confusion, especially when dealing with migrations to other host running on a different time zone, or when switching to a Daylight Saving Time (DST) time zone or when leap seconds are introduced. Will the stored date still make sense after changing a system-wide configuration? What happens when migrating a server to another host? What is actually stored in the database? There’s plenty of literature around about MySQL and time zone management, but there’s also missing information, provided new features and fixes are constantly introduced into MySQL Serv ..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 answ ..read more