Showing entries 1 to 10 of 37287
10 Older Entries »
How MariaDB ColumnStore Handles Big Data Workloads – Data Loading and Manipulation

How MariaDB ColumnStore Handles Big Data Workloads – Data Loading and Manipulation david_thompson_g Wed, 02/22/2017 - 18:34

MariaDB ColumnStore is a massively parallel scale out columnar database. Data loading and modification behaves somewhat differently from how a row based engine works. This article outlines the options available and how these affect performance.

Data Loading and Manipulation Options

MariaDB ColumnStore provides several options for writing data:

  1. DML operations: insert, update, delete
  2. Bulk DML: INSERT INTO … SELECT
  3. MariaDB Server bulk file load: LOAD DATA INFILE
  4. ColumnStore bulk data load: cpimport
  5. ColumnStore bulk delete: ColumnStore partition drop.

 

DML Operations

ColumnStore supports transactionally consistent insert, update, and delete statements using standard syntax. Performance of …

[Read more]
MySQL Group Replication: about ack from majority

The documentation states that “For a transaction to commit, the majority of the group have to agree on the order of a given transaction in the global sequence of transactions.

This means that as soon as the majority of nodes member of the group ack the writeset reception, certification can start. So, as a picture is worth a 1000 words, this is what it looks like if we take the illustrations from my previous post:

a group of 3 members

zoom in transaction delivery

 

majority is reached, the system agreed on the order
ack of the remaining node will come too but the order has been already decided
certification can start
the process then continues as usual

So theoretically, having 2 nodes in one DC and 1 node in another DC shouldn’t be …

[Read more]
Converting comma separated fields to MySQL JSON – a case study

This post is a case study of a job I had to do in a legacy application, it doesn’t mean it will apply to you, but it might.

This is a table of contents:

[Read more]
Webinar Thursday, February 23, 2017: Troubleshooting MySQL Access Privileges Issues

Please join Sveta Smirnova, Percona’s Principal Technical Services Engineer, as she presents Troubleshooting MySQL Access Privileges Issues on
February 23, 2017 at 11:00 am PST / 2:00 pm EST (UTC-8).

Do you have registered users who can’t connect to the MySQL server? Strangers modifying data to which they shouldn’t have access?

MySQL supports a rich set of user privilege options and allows you to fine tune access to every object in the server. The latest versions support authentication plugins that help to create more access patterns.

However, finding errors in …

[Read more]
Percona XtraBackup 2.4.6 is Now Available

Percona announces the GA release of Percona XtraBackup 2.4.6 on February 22, 2017. You can download it from our download site and apt and yum repositories.

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona …

[Read more]
Percona XtraBackup 2.3.7 is Now Available

Percona announces the release of Percona XtraBackup 2.3.7 on February 22, 2017. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups.

This release is the …

[Read more]
The Perfect Server CentOS 7.3 with Apache, Postfix, Dovecot, Pure-FTPD, BIND and ISPConfig 3.1

This tutorial shows how to install ISPConfig 3.1 on a CentOS 7.3 (64Bit) server. ISPConfig 3 is a web hosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, Mailman, and many more.

MySQL Connector/NET 6.10.1 beta has been released

MySQL Connector/Net 6.10.1 beta is the second release which supports Scaffold-DbContext, that enables the creation of corresponding model classes from an existing database that are compatible with Entity Framework (EF) Core 1.1.

To download MySQL Connector/Net 6.10.1 beta, see the “Development Releases” tab at http://dev.mysql.com/downloads/connector/net/

Changes in MySQL Connector/Net 6.10.1 (2017-02-22, Beta)

Known limitations of this release:

* The output classes cannot exist prior to using the EF Core database first feature.

* The target database must have a table with a primary key.

* The target database cannot contain one or more views.

* The JSON data exchange format is not supported by the EF Core database first feature.

* No error message is provided when a table given as input does not …

[Read more]
Install EasyGUI on Fedora

The EasyGUI library is a nice tool for developing GUI applications. It doesn’t require you to know event-driven programming to write basic GUI applications because it’s based on Python functions.

You can download and install the EasyGUI library with yum utility like this:

yum install -y python-easygui

It should generate the following list:

Loaded plugins: langpacks, refresh-packagekit
mysql-connectors-community                                  | 2.5 kB  00:00     
mysql-tools-community                                       | 2.5 kB  00:00     
mysql56-community                                           | 2.5 kB  00:00     
pgdg93                                                      | 3.6 kB  00:00     
updates/20/x86_64/metalink                                  | 2.8 kB  00:00     
Resolving Dependencies
--> Running …
[Read more]
Comparing Query Cache in ProxySQL and MaxScale

Few days ago MariaDB announced MaxScale 2.1.0 Beta, and among the new Query Performance capabilities there is Query Cache Filter. Query Cache was among the very first features introduced in ProxySQL, and therefore I was extremely curious to compare them!
Reading the documentation on MaxScale Query Cache Filter I noticed few interesting things compares to ProxySQL Query Cache:

  • MaxScale supports in-memory and on disk storage, while ProxySQL supports only in-memory storage
  • MaxScale can have either shared or per-thread cache, while ProxySQL supports only shared cache: in 2014 ProxySQL had per-thread cache, but benchmark showed that a partitioned shared cache is way more efficient

To compare ProxySQL 1.3.4 Query Cache …

[Read more]
Showing entries 1 to 10 of 37287
10 Older Entries »