Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [web-server]

The tag has no usage guidance.

-5
votes
2answers
29 views

Is there a good database that I can use for Web/Android/iOS development? [on hold]

Which database is good to learn for someone who just started Web/Android/iOS programming and likest to write big applications for those platforms?
0
votes
1answer
100 views

Cannot allocate memory for the buffer pool when using remote access MySQL

I tried to separate the webserver and mysql server. MySQL server = 16GB RAM and the config of Innodb_buffer_pool_size = 10GB. And my Web server = 4GB RAM My website connect to my database server ...
0
votes
2answers
45 views

WARN max_connections from pt-variable-advisor - what to configure for DBaaS?

Our VM configuration (hosted on Vmware) # cat /proc/cpuinfo |grep "cpu cores" | awk -F: '{ num+=$2 } END{ print "cpu cores", num }' cpu cores 32 # free -h total used free ...
0
votes
1answer
163 views

Two Oracle ORDS on one web server accessing one database

Oracle ORDS 3.0 Oracle 12c database Red Hat Linux 6.8 Tomcat 8.0.22 Can two ORDS be deployed to one web server (Tomcat) and access the same database? If so, how is this accomplished? That is, I ...
1
vote
2answers
191 views

What are possible ways of handling multiple users accessing the same database via custom web API? [closed]

I am very new to databases and Web design, but I understand enough to know that designing a good database is crucial, so I would like to prepare for that conceptually. However, I was unable to find ...
0
votes
1answer
3k views

Where is the data stored in MySQL databases?

I don't know much about RDBMS but I am interested, I am working on a project which requires a database, I am planning to use MySQL to maintain that database. I have installed MySQL on macOS and I have ...
1
vote
1answer
179 views

SQL Server Web Service in a web environment architecture

I am new at SQL Server web Service and not too knowledgeable in setting up a secure web environment... From what I've read until now regarding SQL Web Service, I would need to: 1. create a stored ...
1
vote
0answers
1k views

SQL state S1000 in SQLConnect (but not all the time)

I have a CentOS6 webserver and a database server (MS SQL Server 2012). When I use the website everything is going fine except that once an hour or so I get a can't connect error in my php code. I ...
1
vote
1answer
75 views

Sessionizing Web Log Data using MySQL (perhaps by simulating window functions)

I have a large MySQL Table containing about 15 Million rows of web log data. Depending on the IP, useragent and site_id (different sections on the website) I want to create user sessions. The session ...
6
votes
1answer
701 views

Do multiple SQL Server instances increase security?

Context Let's assume you have a server which exposes a web server and one or more web services to store and manage sensible information about physical persons (assume, for this example, complete ...
0
votes
1answer
51 views

Big Size Database and increasing number of users [closed]

Me and my colleagues are using quite big size normalized database. Basically it's used for warehouse management and daily minimum 100 of the user perform data manipulation operations. 80% of the ...
1
vote
1answer
3k views

best way to store tags

I'm a university student building a web application for a project with three collegues , I took the database portion. Our site is basically a link sharing site and supports tags, what is an efficient ...
0
votes
2answers
14k views

mysql connection timeout on small traffic server

How can I set up MySQL so that connections never time out? And how do I even check to see what the current settings for variables such as wait_timeout and interactive_timeout, etc. are? Given that ...
0
votes
1answer
393 views

How to get mysql automatically running when I start tomcat apache on Windows?

When starting my Tomcat Apache Server, I've been having to start up mysql before than using the mysqld command. I was wondering if there was a work around this so that I could have mysql start up when ...
2
votes
1answer
110 views

How dangerous is it to have a user's password in plaintext in a cgi script?

I am setting up a MySQL database and am providing a web interface for it. Now, the DB is extremely simple and the interface just runs certain SELECT statements. I have created a user for my script to ...
1
vote
1answer
595 views

Pl/SQL web application

I have a PL/SQL web application,got the entire DB dump from remote DB. Its very old application, running on oracle 9i. I basically want to get the application up and running on my laptop,but i am not ...
11
votes
3answers
876 views

Is backing a website by a SQL Server 2012 OLAP cube considered reasonable?

I have been tasked with architecting a solution for a large retail chain. They want to allow each of its 1.2 million customers to log on to a web site to see the distribution of recent purchases (...
1
vote
1answer
1k views

MySQL Tables crashing randomly

This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this? How do I keep MySQL tables from crashing and MySQL from crashing? Repairing USR_wp537 ...
1
vote
1answer
686 views

Using multiple Active Directory accounts to connect to SQL Server

I have web applications (Classic ASP and .NET) that connect to SQL Server using SQL authentication. Each one has their own login. I want to convert these to Windows Authentication. The new AD users (1 ...
1
vote
1answer
2k views

SQL Server connection from iis website: “error: 26 - Error Locating Server/Instance Specified”

I've just moved all my databases from one server to another clustered server. The new SQL Server 2008 R2 (enterprise edition) install is using named instances on a non-standard port. SQL is running ...
4
votes
1answer
3k views

Good articles for SQL Server Health Check specifically for Web Applications

I am searching for Database Health check articles specifically for a web application back-end server and SQL Server 2005/2008. My current checklist includes: - Index Fragmentation - SQL Server ...
3
votes
1answer
324 views

Does MVC architecture design pattern effect MySQL database performance?

Our current site is entirely developed in the cakePHP framework with the MVC architecture. If we notice more than around 19-20 users viewing the site at once, it begins to crawl to a hault and begin ...
4
votes
2answers
3k views

Best way to build a server inventory db and web interface?

My team is looking to build a rich inventory of servers at our enterprise. We are trying to consolidate several different excel documents into one database. I found a great utility called AppGini (...
2
votes
1answer
164 views

Oracle Control and Webserver

How does the Database Control work, since Apache is not running on this computer? The Url says https://localhost:1158/em/console/logon/logon. I do have a WAMP apache server on here but I have to shut ...
2
votes
1answer
1k views

How to configure so the Oracle wallet password can be authenticated with a web based Oracle application?

Does anyone know how to configure it so that the Oracle wallet password can be authenticated with a web based Oracle application? I’m trying to make secure LDAP connections with an Oracle web based ...
18
votes
3answers
1k views

How to store 'n' days of web server logs in Sql Server?

For faster reporting and performance analysis, we want to insert our web server logs into Sql Server. This will allow us to see traffic patterns, issues, slowdowns in near real-time. We have a daemon ...