Help to sync shop within cluster

Messages
3
Likes
0
Points
1
Hi guys. I am working on setting up a cluster of servers on my physical server. However i am struggling to figure out how to configure it so the shop files would sync within clusters. I have tried mysql but just cant figure that one out, even the basic use of it (never used one), tried few sync programs, tried sharing the folders via network, as well as setting up work folders and just nothing seem to do it (maybe i am doing it all wrong). Any help would be much appreciated.
 
Advertisement

Official Game Server Partner

WETBATMAN

Active member
Plugin Developer
Donators
Messages
186
Likes
49
Points
28
Website
dopeark.com
you need to use MySQL

https://dev.mysql.com/downloads/mysql/ (Grab it From here)
and select c++ connector MySQL server 64bit and workbench x86

install it with legacy authentication then create a schema in the workbench corresponding to the name of the schema you have in your plugin config

afterward, connect your plugin to the MySQL server and it will auto create the tables :)
 
Messages
3
Likes
0
Points
1
Thank you sooo much. I will give it a go tonight. Fingers crossed, as I'm at my wicks end 😅 how hard can it be ehh? 😬 Only spent like past two days trying to figure it out 🙈
 

KatKilmowski

Member
Donators
Messages
75
Likes
6
Points
8
WETBATMAN#0288 or Kluster,

I downloaded the windows msi installer. It's asking which setup type:
Developer Default
Server Only
Client Only
Full
Custom.

If I use the Developer Default, it says it has failing requirements at:
MySQL for Visual Studio
Connector/Python

What setup type should I select?

Thanks!
 
Last edited:

DoC

Banned
Messages
73
Likes
12
Points
8
If i have different items in some servers like i have green to red gems in ab shop but not in island. If i sync up the shops will it still work or do all shops have to have the same items?
 

Haragon

Member
Plugin Developer
Donators
Messages
55
Likes
8
Points
8
If i have different items in some servers like i have green to red gems in ab shop but not in island. If i sync up the shops will it still work or do all shops have to have the same items?
Only the points and kits are stored in the DB, so you can have a different catalog per server. For kits, I believe they will have a QTY in the database but if its not in the config they can't buy it. That would require some testing to be certain that it wont cause a crash though.
 

DoC

Banned
Messages
73
Likes
12
Points
8
Does the MySQL database get auto populated with the information contained within the sqlite DB? Or do I have to manually move everything over?
 

WETBATMAN

Active member
Plugin Developer
Donators
Messages
186
Likes
49
Points
28
Website
dopeark.com
Does the MySQL database get auto populated with the information contained within the sqlite DB? Or do I have to manually move everything over?
you need to convert your database from sqlite to mysql

WETBATMAN#0288

add me on discord if you require further help
 
Messages
19
Likes
2
Points
3
you need to use MySQL

https://dev.mysql.com/downloads/mysql/ (Grab it From here)
and select c++ connector MySQL server 64bit and workbench x86

install it with legacy authentication then create a schema in the workbench corresponding to the name of the schema you have in your plugin config

afterward, connect your plugin to the MySQL server and it will auto create the tables :)

Bro you would be awesome if you would make a quick tutorial for someone who just opened MySQL for the first time and only wanted to add their shop to the database for a cluster server :D
 

bomhazmat

New member
Messages
1
Likes
0
Points
1
Yea a tutorial would be awesome lol. I looked everywhere for help on this and cant find anything. I have never even messed with mysql but would like to set things up for points to continue to my other servers on cluster. i hope its ok WETBATMAN i added you on discord. I clicked on the link https://dev.mysql.com/downloads/mysql/ and it took me to community server but i saw connector i downloaded and installed c++ connector and the workbench x86 but lost from there.
 

Skynet

New member
Messages
4
Likes
1
Points
3
Bro you would be awesome if you would make a quick tutorial for someone who just opened MySQL for the first time and only wanted to add their shop to the database for a cluster server :D
This would be extremely nice because I have installed it but I have no clue how to connect a database or even what a schema is.
 

Skynet

New member
Messages
4
Likes
1
Points
3
you need to use MySQL

https://dev.mysql.com/downloads/mysql/ (Grab it From here)
and select c++ connector MySQL server 64bit and workbench x86

install it with legacy authentication then create a schema in the workbench corresponding to the name of the schema you have in your plugin config

afterward, connect your plugin to the MySQL server and it will auto create the tables :)
How do you connect your plugins to the schema?
 
Top