Future of the Forum
#1
Future of the Forum
As we draw closer to an anticipated release of MyBB 1.9 I need to ask the questions:

1. Is there anyone in the community with web dev experience who would be willing to help design a new theme? 

The 1.9.x system is going to completely redo the theme engine, so our theme currently won't be portable. 

I cannot afford nor do I trust developers out there to not half-ass the job, so I was curious if we have any web dev guys here.

2. If you're interested, do you have experience with Twig? 

Twig is the engine they're using for theming for MyBB 1.9

3. Can you do a postgres migration?

I want to get us off MariaDB entirely because MariaDB is becoming difficult to backup. The database is less than 50M, but I do not have the expertise to do a postgres migration.

Payment isn't entirely out of the question, but I'm not exactly made of money so I couldn't do a 4 figure deal in all likelihood. 

The forum's 1.8.x branch is likely to be supported to some degree after MyBB 1.9 is released, but I would not like to wait for a last minute failure and risk us gettin hacked. 

Thanks for reading.


Raion
Operator
*******

Posts: 581
Threads: 113
Joined: Nov 2017
Website Find Reply
06-12-2019, 09:55 PM
#2
RE: Future of the Forum
I can help out on the DB side.

Octane2 2x R14k 600MHz|2GB|V10|6.5.30
Octane2 1x R12k 400MHz|1GB|V8|6.5.30
pcar
O2

Posts: 14
Threads: 0
Joined: Mar 2019
Find Reply
06-13-2019, 01:42 AM
#3
RE: Future of the Forum
(06-12-2019, 09:55 PM)Raion Wrote:  I want to get us off MariaDB entirely because MariaDB is becoming difficult to backup. 
Curious as to the specifics of this problem is. (Not trying to question it just wanted some details for my own information)
-Mike
[For those who don't php TWIG is template engine, i've only worked with it once and it is .. ok .. ]
mgtremaine
O2

Posts: 26
Threads: 4
Joined: May 2018
Find Reply
06-13-2019, 01:27 PM
#4
RE: Future of the Forum
(06-13-2019, 01:27 PM)mgtremaine Wrote:  Curious as to the specifics of this problem is. (Not trying to question it just wanted some details for my own information)
-Mike
[For those who don't php TWIG is template engine, i've only worked with it once and it is .. ok .. ]

Sure thing dude, I have no issue talking about it:

Postgres allows something called write-ahead log archiving, which means, you can have it set the write-ahead log up to act as a backup solution. From there, all you need to do is have a grab cron that copies the data to our backup machines. With MySQL/MariaDB, you have to cron a script that dumps the data, another that scp's the data, and another that rotates the backups out. This is a huge expense in time, development and bugtesting for obvious reasons. I'd rather not deal with that more than we have to.

Postgres seems to be a better app for scalability as well. I've been coding a bit in it, and while I'm not a full-time dev nor do i ever desire to code for a living, it's a pretty neat little technology.


Raion
Operator
*******

Posts: 581
Threads: 113
Joined: Nov 2017
Website Find Reply
06-13-2019, 09:45 PM
#5
RE: Future of the Forum
Interesting... I just read up on Postgres WAL vs Mysql Binary Logs and replication strategies. It does seem the WAL format is both fast easy to restore from directly.

(I will admit to just copying myisam raw files directly with rsync after flushing the buffers as backup on lower traffic applications, there is some risk of data loss but for better or worse I never ran into a problem with it, although I only had to reach for the files a few times in the decades across 10 or instances. One time an IT directory was being helpful and deleted a bunch of "cruft" out of the mysql data directories.. DOH! please stop)

-Mike
mgtremaine
O2

Posts: 26
Threads: 4
Joined: May 2018
Find Reply
06-14-2019, 02:13 PM
#6
RE: Future of the Forum
We use InnoDB on MariaDB to get full unicode and fulltext search support. Without it, half of the forum functionality would be broken. Hence, I'd rather avoid that limitation as innodb raw files are a pain in the ass to recover without ib_log or ibdata files.


Raion
Operator
*******

Posts: 581
Threads: 113
Joined: Nov 2017
Website Find Reply
06-15-2019, 06:39 PM


Forum Jump:


Users browsing this thread: 1 Guest(s)