Author: Markus Popp

db4free.net goes MySQL 8.0

MySQL 8.0 has been released as stable (GA) earlier this month. For db4free.net this means it’s time to make MySQL 8.0 the default version and to deprecate the MySQL 5.7 server instance.
The new MySQL 8.0 server is running on the default port 3306. All new registrations will have the database created on this server. It is fresh and empty and will start from scratch.
The previous MySQL 5.7 server will remain available on port 3308. All users who have data there which they want to keep should migrate it to the new MySQL 8.0 server. This will require you to sign up again.
The previous MySQL 8.0 server will remain on port 3307. Both the old MySQL 5.7 and the old MySQL 8.0 server on port 3307 will be available until June 15, 2018. Data which isn’t migrated to the new server instance by then will be lost.
The new MySQL 8.0 server instance will come with the new utf8mb4 character set and the new utf8mb4_0900_ai_ci collation, which are the new defaults in MySQL 8.0. Since db4free.net already used utf8mb4 on the previous MySQL 5.7 server instance, this should not affect many people, if any at all.
Another long overdue change is that the default timezone (on db4free.net, this is not a change in MySQL 8.0 itself) will be UTC. Previously the servers were set to Central European Time since that’s the home time zone where db4free.net is hosted. But with a large international audience it makes sense to use UTC going forward. The timezone can be changed per connection as described in the MySQL Reference Manual.
The MySQL 8.0 Reference Manual is the place to go for all general MySQL questions and to find out what’s new in MySQL 8.0 (which are a lot of things).
As always: please backup data which you can’t afford to lose. db4free.net is a testing service and there is always a risk that something goes wrong, like the server doesn’t start up anymore. This has happened before and may happen again, especially with a brand new version. This service comes with no warranties at all.
If you keep that in mind you should have much fun exploring the new (and old) goodies of MySQL 8.0. Consider following db4free.net on Twitter as this is where you get updates and status information the quickest.
Enjoy!

db4free.net and MySQL 8.0

db4free.net was born in 2005 (which makes it older than Twitter or Google Chrome) when MySQL 5.0 was in early development. 11 years went by but one thing always remained the same: the 5 in MySQL’s major version number. MySQL versions went from 5.0 to 5.1 to 5.5, 5.6 and recently to 5.7. There was always this 5.something.
While this 5 will stay around for a bit longer, it is not alone anymore.
Now there is a duplicate of the db4free.net website at
https://mysql8.db4free.net
where you can create a database on a newly set up MySQL 8.0 server!
MySQL 8.0 is in very early development, the first Development Milestone Release (MySQL 8.0.0 DMR) has just been released on September, 12. It will take several months until there will be a final release.
db4free.net makes it easy to try new features early. The MySQL 8.0 Reference Manual is a good entry point, especially the section What Is New in MySQL 8.0.
While the MySQL 5.7 server keeps running unchanged, the new MySQL 8.0 server will run on port 3307. Make sure to address the correct server in your client. Maybe there is a separate field to set the port, or you may have to change the host name to db4free.net:3307. Of course you can also use phpMyAdmin at https://mysql8.db4free.net which will give you access to the MySQL 8.0 server (while phpMyadmin at https://www.db4free.net will still connect you to the MySQL 5.7 server).
Speaking of clients, please keep in mind that clients may not be fully ready for MySQL 8.0 yet and there may be a problem here and there. This is part of testing a new version in early development.
The mysql8.db4free.net website with black-orange header is mostly a duplicate of the www.db4free.net website with black-blue header. The only major difference is that mysql8.db4free.net manages databases on the MySQL 8.0 server whereas www.db4free.net manages databases on the MySQL 5.7 server. Accounts created on either site do not affect the other site, so they are completely separate. If you want a MySQL 5.7 database as well as a MySQL 8.0 database you need to register on both sites.
Have fun and enjoy!
A word on Bitcoins
db4free.net now accepts donations in Bitcoins. Donations in traditional currencies are also supported via PayPal.

db4free.net offering MySQL 5.7

db4free.net finally runs MySQL 5.7 which was released on October 21.
Rather than upgrading the existing MySQL server I set up a new MySQL 5.7 server. This is cleaner and it helps to get rid of accounts which are no longer used.
For active users, the MySQL 5.6 server will stay online
until January 15, 2016.
You can access it on port 3307 (the new MySQL 5.7 server will again run on MySQL’s default port 3306).
Users who want to keep their data need to migrate it to the new server:

create a backup of your data on the MySQL 5.6 server
signup for a new db4free.net account
restore your backup in the new MySQL 5.7 server

If you use the MySQL default client and mysqldump, it goes like this (commands in one line):

mysqldump -h db4free.net -P 3307 -u [username] -p[password] –database [databasename] –opt > backup.sql

(remember to create the new account)

mysql -h db4free.net -u [new_username] -p[new_password] [new_databasename] < backup.sql

You can also use phpMyAdmin (there are now 2 login boxes) or MySQL Workbench or any other client software which does the job.
Please remember: db4free.net is a testing service. Data loss can happen any time!
The primary reason why not data loss occurred in the last 2 years (how time flies!) are the many stability and bug fix updates that MySQL 5.6 received over time (current version is 5.6.27).
There were some problems while MySQL 5.6 was young though!
With MySQL 5.7 being a new major release (current version is 5.7.9), the risk of data loss and outages will again be higher. Please take this into account (backups, backups, backups!). It’s the price for the shiny new features.
Since db4free.net is a testing service, this shouldn’t be a problem for you. If it is a problem, db4free.net is probably not the right service for you.
Have fun and enjoy!

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569