Simple programming question.

[deep1234]

Hello guys.

 

Let say I have a two Ubuntu Linux servers. One is the database and the second is WordPress (PHP). Suppose that I know lets say Python. Can I make a new server and connect to the same database and do some work on it without effecting the WordPress?

 

Thanks, 

[+Majesticmerc MVC]

I think it depends on what you want to do. If you want to edit the WordPress database directly, you may end up impacting your WordPress by changing data. If you create a second database on the database server, the databases won't interfere with each other.

[DevTech]

  On 01/05/2018 at 09:57, deep1234 said:

Hello guys.

 

Let say I have a two Ubuntu Linux servers. One is the database and the second is WordPress (PHP). Suppose that I know lets say Python. Can I make a new server and connect to the same database and do some work on it without effecting the WordPress?

 

Thanks, 

Expand  

 

If you have control of the 3 servers, you can do anything you want. You can install a variety of OSS DB software such as Neo4j, Apache Giraph, Apache Ignite, Maria DB, Cassandra, CarbonData, Apache Arrow, InfluxDB, Presto DB, Vitess, etc etc

 

At the opposite end, if you are using some sort of hosting plan with one free database plan provided then you may not even be able to make a separate database within the typical cheapo MySQL hosting plan usually included. In that case you need to make new SQL Tables with names that won't conflict with Wordpress.

 

Other side effects would be performance issues if your servers  have any real world usage load.

 

FWIW, nobody designs software applications around servers anymore - find hosting that is  based on Docker Containers for fine grained control, and there is even a growing trend to Serverless Architectures, for example OpenFAAS

[Shiranui]

As long as you know the difference between a database and a table, you should have no problems.