Tag Info

New answers tagged

0

Use a master-master MySQL replication setup. Set auto_increment_increment on both servers to 2. Set auto_increment_offset on one server to the (default) 1, and to 2 on the other server. With this scheme both servers can concurrently insert data into auto-increment tables without getting in each other's way, so that both servers can be used to update the ...


2

"hung tasks" are bugs that cause the kernel to leave a task stuck in uninterruptible "D" state. A task/process in that state cannot be killed, neither with kill -9. Your message in /var/log/messages means that the task 4123, obviously the mysql daemon is in that state since 120 seconds. That means the mysql daemon waits for ressources. Mostly the "D" state ...


1

echo 0 > /proc/sys/kernel/hung_task_timeout_secs only silences the warning. Besides that it has no effect whatsoever. Any value above zero will cause this message to be issued whenever a task is blocked for that amount of time. The warning is given to indicate a problem with the system. In my experience it means that the process is blocked in kernel ...


0

Finally solved it... If someone gets in a similar situation where no mysql-server install doesn't go through, after making sure that the installation steps were correct but service won't start or create necessary files see the following: Problem was: I looked at my repos, fault was there, i had corrupted repos that led to downloading and installing wrong ...


1

One the popular accepted solutions to this problem is using a configuration management system. Some examples are puppet, chef, and saltstack. These systems allow you to define exactly what a server (or in some cases an application stack) looks like. Using these tools you define a server's state, including its configuration. Here is an example of a very ...


0

I've patched mysql-connector-c++.spec and mysql-workbench.spec so you can mock both spec files for Fedora 21. Please read the instructions in README.rst to build it yourself. https://github.com/meeuw/mysql-workbench-fedora-21


1

Yes, the following rules should work, regardless of all your other rules, replacing $IPADDRESS with each IP address you need to allow; iptables -I INPUT 1 -p tcp --dport 3306 -s 0.0.0.0/0 -j DROP iptables -I INPUT 1 -p tcp --dport 3306 -s $IPADDRESS -j ACCEPT iptables -I INPUT 1 -p tcp --dport 3306 -s $IPADDRESS -j ACCEPT iptables -I INPUT 1 -p tcp --dport ...


1

These databases operate on the client-server model. A given machine may require either a client, a server, or both. I don't see what is surprising about that. If the database software is properly packaged, it should be possible to install either packages for either the client or the server software, because it is not necessary to have a client installed for ...


0

Looks like you just installed MySQL client not the server. Use the command below to install the server yum install mysql-server Also you can refer the link for more information:- MySQL


0

If your file my.cnf (usually in the /etc/mysql/ folder) is correctly configured with socket=/var/lib/mysql/mysql.sock you can check if mysql is running with the following command: mysqladmin -u root -p status try changing your permission to mysql folder. If you are working locally, you can try: sudo chmod -R 755 /var/lib/mysql/ source


0

To paste multilines in a variable, I would do : #!/bin/bash echo -en 'Paste your multiline content and ^D to submit >>> ' content="$(cat)" echo "$content"


0

Not sure if this will help you, but I had originally just wget'd phpmyadmin in and set it up manually. I changed it to using apt-get install phpmyadmin. I also had issues with php5-mysql and php5-mysqlnd not being compatible versions, so I had to remove php5-mysql on all servers and add php5-mysqlnd. The errors i was getting were From phpmyadmin only. ...


0

Change IFS separator to "," Iterate while loop over mysql query result Extract dir from old path Perform renaming The code will be something like: #!/bin/bash IFS=',' mysql ...executequery... | while read oldpath newfname do filedir=$(dirname $oldpath) mv "$oldpath" "$filedir/$newfname" done You didn't mention what to do with NULL query results.



Top 50 recent answers are included