Codership will be joining OpenStack Summit Vancouver May 18-22. Visit our booth T52. Codership will have demo theater presentation about Galera in cloud, Time Warner Cable will tell how they use Galera and MariaDB gives best practises to use MariaDB Galera Cluster.

OpenStack Summit is the must-attend OpenStack event. The OpenStack Summit is a five-day conference for developers, users, and administrators of OpenStack Cloud Software. It’s a great place to get started with OpenStack.

Codership’s demo theater presentation at Vancouver:

Do More with Galera Cluster in Your OpenStack Cloud

Galera Cluster is already the way to achieve active/active HA for OpenStack back-end databases. Yet, it is possible to do a great deal more: Galera can provide cloud user with a fully redundant database cluster in place of the traditional …

VividCortex, the monitoring solution for the modern data system, continues building a product that enables IT departments to manage distributed, diverse systems effectively and improve workflow.

Charlottesville, Virginia (PRWEB) May 05, 2015 - VividCortex, the monitoring solution for the modern data system, received the MySQL Community Award for Application of the Year at Percona Live 2015. Since launching in April 2014, the SaaS product for database monitoring has provided unparalleled query insight and given customers a clear view of what is happening on their production servers, allowing companies to improve application and server performance and maximize resources. This award recognizes the new standard for database monitoring, one that goes beyond graphs and charts to provide actionable data. VividCortex will continue to build a service that enables IT teams to manage distributed systems and continuous workflows …

In the MySQL Labs version of MySQL version 5.7, there is a new HTTP plugin. The HTTP plugin documentation from the labs site provides this information (from MySQL Labs):

The HTTP Plugin for MySQL adds HTTP(S) interfaces to MySQL. Clients can use the HTTP respectively HTTPS (SSL) protocol to query data stored in MySQL. The query language is SQL but other, simpler interfaces exist. All data is serialized as JSON. This version of MySQL Server HTTP Plugin is a Labs release, which means it’s at an early development stage. It contains several known bugs and limitation, and is meant primarily to give you a rough idea how this plugin will look some day. Likewise, the user API is anything but finalized. Be aware it will change in many respects.

In …

Being schemaless is one of the key features of MongoDB. On the bright side this allows developers to easily modify the schema of their collections without waiting for the database to be ready to accept a new schema. However schemaless is not free and one of the drawbacks is write amplification. Let’s focus on that topic.

Write amplification?

The link between schema and write amplification is not obvious at first sight. So let’s first look at a table in the relational world:

mysql> SELECT * FROM user LIMIT 2;
+----+-------+------------+-----------+-----------+----------------------------------+---------+-----------------------------------+------------+------------+
| id | login | first_name | last_name | city      | country                          | zipcode | address                           | password   | birth_year | …

In previous topic, we have covered “Transportable Tablespace” concept by copying and importing table’s tablespace to remote server. See -> Copying Tablespaces to Remote Server

The idea is copying tablespace file to remote server, in remote server you must create identical database names and table names manually, then you should discard new table’s tablespace file and import new copied one.

To achieve this you must have running MySQL version >= 5.6, innodb_file_per_table=1 and you must know “CREATE statement” of table.

Let’s to change our test condition. Assume that, you have MySQL server and you have taken physical backup of your server (you can use Percona XtraBackup, …

Incremental backups in MySQL were always a tricky exercise. Logical backup tools like mysqldump or mydumper don’t support incremental backups, although it’s possible to emulate them with binary logs. And with snapshot-based backup tools it’s close to impossible to take incremental copies.

Percona’s XtraBackup does support incremental backups, but you have to understand well how it works under the hood and be familiar with command line options. That’s not so easy and it’s getting worse when it comes to restoring the database from an incremental copy. Some shops even ditch incremental backups due to complexity in scripting backup and restore procedures.

With TwinDB incremental backups are easy. In this post I will show how to configure MySQL incremental backups for a replication …

VividCortex received the MySQL Community Award for Application of the Year. This is an acknowledgement of the work put into developing a smarter monitoring tool providing deep query insights. We continue to be extremely excited about what’s on the horizon. Read the full press release here.

Last  week, a SSL connection security vulnerability was reported for MySQL and MariaDB. The vulnerability states that since MariaDB and MySQL do not enforce SSL when SSL support is enabled, it’s possible to launch Man In The Middle attacks (MITM). MITM attacks can capture the secure connection and turn it into an insecure one, revealing data going back and forth to the server.

Issue resolution in MariaDB is visible through the corresponding ticket in MariaDB’s tracking system (JIRA): https://mariadb.atlassian.net/browse/MDEV-7937

The vulnerability affects the client library of the database server in both MariaDB and MySQL. But, the vulnerability does not affect all the libraries, drivers or connectors for establishing SSL connections with the server.

The vulnerability exists when the connection to the server is done through the client …

As always, this fresh Log Buffer Edition shares some of the unusual yet innovative and information-rich blog posts from across the realms of Oracle, SQL Server and MySQL.

Oracle:

A developer reported problems when running a CREATE OR REPLACE TYPE statement in a development database. It was failing with an ORA-00604 followed by an ORA-00001. These messages could be seen again and again in the alert log.

• Few Random Solaris Commands : intrstat, croinfo, dlstat, fmstat for Oracle DBA
• When to use Oracle Database In-Memory?
• Oracle Linux and Oracle VM at …

To lose your data or make it unavailable there is an excellent option in MySQL, rather than drop or delete Option name is lower_case_table_names. Default value of this setting is 0:

       mysql> select @@lower_case_table_names; 
       +--------------------------+ 
       | @@lower_case_table_names | 
       +--------------------------+
       | 0 | 
       +--------------------------+ 
       1 row in set (0.00 sec) 

Due to documentation value=0: Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement. Name comparisons are case sensitive. You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or OS X). If you force this variable to 0 with –lower-case-table-names=0 on a case-insensitive file system and access MyISAM tablenames using different …