We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Is Oxwall dependable for 1 million community? | Forum

Exclusive
Exclusive Jan 2
Separating Webserver and Database is trivial and not an issue at all for ANY and ALL PHP frameworks.

For Oxwall, you literally just point the DB to the right server address, where your DB information goes in:
ow_includes/config.php

This is how my setup runs on AWS...
You run the server on EC2 and the DB runs on a separate RDS instance.

Security is a different matter entirely, you must ensure the web server is the only system that is able to communicate with the DB on any network.


The benefits are obvious, if your web server doesn't run your DB also you'll have better performance and more resources available for PHP, but this all depends on network latency between server and DB server.

The Forum post is edited by Exclusive Jan 2
Patricia Zorrilla Bcn

Definitely Oxwall DOES NOT work for a community of so many members.

Mine, 5 years old and 10,000 members is continually stuck.

Every day I delete inactive members because there are many new ones every day, hundreds of photos to which no record points in any table and nobody knows how to say where they come from, plugins that do not work with more than 2,000 members, for example https://developers.oxwall.com/store/item/1418 and https://developers.oxwall.com/store/item/1373, slowdown due to continuous access to notification tables, friendships and messages ...

Each plugin author defends only the yours, or do not answer or blame others. For example, each failed photo upload leaves you orphaned tmp*.jpg files that you have to delete manually.

But I have not found a better software than OxWall and it is important to say that it is not how many members you have, but how active they are.

All my experience deleting garbage from other plugins I am turning it into a cleaner plugin, I hope to finish it and put it in store soon. My first plugin will be cheap, it will have good support, it will be signed by me and not by a new user who hides in anonymity to sell and disappear.

Exclusive
Exclusive Jan 2
Sounds good, Oxwall does need a good cleaning plugin that can also check and fix permissions and ownership issues as well.

Another issue is plugins adding insecure elements which break SSL/TLS, ie using http instead of https.


If someone wants to make some Donations towards the cause, I'll start contributing to Oxwall Base and Security.

The Forum post is edited by Exclusive Jan 3
OW-Ghost
OW-Ghost Jan 3
there is many plugin databases that need bee cleaned up after 1 year of use. this is because many plugin developer not care to include such features when they develop a new plugin. you need manualy look inside every plugin for find databases that have a lot of saved garbage data and that takes alot of time for a admin to do


very intresting to setup database on another server ....but what happens when the connection between both servers are bad? i can imagine that would make the site very slow to handle.

I think both servers need bee very close to each other for make no connection problems
Quote from ViXiV Technologies Sounds good, Oxwall does need a good cleaning plugin that can also check and fix permissions and ownership issues as well.

Another issue is plugins adding insecure elements which break SSL/TLS, ie using http instead of https.


If someone wants to make some Donations towards the cause, I'll start contributing to Oxwall Base and Security.


The Forum post is edited by OW-Ghost Jan 3
Exclusive
Exclusive Jan 3
Yes, an in house network is usually utilized with the servers being in close proximity and on a super fast network.


AWS setup between EC2 (server) and RDS (DB) is extremely fast with no issues at all.


In regards to DB and Oxwall file cleaning...


Any and All sites eventually need a DB Admin who manages the database, cleans it and optimizes the DB performance.


Same goes for Server and files...


Sites must start utilizing Admin's, Developers and Engineers for these sort of issues. This is how company and basically all corporate environments operate. You can't expect to just set it and forget it with websites. Programming is an art and humans aren't perfect, we forget things and make mistakes. This bleeds into our work in all sorts of manner in the form of bugs and mess to clean up sometimes.

The Forum post is edited by Exclusive Jan 3
OW-Ghost
OW-Ghost Jan 4
<<<<<<AWS setup between EC2 (server) and RDS (DB) is extremely fast with no issues at all.<<<<<


there is no guide how to install a oxwall software on a aws cloud server same with database on a RDS.


I think many included me would bee very much happy to get such step by step guide.


i think AWS have some type of config files that can use. if you import the config file the server is configed and optimazed for a oxwall software. if i remember correct i did find such very old AWS config file for oxwall, but i not sure how trustful ....it need fit all type of oxwall sites


a complete guide would bee nice on this oxwall forum for they who want to use AWS and a seperate server RDS and optimaze steps...


i think i ask for that 2 or 3 years ago but no one was interested post such detailed guide



make a plugin guide and sell it,,,,because i understand it takes alot of time do a detailed guide


i think if it can boost your website speed and save money then such guide would sell


not everyone is server experts..

The Forum post is edited by OW-Ghost Jan 4
sandeep
sandeep Jan 4
Here is the link, on how to install

https://developers.oxwall.com/forum/topic/63162?page=1#post-233629

OW-Ghost
OW-Ghost Jan 4

Quote from sandeep Here is the link, on how to install

https://developers.oxwall.com/forum/topic/63162?page=1#post-233629

i never heard about alibaba cloud 


i try to find what country they company alibaba cloud are from, but did not find? 


for me alibaba sounds like arabian business but i can bee wrong and there was some strange site named alibaba but maybe they have no connections...


Ow-ghost

The Forum post is edited by OW-Ghost Jan 4
Exclusive
Exclusive Jan 4
RDS is transparent to Oxwall, so you just have to setup your EC2 and RDS instances and then configure Oxwall (on EC2) to connect to the RDS Database endpoint just like you would for any other database in Oxwall's config.php


I already have a tutorial on a Secure EC2 Setup and will create one for RDS soon:

https://www.vixiv.net/index.php/2018/07/setup-ec2-securely/10/


EC2 is just a VPC web server + added security and optimizations

RDS is just a database server + added security and optimizations


You securely connect them through a shared Security Group so only the EC2 VPC server can communicate with the RDS DB instance.


Once your security group is in place, your RDS endpoint will instantly be accessible from your EC2 instance.


The only thing is the EC2 and RDS should be in the same region, availability zone and subnet for configuration simplicity.

The Forum post is edited by Exclusive Jan 4
OW-Ghost
OW-Ghost Jan 5
I was try the url you was post but the page was missing or temporary down?


A guide how to Install oxwall software and add security and optimizations on a EC2 and a RDS would bee awsome. And there shuld bee screen shots that explains.


I think if you have great skills in servers you can optimization the oxwall software with different servers add on so it runs 10 times faster then a traditional standard server.


I looking forward to a complete guide for this , then i will maybe try move my 2 sites to a EC2 and a RDS



Quote from ViXiV Technologies RDS is transparent to Oxwall, so you just have to setup your EC2 and RDS instances and then configure Oxwall (on EC2) to connect to the RDS Database endpoint just like you would for any other database in Oxwall's config.php


I already have a tutorial on a Secure EC2 Setup and will create one for RDS soon:

https://www.vixiv.net/index.php/2018/07/setup-ec2-securely/10/


EC2 is just a VPC web server + added security and optimizations

RDS is just a database server + added security and optimizations


You securely connect them through a shared Security Group so only the EC2 VPC server can communicate with the RDS DB instance.


Once your security group is in place, your RDS endpoint will instantly be accessible from your EC2 instance.


The only thing is the EC2 and RDS should be in the same region, availability zone and subnet for configuration simplicity.


The Forum post is edited by OW-Ghost Jan 5
OW-Ghost
OW-Ghost Jan 5
okey very interesting 


i was contact my host company and send them a ticket and ask them why they not offer a stand alone server for databases 


here is the answer they was give me:


Hello,

We do not offer dedicated SQL database servers. We host our clients' SQL databases on the same server where their hosting account resides and the connection to the SQL database is performed via UNIX socket. This connection method is more reliable and faster than conventional TCP/IP. Check this thread for more information:

https://serverfault.com/questions/124517/whats-the-difference-between-unix-socket-and-tcp-ip-socket

Best Regards,

Milko Nozhchev
Senior Technical Support

Pages: « 1 2