MySQL Support Blogs
479 FOLLOWERS
MySQL is the world's most popular open-source database. With its proven performance & reliability, MySQL has become the leading database choice for web-based applications. This is an aggregated feed of various blogs of Sun Microsystems support staff who work and support MySQL customers and users.
MySQL Support Blogs
2y ago
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
MySQL Support Blogs
2y ago
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
MySQL Support Blogs
2y ago
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
MySQL Support Blogs
2y ago
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
MySQL Support Blogs
3y ago
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
MySQL Support Blogs
3y ago
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 Support Blogs
3y ago
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
MySQL Support Blogs
3y ago
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
MySQL Support Blogs
3y ago
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 Support Blogs
3y ago
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