I’m going to narrate you a story that happened around a crashing MyQL, Corrupted InnoDB table and finally the recovery by table restore. We will see how our database administrator…
The post A tale of Corrupt InnoDB table, MySQL crash & recovery first appeared on Change Is Inevitable.
This video, based on last weeks blog “Ten Tips to Achieve MySQL and MariaDB Security”, walks you through ten different items to keep in mind when deploying a MySQL or MariaDB database to production.
Database security is an essential part of any system. With more and more news reports of widespread data breaches coming in from around the world, there is no better time to check your environments and make sure you have implemented these basic steps to remain secure.
ClusterControl for Database Security
ClusterControl provides advanced deployment, monitoring and management features to ensure your databases and their …
[Read more]AWS recently announced the release of MariaDB 10.2 for RDS. One of customer needs this release for GIS indexing .The recent encounter on a Replication issue with RDS MariaDB 10.2 is briefed here .
Problem Statement:
After the upgrade of replicas to MariaDB 10.2 on RDS, Once replication is stopped manually through “call mysql.rds_stop_replication;” or replication failed due to some error. Replication cannot be started back using “call mysql.rds_start_replication;” and there is no straightforward way or documented process to start the replication back. Also, most of the replication related RDS commands like skip errors etc will not work. This is due to the implementation of replication handling in RDS.
Summary:
On Jan 5, 2018, RDS announced support for MariaDB 10.2. …
[Read more]
Donkey system is a fully automatic MySQL database change
system.
It gives a great help both to the release of the business and the
company’s automated operation and maintenance.
FOSDEM is back in town, folks, and as usual, there will there be a MySQL and Friends Devroom. At this point, we can’t really remember what came first, was it the annual dinner or the devroom? Our memories of the past few years are particularly hazy on that… Can’t imagine why.
Following a great tradition of dining together in style with members from all over the community, we have rented a by now familiar private space at ICAB, more detailed directions below.
A couple of things changed compared to the last couple of years. The community dinner will take place on Friday night 2 February, following the …
[Read more]End of February, from February 26 to March 2 (5 days), FromDual offers an additional training for DBAs and DevOps: our most visited Advanced MySQL and MariaDB training.
This training is hold in the training facilities of the FromDual training partner GFU Cyrus GmbH in Cologne-Deutz (Germany).
There are already enough registrations so it is certain the training will take place. But there are still free places for at least 3 additional participants.
The training is in German.
You can find the training of this 5-day MySQL/MariaDB training here.
If you have any question please do not hesitate to contact us.
Taxonomy upgrade extras: training …
[Read more]End of February, from February 26 to March 2 (5 days), FromDual offers an additional training for DBAs and DevOps: our most visited Advanced MySQL and MariaDB training.
This training is hold in the training facilities of the FromDual training partner GFU Cyrus GmbH in Cologne-Deutz (Germany).
There are already enough registrations so it is certain the training will take place. But there are still free places for at least 3 additional participants.
The training is in German.
You can find the training of this 5-day MySQL/MariaDB training here.
If you have any question please do not hesitate to contact us.
Taxonomy upgrade extras: training …
[Read more]As in every quarter of the year Oracle has released yesterday its recommendation for the MySQL security updates. This is called, in Oracle terminology, Critical Patch Update (CPU) Advisory.
This CPU is published for all Oracle products. But FromDual is only interested in MySQL related topics. So let us concentrate on those.
This time 25 fixes with a maximum score of 8.1 (out of 10.0) were published.
The following MySQL products are affected:
As in every quarter of the year Oracle has released yesterday its recommendation for the MySQL security updates. This is called, in Oracle terminology, Critical Patch Update (CPU) Advisory.
This CPU is published for all Oracle products. But FromDual is only interested in MySQL related topics. So let us concentrate on those.
This time 25 fixes with a maximum score of 8.1 (out of 10.0) were published.
The following MySQL products are affected:
In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the second of two parts.
In the first part of this post, we described the high-level overview of implementing incremental refresh on a ClickHouse table as an alternative support for UPDATE/DELETE. In this part, we will show you the actual steps and sample code.
Prepare Changelog Table
First, we create the changelog table below. This can be stored on any other MySQL instance separate from the source of our analytics table. When we run the change capture script, it will record the data on this table that we can consume later with the incremental refresh script:
CREATE TABLE `clickhouse_changelog` ( `db` varchar(255) NOT NULL …[Read more]
