Showing entries 2251 to 2260 of 44922
« 10 Newer Entries | 10 Older Entries »
Galera Manager Installation Best Practices

A few things we have noticed recently when it comes to Galera Manager support requests, that we feel we should address in this blog post.

First and foremost, it is a requirement that you install Galera Manager on a clean host. This means you install the base operating system and nothing else: no Nginx, no Apache, no InfluxDB, etc. The Galera Manager installer (gm-installer) will pull all the requisite packages, set SELinux to permissive during the install, etc. The next release of the gm-installer aims to be less fragile when it comes to this, and will aggressively handle installs on machines that already have software installed on it.

The other common issue is the inability to access ports, generally blocked by a firewall (gm-installer should have fixed this as long as setup is going properly), or some other reason. What gm-installer cannot fix …

[Read more]
国密算法 + MySQL

 中国加密标准

中国加密标准的SM1、SM2、SM3、SM4、SM7、SM9等。 借助国际加密标准,我们可以利用来自开源的加密库, 例如,最常用和最流行的加密库之一是 OpenSSL。

本文旨在使用有 SMx(中国加密库)的“OpenSSL”库 的 BabaSSL加上 MySQL的TLS设置 来提供一个方法实现 国密的 MySQL。  BabaSSL不是唯一采用 MySQL 的中国加密标准,  来自其他的中国加密供应商/开源的/兼容的/最新的 OpenSSL 库, 也可能会会支持类似的方式来实现MySQL国密TLS加密。


测试环境(用于分享)

1.计算机资源(VM)

2. 操作系统 - 计算 机VM 配备 Oracle Linux 8

3. 通过公用 yum 的存储库安装MySQL 社区版本8.0

4. 使用 BabaSSL 8.3 [ BabaSSL 8.3.2-dev ]。 它基于 2020 年 9 月 22 日的 OpenSSL 1.1.1h 版本

介绍 …

[Read more]
Mining the MySQL Performance Schema for Transactions

The MySQL Performance Schema is a gold mine of valuable data. Among the many nuggets you can extract from it is an historical report of transactions: how long a transaction took to execute, what queries were executed in it (with query metrics), and idle time between queries. Mining this information is not trivial, but it’s fun and this blog post shows how to start.

Mining the MySQL Performance Schema for Transactions

The MySQL Performance Schema is a gold mine of valuable data. Among the many nuggets you can extract from it is an historical report of transactions: how long a transaction took to execute, what queries were executed in it (with query metrics), and idle time between queries. Mining this information is not trivial, but it’s fun and this blog post shows how to start.

Mining the MySQL Performance Schema for Transactions

The MySQL Performance Schema is a gold mine of valuable data. Among the many nuggets you can extract from it is an historical report of transactions: how long a transaction took to execute, what queries were executed in it (with query metrics), and idle time between queries. Mining this information is not trivial, but it’s fun and this blog post shows how to start.

MySQL Transaction Reporting

How to inspect and report MySQL transactions using the Performance Schema

MySQL Transaction Reporting

How to inspect and report MySQL transactions using the Performance Schema

Train your machine learning models 25x faster with MySQL HeatWave ML

The rapid proliferation of ML technology, explosive data growth, and shortage of data science expertise have caused the industry to face increasingly challenging demands to keep up with fast-paced develop-and-deploy model lifecycles. The increase in volume and velocity of data generated by various applications, devices, sensors etc., as well as need for real-time decision making has […]

Train your machine learning models 25x faster with MySQL HeatWave ML

The training time for MySQL HeatWave ML is on an average 25X faster that competing products such as Redshift ML. Learn how does MySQL HeatWave ML achieve this fast model training performance.

MySQL CONCAT Function: How to Concatenate Strings in MySQL

The MySQL CONCAT function is widely used to concatenate multiple column values into a single column. In this article, we will look into the MySQL CONCAT() syntax, demonstrate to you how to use it, and explore the differences between CONCAT and CONCAT_WS. Contents What is concatenation? MySQL CONCAT() syntax MySQL CONCAT examples Select and concatenate […]

The post MySQL CONCAT Function: How to Concatenate Strings in MySQL appeared first on Devart Blog.

Showing entries 2251 to 2260 of 44922
« 10 Newer Entries | 10 Older Entries »