はてなブックマーク

• あとで読む

  テンポラル・テーブル - MariaDB Server 10.3 新機能

  5 users

  mariadb.com

  2018年5月にGAとなった MariaDB Server 10.3 では，すべてのデータ作成/更新/削除履歴を記録可能なテンポラル・テーブル(System-Versioned Tables)が新機能として追加されました。 テンポラル・テーブルにより以下のオペレーションが可能となり，より高度なセキュリティ，データ復旧性などが得られます。 すべてのデータ変更の監査 過去の任意時点でのデータのリカバリ 偶発的なデータ変更/削除や人為的エラー，アプリケーション エラーからの復旧 今回は簡単なサンプルデータを用いてテンポラルテーブルを解説したいと思います。 テスト環境 MariaDB Server 10.3.12 CentOS 7.6.1810 サンプルテーブル作成 従業員リストのようなテーブルを作成し，Linuxのdateコマンドでシステム時間を変更しながらサンプルデータをINSERTします。

  • テクノロジー
  • 2019/06/24 09:59
• あとで読む

  CentOS 7 に MariaDB Community Server 最新版をインストール | MariaDB

  4 users

  mariadb.com

  RHEL 7 / CentOS 7 などの主要な Linux ディストリビューションでは MariaDB Server がデフォルトのRDBMSとなっており，例えば RHEL 7 では以下のコマンドで簡単にインストールすることが可能ですが， sudo yum install mariadb-server 執筆時点では，MariaDB 5.5.60 がインストールされます。MariaDB general release maintenance periods では，MariaDB 5.5 は2020年4月11日でサポート終了予定となっており，新規に production 環境にインストールするのは好ましくありません。 本記事では，CentOS 7 にGA最新版の MariaDB Server 10.4 をインストールする手順を解説致します。 yumレポジトリの設定 今回は実行環境として Ce

  • テクノロジー
  • 2019/06/05 11:39
• あとで読む

  SQL_MODE=ORACLE | MariaDB Documentation

  4 users

  mariadb.com

  MariaDB's SQL_MODE = ORACLE setting enables compatibility with Oracle Database SQL syntax and behavior in MariaDB. This feature is particularly useful for organizations looking to migrate applications from Oracle Database to MariaDB while preserving the behavior and syntax of Oracle SQL. By setting the sql_mode to ORACLE, developers can ensure that their existing SQL scripts, application logic, an

  • テクノロジー
  • 2018/05/30 10:50
• あとで読む

  System-Versioned Tables | MariaDB Documentation

  3 users

  mariadb.com

  MariaDB supports temporal data tables in the form of system-versioning tables (allowing you to query and operate on historic data, discussed below), application-time periods (allow you to query and operate on a temporal range of data), and bitemporal tables (which combine both system-versioning and application-time periods). System-versioned tables store the history of all changes, not only data w

  • 暮らし
  • 2018/01/20 12:59
• あとで読む

  MariaDB Package Repository Setup and Usage | MariaDB Documentation

  3 users

  mariadb.com

  If you are looking to set up MariaDB Server, it is often easiest to use a repository. The MariaDB Foundation has a repository configuration tool and MariaDB Corporation provides two convenient shell scripts to configure access to their MariaDB Package Repositories:

  • 暮らし
  • 2017/09/25 12:28
• あとで読む

  MariaDB MaxScale 21.06 | MariaDB Documentation

  3 users

  mariadb.com

  MariaDB MaxScale 21.06This version of MariaDB MaxScale enhanced data integration and consistency. It introduced the Kafka CDC connector for streaming changes and simplified causal reads for replica servers.

  • テクノロジー
  • 2016/12/31 12:20

  • MariaDB
  • MySQL
• あとで読む

  MariaDB Memory Allocation | MariaDB Documentation

  3 users

  mariadb.com

  MariaDB Memory AllocationUnderstand MariaDB Server memory allocation. This section explains how memory is managed, key configuration parameters, and strategies for optimizing memory usage for enhanced performance.

  • テクノロジー
  • 2016/09/15 15:45

  • db
  • mysql
• あとで読む

  my.cnf による MariaDB の設定 - MariaDB Knowledge Base

  3 users

  mariadb.com

  my.cnf ファイルによって、MariaDB 実行時に任意の設定を反映させることができます。ほとんどの サーバーシステム変数 は my.cnf ファイルでセットすることができますが、通常ここに記述される設定は少数で、残りは単に既定値が利用されます。 MariaDB をどのように インストール したかにより、my.cnf が複数の場所にある場合や、まったく存在しない場合があります。 Linux、Unix、Mac での場所 Linux、Unix、Mac のサーバーにおいて、MariaDB は以下の場所から my.cnf ファイルを探します。

  • 暮らし
  • 2016/07/10 23:41

  • MariaDB
  • mysql
  • windows
• あとで読む

  Server System Variables - MariaDB Knowledge Base

  4 users

  mariadb.com

  Webinar | Beyond Keywords: AI Vector Search with LangChain and MariaDB Cloud

  • テクノロジー
  • 2016/07/03 23:28

  • MySQL
  • 設定
• あとで読む

  yum による MariaDB のインストール - MariaDB Knowledge Base

  6 users

  mariadb.com

  CentOS、RedHat、Fedora の場合、 yum を使用してリポジトリからインストールすることを強く推奨します。 このページでは簡単なインストール方法を紹介しています。 MariaDB yum リポジトリの追加 私たちはいくつかの yum ベースの Linux ディストリビューション向けに、yum リポジトリを公開しています。 オンライン repository generator を使用すると、使用しているディストリビューション向けの適切な MariaDB.repo エントリを簡単に作成することができます。 現在、CentOS 5、CentOS 6、CentOS 7、RHEL 5、RHEL 6、RHEL 7、Fedora 21 向けの yum リポジトリを公開しています。 MariaDB.repo エントリを作成したら、 /etc/yum.repos.d/ にファイルを作成して貼

  • 世の中
  • 2016/05/09 16:42

  • centos
  • db
  • あとで読む
• あとで読む

  About MariaDB Connector/J Guide | MariaDB Documentation

  4 users

  mariadb.com

  Download MariaDB Connector/J List of MariaDB Connector/J Releases MariaDB Connector/J is used to connect applications developed in Java to MariaDB and MySQL databases using the standard JDBC API. The library is LGPL licensed. MariaDB Connector/J is a Type 4 JDBC driver. It was developed specifically as a lightweight JDBC connector for use with MariaDB and MySQL database servers. It was originally

  • テクノロジー
  • 2016/04/04 00:30

  • test
  • git
  • MySQL
  • GitHub
  • Java
• あとで読む

  Python to MariaDB Connector | MariaDB

  6 users

  mariadb.com

  We previously blogged about using Python to connect to MariaDB servers using the MySQL Python package. In June 2020, MariaDB made the first generally available release of Connector/Python. We’ve refreshed this blog to reflect the latest technology. If you need the old blog, you can find it here. You can use the popular programming language Python to manage data stored in MariaDB Platform, includin

  • テクノロジー
  • 2016/03/07 01:26

  • python
  • db
  • Programming
  • あとで読む
• あとで読む

  Backup and Restore Overview | MariaDB Documentation

  4 users

  mariadb.com

  This article briefly discusses the main ways to backup MariaDB. For detailed descriptions and syntax, see the individual pages. More detail is in the process of being added. Logical backups consist of the SQL statements necessary to restore the data, such as CREATE DATABASE, CREATE TABLE and INSERT. Physical backups are performed by copying the individual data files or directories. The main differ

  • テクノロジー
  • 2015/09/18 12:55

  • mysql
• あとで読む

  Failover and High availability with MariaDB Connector/J - MariaDB Knowledge Base

  9 users

  mariadb.com

  Failover occurs when a connection to a primary database server fails and the connector opens up a connection to another database server. For example, server A has the current connection. After a failure (server crash, network down …) the connection will switch to another server (B). Load balancing allows load (read and write) to be distributed over multiple servers.

  • 学び
  • 2015/09/01 20:27

  • Aurora
• あとで読む

  InnoDB System Variables | MariaDB Documentation

  6 users

  mariadb.com

  Description: Setting this to 1 results in the built-in InnoDB storage engine being ignored. In some versions of MariaDB, XtraDB is the default and is always present, so this variable is ignored and setting it results in a warning. From MariaDB 10.0.1 to MariaDB 10.0.8, when InnoDB was the default instead of XtraDB, this variable needed to be set. Usually used in conjunction with the plugin-load=in

  • テクノロジー
  • 2015/03/26 23:07

  • あとで読む
• あとで読む

  ANALYZE FORMAT=JSON Examples | MariaDB Documentation

  3 users

  mariadb.com

  CopyANALYZE FORMAT=JSON SELECT COUNT(*) FROM customer WHERE (SELECT SUM(o_totalprice) FROM orders WHERE o_custkey=c_custkey) > 1000*1000; CopyEXPLAIN: { "query_block": { "select_id": 1, "r_loops": 1, "r_total_time_ms": 39872, "table": { "table_name": "customer", "access_type": "index", "key": "i_c_nationkey", "key_length": "5", "used_key_parts": ["c_nationkey"], "r_loops": 1, "rows": 150303, "r_ro

  • テクノロジー
  • 2015/03/21 23:13

  • MySQL
• あとで読む

  Galera Cluster System Variables - MariaDB Knowledge Base

  3 users

  mariadb.com

  /This page documents system variables related to Galera Cluster. For options that are not system variables, see Galera Options. See Server System Variables for a complete list of system variables and instructions on setting them. Also see the Full list of MariaDB options, system and status variables.

  • テクノロジー
  • 2015/03/05 10:30
• あとで読む

  About Mroonga | MariaDB Documentation

  4 users

  mariadb.com

  Mroonga is a full text search storage engine based on Groonga, which is an open-source CJK-ready (Chinese, Japanese, and Korean) fulltext search engine using column base. See groonga.org for more. With Mroonga, you can have a CJK-ready full text search feature, and it is faster than the MyISAM and InnoDB full text search for both updating and searching. Mroonga also supports Groonga's fast geoloca

  • テクノロジー
  • 2015/01/29 17:49

  • あとで読む
• あとで読む

  Microseconds in MariaDB - MariaDB Knowledge Base

  3 users

  mariadb.com

  The TIME, DATETIME, and TIMESTAMP types, along with the temporal functions, CAST and dynamic columns, support microseconds. The datetime precision of a column can be specified when creating the table with CREATE TABLE, for example: Generally, the precision can be specified for any TIME, DATETIME, or TIMESTAMP column, in parentheses, after the type name. The datetime precision specifies number of d

  • テクノロジー
  • 2014/12/10 09:32

  • mariadb
  • mysql
• あとで読む

  Installing MariaDB with yum/dnf | MariaDB Documentation

  3 users

  mariadb.com

  On RHEL, CentOS, Fedora, and other similar Linux RPM based distributions, these provide MariaDB packages. These are supported by those distributions. If you have a particular need for a later version than what is in the distribution, then MariaDB provides repositories for them. Using repositories rather than installing RPM allows for an ease of update when a new release is made. It is highly recom

  • 暮らし
  • 2014/11/27 11:52
• あとで読む

  MariaDB 10.0.15 Release Notes | MariaDB Documentation

  9 users

  mariadb.com

  The most recent release in the MariaDB 10.0 series is:MariaDB 10.0.38 Download Now Download | Release Notes | Changelog | Overview of 10.0 Release date: 25 Nov 2014 MariaDB 10.0 is the current stable series of MariaDB. It is an evolution of MariaDB 5.5 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6. MariaDB 10.0.15 is a Stab

  • テクノロジー
  • 2014/11/07 14:10

  • mariadb
• あとで読む

  MariaDB MaxScale | MariaDB

  7 users

  mariadb.com

  MariaDB MaxScale is an advanced database proxy for MariaDB Enterprise Server – powering its enterprise high availability, scalability, security and integration services. This datasheet describes the role of MariaDB MaxScale, and provides a summary of its enterprise services.

  • テクノロジー
  • 2014/10/13 20:26

  • MariaDB
  • database
  • あとで読む
• あとで読む

  Enterprise Database Products | MariaDB

  14 users

  mariadb.com

  Enterprise-Grade without the Enterprise Cost MariaDB offers a complete database solution that delivers best-in-class performance, data security, replication, clustering and high availability for production workloads. Get started within minutes with a database platform that provides the peace of mind organizations need to power mission-critical applications at a fraction of the cost of proprietary

  • テクノロジー
  • 2014/03/06 20:40

  • pacemaker
  • maxscale
  • 冗長化
  • MariaDB
  • database
  • mysql
• あとで読む

  MariaDB versus MySQL - Features | MariaDB Documentation

  3 users

  mariadb.com

  Webinar | Beyond Keywords: AI Vector Search with LangChain and MariaDB Cloud

  • テクノロジー
  • 2014/02/04 16:58

  • mysql
• あとで読む

  Index Condition Pushdown

  9 users

  mariadb.com

  That way, the value Handler_icp_attempts - Handler_icp_match shows the number records that the server did not have to read because of Index Condition Pushdown. Limitations Currently, virtual column indexes can't be used for index condition pushdown. Instead, a generated column can be made declared STORED. Then, index condition pushdown will be possible. Index Condition Pushdown can't be used with

  • テクノロジー
  • 2013/12/20 09:16

  • MariaDB
  • mysql
• あとで読む

  Thread Pool in MariaDB | MariaDB Documentation

  4 users

  mariadb.com

  The task of scalable server software (and a DBMS like MariaDB is an example of such software) is to maintain top performance with an increasing number of clients. MySQL traditionally assigned a thread for every client connection, and as the number of concurrent users grows this model shows performance drops. Many active threads are a performance killer, because increasing the number of threads lea

  • テクノロジー
  • 2013/10/10 14:14

  • mariadb
  • db
• あとで読む

  Cassandra Storage Engine Overview | MariaDB Documentation

  9 users

  mariadb.com

  MariaDB starting with 10.6 Cassandra storage engine is no longer a part of MariaDB. The Cassandra storage engine is included but is not installed/activated by default. If using the YUM repositories on Fedora, Red Hat, or CentOS, first install the Cassandra storage engine package with:

  • 暮らし
  • 2013/09/13 12:30

  • mariadb
  • cassandra
• あとで読む

  MariaDB – 日本語

  8 users

  mariadb.com

  Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

  • テクノロジー
  • 2013/02/26 06:18

  • データベース
  • OS
  • ソフトウェア
  • PC
  • あとで読む

次のページ