Database Administrator

HBase cannot assign permissions to users HBase cannot assign permissions to users and reports an error. Problem background description: In the test environment, hdfs is formatted. Many hdfs-based environments are affected. Hbase is also affected.

Solutions to the increasing size of MySQL ibdata1 files I encountered a MySQL database installed in yum when installing zabbix monitoring. Later I used it for a while to find that the ibdata1 space under the data Directory was very large, on the

Oracle Materialized View Details In actual work, multiple data sources are synchronized to a single database for data analysis. These data can not be synchronized in real time. Generally, we extract data from the statistical analysis database

Install the Inception service and use Python 3 to audit MySQL Bison is one of the packages that the Inception service depends on. However, some Linux versions have already installed Bison, or the Bison installed through yum, which is usually in

What if MySQL transactions contain DDL statements? As we all know, MySQL DDL statements are non-transactional, that is, DLL statements cannot be rolled back. What if a transaction contains DDL statements? For example: # Disable automatic

MySQL 8.0.4 RC: Be careful when using auth_socket! The news from the latest MySQL 8.0.4 RC (Candidate edition) is indeed exciting. Unfortunately, for auth_socket plug-in users, the danger is waiting! As early as November 2015, it was reported that

MySQL Case sensitivity: lower_case_table_names & lower_case_file_system MySQL Case sensitivity: lower_case_table_names & lower_case_file_system 〇 lower_case_file_systemThis parameter is used to describe whether the operating system of the data

Oracle tablespace deletion Problems and SolutionsProblem 1: An error ORA-29857 was reported during tablespace Deletion Table space deletion statement:DROP TABLESPACE SAC INCLUDING CONTENTS AND DATAFILES;According to the MOS document:How To Resolve

Mysql read/write splitting implemented by mycat and mycatmysql read/writeMycat is a middleware that can be used for mysql read/write splitting, data sharding, table sharding, and disaster tolerance backup. It can also be used for multi-tenant

Basic Database knowledge and database knowledgeTransaction ACID atomicity (atomicity) Each transaction is an inseparable minimum unit. Operations in the transaction are either all successful or all fail to be rolled back.Consistency) The result of

Use phpmyadmin to set mysql permissions. Step 1: log on to the root user. Step 2: Create a new data table and select a sorting rule. Here we use testtable. Step 3: Create a new user and enter the relevant account name and password. Step 4:

Redis Data Structure Type introduction, redis Data Structure Type----------------------------------------- Redis Data Structure Type -------------------------------------------------------------------I. string type1. Set the valueSet key value (if

Flask and MySQL configuration operations, flaskmysql Configuration Running environment:Centos6.7; python 2.7.11; Fix the bug by writing it above:SQLALCHEMY_DATABASE_URI is written as SQLALCHEMY_DATABASE_URL, which is extremely concealed;Write

PostgreSQL uses dblink to implement cross-database query. postgresqldblink A recent SQL statement involves joint queries between tables in different databases. At the beginning, I learned how to write SQL statements, but failed to execute them. I

Summary of common SQL statement optimization techniques [classic] and SQL statement techniques classic This example summarizes common SQL statement optimization techniques. We will share this with you for your reference. The details are as

Use SQL statements to connect two tables in different databases on two different servers. Initially, the SQL statements are written as follows: Select*FromProduct pInner Join  Opendatasource ('Sqlodb','Data Source = Macaco-Online; user ID =

The following is the process of manually deploying the SQL Server CLR assembly. Here, we will make a record for you to read it at any time and provide reference for those who have no manual deployment experience, if you have any more convenient and

SQL Server has three different functions that can be used to obtain the final id value in the table containing the ID column: @ IDENTITY SCOPE_IDENTITY () IDENT_CURRENT ('Data table name') Although all the above three functions can return

When sorting, grouping and summarizing, and indexing are performed in the Oracle database, a lot of temporary data is generated. If there is an employee information table, the database stores the installation record creation time. If you use the

Data backup is almost a task that every system administrator has to do every day. However, this is very tedious-if the system automatically backs up data at a fixed time every day, that would be nice! Next, I will talk about how to implement