MySql 8.0.13

[andrew913]

Good to know; thank you

Are you in the UK? If so, what's the speed like?

Central USA, but they have datacenters across US and Europe. They'll set your account to the nearest server.
cloud.ionos.com/data-centers

Speed is great. I'm on their $12/mo plan on a shared server. Includes SSL certificate and a dedicated support rep.

One note: They have a Joomla installer that does weird things with folders and permissions. I always install manually for new sites.

[JAVesey]

Thank you - great info. Not considered them until now.

I’ll be doing a manual set-up from files and an database dump

[SForsgren]

I reached out to SiteGround today to complain again about mySQL 8 not being available. To my surprise, their ticket desk shows they are rolling it out now. Has anyone gone to mySQL 8 with Joomla on SG?

If they upgrade the db to mySQL 8 on a site already on J4, my understanding is that there should be no negative impacts and the site should still operate fine and also enable upgrading to J5.

Thoughts? Thanks!

[JAVesey]

If they upgrade the db to mySQL 8 on a site already on J4, my understanding is that there should be no negative impacts and the site should still operate fine and also enable upgrading to J5.

That is my understanding...

[Per Yngve Berg]

Will the features of Mysql 8 actually be used?

JSON is still saved in varchar columns.

I changed the "rules" column from varchar to JSON and got an error message when I tried to save invalid JSON.

[jtalbot]

The allure of enhanced performance and security with MySQL 8.0 is undeniable. However, the decision to mandate a minimum requirement of MySQL 8.0 for Joomla 5, despite Joomla 5 not utilizing any new features MySQL 8.0 offers, is a misstep that could hinder rather than propel progress.

Acknowledging that Joomla 5 functions seamlessly on MySQL 5.7 and recommending MySQL 8.0 for its advancements is a much more reasonable approach. Delaying the requirement bump to MySQL 8.0 until Joomla 6 would ensures a smoother transition to Joomla 5, preventing unnecessary disruptions to users and hosting providers.

By prematurely enforcing MySQL 8.0, Joomla is alienating users and creating unwarranted obstacles. This is driving individuals away from the platform altogether. It's imperative to exercise caution and ensure that requirements align with the majority of users' capabilities and infrastructure.

Fortunately, it's not too late to rectify this situation. Rolling back the requirement to MySQL 5.7 and recommending (instead of requiring) MySQL 8.0 would result in a higher adoption rate for Joomla 5. Failure to do so will see users cling to Joomla 4 beyond its end of support date or, worse, migrate to alternative CMS options.

[SForsgren]

Amen! Agree with you 100%.

[AMurray]

And additionally, I expect it's far easier for web hosts to update and offer varying PHP versions periodically rather than have to build new servers or whatever, to accommodate MySQL 8.

On the other hand, web hosts could also offer (shared) hosting options for MariaDB 10.4+ as part of their hosting product range.

[cropots]

I didn't know how difficult it was to find a host with this version available, even on dedicated servers. I bought an update for a component that I use in my systems, I made all the adjustments on Locahost using Wampserver and everything seemed fine.

When I tried to install it on an Online server, I had a tragic surprise when I found out that none of them supported MySQL 8.0.13 (which is the minimum required). I was really surprised to learn this, since the most widely used version was discontinued years ago. I searched for hours and hours and I couldn't find ANY host with this version available, at least not here in Brazil.

The most I found was MySQL 8, which probably won't work, or will it? I was really frustrated to learn this. I work hard to be able to buy my extensions and keep everything updated. It was an unprecedented blow to me. Maybe it was a lack of planning in not researching all this beforehand, but who can blame me?

A country the size of Brazil, with thousands of hosting companies, none of them support the most up-to-date MySQL, not even on dedicated servers. Probably only on PRO servers that cost much more per month than I can collect from my clients in the same period. I was even more frustrated to see that some people can run Joomla 5 on MySQL 5.7 without any problems (at least for now) using some "shortcuts".

So I ask, why take such a big leap and limit the user to having to hire very expensive plans simply to use a CMS? Now I understand why some companies that create extensions for Joomla, such as JoomlaWorks ( K2 ), have abandoned Joomla.

I am afraid of the future, I have been using Joomla for over 10 years, I have many clients who depend on my services, and now I am unable to continue because of this.

[abernyte]

Why are you limiting yourself to hosts in Brazil? The world is awash with good quality hosting across all continents.

[jtalbot]

Why are you limiting yourself to hosts in Brazil? The world is awash with good quality hosting across all continents.

Even if @cropots doesn't have a good reason to limit his quest for a host to Brazil, many (most?) of the most popular hosts in the US don't support MySql 8.x .

The real issue is this artificial requirement of MySQL 8.x. It is unnecessary and just slows down adoption of Joomla 5. MySQL 8.x should be recommended, with a minimum requirement of MySql 5.7

[gws]

Its called progress. The web changes constantly and you have to keep up.Just remember Joomla has a good reputation for security and the devs would like to keep it.

[Mr. Wimpy]

What version of MySQL 8?

There are other Databases available. So far the hosts I use, use MariaDB.
Minimum requirement for MariaDB is 10.4.

And +1 @gws

[jtalbot]

Its called progress. The web changes constantly and you have to keep up.Just remember Joomla has a good reputation for security and the devs would like to keep it.

Nobody will argue against progress and security. But will progress and security be enhanced if people stick with Joomla 4 because their host don't support MySQL 8?

[gws]

I would imagine any host worth his salary would have updated to mysql 8 and beyond before J4 is obsolete, if not it says all you need to know about your host. Changing host to one that is not stuck in the dark ages is so simple, there is even a joomla extension that automates it!

[sgiobbio]

for example: FastComet, Neoxea, HostArmada, Verpex...

[jtalbot]

I would imagine any host worth his salary would have updated to mysql 8 and beyond before J4 is obsolete, if not it says all you need to know about your host. Changing host to one that is not stuck in the dark ages is so simple, there is even a joomla extension that automates it!

The largest shared hosts in the US don't support MySQL 8+ . Sure, one might find a smaller provider that might support it; but the risk of using a smaller provider seems bigger than the risk of using MySQL 5.9 for a few more years. It's not like sites using MySQL 5.9 are getting hacked left and right.

Joomla version stats (https://developer.joomla.org/about/stats.html) don't seem to be working; If I'm right, they would show very small adoption of Joomla 5

[gws]

The largest shared hosts in the US don't support MySQL 8+

What can I say, for most of us we don't have that problem. You can choose a host anywhere you please,there is no advantage these days in hosting in the US even if your site is US based.

[cropots]

Why are you limiting yourself to hosts in Brazil? The world is awash with good quality hosting across all continents.

Well, your reality is certainly not everyone's, and I don't hire a server just because it has a certain type of function that I need at the moment. Quality support, customer service in the native language, and price are things that come first. It seems that many here who defend this approach of developers can't think straight about it. In case you didn't know, we are living in a crisis in Brazil where the dollar costs almost 6x our local currency, hiring an external server will be the end of my journey with Joomla, because in that case I would have to pay out of my own pocket to cover all of this. Not everyone can pay a fortune just to have their simple presentation site online. Unless you can recommend a hosting with the following requirements:

Unlimited sites
Unlimited disk
10 databases per installation
No inode count
Support in Brazilian Portuguese
7-day rotating backup

All this for 80 dollars per year (converted from local currency).

If you can find something like that and still have MySQL 8+ for only $80 per year, I would be happy to hire you.

I currently have about 50 clients and about 80 installations. Since it is a shared server, there are occasional slowdowns or downtimes, but nothing that cannot be resolved in a few hours. I always give clients the option of choosing a dedicated or shared server, and in 100% of cases they choose the shared one, and some of them have been using the service for over 5 years without any serious problems with Joomla 3 and 4.

As mentioned above, this version is not even popular on foreign servers, so I ask, why did adopt such an extreme measure? Show me some really valid points so that I can understand and don't just say "this is called progress" as said above, because that is very vague. It's not just MySQL 8 (which I could use) but yes MySQL 8.0.13/Minimum. What's the difference between these two versions that is so important that it prevent installation?

Everyone wants to have security on their systems, I think that's valid, but it seems to me that Joomla is really becoming an exclusive system for some users, and that's not good in the long run, unless these users who defend everything the developers do can pay for everything on their own.

[abernyte]

MySql 8 was released 6 years ago. It is not some bleeding edge innovation thrust upon us unexpectedly. Your hosting package is extraordinarily generous for so little cost....so I get why you don't want to change but change has happened. MySql 5.7 was EOL in October 2023, we can't stand still for ever.

[cropots]

MySql 8 was released 6 years ago. It is not some bleeding edge innovation thrust upon us unexpectedly. Your hosting package is extraordinarily generous for so little cost....so I get why you don't want to change but change has happened. MySql 5.7 was EOL in October 2023, we can't stand still for ever.

I understand your point of view, but as many people have already reported, this is not a popular version anywhere in the world and I really can't understand why, especially considering the time it was released.

PHP versions are always easier to update, and I can get any version on any server, but MySQL seems to work differently so few servers are willing to adopt it.

I found Hostinger that has MariaDB in one of their plans, but it has an inode counter that is something that will be completely exhausted with some Joomla installations.

[cropots]

I just sent my system created on Wampserver with MySQL 8.3 to an online server with MySQL 5.6 and it is working perfectly. Apparently, Joomla does not check the MySQL version if the files are sent manually. I have done dozens of tests on the sending and editing stress in the component I use and have not had any problems. This reinforces the theory of many people that this minimum required version of MySQL 8.0.13 is something completely unrealistic. I certainly will not use this technique on a client system, because I still do not know if I will really have future problems.

I am still waiting for someone who can really explain in technical terms why the minimum version 8.0.13 is needed.

I will continue with the tests to see how far it goes.

[Mr. Wimpy]

And now you will not be to update Joomla, because that again requires MySQL8+/MariaDB10.4+.

MySQL5.7 2015
MySQL5.7 End of support 2023
Joomla5 End of security support 2027
Meanwhile MySQL8.0 is supported until 2026 and MySQL8.4 until 2032.

This Joomla Magazine article details the reason for MySQL 8
https://magazine.joomla.org/all-issues/ ... equirement

[abernyte]

It's not just MySQL 8 (which I could use) but yes MySQL 8.0.13/Minimum. What's the difference between these two versions that is so important that it prevent installation?

MySQL 8.0.13 was released in September 2018 and introduced a security function of password verification on changing the account password so it seems an obvious version to place as a minimum.
There is another way to look at this. No one is forcing you to change any software. If you can only access suitable hosting in an affordable price band with EOL software then that is the qualified risk that you have to assess. Can you live with and support that degree of risk for the next 18 months to two years while you do what? Prepare to migrate to supported software? Hope that the host upgrades the server but not the price charged?
All the main CMS are mostly in the same place on this, you do need to change at some point.

[cropots]

Thanks for the answers, I will continue my search for a server that meets the minimum requirements. Coincidentally, my server provides PostgreSQL databases, but to the surprise of zero people, it is also outdated at version 9. They said that there is a migration taking place per client but I have not been included yet.

[gsmela]

The largest shared hosts in the US don't support MySQL 8+ . Sure, one might find a smaller provider that might support it; but the risk of using a smaller provider seems bigger than the risk of using MySQL 5.9 for a few more years. It's not like sites using MySQL 5.9 are getting hacked left and

Ah, I see SiteGround supporting MySQL 8,along with Hostinger and IONOS if looking at the largest hosting providers. AWS, Google, Hezner and others aren’t simply website hosting companies but they also are at the latest versions.

I think your premise is wrong.

[cropots]

The largest shared hosts in the US don't support MySQL 8+ . Sure, one might find a smaller provider that might support it; but the risk of using a smaller provider seems bigger than the risk of using MySQL 5.9 for a few more years. It's not like sites using MySQL 5.9 are getting hacked left and

Ah, I see SiteGround supporting MySQL 8,along with Hostinger and IONOS if looking at the largest hosting providers. AWS, Google, Hezner and others aren’t simply website hosting companies but they also are at the latest versions.

I think your premise is wrong.

Hostinger has an inode counter, which is a problem for Joomla unless you are just going to install a personal website. Ionos says it only has MySQL 5 and MariaDB 10. Could you send me a link to a server that has MySQL 8+? Ionos' prices are quite attractive.

[AMurray]

I find Scala Hosting more reasonable pricing (and scalable depending on your VPS configuration) and use MariaDB 10.6.x upwards. More than enough for J5 requirements.

Scala is also recommended by one of Joomla's founding members Brian Teeman (it was his recommendation video on the Extensions directory site that convinced me to move from my former host).

[cropots]

I just bought a plan from Hostinger, it works perfectly well. My idea was to use only the databases, and host the files on my old server, but the connection between servers got very bad, making it unfeasible to use. A single installation of Joomla + Jreviews already accounted for 40,000 inodes out of 400,000, basically a plan of 400,000 inodes will only serve one client. They advertise that you can install 100 sites, but only if they are 100 pure HTML sites.

[AMurray]

and Joomla 4 support ends next month (oct 2024) except for 12 months for critical security updates only - no bugfixes or feature additions.