PIXNET Logo登入

DanBrother的部落格

跳到主文

歡迎光臨DanBrother在痞客邦的小天地. 部落格文章同步於=> http://blog.xuite.net/gem083/dba

部落格全站分類：數位生活

  • 相簿
  • 部落格
  • 留言
  • 名片
  • 7月 22 週一 201913:44

  • MariaBackup Usage

MariaBackup Usage for Debian / Ubuntu:
https://1drv.ms/b/s!AiM4lZDi7mITgZYwmvN2DRGThsV2jA?e=PCEqVE
MariaBackup Usage for CentOS:
https://1drv.ms/b/s!AiM4lZDi7mITgZYyysUNlhT7hNvfAw?e=wf2fNW
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(12)

  • 個人分類：MariaDB
▲top
  • 6月 19 週三 201917:08

  • MariaDB Galera Cluster Installation on MariaDB 10.3.16 / Debian 9.9

MariaDB Galera Cluster Installation on MariaDB 10.3.16  / Debian 9.9
MariaDB Galera Cluster Installation on MariaDB 10.3.16  Debian 9.9.docx
 
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(12)

  • 個人分類：MariaDB
▲top
  • 5月 21 週二 201911:12

  • MariaDB IP Address Conversion Functions

MariaDB IP Address Conversion Functions:
 
########
# IPV4:
########
-- Address To Number:
MariaDB [test]> select inet_aton('10.0.2.15');
+------------------------+
| inet_aton('10.0.2.15') |
+------------------------+
|              167772687 |
+------------------------+
1 row in set (0.001 sec)
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(6)

  • 個人分類：MariaDB
▲top
  • 5月 21 週二 201910:33

  • MariaDB Unix Time Conversion Functions

MariaDB Unix Time Conversion Functions:
MariaDB [test]> select unix_timestamp('2019-05-21 09:00:00');
+---------------------------------------+
| unix_timestamp('2019-05-21 09:00:00') |
+---------------------------------------+
|                            1558400400 |
+---------------------------------------+
1 row in set (0.001 sec)
 
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(2)

  • 個人分類：MariaDB
▲top
  • 11月 09 週五 201816:41

  • MariaDB Audit Plugin - Installation Procedures

MariaDB Audit Plugin - Installation Procedures
######################################
# Check the plugin library directory
######################################
MariaDB [(none)]> show global variables like 'plugin_dir';
+---------------+--------------------------+
| Variable_name | Value                    |
+---------------+--------------------------+
| plugin_dir    | /usr/lib64/mysql/plugin/ |
+---------------+--------------------------+
1 row in set (0.001 sec)
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(41)

  • 個人分類：MariaDB
▲top
  • 1月 09 週二 201817:31

  • MariaDB Backup & Restore Using Percona XtraBackup

MariaDB Backup & Restore Using Percona XtraBackup
** Note: Percona XtraBackup 8.0 and onward, the deprecated "innobackupex" script was removed
######################################################
# Download the Percona XtraBackup RPM file & libev
######################################################
# wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.9/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.9-1.el7.x86_64.rpm
# wget http://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/libev-4.15-3.el7.x86_64.rpm
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(50)

  • 個人分類：MariaDB
▲top
  • 1月 09 週二 201811:29

  • MariaDB 10.2 Installation Procedure on Oracle Linux 7

MariaDB 10.2 Installation Procedure on Oracle Linux 7
#####################################
# Creatiing the MariaDB YUM repository
#####################################
vi /etc/yum.repos.d/MariaDB.repo
>>
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2.12/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(1,408)

  • 個人分類：MariaDB
▲top
1

廣告

個人資訊

DanBrother
暱稱：
DanBrother
分類：
數位生活
好友：
累積中
地區：

熱門文章

  • (625)OSQL公用程式的使用方法
  • (49,259)Excel 2007 中文字顯示亂碼之修復步驟
  • (136)crsctl command usage
  • (2,928)ORA-24247: 存取控制清單 (ACL) 拒絕網路存取
  • (58,068)祝福禱告文-為工作祝福
  • (6)SQL Server 2005 Reporting Services Permission Settings for Viewing Reports
  • (84)Oracle 11.2.0.3 Grid Infrastructure ora.diskmon shows OFFLINE
  • (83)ORA-15306: ASM Password File Update Failed On At Last One Node
  • (542)Workaround for NI cryptographic checksum mismatch error: 12599 (TNS-12599)
  • (1,851)FRM-91111 and FRM-10039 When Starting Oracle Forms Builder 11g on Linux

文章分類

  • Android (1)
  • Java (1)
  • MongoDB (1)
  • MariaDB (7)
  • Python (10)
  • HTML (1)
  • ORDS (1)
  • Apache Tomcat (1)
  • Oracle Streams (1)
  • Javascript (1)
  • Oracle Data Guard (2)
  • Oracle VirtualBox (3)
  • Grid Infrastructure (4)
  • Oracle SQL Tuning (6)
  • OEM11g / 12c (28)
  • IT Links (1)
  • 心靈饗宴 (161)
  • Oracle Clusterware (5)
  • ORACLE RAC (21)
  • Oracle ASM (18)
  • Oracle Export/Import (10)
  • MySQL (22)
  • Windows Series (18)
  • Oracle HTTP Server (8)
  • Linux (49)
  • Microsoft Office (6)
  • SQL SERVER (19)
  • Install Apache & PHP (2)
  • Oracle in General (111)
  • RMAN (15)
  • SQL / PL/SQL (30)
  • 未分類文章 (1)

最新文章

  • MySQL Array Simulation in Stored Procedure
  • Extracts, orders, and then prints grants for MySQL user accounts (pt-show-grants)
  • MySQL Stored Procedure - Nested Loop Example
  • Metabase H2 DB Migration to MySQL 5.7
  • Steps for Upgrading Percona-Toolkit to the Latest Version
  • MySQL Slave - Skip Replication for A Particular Table
  • MySQL - Export & Import Table Data Based on the SQL Query
  • MySQL Table Fragmentation Detection and De-fragmentation Implementation
  • Multiple Log File Viewer (Linux Bash)
  • Solving MySQL slave lag Issues

動態訂閱

文章精選

文章搜尋

誰來我家

參觀人氣

  • 本日人氣：
  • 累積人氣：

留言板