Tag:data base

  • Introduction to the technical architecture of Apache trafodion

    Time:2019-10-21

    About trafodion Trafodion is a relational database based on Hadoop / HBase, which is completely open-source and free. Trafodion can fully support ANSI SQL and provide acid transaction guarantee. Different from the traditional relational database, trafodion can provide high scalability by using the horizontal expansion ability of the underlying Hadoop. Traditional databases, such as mysql, […]

  • Delete database without running away – explain MySQL data recovery in detail

    Time:2019-10-21

    In daily work, there will always be some mistakes in deleting database tables and data caused by shaking hands, writing wrong conditions, writing wrong table names, and connecting the production database wrongly. Then, if you can’t recover the data, what DBAs are needed. Related articles MySQL backup strategy MySQL data recovery 1 Preface The premise […]

  • Oracle delete user and tablespace details

    Time:2019-10-21

    Oracle delete users and tablespaces Oracle has been used for a long time, and many new users and tablespaces have been added. It needs to be cleaned up. For a single user and tablespace, you can use the following command. Step 1: delete user drop user ×× cascade Note: if the user is deleted, only […]

  • Oceanbase high availability practice

    Time:2019-10-20

    background High availability is the cornerstone of building a distributed system. On the one hand, due to the consideration of cost, the distributed system often adopts relatively cheap hardware, and its reliability has a lot of shortcomings compared with the small-sized machine and proprietary hardware, while the scale of the distributed system is generally large. […]

  • C ා tool class MySQL helper, based on mysql.data.mysql client encapsulation

    Time:2019-10-20

    Source code: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data; using MySql.Data.MySqlClient; namespace Fly.Util.DataBase { /// ///Mysql database operation class /// public static class MySqlHelper { /// ///Execute database non query operation and return the number of affected rows /// ///Database connection string ///Type of command ///MySQL stored procedure name or […]

  • The creation, import and export of Linux database and some basic instructions

    Time:2019-10-20

    First, under Linux, check MySQL related directories ViewmysqlInstallation path for Execute querySQL mysql>show variables like ‘%dir%’; datadirData path Determine the running path and execute the command of importing and exporting MySQL databaseI. use mysqldump command to export database(Note: first CD to MySQL running path, and then execute the following command):1. Export data and table structure:Mysqldump […]

  • Sqlmap actual battle-1

    Time:2019-10-19

    Sqlmap actual battle-1 Detect and utilize SQL injection Python2 sqlmap. Py – U “[url] SQL injection point]” [– batch] –batch: automatically select the default selection of sqlmap Finding goals Direct connection to database python2 sqlmap.py -d “mysql://[user]:[password]@[ip]:[port]/[dbs]” –banner –dbs –users Database operation parameters: –dbs: enumerate database information –current-db: current database name –current-user: current database user […]

  • Database API specification v2.0 (PEP 249)

    Time:2019-10-19

    Database API specification v2.0 (PEP 249) GitHub @ orca-j35, all notes are hosted in the python_notes warehouseAny reprint is welcome, but please indicate the source. Reference resources: https://www.python.org/dev/pe… http://sinhub.cn/2019/01/pep2… https://zh.wikipedia.org/wiki… https://en.wikipedia.org/wiki… introduce PEP 249 is version 2.0 of Python database API specification, and PEP 248 is version 1.0. PEP 249 not only contains the python […]

  • Ora-12514 error analysis

    Time:2019-10-19

    Solution to the problem that the ora-12514 TNS listener cannot recognize the request service in the connection descriptor at present   Ora-12514 TNS listener currently does not recognize the requested service in the connection descriptor Some colleagues have encountered this problem. Here’s a summary. The reasons are as follows: After your Oracle installation is successful, […]

  • What does this distributed kV storage system course teach me? |Talent plan and I

    Time:2019-10-18

    Author: Zhang Yiwen Author introduction:Zhang Yiwen, a sophomore of Wuhan National optoelectronic Laboratory of Huazhong University of science and technology, mainly focuses on kV storage based on new storage devices. Pingcap talent plan phase II excellent students. Three months have passed since I graduated from pingcap talent plan, which is also my first close contact […]

  • Roaming adventure of a piece of data

    Time:2019-10-18

    Alimei’s Guide:Database storage engine is a historical technology, after decades of development, there have been many excellent and mature products. The paper “x-engine: an optimized storage engine for large-scale e-commerce transaction processing” written by Alibaba’s x-engine team detailed the original work of the team on the database storage engine, which was received by SIGMOD’19 industrial […]

  • Empire CMS (Empire CMS) v7.5 background arbitrary code execution

    Time:2019-10-18

    Empire CMS (Empire CMS) v7.5 background arbitrary code execution I. vulnerability description When the EmpireCMS 7.5 and earlier are backing up the database in the background, the database table name is not verified, and arbitrary code execution can be realized by modifying the database table name. II. Affected version EmpireCMS<=7.5 III. environment construction 1. Official […]