Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Apr 22, 2018 17:49:01 GMT
CoreProtect stores block information [for this server] in an individual [non-hierarchical] file (known as a flatfile) - 'database.db' - which is located in this server's 'plugins' directory, under CoreProtect; and while this solution is adequate for many servers (where block placements are logged under moderation, and the need to actuate this data is much lesser), TotalFreedom is plagued by the consequences of storing CP information [in this fashion]: slow restoration, the inability to quickly view logs, along with 'hogged' databases (I'm sure every administrator has encountered this: the database is busy... please try again later). For larger servers (such as TotalFreedom), CoreProtect reserves the ability to utilise a SQL database [in comparison to the current 'database file']; in application, administrators would be expected to witness quicker restorations using the plugin - alongside a significant reduction in database-related issues. Since we're now using a VPS (virtual private server), there should be no problem with making the switch to SQL; therefore, that is what I suggest. For more information regarding how one may do this with CoreProtect, I refer you to this article and this thread (both are external, so see excerpt below): |
|
Video
Forum Admin 
An op's rights activist
Posts: 5,585
| Likes: 5,894
IGN: VideoGameSmash12, videogamesm12
Old IGN: https://namemc.com/profile/VideoGameSmash12.2, https://namemc.com/profile/videogamesm12.1
Discord: Video#9801
Birthdate (MM/DD): 07/16
Timezone: UTC-07:00
Member is Staff. Need immediate assistance? Send a PM
|
Post by Video on Apr 22, 2018 17:51:35 GMT
Vouch.
|
|
|
|
Post by Darth Windu on Apr 22, 2018 17:52:42 GMT
Vouch
|
|
? Shyrix ?
Veteran Member
00111010 01011110 00101001 00001010
Posts: 1,567
| Likes: 645
|
Post by ? Shyrix ? on Apr 22, 2018 17:53:32 GMT
Vouch.
|
|
Lemon
Veteran Member
Insert status here.
Posts: 2,491
| Likes: 2,165
|
Post by Lemon on Apr 22, 2018 18:19:41 GMT
Vouch
|
|
StevenNL2000
Forum Admin
Posts: 6,415
| Likes: 6,936
IGN: StevenNL2000
Timezone: UTC+01:00
Member is Staff. Need immediate assistance? Send a PM
|
Post by StevenNL2000 on Apr 22, 2018 18:46:03 GMT
Why would accessing a database file through a locally hosted MySQL server be any more efficient than accessing it directly?
|
|
Cowgomooo12
Club 4000 Member
Vaarwel, afscheid
Posts: 4,894
| Likes: 5,266
|
Post by Cowgomooo12 on Apr 22, 2018 19:47:27 GMT
Why would accessing a database file through a locally hosted MySQL server be any more efficient than accessing it directly? "High Concurrency" and potentially "Very large datasets" Also, "If file locking does not work correctly, two or more clients might try to modify the same part of the same database at the same time, resulting in corruption" -- if you are simultaneously write data, it should queue. However, from time to time, it does not which will result in database corruption. Corruption for our server is not that big of an ordeal because we purge our maps frequently. However, this is not an issue with a standard MySQL database. In my honest opinion, the differences are very unlikely to be noticed. However, there is no downside that I can think of. |
|
mattlawn
Veteran Member
back
Posts: 1,488
| Likes: 490
|
Post by mattlawn on Apr 22, 2018 22:12:25 GMT
vouch
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Apr 22, 2018 23:06:00 GMT
I vouch. I don't think there will be that much of a difference but there isn't a downside (except for waiting 8 months for Windows to set it up)
|
|
kunochan
Veteran Member
Posts: 407
| Likes: 123
|
Post by kunochan on Apr 22, 2018 23:49:57 GMT
Vouch.
|
|
_Windows
Club 4000 Member
Posts: 7,881
| Likes: 9,611
|
Post by _Windows on Apr 23, 2018 0:56:05 GMT
I'll look into it. It shouldn't take very long, but I'd rather use MariaDB than MySQL (I'd really rather not depend on Oracle given the nature of that company).
|
|
Lemon
Veteran Member
Insert status here.
Posts: 2,491
| Likes: 2,165
|
Post by Lemon on Apr 23, 2018 2:27:43 GMT
Why would accessing a database file through a locally hosted MySQL server be any more efficient than accessing it directly? "High Concurrency" and potentially "Very large datasets" Also, "If file locking does not work correctly, two or more clients might try to modify the same part of the same database at the same time, resulting in corruption" -- if you are simultaneously write data, it should queue. However, from time to time, it does not which will result in database corruption. Corruption for our server is not that big of an ordeal because we purge our maps frequently. However, this is not an issue with a standard MySQL database. In my honest opinion, the differences are very unlikely to be noticed. However, there is no downside that I can think of. The upside is that it gets rid of the database is busy errors. |
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Apr 23, 2018 3:30:53 GMT
www.sqlite.org/whentouse.html"High Concurrency" and potentially "Very large datasets" Also, "If file locking does not work correctly, two or more clients might try to modify the same part of the same database at the same time, resulting in corruption" -- if you are simultaneously write data, it should queue. However, from time to time, it does not which will result in database corruption. Corruption for our server is not that big of an ordeal because we purge our maps frequently. However, this is not an issue with a standard MySQL database. In my honest opinion, the differences are very unlikely to be noticed. However, there is no downside that I can think of. The upside is that it gets rid of the database is busy errors. Then I totally think we should set it up then |
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Jun 26, 2018 19:01:48 GMT
Bump. The correlation between any lack of implementation [of this suggestion] and prominent issues afflicting administration are still very relevant; none of what I have stated, or proposed, has been taken into account. ...but I'd rather use MariaDB than MySQL (I'd really rather not depend on Oracle given the nature of that company). I'd much rather depend on Oracle than hinder the ability of our administrators to effectively fix people's content. |
|
Video
Forum Admin
An op's rights activist
Posts: 5,585
| Likes: 5,894
IGN: VideoGameSmash12, videogamesm12
Old IGN: https://namemc.com/profile/VideoGameSmash12.2, https://namemc.com/profile/videogamesm12.1
Discord: Video#9801
Birthdate (MM/DD): 07/16
Timezone: UTC-07:00
Member is Staff. Need immediate assistance? Send a PM
|
Post by Video on Jun 26, 2018 19:37:43 GMT
hinder the ability of our administrators to effectively fix people's content This has happened on occasions where I needed to roll back a grief to someone's builds and couldn't use /co rb because it kept throwing that "Database busy" error. This happens often during a moderately busy day too, meaning that while it may not be a huge problem if the server is barely populated and nothing is going on, it is a massive problem when a bunch of players are on (maybe around 25-30) and the server is getting chaotic. I can't do my job as an admin during these times because of a problem that isn't even my fault but is the fault with how CoreProtect set up. |
|
