Tag: MariaDB

Feed: Percona Database Performance Blog. Author: Colin Charles. Colin Charles  | August 18, 2017 |  Posted In: MariaDB, MongoDB, MySQL, Percona Live, TokuDB PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Has a week passed already? Welcome back to the second column. A lot of time has been spent neck deep in getting speakers accepted and scheduled for Percona Live Open Source Database Conference Europe 2017 in Dublin, as well organizing the conference sponsors. At the time of writing, we are six weeks away from the conference, so ... Read More

Feed: Planet MySQL; Author: The Pythian Group; This Log Buffer Edition covers from various blogs covering the technologies and news of Oracle, SQL Server and MySQL.Oracle:Storage Server: datasets, snapshots and performanceA Different Cause for enq: TM – contentionODA X6-2M – How to create your own ACFS file systemOracle New Version NumberingKBHS-00600: Internal Error, Arguments [1] [kbhshtCreateDataBucket] Error During Backup To Oracle CloudSQL Server:Using Database Master Keys in SQL ServerSQL Server Management Studio TipsSqlcmd is not just a script execution tool. It gives us access to internal variables and commands that we can use to automate code execution.Additional SERVERPROPERTY properties in ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles  | August 10, 2017 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL PREVIOUS POST Welcome to a new weekly column on the Percona blog. My name is Colin Charles, Percona Chief Evangelist, and I have been involved in MySQL, MariaDB Server and the open source community for over a decade. Now I am at Percona, and this is my weekly column. When you start a column, you have ask yourself what you’ll be writing about. Keeping the focus on the reader is what’s crucial. With this in mind, I plan to cover happenings, ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; TL;DR: unless you know what you are doing, you should always have a primary key on your tables when replicating in RBR (and maybe even all the time). TL;DR2: MariaDB 10.1 has an interesting way to protect against missing a primary key (innodb_force_primary_key) but it could be improved.A few weeks ago, I was called off hours because replication delay on all the slaves from a replication chain was high and growing.  It was not the first time this happened on that chain, so I thought right away that this was probably an UPDATE or DELETE of many ... Read More

Feed: Planet MySQL; Author: MariaDB; MariaDB ColumnStore 1.0 supports User Defined Functions (UDF) for query extensibility. This allows you to create custom filters and transformations to suit any need. This blog outlines adding support for distributed JSON query filtering.  An important MariaDB ColumnStore concept to grasp is that there are distributed and non-distributed functions. Distributed functions are executed at the PM nodes supporting query execution scale out. Non distributed functions are MariaDB Server functions that are executed within the UM node. As a result, MariaDB ColumnStore requires two distinct implementations of any function. The next release, MariaDB ColumnStore 1.1, will ... Read More

Feed: Planet MySQL; Author: MariaDB; The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.26. See the release notes and changelogs for details. Download MariaDB 10.1.26 Release Notes Changelog What is MariaDB 10.1? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB! ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles  | August 10, 2017 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL PREVIOUS POST Welcome to a new weekly column on the Percona blog. My name is Colin Charles, Percona Chief Evangelist, and I have been involved in MySQL, MariaDB Server and the open source community for over a decade. Now I am at Percona, and this is my weekly column. When you start a column, you have ask yourself what you’ll be writing about. Keeping the focus on the reader is what’s crucial. With this in mind, I plan to cover happenings, ... Read More

Feed: Planet MySQL; Author: MariaDB; We are pleased to announce the general availability (GA) of MariaDB Connector/J 2.1, the newest version of MariaDB Connector/J for Java 8+.  MariaDB Connector/J 2.1 is fully compatible with MariaDB Connector/J 2.0, so version 2.0.3 was the last maintenance release for 2.0 and will be replaced by version 2.1 moving forward. MariaDB Connector/J 2.1 includes the following new enhancements: Security MariaDB Connector/J 2.1 adds verification of SSL certificate name mismatch functionality. When using SSL, the driver will check the hostname against the server's identity as presented in the server's certificate (checking alternative names or certificate ... Read More

Feed: Planet MySQL; Author: MariaDB; The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.32, as well as the recent releases of as MariaDB Connector/ODBC 3.0.1 (beta), MariaDB Connector/J 2.1.0 and MariaDB Connector/J 1.6.3. See the release notes and changelog for details. Download MariaDB 10.0.32 Release Notes Changelog What is MariaDB 10.0? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/ODBC 3.0.1 (beta) Release Notes Changelog About MariaDB Connector/ODBC Download MariaDB Connector/J 2.1.0 Release Notes Changelog About MariaDB Connector/J Download MariaDB Connector/J 1.6.3 Release Notes Changelog About MariaDB Connector/J Thanks, and enjoy MariaDB! ... Read More

Feed: Percona Database Performance Blog. Author: Dave Avery. Dave Avery  | August 3, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live PREVIOUS POST We are excited to announce that the sneak peek schedule for the Percona Live Open Source Database Conference Europe 2017 is up! The Percona Live Open Source Database Conference Europe 2017 is September 25 – 27, at the Radisson Blu Royal Hotel. The theme of Percona Live Europe 2017 is Championing Open Source Databases, with sessions on MySQL, MariaDB, MongoDB and other open source database technologies, including time series databases, PostgreSQL and RocksDB. This year’s conference will feature ... Read More