We’re excited to announce the general availability of MONyog for Amazon Aurora. Amazon Web Services’ (AWS) latest offering, the Aurora database combines the speed and availability of commercial databases with the cost-effectiveness and simplicity of open source databases. Designed to provide up to 5x improved performance than MySQL at a price that’s one-tenth of any commercial RDBMS, Aurora definitely looks promising.

Aurora is fault-tolerant by design, since it replicates data into three locations, making it highly available. To monitor your Aurora databases, you can always rely on MONyog to do the job for you.

Aurora doesn’t allow to install anything on your Aurora database. Since MONyog is built on an agent-less architecture, it can connect to Aurora without any hassle.

Connecting to Aurora
Enter the DNS address of your …

We’re excited to announce the general availability of MONyog for Amazon Aurora. Amazon Web Services’ (AWS) latest offering, the Aurora database combines the speed and availability of commercial databases with the cost-effectiveness and simplicity of open source databases. Designed to provide up to 5x improved performance than MySQL at a price that’s one-tenth of any commercial RDBMS, Aurora definitely looks promising.

Aurora is fault-tolerant by design, since it replicates data into three locations, making it highly available. To monitor your Aurora databases, you can always rely on MONyog to do the job for you.

Aurora doesn’t allow to install anything on your Aurora database. Since MONyog is built on an agent-less architecture, it can connect to Aurora without any hassle.

Connecting to Aurora
Enter the DNS address of your …

I have heard this question quite often: “At busy times, our replicas start lagging quite frequently. We are using N schemas, so which performance boost could we expect from MySQL 5.6 parallel replication?” Here is a quick way to give you a rough estimate of the potential benefit.

General idea

In MySQL 5.6, parallelism is added at the schema level. So in theory, if you have N schemas and if you use N parallel threads, replication could be up to N times faster. This assumes at least 2 things:

• Replication throughput scales linearly with the number of parallel threads.
• Writes are evenly distributed across schemas.

Both assumptions are of course not realistic. But it is easy to know the distribution of writes, and that can already give you an idea about how much you could benefit from parallel replication.

Writes are stored in binary logs but it is much easier to work with the …

Oracle released a GA version of MySQL 5.6 in February 2013, Codership released the first GA in their patched 5.6 series in November 2013. Galera Cluster for MySQL 5.6 has been around for almost 2 years now, so what are you waiting for? :-)

Okay, this is a major upgrade so there are risks! Therefore, an upgrade must be carefully plan and tested. In this blog post, we’ll look into how to perform an online upgrade of your Galera Cluster (the Codership build of Galera) to MySQL 5.6. 

Offline Upgrade

An offline upgrade requires downtime, but it is more straightforward. If you can afford a maintenance window, this is probably a safer way to reduce the risk of upgrade failures. The major steps consists of stopping the cluster, upgrading all nodes, bootstrap and starting the nodes. We covered the procedure in details in …

Previous episodes:

• MySQL replication monitoring 101

MySQL replication in action - Part 1: GTID & CoMySQL replication in action - Part 2 - Fan-in topologyMySQL replication in action - Part 3 - All-masters P2P topology
Introducing star topology.In all-masters P2P topologies, we have seen that we have a way of deploying a topology where all nodes are masters, and achieve better efficiency and stability than ring topologies. That …

how to use percona-tookit to verify mysql data

Read this PDF : mysql_checksum

Here at VividCortex, it’s clear to us that proper database monitoring is “an art.” Beyond simple, raw power, navigating and understanding a database takes finesse, insight, and, often, a kind of eloquence.

On special occasions, though, the artistry of database monitoring becomes a little bit more literal, and we get to see how the functions of big data can be applied to the actual world of Fine Art. Such is the case now: this summer, New York’s world-class Museum of Modern Art (MoMA) decided to publicly post an enormous CSV file on GitHub, which contains various data sets for more than 125,000 pieces in the museum’s collection.

Essentially, with this document, a scholar, museum guest, or artist now has access to huge swaths of information about the art at MoMA – short of an image of the piece itself. While the ultimate experience for most …

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.21 and 5.5.45. These are both Stable (GA) releases.

Download MariaDB Galera Cluster 10.0.21

Release Notes Changelog What is MariaDB Galera Cluster?

Download MariaDB Galera Cluster 5.5.45

Release Notes …

Astute readers will note that InnoDB already had compression since the MySQL 5.1 plugin. We are using the terminology of ‘Page Compression’ to describe the new offering that will ship with MySQL 5.7, and ‘InnoDB Compression’ for the earlier offering.…

We are elated to announce the availability of SQLyog for Amazon Aurora Databases. You can now manage Amazon Aurora databases with SQLyog, the most powerful database manager, admin and GUI tool.

About Amazon Aurora:
Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

SQLyog + Amazon Aurora:
It is very easy to connect Aurora database using SQLyog: just enter the DNS address of the Aurora instance as the host parameter, port number from the endpoint as the port parameter and key in your credentials. You can manage your Aurora databases with powerful tools like Synchronisation, Import External Data, Backup Wizard, Job Scheduler etc.

Not only these, you get all the …