With the new realease of Ubuntu 10.04 LTS, I was wondering if there was going to be a package for installing Mysql Cluster Server 7.1
If not does anyone know of a good walkthrough for compiling and installing it in Ubuntu 10.04 LTS?
I have setup a MySQL High Availability Cluster with two nodes using DRBD & Heartbeat. I have successfully installed the cluster but one question which is still not solved is that Heartbeat monitors failover of network or server failure, etc.
What will happen if MySQL service gets stopped or do not start. This heartbeat-DRBD cluster does not take any action on that part. Now I want to enable this feature too which also monitors MySQL service. I have gone through MON help on web but could not find out any good step by step tutorial.
Im having a frustrating issue with my two machine cluster I setup using Conga. Everything was working great except now when lucci starts mysql the port (3306) is never opened to outside machines. I can do a "ps -ef | grep mysql" and see it running as well as login to mysql on the node it is running on - but an nmap of the machine does not show the 3306 port and I cannot login to mysql remotely and yes I turned off all iptables(iptables,ip6tables) and SElinux is disabled.What am I missing here? If I start mysql on my own (and it is using the same my.cnf as lucci is) it does show the port open and works perfect,t for some reason when lucci starts it, no dice
View 1 Replies View RelatedI am working in a project that needs to set up an Apache Web Cluster. The cluster needs to be High-availability (HA) cluster and Load-balancing cluster. Someone mentioned the use of Red Hat Cluster Suite, but, honestly, I can't figure out how it works, I haven't been able to configure it correctly. The project currently have two nodes, but we need to support at least three nodes in the cluster.
View 5 Replies View RelatedI am trying to build GFS2 cluster with 2 or 3 Fedora 14 nodes, but I've encountered some problems from the start. First luci does not work at all in Fedora 14. There is no luci_admin and even if I manage to start luci service, I get a blank white screen when I try to open it from the browser. I've googled a bit and found that I'd might be able to setup GFS if I manage to build cluster.conf manually and start the cluster suite, but I cannot find documentation on how to create cluster.conf anywhere. If anyone knows how to setup GFS2 without a cluster suite or how to configure cluster.conf.
View 9 Replies View RelatedI have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
I'm having a very strange problem with red hat cluster. After testing it in the lab, I tried to install a new cluster and received the following error: cman not started: Cannot start, cluster name is too long or other CCS error /usr/sbin/cman_tool: aisexec daemon didn't start I've checked the internet for that error, but nothing. I decided to to take the example from cluster.conf man, which looks like that :
[Code]...
And still I get the same error. I can find my servers both from DNS (FQDN and short name) and they also appear in /etc/hosts.
I need to build a 3 node web server cluster to run a php application. Since the app requires users to login (which means a session state is to be maintained), I will be sharing sessions save path, I also need to share the application directory across 3 nodes. I having trouble deciding which cluster file system to select.
View 5 Replies View Relatedconfigure a separate NIC for the heartbeat. what i need to add to cluster.conf to achieve this?
View 1 Replies View RelatedI've just made my old, dusty computer into an Ubuntu Server. So far, i have installed a well functioned LAMP server, to host my Website. I have also installed a FTP-Server (proftpd) and i was wondering if i could manage my FTP accounts in MySQL so i could make an account creation page for it? If yes, how?
View 2 Replies View RelatedI am trying to do the cluster storage with the Rock Cluster storage operating system . I have install the rock cluster on the main server . and I want to connect the client with the PXE boot . when I starting the client then it boot from the PXE boot into the mode of compute node. but it ask the where is to be stored the I have give the path..then server says that not able to find the directory path.
Steps:-
1) insert-ethers
2) client is started with the PXE boot.
3) it detects the dhcp .
4) At last it demand where is to be started by cd-rom, harddisk ,nfs etc.
then I started with the nfs and I have given the lanIp of server.and server is detecting the client but client is not finding the filesystem directory. into export partition directory but it is not taking path.
PATH:-
/export/rock/install it is not finding this path then it is not able to start the o/s from PXE boot..Is there any solution and manual of rock or anyother solution then u can reply to me...
I'm trying to build a Fedora 12 cluster to run DHCP on top of two servers using pacemaker and drbd. The pacemaker runs great but i'm having the hardest time getting DRBD installed.
My kernel version is 2.6.32.11-99.fc12.i686.PAE First i tried to [root@dhcp-primary drbd]#yum install drbd this doesn't give me everything because apparently the kernel module for DRBD must be built from source. so i unpacked drbd-8.3.6.tar.gz and tried :
[Code]...
I'm not very experienced in compiling from source i'd love to make an rpm for this but after scouring the web and trying different install methods, I am still at a loss.
When you access mysql within the same Apache server (same ip address) via php, do you need to GRANT user ip in order to login to mysql?
Where are the log files for php, mysql etc?
I have a xubuntu mysql server, and my winxp machine is unable to connect to the sql server using mysql ODBC.
View 2 Replies View RelatedI've looked everywhere for this (simple) problem, and I can't get this working. I have a mysql server on my LAN which is accessible from within the server.I want to access the mysql server from another computer on the LAN, but it never works.
View 7 Replies View Relatedwhenever i try to connect with phpmyadmin igot this error "#2002 Cannot log in to the MySQL server".how to recover this error?
View 6 Replies View Relatedi'm trying to install mysql-server on my pc. so i type this on my terminal:
Code:
sudo apt-get install mysql-server
it starts to download & install everything, but when it has to configure the server, it simply "freeze" and does nothing!
how can i solve that? i've tried to purge and reinstall, but it was no use!
So recently my MySQL server doesn't startup when Ubuntu boots (it used to) and therefore causes database errors with my Web applications. How do I add MySQL to the run at startup list?
View 1 Replies View RelatedI think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I recently installed an Ubuntu 10.04LTS server. I have zabbix-server on that machine, and I noticed that after reboot it won't start. Probabily, the mix of upstart and old init.d scripts result in zabbix starting when mysql is not active yet, in fact in zabbix-server.log I see it cannot reach db. How can I make sure zabbix-server waits for mysql?
View 9 Replies View RelatedSo, I have a website that is hosted at Godaddy and I've set up a database with the ability to access it remotely. I was wondering if there is an easy way to set up an automated back-up of said database at Godaddy, to my local server.
View 2 Replies View RelatedBeen trying to upgrade home server for several days and it keeps hanging on the mysql upgrade. Here's the what apt-get says code....
View 3 Replies View RelatedI'm working on a side project where I would like to install three ubuntu server systems,each with only one task.So server0 would be the apache server, server1 would be the database and server2 would be the file server.which key terms I should be researching?
View 9 Replies View Relatedi was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
A week or so ago I ran an aptitude safe-upgrade and while it was updating mysql I suffered a power-failure. Now, this never really happens in Holland but of course this once it happened at the worst possible time.
I've tried a lot of different things to get mysql working again, but am running into all kinds of problems. First mysql won't shut off properly (it does startup with the computer but I can't connect to it at all) during an aptitude purge. If I kill the process mysql seems to purge properly, but I guess this is not the case because I wasn't able to install it then.
Things seem to have gone a bit more smoothly this time, however:
Code:
snek@snek-server:~$ sudo aptitude install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
[Code].....
i want to install oscar cluster on my ubuntu 8.04 , so i added its repository from http://svn.oscar.openclustergroup.or...ki/repoTesting .i added repo from Testing the development version section.when i use oscar-config --bootstrap i receive this error :
Initializing ODA: mysql
ERROR: Unknown ODA type ()
at /usr/bin/oda line 886[code]....
i must mention that i have mysql database .
I am currently trying to setup a cluster using heartbeat. Unfortunatly it does not do what I want to do. I am using heartbeat 2.1.4-11 on a readhat system. I am using the the cib for configuration. What I want to do is the following: I have two Nodes. I want to run a clone resource on both nodes. It's named I want to run as a clone. This works fine.Additionally I want to have two virtual IP adresses. One should be set on Node 1 the other on Node 2. This works fine as well. I want to set dependencies between the resources. And this is where I have problems. What I want to achive: In case named is not able to run on a node, the vIP should switch to the other node (which then will have both vIPs). In case both nodes are able to run named, there should be one vIP on each node. Sounds simple, but does not work.Accourding to the heartbeat docu this an be achieved by using
[Code]...
I have two machines fairly decent which I wish to cluster and run a vm (preferred choice virtualbox) on it, if possible with load balance.
View 1 Replies View RelatedI set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-
Quote:
root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Query :-
1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).
2) Is there a way to
a) Find out the usernames that are recorded on the MYSQL server ?
b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user)
c) anything else I can do on the PHP / website code to see if MYSQL is working
(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)
Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)
