Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34321 10 Older Entries
VividCortex Receives the MySQL Community Award for Application of the Year
+0 Vote Up -0Vote Down

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 …

  [Read more...]
MySQL 5.7 Labs — Inserting, Updating, and Deleting Records via HTTP
Employee_Team +1 Vote Up -0Vote Down

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 …

  [Read more...]
MongoDB’s flexible schema: How to fix write amplification
+0 Vote Up -0Vote Down

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; …
  [Read more...]
Partial table recovery from physical backup
+0 Vote Up -0Vote Down

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 …

  [Read more...]
How to setup MySQL incremental backup
+2 Vote Up -0Vote Down

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 …

  [Read more...]
VividCortex Press Release: Receives Award, Continues to Expand
+0 Vote Up -0Vote Down

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.

Information on the SSL connection vulnerability of MySQL and MariaDB
+0 Vote Up -0Vote Down

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

  [Read more...]
Log Buffer #421: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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 …
  [Read more...]
lower_case_table_names option to lose databases and tables
+0 Vote Up -0Vote Down

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 …


  [Read more...]
Percona Acquires Tokutek : My Thoughts #3 : Fractal Tree Indexes
+0 Vote Up -0Vote Down

Last week I wrote up my thoughts about the Percona acquisition of Tokutek from the perspective of TokuDB and TokuMX[se]. In this third blog of the trilogy I'll cover the acquisition and the future of the Fractal Tree Index. The Fractal Tree Index is the foundational technology upon which all Tokutek products are built.



  [Read more...]
Showing entries 1 to 10 of 34321 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.