Conversation:
Notices
-
@aroque Yes, I expect my !GNUsocial instance at http://status.hackerposse.com/url/9394 to be revived. Real Soon Now. My apologies to you and the entire !Fediverse -- I'm in the process of resurrecting my database, the unfortunate victim of power failures, dead UPS batteries, a dead motherboard, a power supply with all the smoke escaped, and a drive that died while restoring from …
-
@bobjonkman2 Well I had no problems with drop-in replacing MySQL with MariaDB. What kind of issue did you experience?
-
@aroque Yeah, this will happen (not retroactively though) when we start storing incoming activities that we currently throw away ("follow" and "join" with their respective anti counterparts).
-
@aroque hmmm, maybe not group stuff though... Hm...
-
@mmn I did a *literal* drop-in -- took the MySQL files from /var/lib/mysql from the dead server and put them in /var/lib/mysql on the new server running MariaDB. Most DBs can still be read, but most of those can't be updated. Only one or two DBs are fully functional. Affects !GNUsocial, WordPress, MediaWiki...
-
MySQL usually has scripts that will fix changes between versions. I've needed to run 'mysql_upgrade' to fix DBs moved from 5.0 to 5.1
-
I imagine MariaDB might have similar scripts.. You might also start the DB manually from the command line to look for errors.
-
I did see some MariaDB errors; consensus on the Internets was that I should create empty DBs in MariaDB then import the MySQL tables. That almost worked -- sadly, my most recent backup got trashed in the drive crash during the restore. An earlier backup was done with `mysqldump --all-databases` resulting in a 45 GByte .sql file that has a logical error about 3/4 way through (noth…
-
I would really like to see that !Groups are distributed across the !Fediverse. For example, if I create a !selfhost group on my instance, and then you create a !selfhost group on your instance, they would really be replicated instances of the same !selfhost group. That would provide resilience when my group becomes unavailable, and solves the problem of separate groups on differe…
-
That's amazing. My compressed backups are about 100 megs. That's just StatusNet, though.
-
Agreed, there are logistics to be worked out. Some can be solved technically, some need to be solved socially. I think the !Fediverse is up to the challenge.
-
The 45 GByte .sql file is uncompressed, and contains all the databases in MySQL (now MariaDB). That's two !GNUsocial instances, 8 WordPress installations, my ownCloud DB (with at least four users), one Drupal install, one WikiMedia, a brdcst DB that I never got to work, something for PHPMyAdmin, and a handful of MySQL housekeeping DBs.
-
That's a lot of stuff. I used ownCloud for home folder backup at my last job and loved it. Might get that running at home too.
-
I've used replication to keep MySQL servers backed up in the past. You need another server of course, but it's nice to have a backup server
Bob Jonkman
MMN-o ✅⃠
Jeff Ratliff
All Hacker Poesy content and data are available under the