|
Hi All,
I want to use mysql server on two different ports on same machine. I made two separate cnf files for the same. when I am trying to connect to mysql server with second port which i have added I am unable to do so. I am working on Windows Vista....
Started by MySQL DBA on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For ....
You cannot open the same databases in different instances, as they would lock server/operating system.
Manually-installing-multiple-mysql-instances-on-linux-howto
Google it and you might find for others) on the command-line.
|
|
How to configure multiple MySQL instances on a single machine? There are a lot of information on the web, but they are not very useful.
Instead of generic information that can only be understood by a mind with years of MySQL administrative experience,...
Started by Ngu Soon Hui on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Decided to take the plunge ....
Lets start with a google search
(5 mins later...
Now we have step by step instructions for running multiple MySQL instances used MySQL and someone can probably do a better answer.
Mysql2 20 mins, done.
|
|
I've inherited a company application that uses 58 tables per "object", and the application can have N objects. We are looking at an install of 75 - 100 objects for an application, which is 4300-5000 tables.
What we are trying to figure out is do we want...
Started by Ian on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Normally (on Linux anyway) mysql should tune the maximum number correctly using ulimit.
How can latency help?
MySql stores each table as a file, and there is no limit aside open table.
The databases.
|
Ask your Facebook Friends
|
We are building a web app using Amazon EC2 instances running Linux. All the traffic to the client browser is encrypted with SSL. What should be used to encrypt the traffic between the instances.
The traffic will include connections to a MySQL database...
Started by phoven on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
MySQL 5 also supports SSL betweenMy understanding is that EC2 instances act as though they are independent servers on a switched network, so traffic should only going....
Files between instances as it will provide encryption for you.
|
|
Hi all,
I'd like to hear your approaches for monitoring Linux instances running in EC2. I'm very accustomed to using Nagios to monitor all manner of aspects of a Web-based application's ecosystem, but its model doesn't seem to lend itself particularly...
Answer Snippets (Read the full thread at serverfault):
For EC2 instances there are two "perspectives....
The script would have to read a list of active instances and their addresses, and generate.
instances need the same services, then you associate the service with a hostgroup rather than often.
|
|
I just created a new MySQL data directory using mysql_install_db :
$mysql_install_db --datadir=/home/user1/opt/mysqld/data/ Installing MySQL system tables... 091123 10:51:54 [Warning] One can only use the --user switch if running as root OK Filling help...
Started by User1 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
mysql -P 3307 -u root should do the trick, too..
mysql --socket=/home/user1/opt/mysqld/mysql.sock -uroot did the trick.
Ah, it must use a socket file instead of a port .
|
|
I have a web app that lives on two AWS instances - one instance hosts the site, and the other hosts the actual database (MySQL). The instance hosting the site has an elastic IP pointing to it, which is tied to my domain name.
Obviously, one of the major...
Started by mattloaf1 on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
Amazon Elastic IPs that are assigned ....
I'm sure it'll handle your app as well.
Across several dozen web server instances.
However, EC2 instances aren't durable pageviews/mo.
And easy solution, that's probably what I'd recommend as well .
|
|
Two separate MySQL servers (instance) on Windows Server 2008 running concurrent to serve requests. Database files on SAN. Does MySQL supports this setup?
Started by Iman on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
What you can't do, even with a cluster filesystem (which, last I knew wasn't in Windows Server) is have multiple instances pointing at the same disk, you could only do a failuover....
Given that a SAN is just a block device MySQL doesn't care.
|
|
We have a web application right now that we deploy a copy for each client. Our current deployment strategy is to create a uniquely named jdbc connection pool for each instance. so say jdbc/client. They are specified like this...
< Context path="/" ...
Started by Isisagate on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
If all clients share the same Tomcat instances.
Context.xml, which is shared by all hosts.
|
|
On my server I have installed a web application that comes with a bundle of Apache Services. Hence all the apache related dlls are located in the application folder's sub directory (e.g., C:\Program Files\MyWebApp\apache2). It seems that when the windows...
Started by Ngu Soon Hui on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
To install apache as a second service....
Does the original site still work ok? If it does, there is a chance that the second installation of apache is trying to install itself as a service with the same name as the first instance and therefore, failing.
|
