Perhaps blues name database should be carried over to green?

[DMN]

Short term we have no impostors, and long term no issue if the server is later merged with blue.

[Octopath]

Agreed

[DMN]

Hopefully they can actually do it. They might not be able to. Ideally the servers should share the same name database so we can make it future-proof, too.

[loramin]

Originally Posted by DMN [You must be logged in to view images. Log in or Register.]

Hopefully they can actually do it. They might not be able to. Ideally the servers should share the same name database so we can make it future-proof, too.

Servers share databases all the time (in fact, the standard setup on any sufficiently advanced site is to have your database on a completely separate server from your application server, and then have multiple application servers since you tend to need to scale them up faster than you need to scale database capacity).

So while I know nothing about P99's setup, I'd be amazed if there was any technical reason preventing it. But whether this is actually the staff's vision for Green is an entirely separate question.

[Izmael]

Originally Posted by loramin [You must be logged in to view images. Log in or Register.]

Servers share databases all the time (in fact, the standard setup on any sufficiently advanced site is to have your database on a completely separate server from your application server, and then have multiple application servers since you tend to need to scale them up faster than you need to scale database capacity).

So while I know nothing about P99's setup, I'd be amazed if there was any technical reason preventing it. But whether this is actually the staff's vision for Green is an entirely separate question.

Red and Blue don't seem to share their databases. Most likely Green won't share its database with anything else, either.

I'm not even sure sharing databases or even just tables between servers is even that practical. EQEmu uses MySQL and there must be some amount of locking going on, most likely not meant to be shared between servers at all.

[loramin]

Originally Posted by Izmael [You must be logged in to view images. Log in or Register.]

Red and Blue don't seem to share their databases. Most likely Green won't share its database with anything else, either.

I'm not even sure sharing databases or even just tables between servers is even that practical. EQEmu uses MySQL and there must be some amount of locking going on, most likely not meant to be shared between servers at all.

Again, I can't speak to P99's specific setup, but what I can say is sharing databases (and every table in them) between multiple other servers is extremely practical, whether it's with MySQL, PostgreSQL, or any other database (even NoSQL ones like MongoDB).

Again, the standard setup for any small to medium sized website you visit (ie. not gianormous ones like Google or Amazon) is:

• multiple application servers (the servers running your app's logic ... the equivalent of Blue, Red, and Green)
• multiple web servers (servers that just serve static files like images and HTML)
• some load balancers to distribute the traffic between them
• a single database server

Crucially, you want to avoid having multiple DB servers as long as possible, because multiple DB servers are a giant PITA (you noted "locking" issues; multiple DB servers have much more of that kind of problem). Even that's doable though (there are ways to split DBs between multiple servers), it's just a hassle you want to avoid as long as you can.

So again, all the major (but not super-major) websites you visit work by sharing a single database server (quite possibly with a MySQL database) between multiple application servers ... unless of course they're so small they only have a single app server. Speaking in generalities, there's no technical reason why P99 can't do the same.

[fadetree]

Originally Posted by Izmael [You must be logged in to view images. Log in or Register.]

Red and Blue don't seem to share their databases. Most likely Green won't share its database with anything else, either.

I'm not even sure sharing databases or even just tables between servers is even that practical. EQEmu uses MySQL and there must be some amount of locking going on, most likely not meant to be shared between servers at all.

You can't share a single EQ db between servers. It's all one thing, and the names are part of the table structures, so you can't share just the name tables. Shared DB's are certainly a thing in the world, but not by EQ.

[loramin]

Originally Posted by fadetree [You must be logged in to view images. Log in or Register.]

You can't share an EQ db between servers. It's all one thing, and the names are part of the table structures.

It's not "all one thing". By default yes EQ Emulator runs on the same machine as the database. However, you can absolutely configure a separate DB server:

<database>
<host>localhost</host>
<port>3306</port>
<username>un</username>
<password>pw</password>
<db>peq</db>
</database>

Now of course the EQ Emulator software undoubtedly isn't designed to check a separate server out of the box, but again technically there is absolutely no reason why it can't: all it requires is a bit of custom code.

And again, writing custom code to check a database on another server isn't just "not hard" it's "standard operating procedure". The staff here has made massive custom changes to the default EQ Emulator software; I just can't imagine it would be very difficult for them to tweak the software so that the name checking parts use a different DB than the rest.

[indiscriminate_hater]

no way, I need to squat on as many names as possible when green drops

[Halox]

Blue needs to purge names badly. There are tens of thousands of lvl 1 names in reserve that need to be freed.