MySQL And Shared Storage
--=_D38DA341.B3D2A80A
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
I would like to set up a round robin cluster with mysql. The round robin =
would be done through the DNS to two different servers. Each of those =
servers would have mysql installed and each would reference the same data =
directory on our SAN. Are there any problems with doing this?
=20
View Complete Forum Thread with Replies
Related Forum Messages:
MySQL-shared RPM Install
I'm having problems installing the shaired libraries. This RPM came from the MySQL.com download site. [root@localhost src]# rpm -i MySQL-shared-4.0.17-0.i386.rpm warning: MySQL-shared-4.0.17-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
View Replies !
Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system. I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle. Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!
View Replies !
ODBC Connection To MySQL On Shared Hosted Website
I'm trying to connect to a mySQL database that exists in connection w/ my website. I created the database using c-panel. Everything that I use to access the website from my site uses "localhost" as the host name. I installed the ODBC drivers for Windows on my XP machine and am trying to connect from my local machine. I am not sure what I should use for the hostname in that case -- I tried www.mysitename.com as the host but that didn't work. I also tried the IP address, but that didn't work either. I asked my host's support team, but haven't heard back from them yet. It's a shared hosting service. Any ideas on what the hostname should be?
View Replies !
MySQL 2k+ Storage Host
A good MySQL host? i just need access to a MySQL database. I need to be able to connect to it from another website/server. i dont care if it is pay or not just as long as it isnt too much and doesnt have a "max_questions" limit set i have a huge database with 2K+ entries, and freesql.org only allows 1600 "max_questions".
View Replies !
MySQL Image Storage
Wanting to know which is better / easier to work with. Uploading a file as a blob to MySQL and then process a thumb and larger image. Or Process the images first, and store the location of the images as a string, instead of the image as a blob.
View Replies !
Mysql Table Physical Storage
how and where the real mysql database tables are stored? I would like to access the tables without login into mysql or use any mysql command. Do you think I can do that? I noticed that tables are stored in .myi and .myd format through myisam storage engine. Do you know where this .myi and .myd stored? How can I view them? Using a text editor?
View Replies !
MySQL Administrator - Password Storage
I am scheduling backups using MySQL Administrator and have to set the Password Storage options for it to work. What I am wondering is how does the 'OS Specific' password storage method work? Are any of these password storage methods secure? If not, how else can I automatically backup the server?
View Replies !
MySQL 100mb+ Storage Host
I can't find any dedicated servers or anything that give a good chunk of mySQL storage space,100mb is all I can find. Does anyone know of any host that offers a good amount of mySQL space?
View Replies !
UDF Shared Library
I am trying to create a User Defined Function (UDF) using mySql 4.1.11 (mysql-max-4.1.11 for Solaris 8). I am trying to get the examples to work (udf_example.so) I have successfully compiled it and copied the resulting .so file to /usr/lib. The command 'crle' (like ldconfig on Linux) shows that /usr/lib is in the library path, but when I type in mysql: CREATE FUNCTION metaphon RETURNS STRING SONAME "udf_example.so" I get the error 1126, Can't open shared library 'udfexample.so' I've tries renaming the library 'libudf_example.so', but that didn't work either. I don't know how to check what libraries mysql is looking through. I am just guessing that it uses the library path from 'crle'. Any ideas?
View Replies !
Shared Password
I've installed mySQL out of the box and set a new password for the root account, which works in the MySQL monitor but not with the mysqladmin tool. Please can anyone advise whats going on or if I have to do anything else to get access to the admin tool?
View Replies !
Replication Using A Shared Fileserver
I thought of a radical way to do replication of MySQL servers. Let's assume two MySQl servers access a shared mapped storage (/mnt/db) which is a local mount to a fileserver on the network. This fileserver is shared between the MySQL servers; which means any writes to /mnt/db appears immediately on /mnt/db on the other MySQL machine. Two MySQL servers may attempt to modify to the same file if we don't use synchronization. My question is, first, can we do this without making patches to MySQL code, and somehow using some synchronization mechanism accross the two machines running MySQL server each. Or we need to patch MySQL code to support such architecture. Second, is it trivial or impossible to do, how much man-time it requires roughly.
View Replies !
Connections On Shared Server
I frequently get the error message: Warning: mysql_connect(): User user1 has already more than 'max_user_connections' active connections in /home/.sites/60/site23/web/Connections/mysite.php on line 9 It's commercial web hosting on a shared server so I have no control over the server side of things. The php scripting has been written using the GUI in Dreamweaver. Is there anything I can do to resolve this? Should I be using mysql_connect or mysql_pconnect, or is this not the problem? Do I need to include somewhere in my scripts a snippet which disconnects from the server? If so where would I put this? I am not all that familiar with php and mySQL, though I understand parts of it when looking at the code. The database connection is made via a connection.php file produced by Dreamweaver which includes the database details etc. My max connections are only 10. Is this the issue? It only seems to appear when I use php to edit or add to the mySQL database.
View Replies !
Find Shared Values
Say I have a one long Table of people and the foods they like. How do I find all the foods that are like by both of two particular people? ie David peas Kate sausages Kate eggs Bill eggs Kate peas Fred sausages Fred peas and i want to find out what both Fred and Fate like:
View Replies !
How To Find Out Values Shared By Some Members
I have a table contains words extracted from documents which are belonging to a number of categories. Each category contains a number of documents. For each category, I want to find out those words which occur at least in N documents belonging to this category. Code:....
View Replies !
Shared Column Data Transfer
I have two tables with one shared column. One other column in table 2 is empty but has to get filled with a value from one column in table 1. select * from tbl1, tbl2 where tbl1.column = tbl2.column; Above query gives me the results that need to be updated. What will the update statement look like?
View Replies !
Multiple Database, 1 Shared Table, Is It Possible?
I Used MySQL for a long time dev under PHP 3, 4 and now 5 now i'm facing a problems that i solved in the past with php, but i wonder if MySQL could do it on it's own, that'll help me a lot. Multiple database, 1 shared table, is it possible? i mean, i already done with 5 install of Xoops CMS and modified it that every install is on the same database, with deifferents prefixes (like db1_ db2_ ...) then i mod Xoops for each time it called for it's users or saved open sessions id in the DB it use the same table on all install... so the users seamlessly wonder about in 5 differents xoops install without disconnect and change username. now i face the same problem, i need a multi-install or a single install of a core system that will act as a multi-install sofware, but with the same set of users, sessions and some other things.
View Replies !
Security For Shared Server.xml Passwords
I have an ISP that has the server.xml in a shared environment. The server.xml file is where my password is available for database access under connection pooling. I really would like to use connection pooling. Does anyone know how I can protect my password from being viewed by others using the same server.xml file? I cannot get the administrator to change the protection of the file because others in the shared environment need to be able to view it.
View Replies !
Cannot Open Shared Object File!
i just upgraded from MySQL 4.1 to MySQL 5.1. But when i try to run a program, i'm getting this error: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory
View Replies !
How Often Is Best To Create New Database, Migrate Data With Shared Hosting?
I have got a web site that I have ben working on since March, 2007. It is a news reporting web site. It is replacing an older web site. I created a new database (it uses the MySQL database) last March when I started working on the new web site. I have migrated all of the news content from the old web site database to the new web site database. I have a shared web hosting. It's my understanding that the hosting service provider fills up one server with databases then starts a new server with databases. For example, the IP for the server that is hosting the current database for the new web site is 10.6.166.5 I just created a new database (the hosting allows you to have ten databases per shared hosting). The IP for the server for the recently created database for the new web site hosting is 10.6.166.92 If the servers are ordered sequentially there have been 87 new servers filled up with databases since last March (i.e. 10.6.166.92 recently created IP minus 10.6.166.5 March, 2007 IP equals 87 servers). The problem with migrating the nine-month old database to the new database is that I have got over a thousand news stories and two thousand pictures stored in the database with the 10.6.166.5 IP address. I would have to copy and paste all of the data into the phpMyAdmin program or write a PHP script that would automate the process. Is there any benefit to migrating the 10.6.166.5 March, 2007 IP database over to the more recently created 10.6.166.92 IP database? Would it be reasonable to expect the more recently created database to perform better over the next 12 to 18 months than the one created nine months ago?
View Replies !
Why Dont Shared Hosting Accounts Provide Stored Procedures And Triggers?
i am searching for 3 days now for a reliable, fast hosting company, which supports stored procedures and triggers on mysql5. most of them dont support this, because mysql5 has a design-flaw in which it stores procedures and triggers on a root level-area (tables mysql information_schema). due this logic, most of the hosting companies wont allow you to create/run procedures and triggers. funny, that hosting companies forbid you to use new technologies and methods to build faster.
View Replies !
Password Storage
I've been working on an update for an excisting site with 1000 or so users, my new version uses sha(password) to store the password in the database. I've just been handed the excel file of the old database and the password is stored in plaintext. Is it possible/easy to change all the plain text passwords into the encrypted sha() format? Is there another easy option? It would obviously be preferable for the old users to be able to log straight in with their old password.
View Replies !
Storage Engine
I have spent the last two years learning about PHP and MySQL, queries etc which has been easy enough to learn and impliment. However I have never had to manage large databases. I have recently taken on a massive database - 1 table is 1GB and growing. I am concerned about speed, backups etc. Previously I was backing up the data every day on the server, however this means I am storing a huge amount of information, has anyone got any other ideas about backing up large database? Also, I have read alot about storage engines, from what I understand depending on the requirements of the database different storage engines provide different benefits.
View Replies !
Storage Requirements
According to the link above, you can have up to 24 digits use only 4 bytes...how is that possible. I'm sure I'm mistaken, but can someone please explain to me what this means. I know when creating a float you use 2 params float(total_num_digits, percision), I just wanted to know how i could calculate storage requirements.
View Replies !
Data Storage
I have MySQL and MOODLE installed on my system hard drive. I always maintain separate system and data drives, this means my system hard disk is smaller than my data hard disk. Is there a way to have MySQL to save database information on the data drive? ie. hda1 is my system drive/disk and hdb1 is my data drive/disk What should I do? I'm really concerned about my system drive filling up as I begin to add courses/teachers/students/ etc.. to my MOODLE system.
View Replies !
Storage Space
I've been reading a few books about MySQL and none of them give a clear answer. What I'd like to know is whether empty fields use up storage space. For example, if I had a table as follows: Username VARCHAR(50), Color CHAR (10) If I enter a username, but don't put anything under Color, does each entry take up hard drive space for the empty CHAR? What about if, there originally was data in the COLOR field, and I deleted the value next to a few Usernames, would that clear up the hard drive space? Lastly, most data types say they take up x bytes in storage. Does that mean if you put any data in that field, regardless of how much data, it will take up that much storage? If I am correct, I believe the VARCHARs are the exception, where they only take up as much storage as needed plus 2 Bytes.
View Replies !
Storage Save
I had two table very large data, i just now did "truncate table cdr", all data erased but still my space is not free. because following file is still same size, how can i reduce this size? I also cant ftp this file the server goes down with blue screen. Mysql Server 5.0: ===================== C: Free 1.5gb C:Program FilesMySQLMySQL Server 5.0dataibdata1 10.8 GB (11,670,650,880 bytes)
View Replies !
Storage Engines
I see that InnoDB storage engine does not support FUllTEXT searches, but is good for transactions. I have a situation where I need to make use of both, is there a storage engine that allows for both transactions and fulltext searches?
View Replies !
Storage Capacity
I am using Mysql 4.0.13. Can anybody send me the storage capacity of Mysql database ie how many GB's of data it can store and also how many records it can store.
View Replies !
Reclaiming Storage
If I delete rows from one or more tables, does the space occupied by the deleted rows remain allocated or is it freed up. If it is still allocated, is there are way to free it up?Our Network Admin is complaining about how the database has grown, it takes over an hour to back up.A related question. We have added multiple volumes to the database and am worried that if we delete a large amount of data, can this space be reused or will it just be wasted?
View Replies !
Efficient Storage Of IP Address
I am establishing a database for the purpose of logging access to my secure webserver and am wanting to make the database as efficient as I can because it will be doing a lot of work when the site goes live. What is the most efficient way in a MySQL table to store remote IP addresses? What data type should I use? Should I just go with a basic VARCHAR(15) to allow for 4 sets of 3 digits with 3 decimal separators, or is there a better way?
View Replies !
Fix Error 134 From Storage Engine
IPB WARNING [2] mysql_query() [function.mysql-query]: Unable to save result set (Line: 457 of /ips_kernel/class_db_mysql.php) There appears to be an error with the database. You can try to refresh the page by clicking here. Error Returned mySQL query error: SELECT MIN(pid) as pid FROM ib_posts WHERE queued=0 AND topic_id=85734 AND post_date 1160298086 LIMIT 0,1 SQL error: Got error 134 from storage engine SQL error code: Date: Wednesday 13th of October 2006 04:51:36 PM.
View Replies !
Storage Efficiency Of VARCHARs
I am curious about the internal representation of VARCHARS. I cannot find any documentation on it in the mySQL manual. Will a VARCHAR(10) take up less space then a VARCHAR(80), even though they are variable?
View Replies !
Losing Storage Space
I have a slackware 10 box with mysql 4.0.20. I have just started learning to use mysql. I have used the medium file for my my.cnf file and have uncommented the innodb stuff as that is what i wanted to play with. I imported 3 million recs from my postgresql table into mysql as an myisam table and ran some speed tests... I then converted the table to innodb format and ran the same tests. When i was finished i dropped the table and database i was using and my disk space is almst 2 gigs less than it was before i started the test. I am assuming the space went into a transaction log somewhere. Is there some way to reclaim this space?
View Replies !
Error 1 From Storage Engine
I run a forum using Invision (IP.Board). I have named its MYSQL Database - IPB DB I was trialing a component modification IBPWIKI mod, which runs its own (mediawiki) wiki DB, but adds an interface with my Forum and installs 5 tables in my IPB DB I last used the mod about 4 months ago and the other day I went to uninstall it. But I found that the Wiki DB was corrupted - maybe when my host was moving server - about a month ago. I have reloaded a wiki DB backup, and the wiki DB looks fine (I removed the lines in the MediaWiki local sttings file which allows the wiki to run independently from the Invision Forum I then have tried to drop the tables in my IPB DB, but I am getting this errror Quote:
View Replies !
Error 28 From Storage Engine
Quote: mySQL query error: SELECT * FROM ibf_quotes WHERE accepted=1 ORDER BY rand() LIMIT 0,1 mySQL error: Got error 28 from storage engine mySQL error code: Date: Sunday 29th of May 2005 12:54:38 PM does anyone know what error 28 is and how i can resolve it??
View Replies !
Storage Of Domain Names
I'd like allow user to enter domain names in a form and then to store these in a table field in MySQL.Googled this bigtime butdidn't find anything on it. What I would need is the regex poliching of the domain names (I guess I cannot put slashes into the database without caution, right?
View Replies !
Storage Space For NULL
Does anybody know how much storage is taken up if a NULL value is stored in an int column or timestamp column? Is it still 4 bytes, or is it less because it is null? The optimization page says that NOT NULL takes 1 less bit per column than NULL, but is that still true if the actual value stored in the field is NULL, as opposed to 0 or another integer or timestamp?
View Replies !
Alternate Storage Location
I am trying to change the location of my data storage for windows mysql 5.0, but mysql doesnt seem to want this to happen. I have tried doing this from both the administrator tool and directly editing my.ini, but once I make these changes and then start the mysql service I get a "Error 1067: Process terminated unexpectedly". From looking around, I see that this is a kinda common issue, but I cant really find very good answers on how to fix it. The mysql docs say to move my.ini to the windows directory, but that didnt help either. (I'm using windows 2000 sp4)
View Replies !
Error 139 From Storage Engine
So I'm writing a simple application that connects to a MySQL database and displays it all pretty, and on one entry whenever I try to edit any of its columns or add more columns I get: "Got error 139 from storage engine". From briefly looking around it looks to be a memory problem, so I stuck another 512mb stick in my computer and am still getting the same result. There are about 30 columns most being of type TEXT. Does TEXT take up a lot of memory, what is causing my problem?
View Replies !
Storage Size Clarification
The MySQL docs state that a BIT(M) type column uses approximately (M+7)/8 bytes of storage. I am a little confused, though.. If I have a BIT(15) column, that is (15+7)/8, or 2.75. Does that mean the column will require 2 bytes, 3 bytes, or 2 bytes and 6 bits of the next byte? Actually, I'm only currently using 10 bits for data, and assuming the size will be two bytes, with the 5 extra bits of the second byte reserved for future use, and one bit unassigned/padding. Would this be the correct assumption, does MySQL use some additional bits as overhead, or what?
View Replies !
Got Error 22 From Storage Engine
got this message during script execution: "Got error 22 from storage engine" and can't find any documentation on it. What does it mean and how do I fix it? There was also a "ErrNr 1030" indicator. As a quick summary of where it occurred, I created a fairly large (1.3M lines) table with range partitions and hash subpartitions using the MyISAM engine. The purpose is to be able to use the table for fast full text index queries by taking advantage of partition pruning. Everything appears to be fine with the table when using Explain and Show Table Status, but when I try to index the table with "create index TileXIndex on Yellow (TileX);" I get the above error. Another peculiarity is that when I try to create a fulltext index with "create fulltext index BusinessNameIndex on Yellow (BusinessName);" I get the error "The used table type doesn't support FULLTEXT indexes" even though "show table status;" gives " 'yellow', 'MyISAM', 10, 'Dynamic', 1315785, 2189, 2881159164, 0, 691200, 1991574552, , '2009-02-06 16:45:37', '2009-02-06 17:24:08', '', 'latin1_swedish_ci', , 'partitioned', '' " showing that the table type is indeed MyIsam
View Replies !
|
TRACKER
