Jetzt sind auch noch die letzten MariaDB und MySQL Schulungstermine für 2019 festgelegt und veröffentlicht.
Mit unseren drei Schulungspartnern in Essen, Köln und Berlin bietet FromDual zur Zeit insgesamt 12 öffentliche Schulungen zum Thema MariaDB und MySQL an.
Es sind dies:
Jetzt sind auch noch die letzten MariaDB und MySQL Schulungstermine für 2019 festgelegt und veröffentlicht.
Mit unseren drei Schulungspartnern in Essen, Köln und Berlin bietet FromDual zur Zeit insgesamt 12 öffentliche Schulungen zum Thema MariaDB und MySQL an.
Es sind dies:
There are multiple way to setup replication with MySQL 8.0 and our replication offer as never been so rich: asynchronous, semi-synchronous, group replication, multi-source, … and much more options !
But if you want to setup a very quick Master-Slave environment from scratch for a quick test (you can always use dbdeployer), here are some commands to make it right the first time
Requirements
You need to have MySQL 8.0 installed and running on both servers
and with the same initial data (a fresh install for example).
Here we use mysql1 and mysql2. We will
also use GTID as it’s much more convenient.
Servers Configuration
Let’s setup mysql1 first:
mysql1> SET PERSIST server_id=1; mysql1> SET …[Read more]
When deciding on your backup strategy, one of the key components for Point In Time Recovery (PITR) will be the binary logs. Thankfully, the mysqlbinlog command allows you to easily take binary log backups, including those that would otherwise be encrypted on disk using encrypt_binlog=ON.
When
mysqlbinlog
is used with
--raw --read-from-remote-server --stop-never --verify-binlog-checksum
then it will retrieve binary logs from whichever master it is pointed to, and store …
[Read more]This log buffer edition covers Cloud, Oracle and MySQL.
Cloud
Cloud Directory is a neglected serverless data store that deserves much more attention.
Many of our large enterprise customers have this worry hanging over their heads … what are they going to do about that mainframe when they migrate?
Miners Extract More Value from the Cloud When They Transform Their Cultures
7 steps to keep your …
[Read more]
MySQL Group Replication (GR) is a MySQL Server
plugin that enables you to create elastic, highly-available,
fault-tolerant replication topologies. Groups can operate in
a
single-primary mode with automatic primary election, where only
one server accepts updates at a time. Alternatively, groups can
be deployed in multi-primary mode, where all servers can accept
updates, even if they are issued concurrently.…
We are happy to announce that there will be a MySQL Day/MySQL Community Meetup hold in Oracle Buliding in Dubai on October 17th. Please find more details below:
From MySQL 5.7.11, encryption is supported for InnoDB (file-per-table) tablespaces. This is called Transparent Tablespace Encryption or sometimes referred as Encryption at Rest. This blog post aims to give the internal details of InnoDB Tablespace Encryption.
Keyring Plugin : Why What How ?…
Offering over 110 conference sessions across Tuesday, 6 and Wednesday, 7 November, and a full tutorial day on Monday 5 November, we hope you’ll find that this fantastic line up of talks for Percona Live Europe 2018 to be one of our best yet! Innovation in technology continues to arrive at an accelerated rate, and you’ll find plenty to help you connect with the latest developments in open source database technologies at this acclaimed annual event.
Representatives from companies at the leading edge of our industry use the platform offered by Percona Live to showcase their latest developments and share plans for the future. If your career is dependent upon the use of open source database technologies you should not miss this conference!
…
[Read more]Some time ago, a customer had a performance issue with an internal process. He was comparing, finding, and reporting the rows that were different between two tables. This is simple if you use a LEFT JOIN and an
IS NULL
comparison over the second table in the WHERE clause, but what if the column could be null? That is why he used UNION, GROUP BY and a HAVING clauses, which resulted in poor performance.
The challenge was to be able to compare each row using a LEFT JOIN over NULL values.
The challenge in more detail
I’m not going to use the customer’s real table. Instead, I will be comparing two sysbench tables with the same structure:
CREATE TABLE `sbtest1` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `k` int(10) unsigned DEFAULT NULL, `c` char(120) DEFAULT NULL, `pad` char(60) DEFAULT NULL, PRIMARY …[Read more]
