I have to regularly run the "RESET MASTER" command in MySQL to clear up space on a server's hard drive partition, is there a way to have this command execute automatically so as to avoid having to manually log in to the shell and enter it all the time ? Can this be done via Crontab?
View 2 RepliesI'm not too experienced with this, so I'm hoping someone more enlightened here can help.
Scenario:
I'm trying to build a social network site geared towards old people. I'm using LAMP environment. I want to have 1 mysql master (writes) and 2 mysql slaves (reads). Two web servers will read from the 2 mysql slaves and write to the one mysql master.
Questions:
My concern is this: when a user posts a comment via the webserver, the comment is written to the mysql master. I would like for him/her to see the comment he posted right away so they don't think something failed or went wrong. I'm afraid that replication to the mysql slaves will take some time to sync all of the mysql databases together. How can I work around this? Or am I mistaken and this doesn't actually happen?
How fast is replication? How can I mitigate this delay in replication to show the user instant results of their submission.
The same thing can apply to uploading photos to a user's profile.
I have a xampp install on my Home PC(Windows) for testing scripts. I forgot the password for mysql as didn't use it for while. now Phpmyadmin won't connect.
how do i reset password for Xampp?
i just wanna reset my wordpress database password
View 6 Replies View Relatedhow can i creat Master Reseller in my cpanel/whm and so install this plugin?
View 10 Replies View Relatedi have dsedicated server so i want to install
Master REselelr to allow reselelr to creat reseller
can this software work on CENTOS Enterprise 5.2 i686 on standard
and how can i install it
Just asking, where should I usually install my boot loader:
/dev/sda - master boot record (MBR)
-- or --
/dev/sda1 - first sector of boot partition
My partition for /sda1/ is /boot 100MB
how i can make master reseller on my vps
View 9 Replies View RelatedLogging in to cpanel using root password warned you that you had logged in using root privs and you got a nice drop down where you could jump to any account's cpanel.
After changing my root password, the first domain set up on that server gets the nice drop down, and indeed full rights, despite using it's normal password. I also don't see the warning message about using root privs.
So, somehow, the domain's account has gained ROOT cpanel privs. Where is this set?
I've four servers of them working as webserver and MySQL slave. and another one is MySQL Master server.
website seem to very sow when open any link which right to MySQL Master server. so i need to do Dua master with 2 slaves servers. any one can recommend me.
O.S. CentOS 4.4
Apache 2.0
MySQL 4.1
I'd like to run two servers, both will be using lxadmin and tinydns, what would be the best way to run a master/slave nameserver setup, and allow DNS updates to be transferred from the master to the slave?
View 2 Replies View RelatedI want to know more about dns servers (master2slave), is there any tutorials how can I do that? I have 10 servers now, do I need to buy 2 more only for DNS?
View 6 Replies View RelatedI am thinking about install CSF firewall (without cPanel or any control Panel) in the master (the dedicated is virtualized with OpenVZ).
I no have services (only the OpenVZ panel to manage -hypervm-) and no extra services. Only for increase secutiry on master and avoid security problems-related.
Its recomendable to use any firewall in Master? Could be problematic on future?
I need to open the vps ports in use on master firewall?
I have bought a Master Reseller recently.
I have some technical question in my mind regarding backup.
I will start step by step.
1) I login to the WHM.
2) I click to WHMreseller Master Resellers placed on the bottom of the left menu.
3) There I saw some options at the bottom , 'Migrate' , 'Backup' ,'Change Owner', 'IP Delegation'
4) I clicked on 'Backup'.
5) There I saw two check boxes:
Enable Weekly Automated FTP Backups
Enable Weekly Automated Local Backups (will only run if cpbackups are disabled by root)
My questions are very simple:
Q1) What these two check boxes mean ?
Q2) If i check 'Enable Weekly Automated FTP Backups' and save these settings then every week , back of my all cpanels including cpanels of reseller will be generated or wht?
Would anyone happen to know the commands to restore a master backup file via command line on a hypervm master node?
View 2 Replies View RelatedIs it possible to have a master 404 page that is applied to all the people on our hosting?
View 0 Replies View RelatedWich port used by hypervm (master/slave)
I have csf installed on my server and i need to open needed ports.
In 'Operations > DNS manager > Nameservers' the nameserver lists the hostname of the node as the nameserver. How do you specify or alter the nameserver to something different which would be more standard for example ns.domain.name?
View 8 Replies View RelatedI am having some serious issues on one of my servers. The server/browser error I (and clients) get when executing something that needs more than 5 secs to finish is "The connection to the server was reset while the page was loading".
[Sat Feb 23 11:27:22 2008] [info] (104)Connection reset by peer: core_output_filter: writing data to the network
[Sat Feb 23 11:27:24 2008] [notice] Digest: generating secret for digest authentication ...
[Sat Feb 23 11:27:24 2008] [notice] Digest: done
[Sat Feb 23 11:27:24 2008] [warn] pid file /var/run/apache2/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sat Feb 23 11:27:24 2008] [notice] Apache configured -- resuming normal operations
[Sat Feb 23 11:27:24 2008] [info] Server built: Jul 28 2006 09:04:55
[Sat Feb 23 11:27:26 2008] [info] (104)Connection reset by peer: core_output_filter: writing data to the network
[Sat Feb 23 11:27:27 2008] [info] (104)Connection reset by peer: core_output_filter: writing data to the network
I just recently installed RTG to poll my switch.
I am trying to figure out how to reset RTG per port so that it would poll data from the beginning.
Example: I only want to restart the polling on port1, how would I reset the RTG to do so?
For the longest time that i know of i setup a Fortigate 50 at a LAN cafe. No issues but they asked me to change a few things and update a few things. For the like of me i don't have any details saved about the admin password, nor do they.
I have an account setup thinking i can put a ticket in, but no... I need a support plan... The email address i have for Fortigate returns please open a ticket via web... So im kinda stuck.
Does any one on hand know how to fully reset these boxes? I have the CLI up but theres nothing regarding doing so, like some others.
I have 3 servers, but one of them has some problem.
When Internet connection is slow and I try to access any webpages on this server, very often I get just a blank page or "The connection was reset" error. When I refresh page, it loads normaly. Sometimes it happends on each 5th-10th click.
It happends only with one server.
when I run DNS report for some of domain of my it give few errors on
1)
SOA MNAME Check Your SOA (Start of Authority) record states that your
master(primary) server is: Fail
2)
Invalid characters Checks if MX records use valid host names, without any invalid characters. FAIL
how to fix this using WHM.
I changed the DNS parameters of the default domain service plans to slave.
But where can I set the default master server, I didn't find it.
I have two VPS with two different Datacenters. I am running my website on one of the VPS which has Plesk Panel 11.5 installed on it. Since my second server is not in use, I would like to use it as a Secondary DNS Server for redundancy. I know this can be done with Plesk Expand. But, I am not in a position to invest further as I just run 4 domains on my main server. I was looking at installing some free control panel on my secondary VPS and set it up as a Secondary DNS Server if possible. But, I could not find any Guides on setting this up.
How I can do this? I see that we have an option in Plesk - 'Switch DNS Service mode' which can be used to either setup my first server as a Secondary or Primary. I have installed Webmin/Virtualmin on the second server, but how to set this up perfectly. I can reinstall the 2nd Server if required, but not my first one with Plesk.
Our partition become full and drop the vps, after that we are unable to start postifx, actually postfix start but master not.
So if I run :
/etc/init.d/postfix restart
Shutting down postfix: [FAILED]
Starting postfix: [ OK ]
/etc/init.d/postfix status
master is stopped
I already try to reconfigure all
/usr/local/psa/admin/bin/mailmng-service --start-service --mail-component=all
Into ToolsSettings i change between qmail and come back again to postfix (reinstalling)...