• Announcements

    • MannDude

      Current state of vpsBoard   02/04/2017

      Dear vpsBoard members and guests:

      Over the last year or two vpsBoard activity and traffic has dwindled. I have had a change of career and interests, and as such am no longer an active member of the web hosting industry.

      Due to time constraints and new interests I no longer wish to continue to maintain vpsBoard. The web site will remain only as an archive to preserve and showcase some of the great material, guides, and industry news that has been generated by members, some of which I remain in contact to this very day and now regard as personal friends.

      I want to thank all of our members who helped make vpsBoard the fastest growing industry forum. In it's prime it was an active and ripe source of activity, news, guides and just general off-topic banter and fun.

      I wish all members and guests the very best, whether it be with your business or your personal projects.

      -MannDude

Search the Community

Showing results for tags 'mysql'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • vpsBoard
    • Announcements & Contests
    • Industry News
  • Virtual Private Servers
    • General Talk
    • Operating a VPS Business
    • Tutorials and Guides
    • Questions and Answers
  • The Lounge
    • The Pub (Off topic discussion)
    • Coding, Scripting & Programming
    • SBC, ARM, Home Automation
  • Marketplace & Reviews
    • Reviews
    • VPS Offers
    • Other Offers
    • Service Requests

Found 12 results

  1. Hello , sorry for the confusing title ,I do not speak english as my first language.(and also sorry if the topic does not fit here) Problem background: I just want to create a website as a competitive program grader for my school. Like complie and run source code on the server. So below is my idea and i would like some help/suggestions before i do it,I still don't know if this will work. Mysql usage: The problem one is that i would use one of the table as my user-submission queue.When user submit a code, I first put it in this table(i suppose it put the new row in the bottom of the table?) . Python program usage: I would run a 24/7 program on my server that check every 10 second if the queue table is not empty, just run the grading process(I know how to do it) and then pop it off the queue.Then check again. PHP usage: When a person submit code, i will use php to put it on the queue table,but it may be the same time my python program is popping something off the queue table too. This is where I get confuse whether it will work or not.(Other usage of the php is just things about web interface which I had done before and know what to do) So,would this idea even work? Will it break my server or something?As a competitive programmer guy I don't know much snd will greatly appreciate any help from u guys. :) Thank you very much.
  2. CVE issued this morning : http://seclists.org/oss-sec/2016/q3/481 detailed: http://seclists.org/oss-sec/2016/q3/att-482/MySQL-Exploit-Remote-Root-Code-Execution-Privesc-CVE-2016-6662.txt Percona has already issued patches. Most other vendors however: not yet.
  3. Can someone help with...

    Hello. I have a NAT IPv4 VPS from LES and I need to do a couple of things. Those include, install LightHTTPD or Nginx to use port 80 as I have my domain proxied to my VPS, install MySQL or an lightweight alternative and install PHP or a lightweight alternative. I also need to set up a Teamspeak 3 server. All of the tutorials I found (which there aren't very many due to the nature of NAT VPS) didn't work and I tried repeatedly. I use CentOS 6.x 32bit and am looking for someone to help me remotely via Teamviewer or Skype... Thanks.
  4. I recently needed the MySQL root password on a server of mine to complete a task but had misplaced it and was unable to locate it. Thinking that I had seriously goofed up I was worried. Luckily, resetting the password was surprisingly simple. All you will need is root access to your VM and about two minutes of time. First things first, you'll need to shutdown MySQL temporarily: service mysql stopOnce the service has shutdown, you can proceed to restart it with the following: mysqld_safe --skip-grant-tables &Now you should be able to login as the MySQL root user without being prompted for a MySQL password. Give it a whirl: mysql -u rootYou should see the familiar MySQL prompt now. To reset the password you can follow the commands below: mysql> use mysql; mysql> update user set password=PASSWORD("MyNewMySQLPassword") where User='root'; mysql> flush privileges; mysql> quit(Obviously replacing "MyNewMySQLPassword" with a proper password) Restart MySQL: service mysql restartCheck that your new MySQL password works, it should: mysql -u root -p That's it.
  5. About time I posted a quick guide for installing Centmin Mod so here it is :) Centmin Mod v1.2.3 background info http://centminmod.com/centminmod_v123.html Requirements: Fresh CentOS 6.x based 32bit or 64bit installation (CentOS minimal ISO recommended) Minimum 256MB memory available. With some tweaks outlined here, you can install on 128MB memory based VPS. But recommend at least 256MB memory. 25 - 60 minutes of your time depending on speed of your server, network speed (for downloads/yum etc). Links: Install instructions http://centminmod.com/download.html FAQ http://centminmod.com/faq.html Change Log http://centminmod.com/changelog.html General Notes: For Xen 32bit OS users on 64bit host nodes, please read FAQ note regarding ARCH_OVERRIDE value you need to enable for Centmin Mod or Original Centmin script to work. If your SSH2 Telnet client options allow for it you can increase the size of your scroll back buffer size to allow larger amounts of outputted text to be shown via scrolling back and forth. Install: Download to any directory EXCEPT /tmp as scripts won't be executable from /tmp yum -y install bc wget http://centminmod.com/download/centmin-v1.2.3-eva2000.03.zip unzip centmin-v1.2.3-eva2000.03.zip cd centmin-v1.2.3mod chmod +x centmin.sh ./centmin.sh then hit menu option #1 -------------------------------------------------------- Centmin Mod 1.2.3-eva2000.03 - http://centminmod.com -------------------------------------------------------- Centmin Mod Menu -------------------------------------------------------- 1). Centmin Install 2). Add Nginx vhost domain 3). NSD setup domain name DNS 4). Nginx Upgrade / Downgrade 5). PHP Upgrade / Downgrade 6). XCache Re-install 7). APC Cache Re-install 8). XCache Install 9). APC Cache Install 10). Memcached Server Re-install 11). MariaDB 5.2.x Branch Upgrade Only 12). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade 13). Install ioping.sh vbtechsupport.com/1239/ 14). SELinux disable 15). Install/Re-install imagick PHP Extension 16). Change SSHD Port Number 17). Multi-thread compression: pigz,pbzip2,lbzip2,p7zip etc 18). Suhosin PHP Extension install 19). Install FFMPEG and FFMPEG PHP Extension 20). NSD Re-install 21). Exit -------------------------------------------------------- Enter option [ 1 - 21 ] -------------------------------------------------------- The depending on your site setup: Enable Nginx PageSpeed ngx_pagespeed module http://centminmod.com/nginx_ngx_pagespeed.html :) Follow rest of steps at http://centminmod.com/getstarted.html
  6. One of our admins, Kevin Quinn took some time to do a nice write up about increasing the efficiency of MySQL by adding an index. So far, it's been pretty well received. We just posted it up yesterday, so head over and have a peek if you'd like. As always, any comments or feedback are certainly welcome. http://blog.totalserversolutions.com/boost-mysql-efficiency-by-adding-an-index/ Thanks
  7. I need a database in the cloud. I have various VPSes and I'd like to coordinate the jobs they run, so I thought I'd have each write to a central DB. I'd also like to store config, capacity planning, etc. data there. Small stuff - probably less than 500M for a long time. MySQL (or Maria) or PostGreSQL would be ideal but I haven't written any code yet. I do need it to be very available/reliable. My concerns about self-hosting it on a VPS is high availability/single point of failure/security (MySQL open to the net, though I think MySQL allows you to limit connections from only certain IPs and if not I could do that with iptables). I could cluster but I'm thinking there might be some sort of cloud-based service? I don't mind paying some small amount per month. AWS RDS (Amazon's hosted MySQL) is $18/month + storage/data at its cheapest (extra small tier), and that's more than I was thinking. There's Amazon's SimpleDB and the free tier is enough I could probably run for a long time...that's another possibility though it's entirely proprietary: http://aws.amazon.com/simpledb/pricing/ Hopefully there is a perl or python module. My fallback would be something like MongoHQ or Amazon Dynamo. I see this as more row-based data than document data though.
  8. Warning: A bit of a ramble. Over the years on multiple occasions I have had to write software that takes messages sent from one server (remote) and does something (e.g insertion into a database or executing some script etc). This tutorial/guide will cover my current implementation and include some tips and warnings regarding potential pitfalls. This kind of architecture can be utilized by any system implementing a central sever - distributed node structure. For example VPS Panels and CDN Systems Aim: To develop a reliable way for a remote server to send a message or perform an action on another (e.g central server) server. This solution should be reliable (reasonably guaranteed delivery), fault tolerant and reasonably resistant to duplicates. Performance is also important as the system should be able to handle high rates of messages per second and be horizontally scaleable as required. Problems: Problem 1: Reliability & Fault Tolerance Its important that these messages be delivered reliably, this rules out most UDP based solutions. There also should be a memory & disk buffer to cover situations where the receiving central server is otherwise unavailable. Problem 2: Performance Previously many of my solutions had involved using rsyslog and its ommysql module to insert into a temporary mysql table (where the messages would be read in chunks and processed). This solution was extremely non performant (max of 200-300 messages per second per worker) and non fault tolerant (reading in chunks of over 5,000 messages). In addition while this solution was simple it was also capped as far as scaleability due to its common table mysql approach. ---- Our solution: software -> rsyslog -> RELP TRANSPORT -> rsyslog -> unix pipe -> redis -> php Parts of the process that exist on the remote server are colored green ORANGE. Worst case data loss: 25 messages rsyslog Now why do we use rsyslog & the syslog protocol as apposed to sending these application messages direct? Really this is more of a personal choice but there are many great pieces of software out there for dealing with and processing syslog messages (rsyslog, elastic search & kibana etc). And lets be honest, its an easier to use existing software to do the heavy lifting than to develop your own clients, servers and modules for application integration. RELP RELP or Reliable Event Logging Protocol is a protocol developed for use in rsyslog for reliabe syslog forwarding over TCP. Its aim is to provide something that is high performing, non duplicating and with a low chance of message loss. More details on the protocol can be found here: http://www.rsyslog.com/doc/relp.html For our purposes its a great protocol unlike UDP forwarding it has 'guarunteed' delivery and unlike a plain TCP forwarder it performs nicely without needing to massively multiplex. There are also other advantages such as the window size and being more able to determine the state during connection break & recovery. Unix FIFO Pipe A fifo pipe is a great posix way to pass data between processes (IPC). They exist as a "file" with a path and store in memory data in a FIFO manner. These FIFO's have a limited space and it is very important to read as fast as we are able to from them. If we are unable rsyslog's write call will fail and begin writing to the on disk / memory queue (as configured). In order to process at large volumes you may need to utilize multiple inserts into the redis list, this does increase the chances of loosing small amounts of messages if this service crashes. Here I have attached a link the code we are using for this process, its simple and utilizes a 25 entry buffer (equates to less than 1/100th of a second worth of logs for us). We have tested it at handling over 10,000 log entries a second at very minor (<5%) CPU usage. Outputting to a unix pipe is as easy as adding lines like below to your rsyslog.conf file. $template pipe, "~%syslogfacility%|%syslogpriority%|%timegenerated%|%msg%\n" local3.* |/rsyslog/pipe;x4b_pipe Redis By inserting the data from the unix pipe into redis we can now process data from the list from multiple PHP workers (possibly remote) in an atomic way. We can also easily utilize multiple redis servers (for redundancy or via sharding for scalability) or redis cluster when stable. Redis provides a list construct (implemented as a linked list) that can be used as a simple queue with great performance for insertions and pops. An example of usage in this way can be found in the above linked Gist. The CPU usage of redis is minute for this workload so it is safe to say you can have many consumers working before you will need to consider sharding this resource. Redis while writing to a list in memory will also syncronise its datastore to disk, this provides added reduncancy incase of issues such as consumer crash. The size of this datastore also provides a safe buffer to handle any peaks that would not otherwise fit in the space allocated to a Unix FIFO pipe. PHP Reading from the redis queue and performing the intended task is the next logical step. As this is most likely the most constly part of receiving the message it makes sense that this step may require multiple workers. Redis is 100% atomic and this solution is no exception. Simply calling LPOP is sufficient. Further integration with subscriptions may be a more efficient solution however you would need to wager fault-tolerance or a possibly further engineered and complicated solution. Remaining points for consideration: Encryption - You will most likely also want to implement encryption if the data you are transiting may contain sensitive data. IPSec is a good transparent solution for this. Authentication - If trusting the sending address is not sufficient for you then you will want to develop an authentication method. Kerberos may be able to help you with this. -- If you are doing something similar and want to submit a better solution feel free (or improvements). Feel free to argue with my logic, there are few weak point in this solution (e.g the number of processing steps) however I feel they are justified. I hope this has interested you, I'm not really sure why I wrote about this particular topic - just felt it might be useful / interesting.
  9. I have been using piwik for some time and i got that super useful. Except one error i get in System Check. I am just curious what does it says..... What is that Thing and how to solve this ? Note:That Database user is not root,created by ispconfig.
  10. MariaDB news - woah huge news it seems Google is also migrating to using MariaDB MySQL server just like Centmin Mod already has by default installed MariaDB http://www.theregister.co.uk/2013/09/12/google_mariadb_mysql_migration/ ! Centmin Mod users are in good company with the likes of other big names migrating to MariaDB including Wikipedia, Red Hat, OpenSuSE, Slackware, Arch Linux, Fedora and now Google ^_^ Congrats to Monty and MariaDB team !
  11. Anyone using/have/recommend a very small my.cnf config for 128MB or less RAM server? Know the topic has been punted around here and there. Never bookmarked and/or tried one. Today is one of those days to experiment. Anyone have one?
  12. Hi peeps, I just posted a tutorial about Setting up development environment for PHP+MySQL using VirtualBox on a PC machine. Maybe someone will find it helpful: http://dagent.org/2013/05/setting-up-development-environment-for-php/