mariadb storage engine - sharding and xa transactions
#mariadb #storage #linux #db #database #spider #sharding #partitions #partition xa_transaction

https://t.iss.one/unixmens

mariadb spider storage engine



Spider Storage Engine is a plugin of
MySQL/MariaDB. Spider tables can be
used on other MySQL/MariaDB/OracleDB
tables as local tables. And Spider can
create database sharding by using table
partitioning feature.


spider engine suport xa transactions



Redundant feature
You can choose redundant level per table/partition.
Fault tolerance feature
You can use not only Spider’s fault tolerance feature
but also other MySQL’s fault tolerance solutions.
Fulltext/Geo search feature
(with table partitioning, available for patched MariaDB)
You can use backend Fulltext/Geo search feature
transparently.

NoSQL feature (now support )
You can use handlersocket for Spider.
OracleDB connecting feature
You can search sharded table by parallel.


mariadb storage engine - sharding and xa transactions
#mariadb #storage #linux #db #database #spider #sharding #partitions #partition xa_transaction

https://t.iss.one/unixmens

کتابی که در مورد اوراکل نوشته بودم سالها پیش ، تقدیم عزیزان

#oracle #db #database #dba #yashar_esmaildokht
#book

https://t.iss.one/unixmens

#oracleDB #support

#db #oracle

@unixmens

کتاب مرجع oracle mysql |mariadb که سالها پیش نوشته بودم . تقدیم عزیزان



MariaDB and MySQL are both popular open-source relational database management systems (RDBMS) that are used to store, organize, and manage data. They are both based on the same core software, which was originally developed by MySQL AB, but MariaDB is a fork of MySQL that was created in 2009 due to concerns about the acquisition of MySQL by Oracle Corporation.

MariaDB and MySQL have many similarities, including their architecture, syntax, and functionality. Both databases use SQL (Structured Query Language) to manage data and support a wide range of programming languages. They also offer features such as replication, clustering, and partitioning to improve performance and scalability.

However, there are also some differences between MariaDB and MySQL. MariaDB has some additional features and improvements over MySQL, such as better performance, improved security, and more storage engines. MariaDB also supports more data types than MySQL and has more built-in functions.

Overall, both MariaDB and MySQL are powerful and reliable RDBMS options for managing data, and the choice between them may depend on specific needs and preferences.

#db #dba #yashar_esmaildokht #book #mariadb #oracle #mysql 📕 📖

https://t.iss.one/unixmens

Oracle® Audit Vault and Database Firewall
#oracle #book #linux #firewall #net #security
#db #dbfirewall #db_firewall
https://t.iss.one/unixmens

کتاب مرجع اوراکل نسخه 0.4 تقدیم عزیزان
بصورت آزاد منتشر کردم .



دوست داشتید عضو کانال هم بشید .
https://t.iss.one/unixmens
#linux #db #oracle #book #yashar_esmaildokht

Type of Database

#database #db

@unixmens

https://dbaclass.com/article/transparent-data-encryption-tde-in-oracle-12c/


#db #oracle

CREATE INDEX index_name ON table_name(column_name)
LOCAL (PARTITION partition_name1, PARTITION partition_name2, ...);

مثال:

CREATE INDEX emp_partition_idx ON employees(employee_id)
LOCAL (PARTITION part1, PARTITION part2);

نکات مهم:
- استفاده از ایندکس‌ها نیازمند درک کامل از نیازمندی‌های کوئری‌ها و ساختار داده‌ها است.
- ایندکس‌ها باعث بهبود سرعت خواندن داده‌ها می‌شوند اما ممکن است سرعت عملیات درج، به‌روزرسانی و حذف را کاهش دهند.
- برای مدیریت ایندکس‌ها، می‌توانید از دستورات DROP INDEX برای حذف ایندکس‌ها استفاده کنید:

DROP INDEX index_name;
```

با توجه به نیازهای خاص برنامه و داده‌های شما، می‌توانید از انواع مختلف ایندکس‌ها برای بهینه‌سازی عملکرد دیتابیس استفاده کنید.

در آینده در مورد آنها بیشتر خواهم نوشت .

#index #oracle #db #database

https://t.iss.one/unixmens