MySQL replication and reverse replication?
Good day all I am hoping everyone is well. Can someone perhaps assist me with some resources on the following topic one of our clients are running a MySQL 5 master/slave replication setup. There is a DR test schedule during next month, however they want the slave server to become the master and the master server to become the slave server. I am busy looking into how to setup a master / slave replication, however I am trying to find out how to do the relevant changes as mentioned above. The next test they then want to do is to test the switch over to the slave server in cases where the master server should fail. I am however not that experienced on MySQL as yet and cant seem to find specific references on how to do this change over? any ideas or resources will be appreciated. Regards Machiel
Re: Unique ID's across multiple databases
I may have missed what you are trying to do here. NoSQL is really a bad name and should really be renamed to NoREL instead. NoSQL implementations are not used just because of limitations of traditional RDBMS when it comes to sheer traffic volume, they are also used because they scale horizontally very well. When I was reading though all these emails it seems to be you would have 200+ nodes here with the SAME data. Maybe that's not what you are trying to do? I also did not know the software for maintaining the data was already in place. JW On Tue, Sep 14, 2010 at 12:57 AM, Johan De Meersman vegiv...@tuxera.bewrote: On Mon, Sep 13, 2010 at 8:59 PM, Johnny Withers joh...@pixelated.netwrote: This sounds like a good job for a 'NoSQL' system. Maybe? I can't help but blink at that. How exactly is NoSQL going to fix issues that are related to topology, not inherent SQL limitations ? Which particular incarnation of NoSQL are you thinking of ? Also, I suspect rewriting all 200 clients' services is not going to be an option :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- - Johnny Withers 601.209.4985 joh...@pixelated.net
Capitalize Input via Auto Complete?
I am new to MySQL coming from PostgreSQL noticed a really annoying issue. When I select a database, and try to auto complete in MySQL, it doesn't capitalize the MySQL statements. It's irritating to me to only be able to auto complete statements like 'SELECT', 'ALTER', 'INSERT' only if I hold down the shift key or caps lock key while typing. Is there a way to force MySQL to auto complete commonly used statements while typing them in lowercase which is normal behavior in PostgreSQL? Thanks for any info! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Crashed Table - How to report/prevent?
Innodb doesn't suffer from corruption issues nearly as often as myisam tables, and it is able to recover on its own in many cases (crash recovery.) In my experience, if innodb does get corrupted, it's most often because of hardware problems. You could consider using it instead. -Original Message- From: Steve Staples [mailto:sstap...@mnsi.net] Sent: Monday, September 13, 2010 7:03 AM To: mysql@lists.mysql.com Subject: Crashed Table - How to report/prevent? Good day MySQL! I had a table that crashed last night. There is a cron function that goes out every 6 hours or so, that does a quick table backup (it's also replicated, it's just something that we have running now). ANYWAY, I think it crashed early in the evening, but when the backup ran, it looks like it marked it as crashed finally (which was about 4 hours later). The table was able to be read up until then, but it looks like it wasn't able to be written too. What I want to know is, is there a quick and easy way to maybe every few hours, check to see if there are any crashed tables or whatnot? This is only the 2nd time in the last 1 1/2 years. the table that crashed, is a table that gets created every month, and is about 5gig in size at the end of the month (it has a lot of records/fields in it which is why i create a new one every month). I could write a quick routine that goes and 'shows' the tables, and if it fails, then repair it (or report it back to me via email or something). Any ideas on a way to automate something that is efficient and quick? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are notified that reviewing, disseminating, disclosing, copying or distributing this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any loss or damage caused by viruses or errors or omissions in the contents of this message, which arise as a result of e-mail transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com
RE: no success (was: hard disk crash: how to discover the db?)
With PHP, a blank page usually means it's generating an error, but not displaying it in the browser; this is often disabled for security reasons, but makes debugging harder. First step should be to get PHP to spit out the actual error. There should probably be a setting in the mediawiki configuration for this, or see the PHP docs for error reporting. -Original Message- From: Uwe Brauer [mailto:oub.oub@gmail.com] On Behalf Of Uwe Brauer Sent: Monday, September 13, 2010 10:35 AM To: George Larson Cc: andrew.2.mo...@nokia.com; mysql@lists.mysql.com Subject: no success (was: hard disk crash: how to discover the db?) On Thu, 09 Sep 2010 18:02:09 -0400, George Larson george.g.lar...@gmail.com wrote: We do nightly backups at work just by taring the mysql directory. In my environment, that is /var/lib/mysql. Like this: service mysql stop cd /var/lib/mysql rm -rf * tar zxvf file.tar rm -rf ib_logfile* chown -R mysql.mysql service mysql start I have followed these steps and it seems not to work. I have re installed the mediawiki software and then I tried to open the corresponding wikipage, but only see empty pages. There are several reasons for this: - when the hard disk crashed the database was damaged, as a matter of fact when I have a look into the /var/lib/mysql/maqwiki directory most of the files are very small in size with the exception of searchindex.MYD and searchindex.MYI. I have no idea whether this is normal. - I did not do the recover process correctly. Is there any hardcore mysql command I could use to check the database? - the connection between the mediawiki conf and the data base is broken. I will ask in the mediawiki page about this. Any advice and help is very much appreciated. Uwe Brauer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are notified that reviewing, disseminating, disclosing, copying or distributing this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any loss or damage caused by viruses or errors or omissions in the contents of this message, which arise as a result of e-mail transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Capitalize Input via Auto Complete?
Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. -Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Tuesday, September 14, 2010 9:03 AM To: MySQL Subject: Capitalize Input via Auto Complete? I am new to MySQL coming from PostgreSQL noticed a really annoying issue. When I select a database, and try to auto complete in MySQL, it doesn't capitalize the MySQL statements. It's irritating to me to only be able to auto complete statements like 'SELECT', 'ALTER', 'INSERT' only if I hold down the shift key or caps lock key while typing. Is there a way to force MySQL to auto complete commonly used statements while typing them in lowercase which is normal behavior in PostgreSQL? Thanks for any info! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Capitalize Input via Auto Complete?
Daevid Vincent wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. Alternatively, there is MySQL WorkBench. Some of the guys around here use SQLYog but, since it is a LAMP environment, I like that WorkBench is native instead of dealing with wonky Wine issues. I haven't noticed anything that I miss from SQLYog yet. -Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Tuesday, September 14, 2010 9:03 AM To: MySQL Subject: Capitalize Input via Auto Complete? I am new to MySQL coming from PostgreSQL noticed a really annoying issue. When I select a database, and try to auto complete in MySQL, it doesn't capitalize the MySQL statements. It's irritating to me to only be able to auto complete statements like 'SELECT', 'ALTER', 'INSERT' only if I hold down the shift key or caps lock key while typing. Is there a way to force MySQL to auto complete commonly used statements while typing them in lowercase which is normal behavior in PostgreSQL? Thanks for any info! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Capitalize Input via Auto Complete?
On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. I can't use any graphical or 3rd party add-on's. I was hoping MySQL had this native / built in. I guess not... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Capitalize Input via Auto Complete?
Carlos Mennens wrote: On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. I can't use any graphical or 3rd party add-on's. I was hoping MySQL had this native / built in. I guess not... There's some impressive stuff built for VIM, but my VIM-fu is still pretty weak. This is script, though. [ http://www.vim.org/scripts/script.php?script_id=356 ]
Re: Capitalize Input via Auto Complete?
On Tue, 2010-09-14 at 15:45 -0400, george larson wrote: Daevid Vincent wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. Alternatively, there is MySQL WorkBench. Some of the guys around here use SQLYog but, since it is a LAMP environment, I like that WorkBench is native instead of dealing with wonky Wine issues. I haven't noticed anything that I miss from SQLYog yet. I've been using sqlyog on wine for a while now, with no issues. it has never crashed, or caused errors in anyway. I am on Ubuntu 9.10 (it wants to uninstall wine to upgrade to 10.04, so for now i am not upgrading) Steve -Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Tuesday, September 14, 2010 9:03 AM To: MySQL Subject: Capitalize Input via Auto Complete? I am new to MySQL coming from PostgreSQL noticed a really annoying issue. When I select a database, and try to auto complete in MySQL, it doesn't capitalize the MySQL statements. It's irritating to me to only be able to auto complete statements like 'SELECT', 'ALTER', 'INSERT' only if I hold down the shift key or caps lock key while typing. Is there a way to force MySQL to auto complete commonly used statements while typing them in lowercase which is normal behavior in PostgreSQL? Thanks for any info! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dae...@daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Capitalize Input via Auto Complete?
-Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Tuesday, September 14, 2010 12:54 PM To: MySQL Subject: Re: Capitalize Input via Auto Complete? On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. I can't use any graphical or 3rd party add-on's. I was hoping MySQL had this native / built in. I guess not... Is there some reason you can't use a graphical tool? You do know you can use ssh tunnels and such to connect to your server from your desktop right? I do it all day long. It's pretty easy to do and built in to these programs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org