Misc go-to FOSS options
-
@scottalanmiller said in Misc go-to FOSS options:
@bbigford said in Misc go-to FOSS options:
TSQL: Defaulted to MySQL until some devs spun off concerned with the Oracle acquisition and started defaulting to MariaDB
I think you mean "Relational Database". SQL is a general purpose query language intended for relational databases but used for any kind. T-SQL is the specific language of MS SQL Server and nothing but Microsoft's product ever has used it.
ah, you're right, relational was meant here, not TSQL. Good catch.
-
@scottalanmiller said in Misc go-to FOSS options:
@bbigford said in Misc go-to FOSS options:
TSQL: Defaulted to MySQL until some devs spun off concerned with the Oracle acquisition and started defaulting to MariaDB
Again, it's about workloads. Doing a website, MariaDB. Doing a robust application, PostgreSQL. Doing a traditional workload with only one application touching it, SQLite.
Where does MariaDB fall down with a more robust application compared to PostgreSQL? Wondering when you start to lean toward PostgreSQL.
-
@bbigford said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@bbigford said in Misc go-to FOSS options:
TSQL: Defaulted to MySQL until some devs spun off concerned with the Oracle acquisition and started defaulting to MariaDB
Again, it's about workloads. Doing a website, MariaDB. Doing a robust application, PostgreSQL. Doing a traditional workload with only one application touching it, SQLite.
Where does MariaDB fall down with a more robust application compared to PostgreSQL? Wondering when you start to lean toward PostgreSQL.
Basically anytime that I need to be doing anything other than a cached read of a site. Basic websites like WordPress are built around MariaDB. If I'm building my own code, it's always SQLite or PostgreSQL. PostgreSQL is faster, more robust, and has more features. MariaDB is targetted at read heavy websites and blogs.
-
@gotwf said in Misc go-to FOSS options:
So maybe at least take a gander before dismissing: https://www.percona.com/software/mysql-database/percona-xtradb-cluster
It's just clustering on top of MySQL, though. I wouldn't use MySQL at all. MariaDB is better, but I'd only use it to the point of software built to use it. Building a cluster of MySQL seems odd. Not entirely terrible but... odd. If I had something that important, it would never be on MySQL.
-
@gotwf said in Misc go-to FOSS options:
So maybe at least take a gander before dismissing: https://www.percona.com/software/mysql-database/percona-xtradb-cluster
This seems less good than Galera, the built in included clustering in MariaDB. Not sure why I'd replace Galera with something else unless it has a significant advantage. I'm not against Percona, if I needed commercial support they'd be my first call, this is what they do. And I love that they are a one stop shop for support of many open source DBs. But I've never needed third party support and I wouldn't want to stray from the base product that everyone can support.
-
@bbigford said in Misc go-to FOSS options:
I've been wondering about others' preferences on a few things. The landscape of operating systems and databases has changed a bit in the last few years. Not curious about Windows or MSSQL, nothing new there.
Server OS: I've bounched back and forth with CentOS before Stream (the split between 6 and 7 was weird), Ubuntu Server (seems to get a lot of hate, no idea why), Fedora Server (also seems to get some hate, not sure why), RHEL (only when the customer absolutely requires the support and can't convince them otherwise), Debian (not used a ton, not sure why, pretty barebones)
NoSQL DB: MongoDB went through a really shady legal bit when they were doing their as-a-service initially, which basically spelled out they own your IP if you use their DB with your app, haven't checked back to see if that got cleared up. On-prem I've used CassandraDB and MongoDB mainly, and started looking into ScyllaDB more recently.
Relational DB: Defaulted to MySQL until some devs spun off concerned with the Oracle acquisition and started defaulting to MariaDB, mainly see PostgreSQL in larger deployments but don't know much difference to go with one over the other than what a vendor leans toward.
What are some of your go-tos these days? Why?
We've been pushing hard on getting up to speed with Ubuntu starting with 18 then 20 now 22. There are a few quirks with 22 but for the most part it's been stable.
MariaDB is where we went with the backend needs.
We've not had a need to go with anything NoSQL at this point.
Workloads are multiple WordPress sites on one Ubuntu server OS (boy, what a lot of fun it is trying to get any documentation that gives a clear step-by-step ... just blew up the server for the umpteenth time now need to figure out what broke it as search sucks at this point for me) as well as Mastodon.
We'll be setting up some SFTP sites for clients once we get the WordPress sites online.
-
@PhlipElder said in Misc go-to FOSS options:
Workloads are multiple WordPress sites on one Ubuntu server OS (boy, what a lot of fun it is trying to get any documentation that gives a clear step-by-step ... just blew up the server for the umpteenth time now need to figure out what broke it as search sucks at this point for me) as well as Mastodon.
We'll be setting up some SFTP sites for clients once we get the WordPress sites online.It's not terrible, but yeah, there is a surprising lack of documentation on that. It's like the single most common Linux server task and it seems no one knows how to do it.
I can only imagine that there was a time when everyone knew how to do it and because of that, stopped teaching it, and now no one knows. But you need it constantly.
-
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
Workloads are multiple WordPress sites on one Ubuntu server OS (boy, what a lot of fun it is trying to get any documentation that gives a clear step-by-step ... just blew up the server for the umpteenth time now need to figure out what broke it as search sucks at this point for me) as well as Mastodon.
We'll be setting up some SFTP sites for clients once we get the WordPress sites online.It's not terrible, but yeah, there is a surprising lack of documentation on that. It's like the single most common Linux server task and it seems no one knows how to do it.
I can only imagine that there was a time when everyone knew how to do it and because of that, stopped teaching it, and now no one knows. But you need it constantly.
Wow, no kidding.
The number of "How to set up WordPress multiple sites on one VPS/Ubuntu Server" articles is crazy and they're all somewhat different. Plus, there's "multisite" which is *.domain.com hosting subdomain sites. We don't want that.
Got a good How-To pointer? Please & Thanks?
*Sorry for co-opting the thread. -
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
Workloads are multiple WordPress sites on one Ubuntu server OS (boy, what a lot of fun it is trying to get any documentation that gives a clear step-by-step ... just blew up the server for the umpteenth time now need to figure out what broke it as search sucks at this point for me) as well as Mastodon.
We'll be setting up some SFTP sites for clients once we get the WordPress sites online.It's not terrible, but yeah, there is a surprising lack of documentation on that. It's like the single most common Linux server task and it seems no one knows how to do it.
I can only imagine that there was a time when everyone knew how to do it and because of that, stopped teaching it, and now no one knows. But you need it constantly.
Wow, no kidding.
The number of "How to set up WordPress multiple sites on one VPS/Ubuntu Server" articles is crazy and they're all somewhat different. Plus, there's "multisite" which is *.domain.com hosting subdomain sites. We don't want that.
Got a good How-To pointer? Please & Thanks?
*Sorry for co-opting the thread.I really need to make one. BUt that's not going to be a "this week" item as I'm in Costa Rica for my anniversary.
My team needs it too. I should be able to hand this stuff off to them easy peasy and I can't.
-
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
Workloads are multiple WordPress sites on one Ubuntu server OS (boy, what a lot of fun it is trying to get any documentation that gives a clear step-by-step ... just blew up the server for the umpteenth time now need to figure out what broke it as search sucks at this point for me) as well as Mastodon.
We'll be setting up some SFTP sites for clients once we get the WordPress sites online.It's not terrible, but yeah, there is a surprising lack of documentation on that. It's like the single most common Linux server task and it seems no one knows how to do it.
I can only imagine that there was a time when everyone knew how to do it and because of that, stopped teaching it, and now no one knows. But you need it constantly.
Wow, no kidding.
The number of "How to set up WordPress multiple sites on one VPS/Ubuntu Server" articles is crazy and they're all somewhat different. Plus, there's "multisite" which is *.domain.com hosting subdomain sites. We don't want that.
Got a good How-To pointer? Please & Thanks?
*Sorry for co-opting the thread.I really need to make one. BUt that's not going to be a "this week" item as I'm in Costa Rica for my anniversary.
My team needs it too. I should be able to hand this stuff off to them easy peasy and I can't.
Happy anniversary. How many years?
Understood.
-
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
Workloads are multiple WordPress sites on one Ubuntu server OS (boy, what a lot of fun it is trying to get any documentation that gives a clear step-by-step ... just blew up the server for the umpteenth time now need to figure out what broke it as search sucks at this point for me) as well as Mastodon.
We'll be setting up some SFTP sites for clients once we get the WordPress sites online.It's not terrible, but yeah, there is a surprising lack of documentation on that. It's like the single most common Linux server task and it seems no one knows how to do it.
I can only imagine that there was a time when everyone knew how to do it and because of that, stopped teaching it, and now no one knows. But you need it constantly.
Wow, no kidding.
The number of "How to set up WordPress multiple sites on one VPS/Ubuntu Server" articles is crazy and they're all somewhat different. Plus, there's "multisite" which is *.domain.com hosting subdomain sites. We don't want that.
Got a good How-To pointer? Please & Thanks?
*Sorry for co-opting the thread.I really need to make one. BUt that's not going to be a "this week" item as I'm in Costa Rica for my anniversary.
My team needs it too. I should be able to hand this stuff off to them easy peasy and I can't.
Happy anniversary. How many years?
Understood.
19 married, 21 together!
-
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
Workloads are multiple WordPress sites on one Ubuntu server OS (boy, what a lot of fun it is trying to get any documentation that gives a clear step-by-step ... just blew up the server for the umpteenth time now need to figure out what broke it as search sucks at this point for me) as well as Mastodon.
We'll be setting up some SFTP sites for clients once we get the WordPress sites online.It's not terrible, but yeah, there is a surprising lack of documentation on that. It's like the single most common Linux server task and it seems no one knows how to do it.
I can only imagine that there was a time when everyone knew how to do it and because of that, stopped teaching it, and now no one knows. But you need it constantly.
Wow, no kidding.
The number of "How to set up WordPress multiple sites on one VPS/Ubuntu Server" articles is crazy and they're all somewhat different. Plus, there's "multisite" which is *.domain.com hosting subdomain sites. We don't want that.
Got a good How-To pointer? Please & Thanks?
*Sorry for co-opting the thread.I really need to make one. BUt that's not going to be a "this week" item as I'm in Costa Rica for my anniversary.
My team needs it too. I should be able to hand this stuff off to them easy peasy and I can't.
Happy anniversary. How many years?
Understood.
19 married, 21 together!
Suweet. December is 20 for my wife and I. It's been an amazing ride. :0)
-
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
Workloads are multiple WordPress sites on one Ubuntu server OS (boy, what a lot of fun it is trying to get any documentation that gives a clear step-by-step ... just blew up the server for the umpteenth time now need to figure out what broke it as search sucks at this point for me) as well as Mastodon.
We'll be setting up some SFTP sites for clients once we get the WordPress sites online.It's not terrible, but yeah, there is a surprising lack of documentation on that. It's like the single most common Linux server task and it seems no one knows how to do it.
I can only imagine that there was a time when everyone knew how to do it and because of that, stopped teaching it, and now no one knows. But you need it constantly.
Wow, no kidding.
The number of "How to set up WordPress multiple sites on one VPS/Ubuntu Server" articles is crazy and they're all somewhat different. Plus, there's "multisite" which is *.domain.com hosting subdomain sites. We don't want that.
Got a good How-To pointer? Please & Thanks?
*Sorry for co-opting the thread.I really need to make one. BUt that's not going to be a "this week" item as I'm in Costa Rica for my anniversary.
My team needs it too. I should be able to hand this stuff off to them easy peasy and I can't.
Happy anniversary. How many years?
Understood.
19 married, 21 together!
Suweet. December is 20 for my wife and I. It's been an amazing ride. :0)
Cool, almost the same. Pre-emptive congrats to you as well.
-
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
Workloads are multiple WordPress sites on one Ubuntu server OS (boy, what a lot of fun it is trying to get any documentation that gives a clear step-by-step ... just blew up the server for the umpteenth time now need to figure out what broke it as search sucks at this point for me) as well as Mastodon.
We'll be setting up some SFTP sites for clients once we get the WordPress sites online.It's not terrible, but yeah, there is a surprising lack of documentation on that. It's like the single most common Linux server task and it seems no one knows how to do it.
I can only imagine that there was a time when everyone knew how to do it and because of that, stopped teaching it, and now no one knows. But you need it constantly.
Wow, no kidding.
The number of "How to set up WordPress multiple sites on one VPS/Ubuntu Server" articles is crazy and they're all somewhat different. Plus, there's "multisite" which is *.domain.com hosting subdomain sites. We don't want that.
Got a good How-To pointer? Please & Thanks?
*Sorry for co-opting the thread.I really need to make one. BUt that's not going to be a "this week" item as I'm in Costa Rica for my anniversary.
My team needs it too. I should be able to hand this stuff off to them easy peasy and I can't.
Happy anniversary. How many years?
Understood.
19 married, 21 together!
Suweet. December is 20 for my wife and I. It's been an amazing ride. :0)
Cool, almost the same. Pre-emptive congrats to you as well.
Ta.
Looking forward. Have lots of surprises for her.
-
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
@scottalanmiller said in Misc go-to FOSS options:
@PhlipElder said in Misc go-to FOSS options:
Workloads are multiple WordPress sites on one Ubuntu server OS (boy, what a lot of fun it is trying to get any documentation that gives a clear step-by-step ... just blew up the server for the umpteenth time now need to figure out what broke it as search sucks at this point for me) as well as Mastodon.
We'll be setting up some SFTP sites for clients once we get the WordPress sites online.It's not terrible, but yeah, there is a surprising lack of documentation on that. It's like the single most common Linux server task and it seems no one knows how to do it.
I can only imagine that there was a time when everyone knew how to do it and because of that, stopped teaching it, and now no one knows. But you need it constantly.
Wow, no kidding.
The number of "How to set up WordPress multiple sites on one VPS/Ubuntu Server" articles is crazy and they're all somewhat different. Plus, there's "multisite" which is *.domain.com hosting subdomain sites. We don't want that.
Got a good How-To pointer? Please & Thanks?
*Sorry for co-opting the thread.I really need to make one. BUt that's not going to be a "this week" item as I'm in Costa Rica for my anniversary.
My team needs it too. I should be able to hand this stuff off to them easy peasy and I can't.
Happy anniversary. How many years?
Understood.
19 married, 21 together!
Suweet. December is 20 for my wife and I. It's been an amazing ride. :0)
Cool, almost the same. Pre-emptive congrats to you as well.
Ta.
Looking forward. Have lots of surprises for her.
nice
