Re: mysql on heroku -- success stories
it's impossible change increment step. Thanks for contacting us. The auto increment steps are set this way as part of our replication strategy, so that we may grow the Heroku clusters that we operate. You'll also notice that if you insert rows on different endpoints that you were provided that the increment seed is different from one another - this is by design. this is email from clear db support. On Thursday, December 20, 2012 2:04:17 AM UTC+9, Brendan McCue wrote: Is it possible to change or work around the increment step being 10? If i modify the my variable for auto_increment_increment to 1 it just goes back to 10. This is how i'm checking and changing the value. SHOW VARIABLES LIKE 'auto_inc%'; SET @@auto_increment_increment=1; Also if not, you mentioned the replication policy they have. Do you have a link to this? Please and thank you. On Monday, January 16, 2012 10:26:27 PM UTC-4, Chang Hoon Jeong wrote: i have experience use ClearDB on Heroku. - default mysql engine is MyISAM. if you want another engine, modify migration file. - default charset is ascii. if you want utf-8, modify migration file - auto increment step size is 10. because their replication policy. (ex, id is 11.. 21.. 31... 41.. not 1, 2, 3, 4) i use ClearDB for personal project so don't know about performance. -- You received this message because you are subscribed to the Google Groups Heroku group. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en_US?hl=en
Re: mysql on heroku -- success stories
Is it possible to change or work around the increment step being 10? If i modify the my variable for auto_increment_increment to 1 it just goes back to 10. This is how i'm checking and changing the value. SHOW VARIABLES LIKE 'auto_inc%'; SET @@auto_increment_increment=1; Also if not, you mentioned the replication policy they have. Do you have a link to this? Please and thank you. On Monday, January 16, 2012 10:26:27 PM UTC-4, Chang Hoon Jeong wrote: i have experience use ClearDB on Heroku. - default mysql engine is MyISAM. if you want another engine, modify migration file. - default charset is ascii. if you want utf-8, modify migration file - auto increment step size is 10. because their replication policy. (ex, id is 11.. 21.. 31... 41.. not 1, 2, 3, 4) i use ClearDB for personal project so don't know about performance. -- You received this message because you are subscribed to the Google Groups Heroku group. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en_US?hl=en
Re: mysql on heroku -- success stories
Has anyone experienced ClearDB on Heroku or outside? Tried to, but their heroku account passwords are all numeric-only, which runs them into a heroku bug - the database.yml file heroku generates has a number instead of a numeric string, and mysql2 is unwilling to work around it. That's why the clearDB heroku help page says you might have to 'use an earlier version of rails' (you could likely get by by using a different mysql adapter more willing to implement workarounds). -- You received this message because you are subscribed to the Google Groups Heroku group. To view this discussion on the web visit https://groups.google.com/d/msg/heroku/-/vHtR_yx7rIwJ. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Re: mysql on heroku -- success stories
Eric, What you're saying about passwords being all numeric is simply incorrect. We use one-way encryption methods to create passwords, and there are no such one-way functions (that I've ever heard of at least) that generate numeric-only results. In addition, the reason why we initially were suggesting that you use an older version of rails was because of the 'mysql://' vs 'mysql2://' schemes. That too has been updated in our docs for awhile now. Hope that helps, Cashton On Sat, Dec 24, 2011 at 7:30 AM, Eric Mueller nevin...@gmail.com wrote: Has anyone experienced ClearDB on Heroku or outside? Tried to, but their heroku account passwords are all numeric-only, which runs them into a heroku bug - the database.yml file heroku generates has a number instead of a numeric string, and mysql2 is unwilling to work around it. That's why the clearDB heroku help page says you might have to 'use an earlier version of rails' (you could likely get by by using a different mysql adapter more willing to implement workarounds). -- You received this message because you are subscribed to the Google Groups Heroku group. To view this discussion on the web visit https://groups.google.com/d/msg/heroku/-/vHtR_yx7rIwJ. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en. -- *Cashton Coleman, CEO* *SuccessBricks, Inc.* c...@cleardb.com Office: 1 469 828 3439 x500 Website: www.cleardb.com -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Re: mysql on heroku -- success stories
What you're saying about passwords being all numeric is simply incorrect. The password added to my heroku environment's database string was all-numeric both times. Both were free-level accounts, though I doubt that's relevant. I successfully logged into the database using each of those passwords. We use one-way encryption methods to create passwords, and there are no such one-way functions (that I've ever heard of at least) that generate numeric-only results. Don't be absurd. Any function that can operate on an alphabet can operate on an alphabet of only digits, and most encryption methods operate on the numbers encoded by those letters, not on the letters themselves. That too has been updated in our docs for awhile now. Perhaps it has, but it was only updated in the Heroku Dev Center docs about a day ago. Here's the google cache from the 15th showing the information ( http://webcache.googleusercontent.com/search?q=cache:2aLYzupRLaMJ:devcenter.heroku.com/articles/cleardbhl=engl=usstrip=1 ) - I saw that very sentence in the page Thursday night (Dec 22). -- You received this message because you are subscribed to the Google Groups Heroku group. To view this discussion on the web visit https://groups.google.com/d/msg/heroku/-/YVY4GRGY9AkJ. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Re: mysql on heroku -- success stories
Hi Jason, Absolutely - if you're looking for how to use the ClearDB URLs that you receive from within Heroku, Adam Wiggins has posted a copy of Wordpress that does it on github - here's the actual file he changed, between lines 17-22: https://github.com/adamwiggins/wordpress-cleardb/blob/master/wp-config.php Hope that helps! Cashton On Mon, Dec 19, 2011 at 7:03 PM, Jason F jfran...@gmail.com wrote: Hi Cashton, We have a PHP app successfully deployed on Heroku. Can we use ClearDB with it? We don't want to move to PostgreSQL either. Thanks, -Jason -- You received this message because you are subscribed to the Google Groups Heroku group. To view this discussion on the web visit https://groups.google.com/d/msg/heroku/-/r0D-lt4gizUJ. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en. -- *Cashton Coleman, CEO* *SuccessBricks, Inc.* c...@cleardb.com Office: 1 469 828 3439 x500 Website: www.cleardb.com -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Re: mysql on heroku -- success stories
Has anyone experienced ClearDB on Heroku or outside? Whats your experience and how long they have been in service? ClearDB pricing on Heroku is very low compared to the huge pricing thats on their website. Why is that so much different - any ideas? Any comparison with Xeround or Amazon RDS? Are they reliable and can exist? I tried to Google - but can't find much about their service. Dash On Dec 9, 4:54 am, Cashton Coleman c...@cleardb.com wrote: If you're interested in using MySQL on Heroku, be sure to check out ClearDB. Our Ignite tier stores up to 5MB and is free to get you started. Paid plans start as low as $9.99 per month and starts with 1GB of storage. ClearDB is also the only geo-distributed MySQL database in the cloud today, which means that even if an entire AWS region goes offline, your database will still be ready, available, and secure. Check it out:http://addons.heroku.com/cleardb Also, if you're interested in moving into a dedicated, globally distributed database platform, check out our website:http://www.cleardb.com. Hope that helps! Cashton On Fri, Dec 9, 2011 at 2:42 PM, djangst djan...@gmail.com wrote: Bah, thanks Neil and Martin. I thought that's how it used to be, but was looking at the Add-ons page and didn't see it there. It's on the Pricing page, Shared and Dedicated database options: http://www.heroku.com/pricing Any comments on performance of the Shared option? I found this, for example: http://groups.google.com/group/heroku/browse_thread/thread/28fafff0b1... On Dec 9, 7:21 am, Neil Middleton neil.middle...@gmail.com wrote: Yes, you can use the Heroku shared databases which come with the hosted applications ranging from free to $20/mo (5mb - 20Gb). If you're not hosting your application on Heroku, create one anyway, and then you'll see the database URL in that applications configuration. Neil -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en. -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Re: mysql on heroku -- success stories
Is there a Postgres option for smaller apps, such as free up to (x) MB? The plans now seem to start at $200/mo., which is steep for a new project. It makes the NoSQL options seem like a better deal, at least at the outset. And if they aren't, that's exactly why a Postgres plan allowing users to ramp-up to something larger would make sense. It reminds me of Braintree, which presents a similar barrier for startups. On Dec 8, 6:51 pm, Peter van Hardenberg p...@heroku.com wrote: Hi Anil, you can set up your own MySQL server outside Heroku on EC2 and attach it to your app. That said, we don't believe RDS is a sufficiently high quality service to offer our customers, which is why we built Heroku Postgres. Peter -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Re: mysql on heroku -- success stories
Hi Anil, you can set up your own MySQL server outside Heroku on EC2 and attach it to your app. That said, we don't believe RDS is a sufficiently high quality service to offer our customers, which is why we built Heroku Postgres. Peter On Thu, Dec 8, 2011 at 12:41 PM, Anil Punjabi an...@hotmail.com wrote: Hi guys, Just wanted to see if anybody had any luck integration their mysql projects with heroku. I'm building a rails app. Don't want to replace it with Postgresql just yet. Xeround seems interesting. Thanks, -Anil -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en. -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.