Fun fact: Michael Widenius named "MySQL" after his daughter My. When MySQL was acquired by sun, he decided to start a new open source database, "MariaDB", named after his second daughter Maria.

This guy is (partially) responsible for two of the largest databasesystems in the world.

Imagine his daughters apply for a database engineering job one day. During application process: "One of the largest databases in the world was named after me..." 😂

Client: Glad to have you on the team, you come highly recommended for your experience in Microsoft technology, specifically asp.net

Me: I was contacted for a php, mariadb project

Client: well they're all the same

Me: actually sir no.... No they're not.

Client: then why was I told to contact you

Me: you tell me, your hiring manager contacted me for a php project not asp or. Net

Client: well I guess I know who to blame for your, sorry for taking your time. Can I contact you if we have a project made with that thing you mentioned?

Me: php?, Sure

Client: nice...... Take care

Me: you too

That went better than I expected

Just looked at the anonymous analytics I collect on the security/privacy blog.

No SQL Injection attacks yet (would be useless anyways as I don't use MySQL/MariaDB for the databasing.

Directory Traversal attacks. Really? 🤣

Nice try, guys.

Front end + back end = Project finished.

This is my first full stack application that I spent a month working on. It's a basic database that holds car information and saves it to a SQL db. I built this using Java Spring/Hibernate for my backend and Node.JS/REACT for my front end. Mariadb handles SQL requests. REACT handles token requests for secure login, that was the hardest part of this whole thing.

I was going to comment on how frequently I feel like garbage and an inadequate excuse of a human being, but today is my birthday and this is the best gift I could get, a finished project from scratch.

I'm 29 today devRant. And I work over the weekend before going back to school, but at least I fucking finished something that I started.

...thanks, for everything. 😄

Accidentally proposing to your colleagues when autocorrect corrects mariadb to married and you end up with:

"As long as we can get married on it, it's fine"

Instead of

"As long as we can get mariadb on it, it's fine"

When migrating from MySQL server to MariaDB and having a query start returning a completely different result set then what was expected purely because MariaDB corrected a bug with sub selects being sorted.

It took several days to identify all that was needed on that sub select was “limit 1” to get that thing to return the correct data, felt like an idiot for only having to do 7 character commit 😆

Screw MySQL/MariaDB. Who the fuck thought not to document that utf8 is only 3 bytes and not unicode capable. You have to use utf8mb4 for it to work. Fuck those idiots that don't want to admit they made a mistake and put this info in a footnote on a pricy documentation piece.

Rails console:
> `ModelOne.joins("ModelTwo")`
# => ActiveRecord::StatementInvalid (Mysql2::Error: Unknown table 'database_name.model_ones')

MariaDB:
> `select count(*) from database_name.model_ones`
# => 13274641

It's right there, ffs

New dev prefers mariadb over postgresql, which is okay.

But his main reason is 'the smaller docker image'

What an argument, wtf

I had to write a job portal which had to be done in php5.6 and mariadb and it had to be IE compatible. All of those good things.

I've created a small smart home web app 2 or 3 years ago.
Features:
- Change DECT heating controller settings
- Philips Hue control
- Wunderlist integration
- Send a cooking recipe to the web app (from a large recipe site, with a greasymonkey script)

I've mounted an old Android tablet to a kitchen cupboard where the web app runs in kiosk mode in fullscreen (you can swipe between the different panels).

The web app is build with .NET Core Web-API, Vue.js and MariaDB. Everything runs on a Raspberry Pi.

Last year I've discovered openHAB with HABPanel...

I hate SQL Server so much, don't matter how Microsoft say they improve themselves at SQL Server.

There's a lot of fucking bloat, messes your system and your services, adds tons of crap in your system registry, while more advanced SQL engines such MariaDB/PostgreSQL are more contained, and its very small.

Why SQL Server has to mess with Windows' ACL and his own privilege systems?.

Uninstall it and a lot of components remain hidden and tons of registry entries, not even TotalUninstaller or CCleaner can help.

I hate it since my technical high school and my goddamn college is forcing us to use SQL Sever for EVERYTHING, instead of good alternatives, messed my computer entirely requiring to format.

I try always to convince my freelance clients to use open-source alternatives, and say how SQL Server is so crap, (i had variant degrees of success).

Ok, so I basically spent my weekend trying to work out why the fuck my python docker container would not connect to my mariadb docker container. Tried fucking everything, bridged network, host network, links (even though theyre deprecated), you name it. It would NOT WORK!

In my despair I finally turned to StackOverflow. There I was told 5min after posting the question that the reason was probably that mysql is a quite heavy service, which takes a bit to start up.

I thought to myself "Oh, get the fuck outta here, that can't be it, shit's way too easy to work!"
I tried it nevertheless by adding a 10sec delay before querying the database AND THE MOTHERFUCKING PIECE OF SHIT ACTUALLY WORKS!! So, I essentially just lost a weekend because I was too impatient... I think I'm gonna punch some trees now.

Estimate for writing a custom WordPress plugin:

1 hour - Learn the API the plugin will support
1 hour - Review how plugins are written
60 hours - Set up XAMPP only to find that the version with PHP 7 no longer supports MySQL but something called MariaDB which my host doesn't support and then uninstall XAMPP and install MAMP only to get really frustrated setting it up and beat myself for not just buying that $99 Windows Pro upgrade so I can install Kalabox with HyperV which is much easier than all of this and why doesn't Kalabox have a way of supporting Windows Home because not everyone buys Windows Pro or can afford a Mac or has time to screw around with 100 possible Linux distros to figure out which one will work best and then buy gasoline and matches and set it on fire and watch it all buuuuuuurn such pretty fire.

Just a long rant here..

Im a bit of fed up with the "management" for this company.

- - - - -
There is a new guy joining the company which is being as "technical lead" a.k.a my new boss. His experience is a OracleDB expert. Anything related to oracle, just name it, he can do it.
But.. on other matter, he just dumb af. all his life only know "oracle", for that.. im really having a complex issue with him. There is a new project coming involving MariaDB, and the project is really complicated. This project is handled by me & him. So, since im not an expert guy, im doing lab test as much as i could, so that i get the knowledge and gist of it. But right now im stuck with my lab test, the project is just around the corner. I ask him to teach or look on his lab test or anything, but really waste my time. He doesnt even do anything about this, not even care. He just sitting, keep himself busy and everyday ask me either my lab test is working or not. I raise a concern that if im doing this alone, the company could facing serious issue, coz im stuck. He even said to me this project is complex af, even himself doesnt know what to do. but.. im not sure what he said is a joke or not but it seems pretty real for me. He just chilling, asking for update everyday..

For clarification : our company have ton of ESX / HyperV / RedHat Virtualization. U can create anything you want with any complex networking as you wish.

I did ask him once, really nicely, :"did you know how to setup the project environment?- out of curiosity"
His asnwer was :"by looking at the guide on the net, i can say MariaDB is really straight forward, really easy and for the load balancer part is really complex because not in the net at all"..
Then i ask :"did u do any labtest or what on this "complex part"?"..
He said :"no, im just reading the guide & my laptop couldnt handle this massive environment, its not supported"...
Me :"Our company have ton of virtual server, u know right?"......
Him :"I know"..
Me :"................."

Wtf im doing here man, im dead.. for sure, if this project went down, im the one will get blamed here. Added, this project is for BANK. Im not comfortable to drag him along, by the look of his ugly face + me blaming him.. I dont want him to feel pure loser. Im not that kind of evil..

Ugly face + loser at work = not a good combination right.
So.. i feel really bad.. idk what to do..

Then, i take another path to learn..
I ask for "MariaDB Training" since we both is dead meat.

now its been a month without any improvement.
Thats it..

I did raise my concern to our upper management,
Got no replied & wont even care. Dead. MoneyTalks.

Im starting to update my resume again..

Thanks for devRant.

My boss's SQL schema has no foreign keys and he said he left them out intentionally because they should be handled in the application layer and they're a large performance impact.

This is a fresh greenfield project and he's already pre-optimizing for problems we don't have yet, on things that may or not be bottlenecks using ideas (e.g. foreign keys have huge performance costs on mariadb/auora) with no hard data or facts to back them up.

Let's start a new project with some technical debt!

Struggling to write the query with query builder for an hour, gave up and wrote the raw query in 5 minutes.

It took me like 3 hours to install stupid mariadb on my fucking arch. From the service not beeing able to start over not finding the correct base dir to permission problems in the data dir.
Well, after reading the wiki it was actually pretty easy (only minor problems) ...

Today I learned two things:
- I must be fucking dumb
- Reading the manual instead of guessing helps a lot when installing stuff on linux

STOOOOP TELLING ME THE TABLE DOESN'T EXIST. YOU'RE FUCKING SUPPOSED TO CREATE THE DAMN TABLE NOT TELL ME IT DOESN'T EXIST! YOU FUCKING DID IT AT HOME ON MY DESKTOP SO WHY DO YOU DO THIS TO MEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEeeAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

So today I accidentally updated more than 3000 records in a table and wasn’t using transactions so I couldn’t Rollback, LOL had the whole team freak out this Monday morning and we had to pull a backup

When suddenly your java program stops running fine. You spend a lot of time searching for the bug, modifing some stuff, but then you discover that mariadb stopped working...

And the modified stuff, produces a lot of bugs...

sudo pacman -Syu --force
sudo reboot

Openfire and owncloud no longer work.

sudo systemstl status openfire

Java exception relating to SQL.

sudo systemstl status mariadb

No such service mariadb

WTF why would that get uninstalled, how the hell.

sudo pacman -S mariadb

Everything now works again

Arch can be a confusing place

😺

Maybe that force was a bad idea.

I just created an Oracle account just to comment on a mysql bug report in order to inform people to use mariadb as a fix ¯\_(ツ)_/¯

^w should delete back a word, not to the beginning of the line! This is broken because instead of readline, Oracle's mysql-client uses editline.

Yet why the fuck do you compile mysql-client with editLine wrapper that breaks the common keybindings?

Licenses is why. Oracle wants to avoid using GNU GPL, and readline uses just that, so they use editline since it has BSD. And they just don't seem to give a damn if it breaks usability.

God fucking damn this stupid MariaDB is full of bugs... First access denied because I tried to login as root as non root and now that... Damn...

Yesterday we released this huge refactoring/rewrite I did alone so it was my task to release and fix any upcoming problems. Not that I would have died to refactor a huge part of the codebase but technical debt was waiting to kill us on upcoming features.

Deployment is done by ssh'ing into prod and pulling from git. I'm happy I could convince them to track a dedicated release branch... Why would we want to build anything? What is automation?

Debian 8 with MySQL 5 community edition... Throws some internal error on my use of JSON functions. Thankfully I was allowed to switch prod to MariaDB but updating packages caused segfaults with the PHP MySQL connector. This is why you need NixOS!

Prod is a 4 core 4 GB VM that would take forever to run migrations. Also no disk space. Had to copy the whole db to staging (which is much more powerful and on Debian 9? diverging environments in the same data center...), migrate there and and pipe back mysqldump directly into ssh while in my neck I feel another client's project that I have about half a week left to finish.

It's Monday night. Customer has a full office of over 50 users at 8 AM.

Almost fell asleep in the car the next day, and I think I have RSI in my enter finger now.

I some time's feel stupid when my Ubuntu start acting up on prod, purge this and that ,fuck apache can't start system CTL that ps ax grep in the p#$#@* , damn apt install nginx full good, mysql can't start too ,OK apt install mariadb-client else percona && apt postgresql thanks ,god no client noticed ..

My journey into learning Docker, chapter {chapter++}:

Today I learned that when you use a database image in your docker-compose file, and you want to rebuild the whole thing for reasons (say, a big update), then if you change your credentials ("root" to "a_lambda_user" or change the db's password) for more security, and you rebuild and up the whole thing... It won't work. You'll get "access denied".

Because the database (at least mysql and mariadb) will persist somewhere, so you need to run "docker rm -v" even though you didn't use any volumes.

I love loosing my fucking time.

Did some distro hopping at the weekend and ended up back in Ubuntu.

And for the most part everything is running like a dream, except MY motherfucking SQL.

Installation appears to be ok, but doesn’t let me set a root password, and throws errors like it’s cool when I try and change the root password.

Same goes for MariaDB.

All of my googling for a solution has so far failed me

Recent experience:

- Installed openSUSE Tumbleweed
- Installed mariadb
- Tried to start the service (several times) with failure
- Searched online, made adjustments as per the suggestions. No luck
- Reinstalled related packages
- Tried again and failed
- Deleted everything in /var/lib/mysql
- Tried again ... and 👍

Just sharing

This one was thanks to the beloved MariaDB.

I needed to update a record with id = 12345
I copied the id to the clipboard.
Then proceded to type:

UPDATE table SET field = NULL WHERE Ctrl+v

So it ended up
UPDATE table SET field = NULL WHERE 12345

I forgot to type "id = " after the "WHERE".

MariaDB says "OK, after the WHERE any number means TRUE".

Simple update taking longer than 0.000001 seconds means bad news. And if you add that I was making the stupid update using phpMyAdmin, I couldn't cancel it faster. I had to log into terminal and kill it from there. Some hundred of thousands of records updated to null, thank you.

It was a testing database, and we had a backup so I had to take my good 30 minutes to restore it but it was not cool.

Why the actual fuck is MariaDB disguised as MySQL in the AUR?!? Is there just no way to install MySQL from the AUR anymore?

Just succesfully setup database cluster , now I need balancer!

Fuck!

I just accidentally installed mariadb and completely fucked mysql. Probably by now I've deleted my databases, but luckily nothing very important.

Time to get round to setting some proper backup system I suppose.

Fuck PHP, fuck Lamp stack and fuck MariaDB

Fuck you MySQL and mariadb!

Where is the support for full join.

Really needed that and discovered noooo MySQL the most used free shit does not want to support it!

Almost made me switch from Debian to Windows server!

Today i chartered new realms for me.

I created a new hyper-v vm on the company windows servers and added a 5th instance to it, but instead of running another windows server i installed an ubuntu 18.04 (cause i am a bit familiar with debian from my raspberry pi)

we have two servers, one which runs the 4 vms and a replica. I first had the new vm on the main server but it occured me to move it instead to the unusued replica machine. That kinda worked..i did a planned failover but the main server isnt configured to be the replica..and even when activating that it didnt work. This is weird.

For the moment i ignored that and proceeded to install nginx, mariadb and php 7.2..basically the lemp stack. I managed to setup nginx and a static ip adress for the machine (which was different from how i remembered it to do (in 18.04 its not done with the network conf but a yaml file).

in the end i added two different virtual servers, one for actual use and one for dev stuff (with phpmyadmin running for instance), listening on port 80 and some random other port.

as a test i brought a mediawiki onto the Port 80 server and it worked.

on monday i have to figure out how to implement the wildcard certificate i have for our company domain (internal dns simply routes intranet.company.com to the local server vm)

i am mighty proud cause all my experience with linux was with a raspberry pi so far and i am fairly certain i did it right and without shortcuts this time. (unlike my raspberry experience)

just wanted to share

(i also sweated a lot of blood when editing the hyper v settings as i did not set up the server in the first place)

((i also installed xrdp and a mate desktop, but i am less proud of that, but sometimes seeing folders graphically helps me))

I've been wondering about renting a new VPS to get all my websites sorted out again. I am tired of shared hosting and I am able to manage it as I've been in the past.

With so many great people here, I was trying to put together some of the best practices and resources on how to handle the setup and configuration of a new machine, and I hope this post may help someone while trying to gather the best know-how in the comments. Don't be scared by the lengthy post, please.

The following tips are mainly from @Condor, @Noob, @Linuxxx and some other were gathered in the webz. Thanks for @Linux for recommending me Vultr VPS. I would appreciate further feedback from the community on how to improve this and/or change anything that may seem incorrect or should be done in better way.

1. Clean install CentOS 7 or Ubuntu (I am used to both, do you recommend more? Why?)
2. Install existing updates
3. Disable root login
4. Disable password for ssh
5. RSA key login with strong passwords/passphrases
6. Set correct locale and correct timezone (if different from default)
7. Close all ports
8. Disable and delete unneeded services
9. Install CSF
10. Install knockd (is it worth it at all? Isn't it security through obscurity?)
11. Install Fail2Ban (worth to install side by side with CSF? If not, why?)
12. Install ufw firewall (or keep with CSF/Fail2Ban? Why?)
13. Install rkhunter
14. Install anti-rootkit software (side by side with rkhunter?) (SELinux or AppArmor? Why?)
15. Enable Nginx/CSF rate limiting against SYN attacks
16. For a server to be public, is an IDS / IPS recommended? If so, which and why?
17. Log Injection Attacks in Application Layer - I should keep an eye on them. Is there any tool to help scanning?

If I want to have a server that serves multiple websites, would you add/change anything to the following?
18. Install Docker and manage separate instances with a Dockerfile powered base image with the following? Or should I keep all the servers in one main installation?
19. Install Nginx
20. Install PHP-FPM
21. Install PHP7
22. Install Memcached
23. Install MariaDB
24. Install phpMyAdmin (On specific port? Any recommendations here?)

I am sorry if this is somewhat lengthy, but I hope it may get better and be a good starting guide for a new server setup (eventually become a repo). Feel free to contribute in the comments.

PHP: Laravel, Phalcon, Composer
JavaScript: Node.js, Express.js, Restify, Sequelize, AngularJS, React, npm, bower
Python: Django, Flask, Requests, pip, SQLAlchemy
Java: Spring, Dropwizard, Hibernate
DB: MySQL, MariaDB, PostgreSQL, Cassandra

PHP dev help/advice needed!
We have problems with mysql. Still stuck with mariaDB, I'm using indexes (correct ones) and we have problems with scaling. we have a few tables with over 100mil rows, 1 of them is being read every morning with a subselect that counts unique rows, and fails every time because of timeout/lock, the temp table size was increased and helped for a little while but as time goes on the table grows and the problem reappears. I'm reading from a slave server that was purposely created for read only, yet we still have problems. We're using managed dedicated servers for out hosting and they aren't willing to optimise the database configs for our needs. What are the easiest options for scaling at this point? Going fully dedicated server and perconaDB? NOsql? Sharding the server? Anyone got any good blogposts or something to read about this? your own experience?

Is it a good approach to use MariaDB in one Server and MongoDB in another one to store various client's data?
The reason I need MongoDB is because the client has to create custom Maintenance Checklist (which mean he has to create rows and columns), and then submit these data based on specific period. And I am finding hard time how to design this on MariaDB, even with dynamic columns since it might bring performance issue.

!rant PostgreSQL or MySQL/MariaDB?

mysqldump db > db.sql
yum install mariadb
*config*
mysql -u username --password pass db < db.sql

Why do I control mariadb with the mysql word? I installed it, I want to use it....

ORM feels like, I can do better than that, with more predictability (like naming, table creation, and stuff).

The only pro, is hopes for inter-dialects interop (SQLite-Postgres-MySQL-MariaDB).

OK, I also want SQLite-MongoDB interop, because of the cheap price; but this is difficult.

How can it be a galera cluster with three DB servers (running in docker) is slower than a single docker container with mariadb under the same load?

! rant, I hope😗

To anybody with MySQL/Mariadb experience, how different are these two as I need to pick one for a database application I'm building.

Also, and God will I sound like an amature for asking, is it best practice to debug and deploy the SQL database on an actual hosted server or to just do it on the client PC? I have both and I want to work with whichever one will give me less of a headache.😣

Any feedback would be helpful! The server is Debian and the client is Arch Linux.

Common Table Expression's, especially recursive, are fucking awesome.

*happy tears*

What’s the appeal of Microsoft SQL Server 2019 over something free like PostgreSQL or MariaDB?

So PHP PDOs... nothing fucking works. It's that or the lovely MariaDB implementation, I know that the query is correct and I've tried a stored procedure as well. The query itself ran once to add one user and never again while anything I try now doesn't return any result. I'm going to install Percona and see if it's the implementation or me.

Help needed: i need the st_distance_sphere function from PostgreSQL, but I only have MariaDB 10.1.21

Question: - can/should i Switch to Postgresql (i do only Basic inserts and selects from PHP PDO)
- has anybody an idea for a workaround (i'm Not very familiar With SQL-functions, so please explain :) )

Thanks a lot 👍

How is your experience with upgrading from Debian 8 to Debian 9? Want to update my homeserver but I really don't want to screw it up. Especially with the switch from MySQL to MariaDB

You got Network Partitioning a.k.a Split Brain syndrome on your cluster database server

What the absolute fuck

Can someone explain why `SELECT foobar FROM sometable` works in MariaDB while `SELECT sometable.foobar` doesn't?

The error is "code 1109. Unknown table foobar in field list"