Lmst

How to Avoid Using OR With LIKE Patterns

OR with LIKE can defeat index usage.

#mysql #or #like #performance #howto #search

https://www.youtube.com/watch?v=N4nEq0x4HJk

MySQL Ndb Cluster is often described as an in-memory or main memory database but this is not the whole story.

Tables in Ndb always support :
- Transactions, parallel query, indexes, FKs etc
- Sync replication between nodes in a cluster
- HA with automatic failover and recovery
- Consistent backup
- Async replication via MySQLD

By default Tables in Ndb also have automatic transactional durability via parallel checkpoints and logs, supporting full system recovery from storage. However, this can be disabled for individual tables if desired for highest performance with lowest resource usage. In the event of a full system recovery from storage, these tables will be empty.

By default, all columns of a table are kept in memory at all times, limiting system capacity to full cluster system memory size. However unindexed columns can be marked for disk storage. Values for these columns are stored in pages of a tablespace, and only cached in memory like most other RDBMS. This allows far more data to be stored while retaining predictable fast access via purely in memory indexes.

#MySQL #ndbcluster #DistributedSQL

Tengo publicado en YouTube un tutorial para la instalación y configuración del driver #JDBC de #MySQL en el servidor de aplicaciones #Wildfly.

https://youtu.be/qSUZLeqxYlA

#Gratis #Free #SiguemeYTeSigo #followback #FolloMe #Java

Nota: imagen generada con IA generativa.

How to Avoid MySQL Skipping Indexes With ORDER BY

Sorting on a different column can kill index usage.

#mysql #orderby #index #howto #performance #schema

https://www.youtube.com/watch?v=INO1H3JEyCc

we continue keynotes with @sarahnovotny on #OpenSourceSoftware everywhere.
Global scale projects that were key for the big companies shw worked on #mysql, #kubernetes, #nginx, #nixos, #nodejs, #opentelemetry, …
#OpenSource is not made of #code, it is made of #people, the governance and collaboration of those projects makes them global. And that helps to solve problems.
We need to help people to become more active in the #community by setting incentives well.
#NationalOpenSourceInnovationSummit

Serverdienste und Dateifreigaben im Netzwerk

Samba unter Ubuntu als Verzeichnis einbinden
https://forum.ubuntuusers.de/topic/samba-unter-ubuntu-als-verzeichnis-einbinden/
06.02.2026 um 08:23 Uhr

#ubuntuusers #forumuu #linux #opensource #fragenistmenschlich #netzwerk #network #server #webserver #ssh #mysql #nfs #samba #vnc #vpn

Как написать прикольную книгу про SQL, которую интересно читать?

Есть довольно устойчивый миф: SQL — это что-то скучное, сложное и строгое. Обычно знакомство выглядит так: несколько глав теории, а потом сразу синтаксис запросов , строки, таблицы, и дальше человек либо втягивается, либо закрывает книгу и возвращается к ней через пару лет — уже по необходимости. Когда мы в «БХВ» обсуждали новую книгу по SQL, разговор неожиданно ушёл не в сторону синтаксиса, а в сторону обучения. Точнее — в сторону того, почему так много людей бросают изучение SQL на середине. И наш постоянный и горячо любимый читателями автор Ольга Назина, известная своими бестселлерами по тестированию, предложила: а давайте сделаем прикольную книгу, с шутками, забавными картинками и простыми примерами, чтобы читать ее было интересно? Мы согласились: а давайте!

https://habr.com/ru/companies/bhv_publishing/articles/993124/

#sql #субд #бд #базы_данных #mysql #postgresql

Finally got the #lab spun up, all that’s left to do now is seed #ActiveDirectory and a couple fake internal APIs. If anyone happens to know any good scripts for dumping a ton of fake but real-looking data into a #MySQL database that’d be a great help too.

#cybersecurity #threatintel #homelab

Introducing #VillageSQL: A New Path for MySQL in the Agentic #AI Era

The successor of #MySQL? Time will show...

https://villagesql.com/blog/introducing-villagesql/

#database

Introducing #VillageSQL: A New Path for MySQL in the Agentic #AI Era

The successor of #MySQL? Time will show...

https://villagesql.com/blog/introducing-villagesql/

#database

How to Stop Functions From Disabling Indexes

Wrapping a column kills your index instantly.

#mysql #index #performance #date #howto #slowquery

https://www.youtube.com/watch?v=MA9CIFDHqMY

MySQL Ndb Cluster 8.4 specific security features include :
- Encrypted backups
- Encrypted storage (Checkpoints, redo logs, undo logs + tablespaces) (TDE)
- mTLS on all internal connections for authentication and encryption (Ndb TLS)

All open source, implemented using industry standard optimised and reviewed OpenSSL libraries.

These features are in addition to the standard MySQL Server Security features ([m]TLS, TDE, Binlog encryption, PAM etc)

https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security.html
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tde.html
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html

https://dev.mysql.com/blog-archive/mysql-cluster-8031-transparent-data-encryption/
https://blogs.oracle.com/mysql/introducing-ndb-tls
https://messagepassing.blogspot.com/2020/11/mysql-cluster-backup-and-restore.html

https://dev.mysql.com/doc/refman/8.4/en/security.html

#DistributedSQL #MySQL #NdbCluster #OpenSource

HI everyone!
I am a Senior Full Stack Developer and DevOps consultant with 8 years of experience and I currently have full time availability from February (next monday) onward.
I help teams design, build, and monitor scalable Laravel and Vue.js applications, from MVPs to long term production systems.

I work hands on with Laravel, Vue.js, FilamentPHP, Traefik, Docker and FrankenPHP, with a strong focus on clean code and observability (New Relic).

Some example projects I have worked on:

Custom platform for an Italian utility company.

Payment request and information portals for Italian municipalities. (pagoPa)

Custom SaaS applications built on Laravel and Vue.js

Monitoring and observability setups for consumer and security companies using New Relic

Monitoring and code quality improvements for a large Italian consulting enterprise

If you are looking for someone who can both ship features and keep your systems observable, secure, and reliable, feel free to reach out and share what you are working on.
#programming #fedihire #freelance #business #developer #laravel #php #vuejs #typescript #docker #mysql

next of @curioss event is @sarahnovotny telling about the intersection between #OpenSource and #AI.
It's beautiful to learn how each of us have become involved with open source. In the case of Sarah was through #mySQL 🐬
LLM as 🦜🦜 Stochastic parrots - brilliant - that it's our responsability.