MySQL Router 8.0.16 Key features
Logrotation via SIGHUP
Sending a SIGHUP signal to the router process will now close and reopen the logfile.
It allows the integration with the logrotate to rotate and compress the Router’s logfiles.…
Facebook Twitter LinkedIn
To operate more easily a MySQL Group Replication (InnoDB Cluster), the Group Replication plugins provides some UDFs.
If you have read the recent article from Tiago Vale about the Group Replication Communication Protocol, you may have heard about two new UDFs allowing to get or set the communication protocol.
So what are all the UDFs provided with the Group Replication and what’s their purpose ?
SELECT UDF_NAME FROM performance_schema.user_defined_functions WHERE UDF_NAME LIKE 'group_repl%'; +-------------------------------------------------+ | UDF_NAME | +-------------------------------------------------+ | group_replication_get_communication_protocol | | group_replication_get_write_concurrency | | group_replication_set_as_primary | …[Read more]
Percona Live provides the open source database community with an opportunity to discover and discuss the latest open source trends, technologies, and innovations. The conference includes the best and brightest innovators and influencers in the open source database industry.
This year, Percona Live is being held at the Hyatt Regency in Austin, Texas from May 28-30, 2019.
Pythian is proud to be a Silver Sponsor this year, with a full force of our technical experts speaking on a variety of subjects and technologies. These are sessions you won’t want to miss!
If you’re attending, make sure you swing by our booth and meet the Pythian crew. We’ll be happy to answer any questions you have about open source, cloud or anything data related. Our speakers will also be covering the event on social media and we’ll recap the event and their talks here on the Pythian …
[Read more]
File/Pos Replication : Skip Slave's sql_thread error
[COMMAND]
For binlog file & position based replication setup, To skip the
slave's sql_thread error, run below command.
stop slave; set global sql_slave_skip_counter=1; start
slave; select sleep(3); show slave status\G
Recently, I was working on one of the support ticket where customer was complaining that when he change datadir location by copying datadir from C: to F:, set mysql permissions and changing location in my.ini, he could not able to start mysql. Even no error msg in MySQL error log OR application log that why it doesn’t start.
We have checked all the required steps mentioned in documentations and blog posts but still the issue was not getting resolved. Finally, one of my colleague suggested to read this forum post.
https://forums.mysql.com/read.php?169,659235,659254#msg-659254
and we found out that NETWORK SERVICE permission is required for datadir. By default, it will be given to the C:\ but not for other drives. So when we change any datadir to other drive like E:\ or F:\, we …
[Read more]During our presentation at Percona Live 2019 Intel and its software partners will introduce the audience to the work we’re doing to enable an open-source framework, we call Cloud Native Database. This is a collaborative effort between Intel, Rockset, PlanetScale, MariaDB and Percona.
Through the presentation the audience will be introduced to a set of principles and architectural elements that define what we mean by Cloud Native Database. We will discuss Rockset’s RocksDB-Cloud library and how it works with Facebook’s MyRocks storage engine. We also will cover …
[Read more]The MariaDB Foundation is pleased to announce the availability of MariaDB 10.3.15, the latest stable release in the MariaDB 10.3 series, as well as MariaDB Connector/C 3.0.10, MariaDB Connector/ODBC 3.1.1 and MariaDB Connector/Node.js 2.0.5, the latest MariaDB Connector releases. See the release notes and changelogs for details. Download MariaDB 10.3.15 Release Notes Changelog What is […]
The post MariaDB 10.3.15, MariaDB Connector/C 3.0.10, MariaDB Connector/Node.js 2.0.5 and MariaDB Connector/ODBC 3.1.1 Now Available appeared first on MariaDB.org.
set --server-id to enable either a master or a slave
Below issue can be faced, when we run CHANGE MASTER command to
setup replication.
mysql> change master to
master_host='xx.xx.xx.xx',master_user='rep_user',master_password="xxxxxxx",
master_log_file='db-01-test-bin.000064',master_log_pos=95854072,master_auto_position=0;
ERROR 1794 (HY000): Slave is not configured or failed to
initialize properly. You must at least set --server-id to enable
either a master or a slave. Additional error messages can be
found in the MySQL error log.
Solution :- Here It is assumed, We have already set server-id
parameter value different on master and slave node but still, we
have the above error.
It happens once, you performed the server packages upgrade(like
from 5.6 to 5.7) and just started MySQL service and going to run
CHANGE MASTER command.
So, to solve this issue, Run mysql_upgrade command …
(In the previous post, Part 3, we covered Compaction.)
In this blog post, we continue on our series of exploring MyRocks mechanics by looking at the configurable server variables and column family options. In our last post, I explained at a high level how data moves from its initial disk-written files into the full data set structure of MyRocks using a process called compaction. In this post, we’re going to look a little closer at two important features that are leveraged as data cascades down through this compaction process: bloom filters and compression.
Bloom filters
Before we approach how bloom filters are used in MyRocks, we need to know what a bloom filter is. The short definition is that a bloom filter is a space-efficient data structure used to tell you if an …
[Read more]MySQL (really) supports CHECK CONSTRAINT since version 8.0.16. In this article I will show you 2 things: - An elegant way to simulate check constraint in MySQL 5.7 & 8.0. - How easy & convenient it is to use CHECK constraints in 8.0.16.